Shopify payout to QuickBooks — one summary per payout, matched to the cent
Drop in the payout transactions CSV from Shopify Admin — get back a QuickBooks-ready .QBO (Web Connect) file.
- One Sales / Refunds / Fees / Other split per payout
- Each split's net is the deposit in your bank feed
- Payout rows themselves stay out of your P&L
- Processed in memory, never stored — your report never touches a database
Drag & drop your Shopify payout export (.csv) here
or
Your report is parsed in memory and immediately discarded — never stored, never logged.
Preview
License active ✓| # | Date | Description | Amount (USD) |
|---|
How it works
Download the report
Shopify Admin → Settings → Payments → View payouts → View Transactions → Export → pick a range → choose Plain CSV (not "Excel file" — that variant formats dates differently) → "Export balance transactions".
Check the match
Each Payout Date shows one summary line: Sales, Refunds, Fees, Other and Net. The green ✓ means the activity net equals the payout row Shopify sent to your bank — to the cent.
Export & import
Download QBO, CSV, or XLSX and import into QuickBooks in a couple of clicks. Summary lines are dated on the payout date, so they land right on your bank feed.
What goes into each line
One payout becomes 3–5 booked lines:
The four buckets
Sales — charge amounts at gross, before the processing fee. Refunds — refunds and disputes (chargebacks) at gross; a dispute_reversal comes back as a positive refund. Fees — Shopify Payments processing fees and the $15 dispute fee (Shopify stores the Fee column as a positive number: Net = Amount − Fee — this converter handles that, and the PayPal-style opposite convention on the PayPal page). Other — adjustments, credits and reserve movements. The negative "payout" rows are the deposits themselves: they are used only as the reconciliation target, never booked as income or expense.
Frequently asked questions
Which Shopify file exactly does this page take?
The payout balance transactions export: Shopify Admin → Settings → Payments → View payouts → View Transactions → Export → Plain CSV. Don't pick "Excel file" — that export formats dates differently. Rows whose payout is still pending (no Payout Date yet) are excluded and listed in the warnings, so they get booked with their payout next time instead of twice.
Why summaries instead of one line per order?
Shopify pays one net deposit per payout day. Per-order imports give you hundreds of register lines that never individually match the bank feed. One split per payout books identical revenue and fees — and its total is the deposit, which is what makes reconciliation one click instead of one afternoon.
How are disputes (chargebacks) handled?
A dispute row removes the sale at gross (booked under Refunds) and adds the $15 dispute fee under Fees. If you win, the dispute_reversal row comes back as a positive refund in its own payout. Both sides stay inside the payout they actually settled in, so every payout still matches.
What do I get for free, and what does the license add?
Parsing and the full preview are free, always. Free export covers the first 25 summary rows — enough to prove the match end-to-end. A one-time $1.99 license exports all payouts for 7 days — no subscription, nothing to cancel.
Is my payout export uploaded anywhere?
Yes — the report text goes over an encrypted connection to the parser, which runs in memory and discards it the moment your result comes back. Nothing is written to disk, a database, or logs. If a parse ever fails, one masked structural digest (every letter and digit replaced — no readable content) may be kept to fix the parser. Details in the Privacy Policy.
I already paid but lost my license key — what do I do?
Your license key is shown on your Gumroad receipt, which was sent to your inbox right after purchase — search for "Gumroad" and open that receipt to copy the key. Then use the "Enter license key" link in the top navigation to reactivate unlimited exports.