Shopify and Xero integration UK (2026): payouts, fees and VAT

Why Shopify payouts don’t match your bank

Shopify’s help pages say a payout goes to your bank or Shopify Balance account, and its activity report splits your Shopify Payments money into transactions, fees and payouts. The bank line differs from your sales for a few reasons:

• Fees come off before the money reaches you, so the payout is smaller than your sales.
• One payout covers several days. Shopify lets you set payouts daily, weekly or monthly, so a single bank line can cover dozens of orders.
• Refunds and reserves. Refunds change what you’re paid. Shopify also says reserves temporarily hold funds from your sales to cover possible disputes and refunds, which lowers a payout even though your sales haven’t changed.
• Other ways to pay. Shopify’s payout pages are about Shopify Payments. If you also take PayPal or cash at a POS till, that money reaches you another way and needs its own clearing account.

If you post sales into Xero one way and the bank shows something else, you end up with suspense entries, guessed fees and a VAT return you can’t fully trust.

The three ways to connect Shopify to Xero

1. Xero’s own Shopify integration

The the Shopify listing on Xero's UK App Store calls it “Xero’s free integration” and says it syncs sales, payouts and fees from your Shopify Online Store and Shopify POS. Xero Central says it’s built with Xero’s partner Amaka. Once it’s set up:

• Daily sales and fees go to an account called Shopify Payment Balance in Xero.
• Sales arrive as invoices or receive money transactions, and fees as spend money transactions.
• When Shopify pays you, Xero records a transfer from Shopify Payment Balance to your bank account, which you then match to the bank feed.
• You choose a summary every 24 hours or one entry per order.
• You can split sales by sales channel, location or product, and map Shopify taxes to Xero tax rates.
• The listing says you can “sync up to 90 days of historical data”.

Amaka’s setup guide adds that refunds come through as credit notes, and that gift cards and tips map to liability accounts by default.

There’s a mixed message here. The listing calls it “Xero’s free integration”, but Xero’s UK Shopify partnership page tells you to “start your 30-day free trial of the integration”. We couldn’t find a price for it anywhere on Xero’s site, so check the screen before you confirm.

2. A paid connector: A2X or Link My Books

These tools read each Shopify payout and post one summary entry into Xero, split into sales, VAT, fees and refunds. Each summary should then match a bank line. These are the prices we found, all per month:

Notes on these figures:

• A2X currency. A2X’s pricing page showed US dollars when we checked, so you may see different prices from the UK. The page also says that from 14 November 2026, prices will rise on every plan except Mini.
• A2X trial. A2X’s free trial lets you post three settlements to your accounting software, so you can test it on real payouts.
• Link My Books VAT. Its pricing page says prices exclude any applicable VAT. Its UK pricing article lists the plans in pounds.
• Link My Books trial and limits. There’s a 14-day free trial, and you don’t need a card. Each Shopify store counts as one channel. It supports every Xero plan except Cashbook, and it lets you group products by VAT rate: standard, reduced or zero.
• History. Both tools set how far back you can import by plan: 3 months on A2X Mini and Link My Books Lite.

3. Build your own with Zapier, Make or n8n

All three automation platforms list Shopify and Xero (Zapier's Shopify and Xero integrations page, Make's Shopify app documentation, Make's Xero app documentation, n8n's Shopify and Xero integration page). You could create a Xero invoice for every order this way, but then fees, refunds, gift cards, payouts and VAT are all yours to handle, along with every edge case.

Building your own makes sense for jobs the connectors don’t do, such as:

• an invoice with payment terms for wholesale customers who order through Shopify;
• a Slack alert when a refund goes over a set amount;
• copying stock or cost data into another system.

To choose a platform, see our n8n vs Make vs Zapier guide. For a worked example, read how to create Xero invoices with Make and get UK VAT right.

VAT points UK sellers get wrong

None of the tools above decides your VAT treatment. They copy whatever mapping you give them, so get these right first:

• Registration. GOV.UK says you must register for VAT if your taxable turnover goes over £90,000 in 12 months, or you expect it to go over £90,000 in the next 30 days. If you go over in the past 12 months, you have to register within 30 days of the end of that month. Keep an eye on this if your shop is growing fast.
• Rates. GOV.UK lists three rates: standard (20%), reduced (5%) and zero. If you sell at more than one rate, a daily summary at a single rate will be wrong. Split by product or use a connector that groups by VAT rate.
• Shopify’s tax settings. Your Shopify tax settings and your Xero mapping need to agree. If Shopify charges 20% and Xero records the sale at zero rate, your VAT return will be wrong, however good the sync.
• Making Tax Digital. HMRC’s VAT Notice 700/22 on GOV.UK says Making Tax Digital for VAT “requires all VAT-registered businesses to keep records digitally and file their VAT Returns using software”. Xero describes itself as HMRC-recognised, MTD-compliant software that can submit returns, so whatever the integration posts ends up on your return.
• Fees. Shopify’s fees come through as their own transaction. Ask your accountant how they should be coded for VAT before you map them.

Which route fits your shop

Setup checklist

1. Agree the VAT mapping with your accountant first. Write down which products sit at which rate, and how fees should be coded.
2. Choose your start date. The start of a VAT quarter is cleanest, because the whole quarter then comes through one route.
3. Check your Xero plan. On Ignite, choose bank transactions rather than invoices.
4. Pick summary or per-order sync. A daily summary keeps Xero tidy. Per-order sync helps if you need to find single orders in Xero.
5. Map accounts. Sales, discounts, shipping, fees, gift cards (as a liability) and the clearing account for payouts.
6. Bring in history carefully. Only import past periods you haven’t already entered by hand, or you’ll count sales twice.
7. Reconcile the first two weeks by hand. Match each payout transfer to the bank line, and look into any difference before you trust the sync.
8. Watch other payment types. PayPal, gift cards and POS cash have their own clearing accounts. Reconcile those too, not just Shopify Payments.

When to get help

You can set up Xero’s own integration yourself, and Xero Central says you can book a guided setup call with an Amaka specialist. Help is worth paying for if you’re cleaning up months of unmatched payouts, you sell across several channels at mixed VAT rates, or you want orders, stock and invoices connected to the rest of your business. For the accounting side, see our best accounting software for UK small businesses and automating invoices and bookkeeping with AI guides.

In our directory, Shopify is mentioned by 23 agencies and Xero by 28 agencies. In the UK, workflow automation is mentioned by 231 agencies. Browse workflow automation agencies, or use Get matched and we’ll suggest suitable agencies at no cost.