If you have ever exported your Shopify sales report, then stared at your bank deposits, and wondered why the two numbers refuse to agree, you are running into the single most common reconciliation trap in ecommerce accounting. The sales report is organized by order date. The deposits are organized by payout date. These are two different clocks measuring two different events, and treating them as interchangeable will make your books look broken when they are perfectly fine.
This guide walks through exactly what each date means, why they drift apart, and how to reconcile them without losing your mind — with a fully worked example you can copy.
What order date and payout date actually measure
Order date is the timestamp on the sale itself. A customer checks out, Shopify records the order, and that moment stamps your Gross, Net, and Total sales figures. It is the answer to "how much did we sell, and when?" This is the clock your revenue, your cost of goods, and your ad-spend comparisons should run on.
Payout date is when Shopify Payments settles a batch of money into your account. It answers a completely different question: "how much cash actually moved, and when did the bank see it?" A payout is not a mirror of a day's orders — it is a batch of balance transactions that happened to clear together.
Those balance transactions include captured charges, but also refunds you issued, chargeback debits, processing fees, and reserve adjustments. Bundle all of that into one deposit and you get a number that will rarely, if ever, equal any single day's sales.
Why the mismatch is structural, not a bug
The reconciliation error nearly every first-time seller makes is assuming "that day's sales minus fees equals the payout." It doesn't. Three things break that equation:
- Timing offset. An order placed today is captured today, but the cash settles later. By default Shopify pays out daily, but the deposit reaches Shopify Balance around the next business day and takes an extra two to three business days over ACH to hit an external bank, according to Webgility. Weekend and holiday orders batch to the next business day, so a Saturday sale can land in a Tuesday payout.
- Different contents. A payout may include a refund on an order from last week and a chargeback on an order from last month. Those adjustments have nothing to do with today's order date.
- Missing sales. Orders paid through third-party gateways like PayPal never enter Shopify Payments at all, so they never appear in a Shopify payout — even though they very much appear in your order-date sales report.
Put those together and you have two ledgers that were never designed to match line for line. The goal of reconciliation is not to force them equal — it is to account for every difference.
The four gaps between order date and payout date
Here are the specific reasons a payout deposit diverges from the sales it supposedly represents. Understanding these is most of the battle.
1. Processing fees come out before the cash lands
Every card charge loses a processing fee before it settles. For US online sales, Shopify Payments charges roughly 2.9% plus 30¢ on the Basic plan, dropping to about 2.7% on Grow, 2.5% on Advanced, and 2.25% on Plus, per ReportPundit's fee summary. International cards add roughly another 1%. So your payout is always smaller than your captured sales by the fee — and the fee never shows up as a line in the sales report, only in the payout.
2. Refunds land on the payout date, not the order date
When you refund an order, Shopify reduces Net and Total sales — but it does so against the original order date. The cash, however, is clawed back from whatever payout is settling when you issue the refund. So a refund on a two-week-old order quietly shrinks this week's deposit while touching a sales figure from two weeks ago. This is one of the biggest reasons the two clocks desynchronize. Refunds also distort your ad math, which is why we cover how refunds should flow through ROAS calculations separately.
3. Chargebacks and disputes debit a later payout
If a customer disputes a charge, Shopify pulls the disputed amount out of a future payout and adds a dispute fee of about $15 per case in the US, according to Webgility. That debit hits the payout date it settles on, with no relationship to the original order date at all.
4. Reserves and adjustments shift cash across dates
Higher-risk accounts may have a rolling reserve — Shopify holds a slice of each payout and releases it later. Money earned on one order date can therefore be deposited across several payout dates.
A worked example: one week, two clocks
Say you run a print-on-demand mug store. In one week you take 100 orders, each averaging $40 in product + $5 shipping + $4 tax = $49 total. Eight of those buyers later request a refund, and one files a chargeback.
Here is what your order-date sales report shows for the week:
- Gross-ish total sales: 100 × $49 = $4,900
- Minus 8 refunds at $49 each: −$392
- Net/Total sales after refunds: $4,508
Now here is what actually lands as the payout for the same period. The arithmetic below is a plain worked calculation, not a market claim:
- Captured charges: 100 × $49 = $4,900.00
- Minus processing fees (2.9% + $0.30 on each of 100 orders): −$172.10
- Minus 8 refunds at $49: −$392.00
- Minus 1 chargeback fee: −$15.00
- Net payout deposited: $4,320.90
So for one clean week of 100 real orders you now have three different "sales" numbers: $4,900 in gross sales, $4,508 in total sales after refunds, and $4,320.90 actually banked. None of them is wrong. They answer different questions on different clocks.
And that $4,320.90 might not even arrive in one deposit — the refunds and the chargeback could settle on a later payout date than the original charges, splitting the week's cash across two or three bank deposits.
How to reconcile order date against payout date
You reconcile by matching each payout to its underlying balance transactions, not to a day of orders. The workflow:
- Pick your source of truth by question. For "how much did we sell and profit," use order-date sales. For "how much cash is in the bank," use payout-date transactions. Never cross the streams.
- Reconcile at the transaction level. Open each payout and confirm it equals the sum of its charges, minus fees, minus refunds, minus disputes, plus or minus adjustments. That total should reconcile to the penny. If it doesn't, you have a genuine discrepancy worth chasing.
- Exclude third-party-gateway orders. Pull PayPal and other non-Shopify-Payments orders out before you compare, since they settle in their own systems.
- Watch the definitions. Remember that Shopify's Net sales means Gross minus discounts and returns — not minus fees. Fees live only in the payout. This is the same class of definition trap that makes sellers unsure whether tax is included or excluded in Shopify reports and how shipping revenue shows up in sales reports.
If you want the full playbook for lining up every data source — sales, payouts, ad platforms, and gateways — start with our guide to reconciling your ecommerce data. And because ad platforms report conversions on the click date rather than the order date, it is worth confirming your Facebook pixel is actually tracking purchases before you trust any cross-tool comparison.
Where per-order profit fits in
The reason any of this matters is profit. Order date tells you what you sold; payout date tells you what you kept after fees and refunds. Neither one, on its own, tells you what each order actually earned once product cost, shipping, ad spend, and processing fees are all subtracted.
That is the gap PodVector is built to close. It connects Shopify, Meta Ads, Google Ads, Printify, and Printful, then computes true per-order profit across all of them — so the order-date revenue and the payout-date cash are already tied together for you. Victor, its AI operator, analyzes that live data and, with your approval, can take Shopify-side actions on it. Victor is not a dashboard; he reads your ad data and proposes moves, but he does not touch your ad account. The point is simple: stop hand-reconciling two clocks in a spreadsheet and let the profit math run on both automatically.
FAQs
Why doesn't my Shopify payout match my sales?
Because a payout is a batch of balance transactions, not a day of orders. It nets out processing fees, refunds issued in the period, chargeback debits, and reserve adjustments, and it excludes any orders paid through third-party gateways like PayPal. "Sales minus fees equals payout" is the classic reconciliation error — the real formula also subtracts refunds and disputes that may belong to entirely different order dates.
Should I report revenue by order date or payout date?
Report revenue, cost of goods, and profit by order date — that is when the economic event happened, and it is the source of truth for how much you sold. Use payout date only for cash-flow reconciliation, to confirm the money that actually reached your bank matches the transactions behind it.
Why did a payout come in smaller than the day's orders?
Most likely a combination of processing fees skimmed off each charge, one or more refunds issued that day against older orders, and possibly a chargeback debit or a reserve hold. Any of these can shrink a deposit below the sales it appears to represent, and refunds and disputes often trace back to order dates from weeks earlier.
Can I make order date and payout date reconcile exactly?
Not as a single number, and you shouldn't try. Instead, reconcile each payout against its own list of balance transactions — charges minus fees minus refunds minus disputes plus or minus adjustments. That total should match to the penny. The order-date sales report and the payout deposit will still differ, and that difference is fully explained by fees, refunds, timing, and gateway split.
How long after an order does the cash actually arrive?
Shopify's default schedule is daily, with funds reaching Shopify Balance around the next business day and taking an additional two to three business days over ACH to reach an external bank, per Webgility. Weekend and holiday orders batch to the next business day, so the payout date for a given order date can land several days later.