Stripe to QuickBooks Desktop — CSV to IIF Converter
Stripe deposits land in your bank net of processing fees, but your books need the gross sale, the fee, and the net deposit. Load the Stripe CSV here and get a QuickBooks Desktop import file with the fee split out automatically.
Runs in your browser — your file never leaves your computer
- 1Load
- 2Map
- 3Review
- 4Download
What this tool accepts
A spreadsheet of transactions, written as balanced check and deposit blocks in a tab-delimited IIF file.
Files
CSV, XLS, or XLSX from your bank or payment processor
Columns
- Date — required — any common date shape
- Description — required — becomes the memo, and the payee if you opt in
- Amount — required — signed in/out, or use Debit + Credit columns
- Fee — optional — splits processor fees to their own account
Output
.iif · tab-delimited !TRNS/!SPL blocks, balanced to zero, dates as MM/DD/YYYY.
Then import in QuickBooks Desktop: File → Utilities → Import → Import IIF Files
How to use this file in QuickBooks Desktop
Work on a backup. Run File → Back Up Company first; imports are easiest to undo on a copy of the company file.
- In Stripe, open Reports → Balance (or Payments → Export) and download the CSV for the period you need.
- Load the CSV here — the Stripe preset maps Net to the bank amount, Fee to the fee column, and Created to the date.
- Enter your exact QuickBooks bank account name, a category account (such as Sales), and your fee account (such as Merchant Fees).
- Download the .iif and import it in QuickBooks Desktop: File → Utilities → Import → Import IIF Files.
- Verify a few transactions in the bank register and compare the deposit totals with your Stripe payouts.
Import path: File → Utilities → Import → Import IIF Files