How to reconcile Shopify payouts to your sales
Your payout is never your sales number, and it is not supposed to be. Here is the bridge from gross sales to the amount that lands in your bank, and how to close it every week.
- A payout is a settlement, not a sales report. It covers a pay period that does not line up with your calendar month, and it arrives net of everything deducted in between.
- Five things move the number: processing fees, refunds issued since the last payout, chargebacks plus their dispute fees, platform adjustments, and the timing gap itself.
- Reconcile per payout, not per month. One payout against the orders in its pay period is a closed, checkable set. A month is not.
- If you sell on more than one channel, the work multiplies rather than adds, because every platform uses its own pay period, fee structure and adjustment names.
Your Shopify payout is not your sales number, and it never will be. It is a settlement: the amount left after fees, refunds, chargebacks and platform adjustments, covering a pay period that does not match your accounting month. The reconciliation job is not to make the two numbers equal. It is to explain the gap between them, line by line, so that the explanation holds up.
Most owners discover this the first time their bookkeeper asks why the bank deposits for the month are 6% lighter than the sales report, and nobody can produce the missing amount on demand.
Why is the payout smaller than the sales?
Five forces sit between an order and the deposit, and they act in this order.
Processing fees. Every card transaction carries a fee that is deducted before the money is paid out, and the rate depends on your plan and the card. Shopify sets these out in its pay periods and fees documentation. This is the predictable part of the gap and the only one you can model in advance.
Refunds. Shopify’s guidance on lower or missing payouts is explicit that refunds processed since the last payout are deducted from the next available one. So a refund on a January order can reduce a February payout, which is exactly the kind of cross-period movement that breaks a month-to-month comparison.
Chargebacks and dispute fees. When a customer disputes a payment, the transaction amount and the associated dispute fee both come out of your account. A single chargeback therefore shows up twice in the gap.
Adjustments. These are the ones that catch people. Shopify’s own documentation names adjustment types including chargeback_fee, chargeback_protection, shopify_collective_debit, shopify_collective_credit, seller_protection and tax_adjustment. None of them correspond to an order you recognise, which is why a payout can fail to balance even when every order in the period is accounted for.
Timing. The last one is not a deduction at all. Your payout covers a pay period set by your payout schedule, which can be daily, weekly or monthly, and that period has its own boundaries. Orders placed at the end of one period settle in the next.
What does a reconciled payout actually look like?
Work down, one payout at a time:
Gross sales in the pay period
less refunds settled in this payout
less processing fees
less chargebacks and dispute fees
plus or minus adjustments
= Net payout, which must equal the bank deposit
If that bottom line matches the deposit to the cent, the payout is reconciled and you never have to look at it again. If it does not, the difference is nearly always one of two things: an adjustment you did not know existed, or an order sitting on the wrong side of the period boundary.
The reason to work per payout rather than per month is that a payout is a closed set. Every transaction in it is knowable, the total is fixed, and the answer is either right or wrong. A calendar month is an open set that straddles pay periods in both directions, which is why monthly reconciliation produces a difference nobody can chase.
Why does this get harder with every channel you add?
Because the work multiplies rather than adds. A second sales channel does not give you two of the same problem. It gives you a second pay period calendar, a second fee structure, a second set of adjustment names, a second refund timing rule and a second export format, all of which have to be reconciled separately before anything can be consolidated.
By the third channel, the weekly reconciliation is a morning’s work, and it is the kind of morning that gets skipped when the warehouse is busy. What follows is predictable: reconciliation slips to monthly, then to quarterly, then to whenever the accountant asks. The gap stops being explainable at roughly the same moment it stops being small.
There is a second cost that owners feel before they can name it. When payouts are not reconciled, you do not know your true margin. Fees, refunds and chargebacks are real costs of the sale, and if they only ever appear as one aggregate bank movement, they never make it back to the product or the channel that caused them. You end up scaling the channel with the worst net margin because the gross number looked fine.
When is this worth automating?
The honest test is frequency times channels. One channel and a weekly payout is a spreadsheet job, and a competent bookkeeper will keep it clean.
Past two or three channels, or once payouts arrive daily, the matching becomes mechanical work at a volume no one keeps up with by hand: pull each payout, pull the transactions in its period, match them, apply the fee and adjustment lines, and surface only what fails to balance. That is a data pipeline problem with a clearly defined right answer, which is the kind that automates well and stays automated.
The principle is the same one behind what 97% reconciliation accuracy really takes: the win is not that software reads the settlement file, it is that software can tell you which three payouts out of ninety need a person. The same structure applies whether the documents are air waybills or payout reports, and the cost side of doing it by hand is set out in what manual invoice reconciliation costs.
Start with one payout
Take your most recent payout and reconcile it properly, by hand, to the cent. It will take an hour the first time. What you learn is which of the five forces actually moves your number, and that is different for every store: some are dominated by refunds, some by chargebacks, some by nothing more exotic than fees.
Then do it again next week. If the second one takes twenty minutes, you have a process. If it takes another hour and you find a new adjustment type you have never seen, you have a case for automating it.
Our free 30-minute ROI diagnostic is a working session on your channels, payout frequency and where the reconciliation time actually goes. If you sell across several storefronts and marketplaces, our ecommerce and retail solutions page shows how we scope this kind of work.
Frequently asked questions
- Why is my Shopify payout less than my sales?
- Because a payout is what remains after deductions. Shopify documents that processing fees are taken from each transaction before payout, refunds you issued since the last payout are deducted from the next one, and chargebacks are removed along with any dispute fee. On top of that, the payout covers a pay period rather than your accounting month, so some orders in the period were placed before it and some orders in your month have not been paid out yet.
- How do I reconcile a Shopify payout?
- Take one payout, list the transactions in its pay period, and work down from gross sales through refunds, processing fees, chargebacks and adjustments to the net figure. If the result equals the deposit, the payout is reconciled. If not, the difference is almost always an adjustment line or an order sitting on the wrong side of the pay period boundary.
- What are Shopify payout adjustments?
- Adjustments are entries that are not ordinary sales or fees. Shopify's documentation names types including chargeback_fee, chargeback_protection, shopify_collective_debit, shopify_collective_credit, seller_protection and tax_adjustment. They are the most common reason a payout that should balance does not, because they rarely map onto anything in your order list.
- Should we reconcile payouts weekly or monthly?
- Weekly, or every payout if the schedule is longer. A discrepancy found within days can usually be traced to a specific order or dispute. The same discrepancy found at year end is a rounding difference nobody can explain, and by then the evidence in the platform interface may have aged out of easy reach.