If you run a store with real sales history, you have seen it. Shopify says you did $3,990 this week. The deposit reads $3,578.79. Nothing is broken — that difference is exactly what the payment reconciliation process exists to account for.
This guide walks the process the way an operator runs it, with real payout math, not the generic "gather your documents" checklist you find everywhere else.
What is payment reconciliation?
Payment reconciliation is the accounting process of matching a payment you received against the orders, fees, and adjustments behind it, so your books agree with your bank.
For a store, the "reconciliation payment" question is really three questions at once. Did every order actually get paid? Where did the money that didn't show up go? And how much of the deposit is yours to keep?
Generic finance guides answer only the first. They treat reconciliation as a tidy loop: pull records, match transactions, flag discrepancies, resolve them. That loop is correct — it just stops right before the part that matters to a store owner.
Why your payout never matches your sales
Here is the twist the top-ranking articles skip. Your Shopify payout is not a day's sales minus fees. It is a batch of balance transactions — captured charges, refunds, chargeback debits, and adjustments — that happened to settle together.
That means a single payout almost never maps to a single day of orders. A payout schedule defaults to daily, hits a Shopify Balance account around the next business day, and takes two to three more business days to reach an external bank by ACH, so weekend orders batch forward, per Webgility's breakdown of Shopify payouts.
Three things eat the gap between what you sold and what you banked:
- Processing fees. Shopify Payments charges roughly 2.9% + 30¢ per transaction on the Basic plan in the US, dropping to about 2.5% + 30¢ on Advanced and 2.25% + 30¢ on Plus, with international cards adding around 1%, according to ReportPundit's payout guide.
- Refunds. When you refund an order, Shopify lowers your net sales and the payout, but the original charge still happened — so the refund shows up as a deduction, not a disappearance.
- Chargebacks and disputes. A disputed charge is debited from your payout, plus a fee of about $15 per dispute in the US, per Webgility.
None of these is an error. They are the reconciliation line items. Your job is to confirm each one, not to make the numbers equal.
If you also sell through PayPal or another gateway, those orders never enter the Shopify Payments payout at all — a point worth understanding before you compare processors in Stripe vs PayPal fees.
The payment reconciliation process, step by step
Step 1: Pull your three sources
You need the sales report, the payout report, and the per-order cost data. The sales report (Shopify Finance) is your source of truth for how many orders happened and how much revenue they carried. The payout report is your source of truth for cash in the bank.
Step 2: Understand the sales report's three tiers
Shopify splits revenue into Gross, Net, and Total sales, and mixing them up is the most common reconciliation mistake. Gross sales is price times quantity before deductions. Net sales subtracts discounts and returns. Total sales adds shipping and tax back on, per the Shopify Help finances report documentation.
The trap: Gross minus expenses does not equal Net. Net is defined by discounts and returns only — fees never appear in the sales report. Fees live in the payout.
Step 3: Match the payout to balance transactions, not to a day's orders
Open the payout and reconcile it against its balance transactions: the captured charges, the refunds issued that period, any chargeback debits, and reserve adjustments. This is the step where "Shopify payout doesn't match sales" stops being a mystery.
Step 4: Resolve what's left
Anything still unexplained is a genuine discrepancy — a missing capture, a payout held in reserve, a gateway order that settled elsewhere. Flag it, trace it, and document the fix. Clean records here are what make tax season and audits painless.
Step 5: Carry it through to profit
This is the step every generic guide leaves out, and it's the only one that changes a decision. We'll walk it with real numbers below.
A worked example: reconciling one week of payouts
Say your store runs about 380 orders a month at a $42 average order value (subtotal plus shipping and tax). In one week you book 95 orders, refund 6, and eat one chargeback. Here's the reconciliation.
Your sales report shows 95 orders × $42 = $3,990 in total sales. Subtract the 6 refunds at $42 each ($252), and net/total sales land at $3,738.
Your payout is a different number. Using the Basic-plan rate of 2.9% + 30¢ from ReportPundit, the math runs:
| Line item | Amount |
|---|---|
| Captured charges (95 × $42) | $3,990.00 |
| Processing fees (2.9% + $0.30 × 95) | −$144.21 |
| Refunds issued (6 × $42) | −$252.00 |
| Chargeback fee (1 dispute) | −$15.00 |
| Net payout deposited | $3,578.79 |
Fee and chargeback rates per Webgility; rates are volatile, so confirm against your own plan before you rely on them.
Now reconcile the two. Net sales of $3,738 minus the $144.21 in fees minus the $15 chargeback equals $3,578.79 — exactly the deposit. The gap is fully explained, and you've confirmed every order was paid.
Step 5, continued: what did you actually keep?
The payout still isn't profit. Say your blank costs from Printify average $18 per order and you spent $900 on ads that week. Subtract 95 × $18 = $1,710 in product cost and $900 in ad spend from the $3,578.79 deposit, and you're left with about $968.79 — roughly $10.20 of real profit per order.
That number is the reason reconciliation matters. A store watching only the $3,990 sales figure thinks it's doing far better than the $968.79 says. For a deeper walkthrough of tying every source together, see the hub on reconciling your ecommerce data.
Doing this every week without losing a day
Reconciling one week by hand is tedious but doable. Doing it every week, across refunds, chargebacks, supplier price changes, and ad spend, is where most operators quietly fall behind — and where the platform-reported numbers start to drift from reality, a problem explained in Stripe fees in the Czech Republic for stores selling cross-border.
This is the work Victor does. Victor is an AI employee for your store, not a dashboard. He connects to Shopify, Meta Ads, Google Ads, and your Printify, Printful, or Gelato account, so he sees every order, every ad dollar, and every supplier cost in one place.
From that, Victor computes the true per-order profit — the $10.20 figure above — for every SKU, and delivers the report straight to your Google Drive. He also reprices the thin-margin products and pauses the ad sets that are quietly losing money, because he already knows the real number behind each order.
If you'd rather compare purpose-built tools first, the guide to payment reconciliation software breaks down the options.
Ready to stop reconciling by hand? Put Victor to work on your store.
FAQs
What is payment reconciliation in simple terms?
It's checking that the money in your bank matches the sales your store recorded, and explaining any difference. For a store, the difference is almost always processing fees, refunds, chargebacks, and payout timing — not a mistake.
Why is my Shopify payout less than my sales?
Because a payout is sales minus processing fees, minus refunds issued that period, minus any chargeback debits and reserve holds. Shopify Payments fees run around 2.9% + 30¢ per order on the Basic plan per ReportPundit, and refunds plus a roughly $15 dispute fee come out on top of that, per Webgility.
How often should an operating store reconcile payments?
Reconcile at least weekly if you're running paid ads, since fees and refunds move fast and a bad week is cheaper to catch early. Monthly is the minimum for any store with real volume. The payout report arrives roughly daily, so you always have fresh data to work from, per Webgility.
Does the reconciliation payment number tell me my profit?
No. The payout is cash after fees and refunds, but before product cost and ad spend. You only see true profit once you subtract what you paid your supplier per unit and what you spent acquiring the order — which is exactly the step this guide walks through.
What's the difference between gross, net, and total sales?
Gross sales is price times quantity before any deductions. Net sales subtracts discounts and returns. Total sales adds shipping and tax back on, per Shopify's finances report docs. Fees never appear in any of them — they're a payout deduction, which is why "gross minus expenses equals net" is wrong.
What if I sell through PayPal too?
Orders paid through PayPal or another third-party gateway never enter the Shopify Payments payout, so you reconcile them separately against that gateway's own report. Lumping them together is a common reconciliation error worth avoiding.