Get this wrong and you’ll spend three to five hours a week manually matching payouts that should take ten minutes, and at the end of it your VAT return still won’t be right. We see this constantly with growing Shopify sellers: the books look fine until the accountant asks why gross sales in Xero don’t match what Shopify actually took, and nobody can answer.

The honest answer is that “connecting Shopify to Xero” isn’t one decision. It’s three different jobs wearing the same name, and most of the pain we see comes from businesses picking the wrong one.

The three ways to do this

1. The free native Xero integration. Xero has an official Shopify connection you can switch on in minutes. It pulls basic sales data across. Fine for a very early stage store with one payment method, no multi-currency, and simple VAT. The problem is it treats a payout as one lump sum. It doesn’t separate gross sales, refunds, discounts, shipping and payment processing fees. Your bank feed shows one deposit, your Shopify report shows a different total, and reconciling the gap becomes a monthly guessing game.

2. A dedicated ecommerce-to-accounting connector. Tools built specifically for this job, Link My Books and A2X are the two worth knowing, sit between Shopify and Xero and do the boring but essential bit: they break each payout down into its components before it hits Xero, so what lands in your ledger already matches your bank statement. A2X prices per sales channel, from around $29 a month for a low-volume Shopify store up to over $1,000 a month at high volume across twelve tiers. Link My Books tends to work out 30 to 40 percent cheaper for multi-channel, VAT-registered sellers because it bundles channels into one plan and applies UK VAT and OSS rules automatically. If you sell on Shopify plus Amazon, eBay or a marketplace, this is usually the right layer. If VAT treatment on your products is anything other than straightforward standard rate, this is also the right layer. A2X will get you there but you’ll need to configure the VAT logic yourself; Link My Books does more of that for you out of the box.

3. A general automation platform. Make and Zapier can both connect Shopify and Xero, and they’re the right call when you need the connection to do more than accounting, triggering a fulfilment step, updating a CRM record, sending a Slack alert, alongside the invoice sync. For pure accounting sync they’re usually overkill and, done badly, a source of duplicate invoices. But on capability: Make offers roughly 84 actions against Xero compared with Zapier’s 25, handles branching logic and JSON parsing that Zapier can’t, and at real ecommerce volume tends to cost 60 to 75 percent less. We’ve seen a store’s Zapier bill run to $448 a month for a workflow that cost under $90 a month rebuilt in Make. Zapier still wins on raw breadth, over 8,000 native app connections against Make’s 2,400, so if you’re stitching together a long tail of niche tools, that matters. For a Shopify-to-Xero core, it usually doesn’t.

The mistake that causes most of the damage

Running two integrations at once. We’ve walked into more than one set of books where a client had switched from the native Xero app to A2X, or from Zapier to Make, and never switched off the old one. Both were quietly posting invoices. Revenue looked roughly double what it actually was for months before anyone noticed, usually the accountant at year end. Before you turn anything new on, turn the old one off first, and check Xero for orphaned draft invoices from the previous setup.

What actually goes wrong without a proper setup

Three patterns turn up again and again in the accounts we get asked to untangle:

Payouts don’t match. Shopify batches transactions and pays out days later as one consolidated deposit. If nothing splits that deposit into gross sales, refunds, fees and tax before it reaches Xero, your bank reconciliation will never be a one-click job, it’ll be a spreadsheet.

VAT gets buried. Tax is sat inside the raw Shopify transaction data but it isn’t automatically separated by rate. Standard-rated, zero-rated and reduced-rated sales all end up in the same bucket unless something actively splits them, and that’s how you end up restating a VAT return.

Mapping breaks quietly. API changes, expired authentication, a product added without a tax class, any of these will silently misroute data for weeks before it surfaces, usually as a number that “doesn’t look right” during a board pack or a loan application.

Our actual recommendation

For a single-channel Shopify store on standard UK VAT: Link My Books into Xero. It’s built for exactly this, it’s cheaper than A2X at typical volumes, and it does the VAT logic without you having to think about it.

For multi-channel sellers, or anyone needing the accounting sync to also trigger operational steps elsewhere in the business: Make, configured properly, with the old integration switched off before the new one goes live.

For a business past about 50 orders a day with genuinely custom logic, split shipments, bundled SKUs, multi-entity accounting, a bespoke integration built once and owned outright can cost less over three years than a subscription tool bent out of shape to fit. That’s a smaller slice of businesses than most agencies will tell you, but it does exist.

If you’re not sure which bracket you’re in, that’s worth checking before you spend anything. Our Full Systems Audit (£695) looks at your actual order volume, VAT position and existing tools, and tells you plainly which of these three routes fits, and what it’ll cost to run properly. No pressure toward the expensive option: half the audits we do end with “the free native app is genuinely fine for you.” Book one at thisisretina.co.uk/technical-audit.

FAQ