If your Shopify deposits never match your sales report, nothing is broken. Each payout is a bundle of many orders, less refunds, discounts and fees, and PayPal and Afterpay pay you separately on their own timetables. The fix is to record each payout in Xero as its parts, and to use a clearing account for every channel so you can prove that every dollar arrived. This guide shows how, with a worked example from a made-up store.

Why the deposits never match
Three things get in the way of a simple match between sales and the bank:
- Payouts are bundles. Shopify pays out on the schedule set in your store, such as daily or weekly. One payout covers many orders, with refunds, discounts and payment fees already taken out.
- Each channel pays separately. Shopify Payments pays into your bank. PayPal pays into your PayPal balance, which you withdraw when you choose. Afterpay sales settled through Shopify Payments arrive inside your Shopify payout, but if Afterpay settles with you directly, its settlements arrive on their own.
- Timing. An order on 30 November can be paid out on 2 December. Refunds can come out of a later payout than the sale they relate to.
If you record each deposit as "sales", your revenue is understated, your fees disappear, and refunds are invisible.
What a clearing account does
A clearing account is a holding account in Xero for money that is on its way to you. Think of it as a waiting room:
- When a payout is recorded, its parts go to the right accounts (sales, shipping, discounts, refunds, fees) and the net amount waits in the channel’s clearing account.
- When the money lands in your bank, you match the deposit against the clearing account in Xero, and the clearing account goes back to zero.
The balance is the point. If a clearing account is not back at zero at month-end, something has not been matched, and you know exactly which channel to look at. Each channel that pays you separately gets its own clearing account.
Tools such as A2X do the first step for you: they read each Shopify payout and post one summary to Xero instead of hundreds of orders. Depending on the channel and how the tool is set up, the summary is either matched straight to the deposit or held in a clearing account until the money arrives. The logic below is the same either way.
A worked example
Tidewren Linen is a made-up homewares store selling through Shopify. In one week in November it had a Shopify Payments payout, PayPal sales and Afterpay sales through Afterpay’s own gateway. All amounts include GST where it applies.
1. The Shopify Payments payout
Payout 1042, covering 3 to 5 November, was deposited on 7 November:
| Part of the payout | Amount |
|---|---|
| Product sales | A$5,180.00 |
| Shipping charged to customers | A$320.00 |
| Discounts | (A$410.00) |
| Refunds | (A$265.00) |
| Shopify Payments fees | (A$131.75) |
| Net payout | A$4,693.25 |
Recorded as one summary, each line goes to its own account, and A$4,693.25 sits in the Shopify Payments clearing account. On 7 November the deposit of A$4,693.25 appears in the bank feed, it is matched against the clearing account, and the clearing account is back to A$0.00. Sales show the full A$5,180.00, and the store can see it paid A$131.75 in fees and gave back A$265.00 in refunds.
2. PayPal
PayPal works differently, because the money sits in your PayPal balance until you withdraw it:
| PayPal clearing account | Amount | Balance |
|---|---|---|
| PayPal sales for the week | A$860.00 | A$860.00 |
| PayPal fees | (A$29.40) | A$830.60 |
| Refund paid from the PayPal balance | (A$45.00) | A$785.60 |
| Withdrawal to the bank on 10 November | (A$785.60) | A$0.00 |
The withdrawal of A$785.60 does not match any single sale, which is why so many PayPal reconciliations go wrong. Recorded step by step through the clearing account, it balances to zero.
3. Afterpay
Afterpay pays the store upfront, less its merchant fees, in its own settlements:
| Afterpay clearing account | Amount | Balance |
|---|---|---|
| Afterpay orders for the settlement period | A$1,240.00 | A$1,240.00 |
| Afterpay merchant fees | (A$71.92) | A$1,168.08 |
| Settlement deposited in the bank | (A$1,168.08) | A$0.00 |
When a clearing account will not go to zero
Back to Tidewren. At the end of November its PayPal clearing account shows A$45.00 left over. Working through the usual suspects finds the cause: the A$45.00 refund had been recorded twice, once from the PayPal report and once by hand. Removing the duplicate brings the account back to zero.
The usual reasons for a leftover balance are:
- A payout that was never matched, often because the deposit landed in the next month.
- A refund paid from somewhere else, such as a bank transfer, so the payout does not show it.
- A fee recorded twice, once in the summary and once from a bank rule.
- A chargeback or a reserve held back by the payment provider.
- Gift cards. Orders paid with gift cards bring in no new money, so they need their own treatment rather than a payout match.
A balance that is only timing, such as a payout made on 30 November and deposited on 2 December, is fine. It should clear in the first days of the next month, and you should be able to name the payout.
A month-end routine
- Make sure every payout for the month is recorded in Xero, for every channel.
- Match every deposit in the bank feed against its clearing account.
- Check each clearing account balance. Every balance should be zero or explained by a named payout in transit.
- Look into anything left over using the list above, before you close the month.
- Review fees and refunds by channel. If one channel’s fees or refund rate jumped, you want to know now, not at year end.
Xero’s own integration or A2X?
For a store with few orders and one payment channel, simpler setups can be enough. Once you have many orders, several channels, or want fees and refunds recorded accurately payout by payout, a tool like A2X saves a great deal of manual work. Whichever you use, the clearing account logic above is what keeps the books honest.
Getting help
We keep the books for Australian online brands that sell on Shopify and run Xero and A2X, with every payout reconciled and every clearing account checked before the month is closed. Read about our e-commerce bookkeeping or see our pricing.
FAQs
It is a holding account for money on its way from Shopify to your bank. A payout is recorded into it, broken into sales, refunds, discounts, shipping and fees, and the bank deposit is matched against it, bringing it back to zero.
Because each payout bundles many orders and takes out refunds, discounts and payment fees before you are paid. Sales through PayPal, or through Afterpay when it settles with you directly, are paid separately.
Record PayPal sales, fees and refunds into a PayPal clearing account, then match each withdrawal from PayPal to your bank against that account. The withdrawal rarely matches a single sale, so the clearing account is what proves it balances.
It depends on how it is set up. Afterpay sales settled through Shopify Payments arrive inside your Shopify payout. If Afterpay settles with you directly, its settlements arrive separately and need their own clearing account.


