Integration · Shopify + Xero
Xero reconciles by matching what is in your bank to what is in your books. But a Shopify payout arrives as one lump figure, with sales, fees and refunds folded inside, so the line just sits there with nothing to match. The fix is to post each payout as its parts, so it reconciles in one click.
What it looks like
Day to day, it looks fine. Sales come in, money lands. The problem appears the moment you open Xero to reconcile the bank, and then it appears on every payout.
The Shopify payout in your bank feed does not match your sales figure, so the line sits there with nothing to match it to.
To clear it, someone codes the whole deposit to a sales account, which quietly buries the fees, refunds and tax inside your revenue.
Refunds and chargebacks are not tied back to the original order, so the books and the takings slowly drift apart.
Payments through PayPal, Klarna or Shop Pay settle separately, so those deposits never line up with anything either.
If you sell in more than one currency, the converted figures rarely match what Xero expected, so even a clean order needs a second look.
By month-end the bank is reconciled on paper, but you know some of it was forced. You are signing off figures you have quietly stopped trusting, and that is a hard way to make a real decision.
Why it happens
These are the culprits we see most often. Yours might be one, a few, or something particular to your setup.
A Shopify payout is a net figure. It bundles many orders, then takes out fees, refunds and adjustments before it reaches the bank, so it never equals your sales total.
Shopify Payments pays out on a delay and on its own cycle, so the deposit date lags the sale, and the two never sit on the same day in the books.
The native Shopify connection often posts a daily summary or the deposit alone, without splitting out the parts Xero needs to reconcile cleanly.
Each payment gateway settles on its own schedule, so without clearing accounts the deposits and the fees land in the wrong place or the wrong period.
Product codes in Shopify do not match the item names in Xero, so a sale can post against the wrong account.
Tax is handled differently wherever you sell, VAT across the UK and EU, sales tax in the US, so a setup built for one market quietly mis-states the others.
Xero does not hold your stock; Shopify does, so without a deliberate setup your inventory value and the cost of goods can drift from reality.
Every business is wired differently, so the right fix depends on your gateways, the markets you sell in, and how your books are set up. The quickest way to know which of these is costing you is to look at a real payout against your bank feed together. That is what a 30-minute review is for.
What good looks like
Each Shopify payout arrives in Xero already broken into its parts, sales, fees, refunds and tax, so the bank line matches in one click.
Fees and refunds are visible, so the profit you see is the profit you actually made.
Every gateway is reconciled through its own clearing account, so PayPal and the rest stop being a mystery.
Tax is mapped correctly for each market you sell in, so VAT and sales tax both land where they should.
Multiple currencies are converted and posted consistently, so a cross-border sale reconciles like any other.
Stock stays aligned between Shopify and Xero, so you stop overselling things you do not have.
Reconciling the bank stops being a chore you force through, and the three-day close becomes an hour. You sign off on numbers you can stand behind. We build it on the tools you already run, the native Xero connection or a specialist one, whichever fits, and if what you have can already do the job, we will say so.
Common questions
In short
Get the two reconciling
Book a 30-minute review and we will look at a real payout against your bank feed, show you where it breaks, and what it would take to make it reconcile on its own.