
Why Don't My Shopify Payouts Match My Sales in Xero?
Why your Shopify payout is lower than your sales in Xero: fees, refunds, timing and other gateways, and a clearing account method to reconcile the gap.
Published 20 November 2026
You sold a healthy amount on Shopify last week, but the deposit that landed in the bank looks smaller. Then you open Xero and the sales figure does not match the payout either. It is one of the most common questions ecommerce owners ask, and the good news is that the gap almost always has an explanation.
A payout is not your sales. It is your sales after a series of deductions and timing differences. Once you can see each piece, the numbers line up.
Why the payout is lower than the sales
- Payment processing fees. Each card transaction attracts a fee, and it is taken out before the money reaches you. Your sales are recorded at the full amount, so the payout is lower by the total of those fees.
- Refunds. A refund issued this week can be taken out of this week's payout, even if the original sale was weeks ago.
- Chargebacks and disputes. If a customer disputes a payment, the amount (and sometimes a dispute fee) can be held back until it is resolved.
- Timing. Payouts follow a schedule. Orders placed late on a Sunday may be paid out with the following period, so a week of sales rarely equals a week of deposits.
- Other payment methods. PayPal, buy now pay later providers and gift cards settle separately, or not at all in cash. Their sales sit in Shopify but their money arrives through a different channel.
- Discounts, shipping and GST. If your sales figure in Xero is recorded before discounts, or without shipping income, or with GST treated differently, the totals will drift apart even when the cash is right.
Why Xero shows something different again
How sales reach Xero depends on how the store is connected. Some businesses post each order, some post a daily summary, and some only record the bank deposit. If only the deposit is recorded, Xero shows net payouts as income, which understates sales and hides your fees completely. If orders are posted in full but fees and refunds are not, the bank will never reconcile cleanly.
The clearing account method
The most reliable way to make Shopify and Xero agree is a clearing account. It works like a holding bay between the store and the bank.
- Record gross sales (and the GST on them) into a Shopify clearing account, not straight into the bank.
- Record processing fees, refunds and chargebacks against the same clearing account, each to its own expense or income line.
- When the payout lands in the bank, match it to a transfer out of the clearing account.
- Repeat for each payment channel, so PayPal and other providers have their own clearing account.
If everything is recorded, the clearing account balance at any point equals the money that is still on its way to you. If the balance keeps growing, or goes negative, something has been missed.
Use the payout report, not the sales report
Shopify's payout reporting breaks each deposit into its parts: charges, refunds, fees and adjustments. Reconciling payout by payout, rather than week by week, removes most of the timing confusion, because each deposit has a clear list of what is inside it.
What to check each month
- The clearing account balance matches payouts in transit at month end.
- Fees are recorded as an expense, not netted off sales.
- Refunds and chargebacks are recorded in the month they happen.
- Gift card sales are treated as a liability until they are redeemed.
- Each payment channel has its own clearing account and reconciles to its own deposits.
This is part of the monthly reconciliation we do for ecommerce clients, alongside daily account updates and weekly client reporting. It means your sales, your fees and your margin are all visible, instead of disappearing inside a single deposit line.
The short version
Your payout is sales minus fees, refunds and disputes, shifted by timing and split across channels. Record the gross sale, record every deduction, and let a clearing account show you what is still in transit.
iKeep is an Australian bookkeeping and payroll team that works as an extension of your business, and untangling ecommerce payouts is part of our everyday work. If your Shopify numbers have not matched for a while, book a free 15-minute Discovery Call to talk through your store and how your books are set up.



100+100+ accountants trust iKeep
Want books you can actually trust?
Reading is a good start. Let iKeep keep your books complete, current and accurate — so the numbers are always right.
More on Bookkeeping
New Financial Year Checklist: 5 Smart Moves After EOFY
New financial year checklist for Australian small businesses: discover 5 practical steps to review performance, improve cash flow and plan for the year ahead.
Read more10 Things Disruptive Founders do Better Than Anyone Else
Imagination, persistence and integrity are vital, but the best founders I know possess a unique DNA. Here are some habits of successful entrepreneurs.
Read more$15.3 Million in Penalties for Sushi Restaurant Chain and Director for Serious Breaches
A director and CEO of a group of four sushi restaurants, operating across New South Wales, the ACT, and the Northern Territory (Sushi Bay Group), has been hit with a $1.6 million penalty by the Federal Court of Australia
Read more