Square to QuickBooks Desktop — CSV to IIF Converter
Square pays out net of fees, so your bank register and your sales account never match on their own. Load the Square CSV and this tool writes the deposit, the fee, and the gross sale as balanced QuickBooks Desktop import lines.
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 Square Dashboard, go to Transactions (or Reports → Sales) and export the CSV for the period.
- Load the CSV here — the Square preset maps Net Total to the bank amount and Fees to the fee column.
- Enter your exact QuickBooks bank account name, a category account (such as Sales), and a fee account (such as Merchant Fees).
- Download the .iif and import it: File → Utilities → Import → Import IIF Files in QuickBooks Desktop.
- Spot-check deposits against your Square payout history, then reconcile the bank account.
Import path: File → Utilities → Import → Import IIF Files