How to Set Up Xero for Your Shopify Store UK: The Complete Guide (2025)

If you're running a Shopify store in the UK, Xero is almost certainly the right accounting software for you — but setting it up correctly is not as simple as clicking "connect" and hoping for the best. The default Shopify-Xero integration creates more accounting problems than it solves. This guide explains how to do it properly.

We've set up Xero for dozens of UK Shopify businesses. The setup we describe here is what we use for all of them — it handles UK VAT correctly, reconciles properly, and gives you real margin visibility by channel.

What You Need Before You Start

• Xero account — if you don't have one, the Starter plan (£15/month) works for most small Shopify stores; Growing plan (£30/month) is needed if you have more than 20 invoices/month or need multi-currency
• Link My Books — this is the integration tool we recommend for UK Shopify sellers. Starts at around £17/month and is worth every penny
• Your Shopify store's VAT status — are you VAT-registered? If yes, what scheme are you on?
• Your payment processors — Shopify Payments, PayPal, Klarna, or other? Each needs to be set up separately

Why Link My Books (Not the Native Shopify Integration)

Link My Books posts Shopify settlement summaries to Xero — not individual orders. Here's what that means in practice:

• Each Shopify payout becomes one clean Xero transaction, not thousands of individual orders
• VAT is correctly split out between standard-rated, zero-rated, and exempt sales
• Shopify fees and refunds are properly categorised
• Reconciliation to your bank statement is straightforward — the Xero entry matches the bank deposit
• Your MTD VAT return pulls correct figures directly from Xero

Link My Books also handles multiple payment processors — if you're using Shopify Payments plus PayPal plus Klarna, each gets its own clean reconciliation.

Step-by-Step Setup

Step 1: Set Up Your Xero Chart of Accounts

Before connecting anything, get your Xero chart of accounts right. The default Xero chart is generic and needs adjustment for ecommerce. Key accounts to add or rename:

• Sales — UK Standard Rate (20%) — for VAT-rated Shopify sales
• Sales — UK Zero Rate — if you sell zero-rated products
• Sales — Export / Outside UK — for international sales outside the scope of UK VAT
• Shopify Fees — for transaction fees and subscription costs
• Returns and Refunds — keep this separate from sales for clean P&L reporting
• Cost of Goods Sold — for your product purchase costs

Step 2: Connect Link My Books to Shopify

1. Create a Link My Books account at linkmybooks.com
2. Connect your Shopify store using the Shopify integration (you'll need admin access to your Shopify store)
3. Connect your Xero account — Link My Books will ask for Xero authorisation
4. Select your posting frequency — we recommend daily for active stores

Step 3: Configure VAT Settings in Link My Books

This is the most important step and the one most people get wrong. In Link My Books, you need to specify:

• Your VAT registration status (registered or not)
• Your VAT scheme (standard, flat rate, or cash accounting)
• The VAT rate for each product type you sell
• How international sales should be treated (zero-rated for exports, or outside the scope)

If you're on the flat rate scheme, Link My Books handles the flat rate calculation automatically — the effective rate is applied to your gross sales and the difference is your flat rate VAT liability.

Step 4: Set Up Your Bank Feed

Connect your business bank account to Xero using the bank feed feature. For most UK banks, this is a direct feed — Xero pulls transactions automatically each day.

Your Shopify payouts will appear in your bank feed as a single deposit. The matching Link My Books journal entry in Xero should reconcile directly to this deposit. If it doesn't match exactly, the difference is usually timing (Shopify takes 2–3 days to pay out) or a fee that wasn't accounted for.

Step 5: Set Up Payment Processor Reconciliation

If you use Shopify Payments, the reconciliation is built into the Link My Books setup above. For PayPal and other processors, you need to connect them separately:

• PayPal: Connect via Xero's PayPal feed, or use Link My Books' PayPal integration
• Klarna / Clearpay: These pay out on their own schedule — set up a clearing account in Xero for each
• Stripe: Use Xero's Stripe integration or the standalone Stripe-Xero connector

Step 6: Inventory and COGS (If Applicable)

If you carry physical inventory, you need to track your Cost of Goods Sold (COGS) in Xero. The options are:

• Simple COGS tracking: Post your stock purchases to a COGS account — works for low-volume stores
• Inventory tracking in Xero: Xero has basic inventory functionality — works for stores with a small number of SKUs
• Dedicated inventory software: For stores with complex inventory, consider Cin7 or Unleashed connected to Xero

Running Your VAT Return from Xero

Once your setup is correct, your quarterly UK VAT return should take 15 minutes rather than hours. In Xero:

1. Go to Accounting → VAT Returns
2. Check the period covers your VAT quarter
3. Review the figures — Box 1 (VAT on sales) and Box 4 (VAT on purchases) should look right based on your sales volume
4. Submit directly to HMRC via Xero's MTD integration

Common issues to check before submitting: any uncategorised transactions (shown as "Uncoded" in Xero), any large movements that look unusual, and whether any transactions from the previous period have been posted late.

Getting Useful Reports from Xero

Once set up correctly, Xero gives you visibility you simply can't get from your Shopify dashboard or bank statement:

• P&L by month: See your gross margin, net of Shopify fees, refunds, and COGS
• Cash flow forecast: Xero's cash flow tool shows projected cash position based on outstanding payments
• Aged debtors: If you sell B2B with payment terms, track who owes you what
• VAT liability: Real-time view of your VAT position so there are no surprises at quarter-end

Common Problems and How to Fix Them

Shopify payouts don't match Xero entries

Usually a timing issue (Shopify processes payouts with a 2–3 day delay) or a fee that Link My Books hasn't picked up. Check the Link My Books reconciliation report for any unmatched items.

VAT figures look wrong on the return

Most commonly caused by incorrect VAT codes on products — particularly if you sell a mix of standard-rated and zero-rated products. Review the VAT audit report in Xero to check which transactions are contributing to each box.

Refunds aren't reconciling

Shopify refunds need to be posted as credit notes in Xero against the original sale. Link My Books handles this automatically if configured correctly, but if you've set up incorrectly, refunds can end up as negative sales rather than credit notes, causing VAT return issues.

International sales are being VAT-rated incorrectly

Sales to customers outside the UK should generally be zero-rated (exports) or outside the scope. If Link My Books is treating them as standard-rated, you're overcollecting and over-paying VAT. Check your Link My Books country settings.

Summary: Getting Set Up Correctly

The right Shopify-Xero setup takes a few hours to configure but saves you significant time every month and ensures your VAT returns are correct. Key points:

1. Use Link My Books, not the native Shopify-Xero integration
2. Set up your chart of accounts correctly before connecting anything
3. Configure VAT settings in Link My Books carefully — this is where most errors originate
4. Connect your bank feed and confirm payouts reconcile
5. Set up separate reconciliation for each payment processor
6. Review your first VAT return carefully before submitting — the second and third are much simpler once the setup is correct

If you'd rather have someone do this for you — or you want us to check that your current setup is correct — book a free call. We set up Xero for Shopify sellers as standard and can usually have a new client fully live within a week.