Square Payout to QuickBooks
Turn a Square payout CSV into QuickBooks-ready books: gross sales, refunds, and fees correctly split through a clearing account — with a payout tie-out check. Both downloads are free, no account needed.
Drop your Square CSV export here
or browse files
Try it without your own data first:
Bank-grade security — No account needed · Both downloads free · Processed in memory, never stored
How to record Square payouts in QuickBooks
Export from Square
In Square Dashboard, open your reports, export the payout detail as a CSV, with payout-id, date, type, gross, fee, and net columns.
Upload it here
Drop the CSV in — the tool groups everything into payouts automatically.
Review the tie-out
Check each payout's gross, fees, and refunds, and confirm the payout ties out to the bank deposit.
Import into QuickBooks
Download the CSV or the QBO — both are free — and import it into a Square Clearing account in QuickBooks.
The clearing-account method
A Square payout bundles many days of sales with processing fees and refunds already deducted — the deposit date rarely matches the sale dates. The correct bookkeeping is to reconcile by payout, not by day: record gross sales as income into a dedicated Square clearing account, record fees and refunds against the same account, then record the payout as a transfer from the clearing account to your checking account. When the clearing account nets to zero, the payout is reconciled to the penny.
What this tool handles
- Payout grouping — sales, refunds, chargebacks, and fees grouped by payout ID.
- Per-payout summaries — gross, refunds, disputes, fees, and net, per payout.
- Tie-out verification — Gross − Fees − Refunds = Payout is checked against the bank deposit for every payout.
- Collision-proof IDs — every clearing entry carries a unique transaction ID derived from the payout, so re-imports are deduped by QuickBooks.
Selling through other channels too? The same clearing-account model powers our Stripe QBO Converter, Shopify Payout Converter, Etsy Payout Converter, and PayPal Payout Converter. If QuickBooks refuses a file, the QBO import-error decoder explains the error and its fix.
More free QuickBooks tools
9 more free tools — pick one, scan free, no account needed.
QBO Duplicate FinderFree to scan — files are processed in memory and never stored. QBO downloads are on Pro.
Stripe QBO ConverterFree to scan — files are processed in memory and never stored. QBO downloads are on Pro.
PayPal Payout to QBO ConverterFree to scan — files are processed in memory and never stored. QBO downloads are on Pro.
Receipt to QBOFree to scan — files are processed in memory and never stored. QBO downloads are on Pro.
QBO File CheckerFree to scan — files are processed in memory and never stored. QBO downloads are on Pro.
CSV to QBO ConverterFree to scan — files are processed in memory and never stored. QBO downloads are on Pro.
Amazon Settlement to QuickBooksFree to scan — files are processed in memory and never stored. QBO downloads are on Pro.
Shopify Payout to QuickBooksFree to scan — files are processed in memory and never stored. QBO downloads are on Pro.
Reconciliation Difference FinderFree to scan — files are processed in memory and never stored. QBO downloads are on Pro.
QBO Import Errors, ExplainedFree to scan — files are processed in memory and never stored. QBO downloads are on Pro.Simple, transparent pricing
Start free. Only pay when you need more.
Free
Try it out — no card needed
- 8 pages free, forever
- CSV & Excel export
- Global banks support
- No credit card required
- ✕OFX / QFX export
- ✕Google Sheets
Basic
For light, occasional use
or $48/yr — save 20%
- 25 pages / month
- CSV & Excel export
- Global banks support
- Email support
- ✕Google Sheets
- ✕OFX / QFX export
Pro
Perfect for CAs & individuals
or $192/yr — save 20%
- 500 pages / month
- All export formats
- Google Sheets export
- Priority processing
- Smart Auto-Categorization (Beta)
- Pre-Export Analytics (Beta)
- Email support
- ✕API access
- ✕Team seats
Business
For CA firms & fintech teams
or $720/yr — save 20%
- 2,000 pages / month
- All export formats
- OCR for Scanned PDFs
- Direct Accounting Push (Coming Soon)
- Smart Auto-Categorization (Beta)
- Pre-Export Analytics (Beta)
- Secure Client Portal (Beta)
- API access
- 5 team seats
- Dedicated support
Frequently asked questions
Record by payout, not by day. Each Square payout bundles many sales with processing fees and refunds already deducted, and the deposit date rarely matches the sale dates. This tool unpacks each payout into gross sales, refunds, and fees through a Square clearing account, then transfers the net to checking — when the clearing account nets to zero, the payout is reconciled.
A Square payout CSV with columns: payout-id, date, type, gross, fee, and net. In Square Dashboard, open your reports and export the payout detail as a CSV. If your export uses different headers, rename them to match — the tool reads exactly these six columns.
The tool verifies Gross − Fees − Refunds = Payout for every payout, against the deposit total in your payout rows. A green 'Ties out' badge means the payout reconciles to the penny. If it shows a difference, check Square for reserve holds, chargebacks, or sales from other periods swept into the payout before importing.
Processing fees are expense lines through the clearing account, refunds are contra-income lines reducing gross sales, and chargebacks appear as their own lines. The fee column in your export is taken as given — the tool does not estimate Square's fee schedule.
First create a bank account in QuickBooks named 'Square Clearing'. Import the QBO there, then match the transfer line against the real payout deposit in your bank feed. When the clearing account nets to zero, the payout is fully reconciled. The CSV works the same way through QuickBooks Online's manual upload.
Yes. The payout summary, the CSV download, and the QBO download are all free on this tool, and no account is needed. Your CSV is processed in memory to build the summary and is not stored afterwards — we never sell or share your financial data.
Bringing statements into QuickBooks?
Convert any PDF bank statement into a balance-checked QBO or CSV file in minutes. The first 8 pages are on us.