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

The 60-second answer: your payout is your sales minus fees, refunds, chargebacks and held reserves — and it's counted on a different clock than your sales, so the two are never meant to be equal. The Finances → Payouts → Transactions export breaks every deposit into its parts, and by definition it ties out to the penny.

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.

  1. In your Shopify admin, open Finances → Payouts.
  2. Click into the payout you want to understand.
  3. Choose Export → Transactions (not the summary).
  4. 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

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:

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.