Payout reconciliation is the process of proving that the lump sum Shopify deposits into your bank account equals the sales, fees, refunds and adjustments that produced it. You do this in Xero by routing everything through a clearing account, then matching each bank deposit to the payout it represents. When the numbers tie out, your books are clean.
Key takeaways
A Shopify payout is net, not gross: every deposit is sales minus fees, refunds, chargebacks and adjustments. It will never equal your invoice totals.
The correct Xero workflow uses a clearing account: post sales and fees to it, then match each bank feed deposit to the payout it represents.
When a payout does not match, check currency conversion, refund timing, chargebacks and duplicate invoices before blaming the tool.
Apps like A2X and Taxomate post one summarised entry per payout so matching is a single click, but they still need correct tax mapping.
Multi-currency stores using PayPal alongside Shopify Payments face the worst breakage: two settlement streams with different timing and exchange rates.
If you have ever stared at a bank deposit from Shopify and wondered why it matches nothing in Xero, you are not alone. In our research across 30 verified complaints about Shopify to Xero integrations, broken payout reconciliation was the third most common problem. One reviewer of Xero's own Shopify app put it bluntly: "Not even a single Shopify Payout matches." Another, a UK yarn shop, described multi-currency with PayPal as a setup where "it doesn't work" and ended up facing an end-of-year audit with broken books. This guide explains what is actually happening and how to fix it.
What is actually inside a Shopify payout?
A Shopify payout is a settlement batch, not a single order. Every few days, Shopify collects the orders it has processed, subtracts what it is owed, and deposits one lump sum into your bank account. You can see the breakdown in Shopify under Finance, then Payouts, by opening an individual payout: it lists sales, refunds, adjustments and a fee column for each transaction.
Here is the rough arithmetic of a typical payout:
Gross sales (the orders customers placed) £8,420.00
- Shopify transaction fees -£146.30
- Refunds and returns -£85.00
- Chargebacks and adjustments -£40.00
--------------------------------------------------------
Payout deposited to your bank £8,148.70
Three things worth noting. First, fees come out before the money reaches you: the payout is net, so comparing it to gross invoice totals will always fail. Second, a payout covers a settlement window, not a calendar day or a single order, so the date on the deposit rarely lines up with the dates on your invoices. Third, Shopify sometimes deducts other charges, such as shipping label purchases, from the same payout. All of this is normal. The payout is correct; the mistake is expecting it to look like an invoice.
Why don't my Shopify payouts match my Xero invoices?
There are six usual reasons, and they stack on top of each other:
Fees were deducted before payout. Xero holds gross invoice values; the bank holds net. Until fees are recorded as expenses, nothing will match.
Timing windows differ. The payout covers orders from a settlement period that rarely aligns with the invoice dates Xero shows.
Refunds land in a later payout. A refund issued on Monday may be deducted from a payout you receive on Thursday, so the week looks wrong in both places.
Currency conversion. Shopify converts multi-currency orders at its own rates. Xero applies its own exchange rates to foreign-currency invoices. The two disagree by small amounts on nearly every order.
Separate gateways, separate payouts. PayPal settles on its own schedule with its own currency conversion. As the UK store in our research found, running multi-currency with PayPal alongside Shopify Payments is the worst combination: two settlement streams, different timing, different rates.
Duplicate invoices. If your integration created duplicate invoices in Xero, your sales are overstated and no payout will ever tie to them. This is more common than most store owners realise: one merchant paid an accountant hundreds of pounds to clean up duplicates an app had created.
How do you reconcile Shopify payouts in Xero correctly?
The method bookkeepers use is the clearing account workflow. A clearing account is a holding account that collects everything Shopify-related so the bank deposit has exactly one thing to match against. The approach below follows the same steps described in Synder's 2026 reconciliation guide and the PayoutClerk manual workflow:
Create a "Shopify Payments clearing" account in Xero as a current asset. You need a clearing account because Xero does not allow bank accounts inside manual journals.
Post a sales journal for the period. Take gross sales, discounts, refunds, shipping and taxes from Shopify's finance reports. Debit the clearing account and credit Sales, Shipping and Tax; debit Discounts and Refunds.
Record the payout's transactions. Export the payout from Shopify (Finance, Payouts, then the payout date) and sum the fee column plus any adjustment rows such as chargebacks.
Match the bank line. When the payout appears in your Xero bank feed, code it to the Shopify Payments clearing account for the deposited amount.
Post a fees journal. Debit Merchant fees and Chargebacks, credit the clearing account.
Check the clearing balance. It should equal only the transactions not yet paid out. If it is zero apart from pending payouts, you are reconciled.
Two mistakes to avoid. First, never code the payout deposit directly to Sales: that records net as revenue, hides the fees entirely, and double counts if you also posted the sales journal. Second, never close a month with a non-zero clearing balance. As one accounting guide puts it, a non-zero balance always means a payout, refund or fee was missed.
How do A2X, Amaka and Taxomate handle payouts?
These tools exist to automate the workflow above. A2X, the incumbent most accountants trust, pulls settlement data from Shopify and posts one summarised journal entry per payout into Xero, broken into sales, fees, refunds and taxes. When the deposit lands in your bank feed, it matches the A2X summary and reconciliation becomes a single click, according to A2X's own documentation. It starts at $29 per month for 200 orders and scales to $249 for multi-channel sellers, per our pricing check in November 2026.
Taxomate takes a similar approach: it imports the payout and posts one summarised invoice to Xero whose total matches the bank deposit, with lines grouped by category. Link My Books does the same at $21 per month. Amaka offers a free tier, which is why many stores try it first.
The honest caveat: these tools automate the posting, not the judgement. Tax mapping still has to be correct, especially for UK and EU VAT, and someone still needs to investigate when a payout does not tie out. They also charge monthly whether your books reconcile or not. In our complaint research, several merchants paid $20 to $65 per month and still ended up reconciling by hand because fees or taxes were miscategorised.
What should I check when a payout doesn't match?
Work through this list in order before rebuilding anything:
Are you comparing net to gross? Subtract fees first; the gap is usually smaller than it looks.
Does the payout window match the period you are checking? Pull the payout's transaction list from Shopify and confirm the dates.
Did a refund or chargeback land in this payout that belongs to an earlier period?
Are there duplicate invoices in Xero inflating sales? Search for duplicate order numbers.
For multi-currency stores: are exchange rates the source of the difference? Small per-order FX differences accumulate into visible gaps.
Are PayPal transactions mixed in? PayPal settles separately; reconcile it as its own stream.
Is the payout still pending at the bank? Shopify marks payouts as sent before banks show them, sometimes a day or two apart.
What is uncertain and what should you be careful about?
Exact payout timing varies by region, plan and bank; treat any stated number of days as typical, not guaranteed. Exchange rate differences between Shopify and Xero are a known source of small gaps that no integration fully eliminates. And if your books have been broken for months, the realistic fix is a clean cutover: reconcile one recent payout end to end, prove the workflow, then work backwards. Merchants who let payout reconciliation slide until year-end consistently report it turning into days of cleanup, and auditors do not accept "the app was wrong" as an explanation.
Reconciliation eating your week? We fix broken Shopify to Xero invoicing for a flat $149, free diagnosis, no monthly fees.
The core idea is simple once you see it: the payout is a net settlement, the clearing account is where the arithmetic happens, and the bank deposit is the control total. Set that up, reconcile weekly instead of yearly, and the mystery deposits become routine.
Originally published on LogicStack. Run the code examples right in your browser with our free interactive Python and SQL playgrounds — no setup, no sign-up.
Top comments (0)