Shopify Payout to QuickBooks
Turn a Shopify Payments payout CSV into QuickBooks-ready books: gross sales, refunds, and fees correctly split through a clearing account — with a payout tie-out check.
Drop your Shopify CSV export here
or browse files
Try it without your own data first:
Bank-grade security — No account needed to scan · Processed in memory, never stored
How to record Shopify payouts in QuickBooks
Export from Shopify
In Shopify admin, open a Shopify Payments payout and export its transactions as a CSV (payout-id, date, type, gross, fee, net).
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 free, or the QBO on Pro, and import it into a Shopify Clearing account in QuickBooks.
The clearing-account method
A Shopify payout bundles many days of orders with processing fees and refunds already deducted — the deposit date rarely matches the order dates. The correct bookkeeping is to reconcile by payout, not by day: record gross orders as income into a dedicated Shopify 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 — charges, 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, Amazon Settlement 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
QBO Duplicate Finder
Free to scan — files are processed in memory and never stored. QBO downloads are on Pro.
Stripe QBO Converter
Free to scan — files are processed in memory and never stored. QBO downloads are on Pro.
PayPal Payout to QBO Converter
Free to scan — files are processed in memory and never stored. QBO downloads are on Pro.
Receipt to QBO
Free to scan — files are processed in memory and never stored. QBO downloads are on Pro.
QBO File Checker
Free to scan — files are processed in memory and never stored. QBO downloads are on Pro.
CSV to QBO Converter
Free to scan — files are processed in memory and never stored. QBO downloads are on Pro.
Amazon Settlement to QuickBooks
Free to scan — files are processed in memory and never stored. QBO downloads are on Pro.
Reconciliation Difference Finder
Free to scan — files are processed in memory and never stored. QBO downloads are on Pro.
QBO Import Errors, Explained
Free 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 Shopify Payments payout bundles many orders with processing fees and refunds already deducted, and the deposit date rarely matches the order dates. This tool unpacks each payout into gross sales, refunds, and fees through a Shopify clearing account, then transfers the net to checking — when the clearing account nets to zero, the payout is reconciled.
The Shopify Payments payout export as a CSV, with columns: payout-id, date, type, gross, fee, and net. In Shopify admin, go to Settings → Payments → Shopify Payments → View payouts, open a payout, and export its transactions.
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 Shopify for reserves, chargebacks, or orders from other days swept into the payout before importing.
It handles what is in the Shopify Payments export: Shopify Payments processing fees, refunds, and chargebacks. Sales taken through a third-party gateway (Stripe, PayPal, and others) settle through that gateway, not through Shopify Payments — convert those with the matching tool (Stripe or PayPal) so each deposit is reconciled against the right clearing account.
First create a bank account in QuickBooks named 'Shopify 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.
No. Your CSV is processed in memory to build the payout 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.