Why Your Shopify Payouts Never Match Your Sales

Why Your Shopify Payouts Never Match Your Sales

Short answer: A Shopify payout is a net figure, not a sales figure. The deposit that hits your bank is gross sales minus refunds, minus processing fees, minus chargebacks, minus any adjustments Shopify made that day. If you record the deposit as revenue, you understate sales, hide your processing costs entirely, and lose the ability to see your real margin. The fix is a clearing account and the payout report.

What is actually inside a Shopify payout

A single $10,000 deposit might represent $12,400 in gross orders, less $980 in refunds, less $360 in processing fees, less $1,060 in a chargeback and a reserve adjustment. Four separate economic events arriving as one number.

Book that deposit straight to revenue and four things break at once. Revenue is understated by $2,400. Processing fees, a real and growing cost of doing business, never appear on your profit and loss at all. Refunds are invisible, so you cannot see whether returns are trending up. And gross margin is quietly wrong, because the fee that should sit in cost of sales has been silently netted against the top line.

The problem compounds. Most brands do not notice for months, because the bank reconciles perfectly. The cash is right. Only the story is wrong.

Why the timing never lines up either

Shopify pays on a rolling schedule. An order placed on the 30th of the month is often paid out on the 2nd or 3rd of the following month. That means every month end carries a balance of sales that have happened but not yet been deposited.

If you recognize revenue when cash lands, you have moved several days of sales into the wrong period. For a brand doing $200,000 a month, a three day lag is roughly $20,000 sitting in the wrong month, every month. Comparisons become meaningless and any growth rate calculated from those numbers is noise.

The clearing account, and why it fixes both problems

A clearing account is a balance sheet account that holds money in transit between the sale and the bank.

The flow is simple. When an order is placed, revenue is recognized and the amount is debited to the Shopify clearing account. When the payout arrives, the clearing account is credited for the gross, and the fees, refunds and adjustments are each booked to their own account. The bank is debited for the net.

Done correctly, the clearing account balance at any moment equals the money Shopify holds that has not yet been paid to you. That balance becomes a live control number. If it drifts from what Shopify says is pending, something is wrong and you know it that month rather than at year end.

How to reconcile a payout, step by step

1. Pull the payout report, not the order report. In Shopify, Finances then Payouts. Export the transaction level detail for the payout date. The order report will not carry fees or adjustments.
2. Total each category separately. Gross charges, refunds, processing fees, chargebacks, adjustments. These are your journal lines.
3. Confirm the net equals the bank deposit. If it does not, you are missing an adjustment. Do not proceed until it ties.
4. Book the entry. Debit bank for the net. Debit fees to cost of sales. Debit refunds to a contra-revenue account. Credit the clearing account for the gross.
5. Check the clearing balance. It should equal sales made but not yet paid out. Compare it to Shopify's pending balance.

What to look for when you first do this

The first month of proper payout reconciliation usually surfaces something. In our experience the three most common findings are processing fees running materially higher than the brand assumed, refunds that were being netted invisibly and so were never managed, and chargebacks nobody had ever seen as a line item because they were buried inside a deposit.

None of these are accounting problems. They are business problems that bad accounting was hiding.

Multi-channel makes this worse, not better

A brand selling on Shopify, Amazon and through a distributor has three settlement systems, three fee structures and three timing patterns. Each needs its own clearing account.

This is where margin by channel either exists or does not. If all three settle into one revenue line, you cannot answer the only question that matters: which channel is actually making money. Many brands discover, once the fees are separated properly, that the channel driving the most revenue is not the channel driving the most profit.

Common questions

Can I just use a single "Shopify" income account? You can, but you lose visibility into fees, refunds and timing. It reconciles to the bank and tells you almost nothing else.

Does Shopify's QuickBooks integration handle this? Some integrations post gross with fees separated, others post net. Check what yours is doing before assuming. A surprising number of brands run an integration for a year without ever verifying which method it uses.

How far back should I fix this? Usually to the start of the current fiscal year at minimum, so the year is comparable. Going further depends on whether you need prior year comparatives to be trustworthy.

Is this different for Shopify Payments versus a third party gateway? The principle is identical. The report you pull and the fee structure differ.

---

FynScale builds accounting operations for consumer brands selling across multiple channels. If your payouts, fees and channel margin are not reconciling cleanly, we can look at it.