Why the Shopify payout never matches the sales report

Every e-commerce founder has had the conversation. The Shopify dashboard says the week did a certain number. The bank shows a deposit that is lower, sometimes by a lot, and on a different day. The bookkeeper posts the deposit as sales because that is the money that arrived, and at the end of the year the profit and loss says something nobody quite believes.

Nothing is wrong with Shopify, and usually nothing is wrong with the bank. The two numbers measure different things. The sales report counts orders. The payout is what is left of those orders, and of some earlier ones, after everything the platform and the card networks take out along the way.

What sits between the order and the deposit

A payout is a net figure. Between the customer clicking "buy" and the money landing, several things happen to it:

• Processing fees come off every order, at a percentage plus a fixed amount per transaction.
• Refunds issued this week reduce this week's payout, even when the original order was paid out a month ago.
• Chargebacks take the disputed amount back, plus a dispute fee, often weeks after the sale.
• Holds and reserves delay part of the money when a platform decides it wants a cushion.
• Sales tax and shipping the customer paid are inside the deposit, but only one of them is income. Sales tax collected is money you owe the state.
• Timing. Payouts run on business days, so a weekend's orders arrive together, and the orders in one payout do not line up with a calendar week or a month end.

Amazon takes the same idea further. A seller receives one net number every 14 days, with sales, refunds, referral and FBA fees, storage, advertising, reimbursements and reserves netted together into a single deposit, as its settlement guides report.¹

One payout, taken apart

Here is one week of a Shopify store, with illustrative figures:

If the bookkeeper posts $11,598 as sales, three things go wrong at once. Sales are overstated by the tax, which is a liability, and understated by the fees, which never appear anywhere. The refunds disappear inside a net number, so nobody can see the return rate. And every month the fees grow with the business without a line in the P&L to show them.

The correct entries tell a different story. Net sales are gross sales less discounts and refunds. Shipping income sits on its own line. The $610 is a liability until it is paid to the state. The $362 and the dispute fee are expenses, and the chargeback itself is a loss worth tracking. Only then does gross margin mean anything.

The fix is a clearing account per gateway

The pattern that holds up is a clearing account for every way money reaches you: Shopify Payments, PayPal, Amazon, a wholesale portal, and any buy-now-pay-later provider.

Each order summary is posted into that clearing account at its gross amounts, split into sales, discounts, shipping, tax, fees and refunds. Tools such as A2X and Link My Books produce those summaries from the platform data, one entry per payout or settlement. When the deposit arrives, it is matched against the clearing account, and the account goes back to zero.

What remains in each clearing account at month end should be explainable in one sentence: orders captured in the last days of the month that pay out in the first days of the next. Anything else, a balance that grows month after month, is money that was earned and never arrived, or arrived and was never explained. That is where missing reimbursements and unreconciled chargebacks hide.

Why it matters beyond the tidy ledger

Clean payouts are the foundation for every number an online brand needs next. Contribution margin by channel needs the fees on their own lines. A return rate needs refunds recorded as refunds. Sales-tax exposure by state needs tax collected kept apart from revenue, so that the records your accountant or your tax tool works from are right. And a lender reading your statements wants revenue that ties to the order data, not to the deposits.

It also changes the monthly conversation. Instead of "why is the P&L lower than Shopify", the question becomes "why did processing fees rise as a share of sales" or "which SKU drove the refunds", which are questions with answers.

How we handle it

At MTL Services, the E-commerce settlement reconciliation (Shopify / Amazon) add-on covers this work every month: the clearing accounts set up and kept at zero, each payout and settlement tied to the bank, fee lines separated, and the exceptions listed with the package. It is $600/mo and adds 3 hours to your package's included hours, so the time shows on your usage statement like everything else.

If you are not sure how far your payouts are from reconciled, ask in a free consult; it takes 30 minutes. No pitch. You get a one-page note on what we heard and what we would propose.

Sources

1. Nova Analytics, “Amazon Settlement Report: How to Read and Reconcile It in 2026”, 2026. A vendor figure, reported rather than measured. ↑