Shopify + QuickBooks / Xero
How to reconcile Shopify payouts in QuickBooks (and Xero)
The clean way to book a Shopify Payments payout so your deposit matches to the penny — without matching order by order.
A plain-English guide for store owners and bookkeepers
Why the naive way never ties out
If you book each order as income and expect the bank deposit to match, it never will. A payout is a batch of charges minus fees, refunds, chargebacks and reserves — and a refund on last month's order can land in this month's payout. Match at the payout level, not the order level.
Step 1 — Create a Shopify clearing account
In QuickBooks (or Xero) add a new account — type Bank or Current Asset — called Shopify Clearing. This is where sales sit between the sale and the payout.
Step 2 — Post one journal entry per payout
Open the payout's Transactions export and book it as a single journal entry:
- Debit — Bank for the amount that actually landed (the net payout).
- Debit — Payment fees (expense) for the total processing fees.
- Debit — Refunds / Chargebacks for anything reversed in this payout.
- Credit — Shopify Clearing (or Sales) for the gross that makes it all balance.
Because the payout total is the sum of its transaction rows, debits equal credits and the entry balances to the penny.
Doing it in Xero
Same method, different button: use a Manual Journal (or a bank rule against the clearing account) with your account codes instead of names. Debits and credits are identical to the QuickBooks entry above.
The mistakes that cost hours
- Booking the net deposit straight to Sales — you lose the fees and your income is understated.
- Reconciling order by order — different clocks, never ties.
- Ignoring reserves — held funds make a period look short, released funds make the next look fat.
- Entering the same payout twice — easy to do by hand, and a nightmare to unwind.
Let NetClear post it for you
NetClear reads your payouts export, builds the balanced journal entry, and posts it straight to QuickBooks or Xero — with a key that stops the same payout being booked twice.
Try it on your payout — free →Free while in early access · connects to QuickBooks & Xero · your data is only read, never changed
Frequently asked
How do I record a Shopify payout in QuickBooks?
Don't record it as a single sales deposit. Post it as a journal entry (or a bank deposit with split lines) built from the payout's Transactions export: debit your bank for the amount received, debit fees / refunds / chargebacks as their own lines, and credit sales — or better, credit a Shopify clearing account that your sales already flow into.
What is a Shopify clearing account and why do I need one?
It's a holding account that sits between your sales and your bank. Sales and refunds post to clearing when they happen; when Shopify pays out, you move money from clearing to the bank and book the fees. The clearing balance is your 'in transit' money, and it's what makes every deposit reconcile cleanly instead of chasing individual orders.
Is reconciling Shopify payouts different in Xero?
The method is identical — a clearing account plus a manual journal per payout. Only the mechanics differ: in Xero you use a Manual Journal (or bank rule) and account codes, in QuickBooks a Journal Entry and account names. The debits and credits are the same.
Do I have to reconcile every single payout by hand?
By hand, yes — export each payout's Transactions CSV, split it into lines, and post a journal. That's the part tools automate: NetClear reads the export and posts a balanced entry straight to QuickBooks or Xero, with an idempotency key so the same payout can't be booked twice.