MCKI Blog · E-Commerce Bookkeeping

Why Your Shopify Payouts Never Match Your Sales Report

If your Shopify payout never matches your sales report, nothing is missing. The two numbers answer different questions. Your sales report totals what you sold, by order date. Your payout totals what actually cleared into your bank, by settlement date, after fees, refunds, and any holds already came out. Here are the beliefs that trip up most store owners I talk to, and what is happening under each one.

Five reasons the two numbers don't line up

"Today's payout should match today's sales."

It won't, and that's by design. A sale doesn't become payable cash the moment the card is charged. Shopify Payments holds it for a settlement period: 3 business days in the US, Canada, the UK, and most of Europe, longer in a handful of other countries. Sales from Friday, Saturday, and Sunday get grouped and paid out together instead of as three separate payouts. Monday's deposit is really Friday through Sunday's sales, still working through settlement, while today's own sales won't show up in a payout until later in the week. You're comparing two different days without realizing it.

"The processor is taking more than it should."

Your processing rate comes out before the money reaches your bank. On Shopify Payments, that rate depends on your Shopify plan and whether the card is domestic or international, with no separate transaction fee added on top. A $100 sale was never going to land in your account as $100. You can see your exact rate under Settings, Payments, Manage, Standard rates, or open any individual payout for the fee breakdown on that specific deposit.

"A refund should reduce the payout for the sale it was on."

Refunds don't work that way. Shopify deducts a refund from your next available payout instead of the one the original sale belonged to. Refund a $50 order from three weeks ago, and this week's payout drops by $50 with no obvious tie to anything you sold this week. Chargebacks work the same way, with a dispute fee added on top. When I see a payout that looks light for no reason, this is usually why.

"A negative payout or a reserve means something went wrong."

Neither one does. If refunds and chargebacks in a period add up to more than that period's new sales, the balance goes negative, and instead of depositing money, Shopify pulls the difference back out of your bank account. A reserve is different: a temporary hold Shopify places on newer accounts, accounts with a sudden jump in volume, or business models with a higher dispute rate, to cover disputes that have not happened yet. Both are standard account controls, and a reserve usually eases as the account builds a track record.

"My accounting software already handles the difference."

Check that before you assume it. Some Shopify connectors book each order as income at its gross amount. If your bank feed also posts the incoming payout as income, you have recorded the same revenue twice, once gross and once net. The gap between the two totals then looks like a bookkeeping error, when it is really a setup problem in how the connector and the bank feed were left to run independently of each other.

The fix is a clearing account, not another look at the bank feed

Once the sales and payout numbers are understood as two different things, the fix itself is straightforward. Book each order at its full amount into a clearing account instead of posting it straight to the bank. When the payout lands, post the fees, refunds, and any chargebacks out of that same clearing account, using the numbers from Shopify's own payout or balance-activity report. Match only the net payout total against the bank deposit. Done consistently, the clearing account sits at zero except for orders still working through settlement. If you use Stripe directly instead of Shopify Payments, pull Stripe's own payout report and use the same approach. Stripe typically pays a new account's first payout within 7 to 14 days, then settles on a 2-business-day schedule after that in the US.

Sources

These are the Shopify and Stripe pages I used for the numbers above.

About me — I'm Mike Lee. I've spent more than 20 years in accounting — controller-level work before opening my own practice — and I'm a QuickBooks Certified ProAdvisor based in Chino Hills, California. More about me and how I work →
The next step

A Shopify clearing account that's drifted for months can still be brought current.

Send me a recent payout report and your bank statement, and I will tell you honestly how far off the numbers are and what it would take to tie them out.

Book a Free Call With Me Not ready? Run the 2-minute books check