Try Pro free for 14 days. No card needed.Start free

    Why your Shopify payout never matches your sales report — the reconciliation math for resellers

    Shopify's bank deposit almost never equals the sales total for the same date range, and it isn't an error. Here's how Shopify Payments actually batches, delays, and nets payouts against refunds and chargebacks — and which report is the one to reconcile against.

    Pull up your Shopify sales for last Tuesday, then check what actually hit your bank account for that date, and the two numbers won't match. Not because something's wrong — because a Shopify payout isn't a receipt for one day's sales. It's a net settlement of a rolling balance, and refunds, chargebacks, and the payout delay itself all move money between periods in ways a daily sales report doesn't show you. eBay sellers run into the same mismatch for different reasons; this is the Shopify-side version, and it trips up the same resellers who already figured out eBay's version.

    The delay: payouts aren't same-day

    Shopify's own payout documentation puts the minimum settlement time for US accounts at 3 business days between a transaction processing and that transaction's money landing in a payout — longer if your account is on a weekly, monthly, or risk-adjusted schedule rather than the standard rolling one. Weekend transactions don't each get their own payout either: Shopify documents that captures from Friday, Saturday, and Sunday are consolidated and sent out together as a single payout, not three. A newer or higher-risk account can be held to a custom schedule of 5 to 20 business days instead of the standard rolling basis, and Shopify's own help pages are the place to confirm which schedule your account is actually on — Settings → Payments → Payouts shows the live setting, not a default you can assume.

    On top of the settlement delay, your bank adds its own processing time — Shopify's documentation gives a typical range of 1 to 3 more business days once the payout leaves Shopify — so the gap between a sale and the deposit for it can run a week even when nothing is wrong.

    The netting: refunds and chargebacks don't subtract from the original sale

    This is the part that actually breaks a same-day reconciliation. A payout isn't "this week's sales minus this week's fees" — it's gross sales minus processing fees, refunds, and chargebacks that cleared *during the payout period*, regardless of when the original sale happened. Refund an order from three weeks ago today, and that refund comes out of today's payout, not a retroactive correction to the payout the original sale was part of. A sales report pulled by sale date and a payout pulled by deposit date are answering two different questions, and matching them line-by-line only works if nothing was ever refunded, disputed, or adjusted — which on a real store, something usually has been.

    Chargebacks carry their own extra line: Shopify's own documentation lists a $15 dispute fee for US-dollar accounts, refunded back to you if you win the dispute. That fee comes out of a payout too, separately from the disputed sale amount itself, and the amount shifts if your account settles in a different currency — worth confirming in your own Payments settings rather than assuming $15 applies.

    The edge case worth knowing before it surprises you: if refunds and chargebacks in a given payout period add up to more than the new sales processed in that same period, Shopify doesn't pull the difference from your bank account. It deposits nothing for that payout and carries the negative balance forward into the next one instead — so a payout can come in at $0 on a week where your sales report shows real revenue, if enough of that revenue got refunded before the payout cleared.

    A worked example

    Say in week one you sell $900 across a handful of orders, all paid by card through Shopify Payments. Standard 3-business-day settlement, no weekend complications. Payout: roughly $900 minus that week's processing fees — 2.9% + $0.30 per order on the Basic plan — lands a few days later, close enough to a straight calculation that it's easy to assume the math always works this cleanly.

    Week three, a buyer disputes a $150 order from week one. Shopify resolves it against you. That payout period now has $150 pulled back out plus a $15 dispute fee, on top of whatever week three's actual new sales were. If week three was a slow week — say $100 in new sales — the payout for that period isn't $100 minus fees. It's $100 minus fees minus $165, which goes negative and carries forward instead of hitting your bank at all. Your sales report for week three still correctly shows $100 sold. Your bank shows nothing. Neither number is wrong; they're just not measuring the same thing.

    What to actually do

    • Reconcile against the Payments → Payouts report, not the Orders report.
    • Each payout in that report expands into exactly the transactions, fees,
    • refunds, and adjustments that made it up — that's the actual unit to
    • match against a bank deposit, not a calendar date.
    • Don't plan cash flow around a sale's date. A sale that happened this
    • week can still be the one that makes next week's payout smaller, if it
    • gets refunded or disputed before the payout clears.
    • **Check your actual payout schedule rather than assuming the standard
    • one.** A new account, a flagged account, or a non-US settlement currency
    • can all run on different timing than the 3-business-day default.
    • Expect a $0 payout occasionally and don't treat it as a failure. On a
    • slow sales period with a refund or dispute landing the same week, a $0
    • or negative-carried payout is the system working as designed, not a
    • missed deposit.

    PalmFlow imports your Shopify orders and sales automatically, but it doesn't hold the Payments scope Shopify requires to read your actual processing fees or payout batches — rather than guess, it stores that fee as a placeholder and lets the fee calculator estimate it from Shopify's published rate schedule, no signup required to check a number before it happens. For the real payout amounts, timing, and dispute fees, Shopify's own Payments → Payouts report in your admin is the actual source of truth, and it's worth checking there directly rather than expecting any sales-tracking tool, PalmFlow included, to reproduce it from the orders API alone. Free plan, 50 items, no card.

    Disclaimer: this is general information, not financial advice. Shopify Payments' settlement timing, dispute fees, and payout scheduling are Shopify policy, not law, and can change or vary by account, country, and settlement currency — confirm your own numbers in Settings → Payments before relying on anything above for cash-flow planning.

    Built for the business you actually run.