Shopify payouts, explained
Why your Shopify payout doesn't match your sales
You sold thousands this month, but a smaller number landed in the bank — and the reports won't tell you where the rest went. Here's exactly why, and the one export that always adds up.
A plain-English guide for store owners · no accountant required
Start with the one report that always ties out
The Payouts summary only shows a total, which is why it never explains anything. The Transactions export does. Every row is typed — charge, refund, dispute, fee, adjustment, reserve, payout — with gross, fee and net, and the payout total is simply the sum of those rows.
- In your Shopify admin, open Finances → Payouts.
- Click into the payout you want to understand.
- Choose Export → Transactions (not the summary).
- Every line that moved the deposit is now in front of you — that's where your 'missing' money is.
The 8 reasons a payout is smaller than your sales
- Processing fees. Shopify Payments takes roughly 1.5–2.9% + a fixed fee per transaction. On the summary you only see the net.
- Refunds. A refund is money leaving a payout. If a customer is refunded, that amount is subtracted — even the original processing fee is usually not returned to you.
- Chargebacks & disputes. A disputed charge is pulled back, often with a dispute fee on top, and it can land in a completely different payout than the original sale.
- Reserves held and released. Shopify may hold back a percentage of your sales as a rolling reserve and release it weeks later. A period looks short when funds go in, and fat when they come back out.
- Timing — different clocks. Orders count when they happen; payouts count when money moves. A late-month sale, or a refund on an old order, routinely falls into the next payout window and breaks a same-month comparison.
- Currency conversion (FX). If a customer pays in a currency different from your payout currency, there's a conversion line and a small FX spread — money that never shows up in your sales total.
- Negative balance carryover. If refunds and fees exceed sales in a slow period, the shortfall is carried into your next payout, quietly shrinking it.
- A second gateway (PayPal, etc.). Sales processed outside Shopify Payments don't appear in your Shopify payouts at all — they settle separately, so your bank total and your Shopify payout total will never line up on their own.
How to reconcile it properly (the clearing-account method)
Stop matching payouts against individual orders — they're on different clocks and will never tie. Instead, run everything through a Shopify clearing account:
- Sales and refunds post to clearing.
- Fees post to an expense account.
- The payout is just a transfer from clearing into your bank.
The clearing balance at any moment is your in-transit total, and every bank deposit reconciles to the penny — because you booked it from the Transactions rows, not from a summary.
When it's genuinely Shopify's mistake
Sometimes the gap is real: merchants have found deposits that were short by five figures. If, after accounting for every line above, the Transactions export still doesn't add up to what hit your bank, that CSV is exactly what you take to Shopify support — it turns 'your numbers feel wrong' into 'this specific line doesn't match', which is a lot harder to wave away.
Let NetClear do it for you
Upload your payouts export and NetClear rebuilds each deposit, tells you in plain English every reason it doesn't match your sales, and flags the payouts worth a second look.
Try it on your payout — free →Free while in early access · no card, no signup · your file is only ever read, never changed
Frequently asked
Why is my Shopify payout less than my total sales?
Because a payout is your sales minus everything Shopify takes out before the money reaches your bank: processing fees, refunds, chargebacks, held reserves, negative-balance carryover and, outside the US, currency conversion. Total Sales is counted when the order is placed; the payout is counted when the money actually moves — so the two are never meant to be equal.
Where can I see a full breakdown of a Shopify payout?
In your admin go to Finances → Payouts, open a payout, then Export → Transactions. The CSV lists every line that makes up the deposit — charge, refund, dispute, fee, adjustment, reserve, payout — each with gross, fee and net. The payout total is the sum of those rows, so it always ties out.
How do I reconcile Shopify payouts in QuickBooks or Xero?
Use a Shopify clearing account. Post sales and refunds to clearing, post fees to an expense account, and record the payout as a transfer from clearing into your bank. The clearing balance at any moment is your in-transit total, and the bank deposit matches to the penny.
Does Shopify pay out the VAT or sales tax my customers paid?
Yes — tax collected is part of the order total and is included in the payout, it just isn't shown as a separate line on the payout summary. If your deposit looks short by roughly your tax amount, check the Transactions export and your tax reports for the same date range before assuming it was withheld.
How long should reconciling payouts take each month?
Done by hand from spreadsheets it can take anywhere from an hour to a full day, especially with refunds and reserves crossing month-end. Working from the Transactions CSV — or a tool that reads it for you — turns it into minutes.