Why your Shopify payouts don't match your bank
A plain-English guide to Shopify payout reconciliation, with a worked example and a free template.
The short answer
Your Shopify sales report shows what customers paid. Your bank shows what Shopify sent you, after taking out fees, refunds, chargebacks and adjustments, and a few days later. Until you split every payout into those parts, the two numbers will never agree.
A real-looking example (demo data)
A fictional store sold $23,488.14 in September. Only $20,064.90 of Shopify money reached the bank. Here is where the $3,423.24 went:
| Item | Amount |
|---|---|
| Shopify Payments fees | $829.66 |
| Refunds | $199.45 |
| Chargeback adjustment | $25.00 |
| Dispute fee taken from a payout, never booked | $15.00 |
| Last payout of the month, still in transit | $2,354.13 |
| Total explained | $3,423.24 |
The 6 reasons payouts do not match the bank
- Processing fees are deducted before the payout is sent.
- Refunds reduce the next payout, even for orders from earlier months.
- Chargebacks and dispute fees are pulled from a payout, often with no matching entry in the books.
- Adjustments and reserves (for example a hold on new or high-risk accounts) change the payout amount.
- Timing: payouts land one to three business days later, so month-end payouts cross into next month.
- Other gateways (PayPal, Shop Pay Installments, Amazon) pay out separately and are easy to mix up.
How to reconcile Shopify payouts, step by step
- Export Finance → Payouts from Shopify admin for the month (and the first days of next month).
- Download your bank statement for the same period as CSV.
- For each payout, find the Shopify deposit one to three days later with the same amount.
- Mark differences: a short deposit usually means a fee or dispute you have not booked yet.
- List payouts with no deposit yet as in transit and check them on next month's statement.
- In QuickBooks or Xero, post gross sales, fees and refunds to a Shopify clearing account and match the deposit.
The free template below does steps 3 to 5 automatically.
Free: Shopify payout vs bank reconciler (Google Sheets / Excel)
Paste your payout export and bank statement. Every payout is matched to a bank deposit and the gaps are flagged.
Get the free templateRelated guides
Questions
Why is my Shopify payout less than my sales?
Payouts are net of Shopify Payments processing fees, refunds, chargebacks and dispute fees, and any adjustments or reserves. Sales from the last day or two of the month are also paid out in the next period.
How long do Shopify payouts take to reach the bank?
Usually one to three business days after the payout is issued, depending on your country and bank. A payout issued on the last days of a month often lands in the next month's statement.
Should I record Shopify payouts as revenue?
No. Record gross sales as revenue, and record fees, refunds and chargebacks separately. The payout itself is a transfer from a Shopify clearing account to your bank, so it should net to zero once matched.
Can I do this in QuickBooks or Xero?
Yes. Use a Shopify clearing account: post each payout's gross sales, fees and refunds into it, then match the bank deposit against it. The template shows the same logic in a spreadsheet.
Want us to check your numbers?
A $149 Books Health Check compares your payouts with your bank and gives you a fixed quote to fix the gaps.
Book a Health Check