Shopify Xero integration and beyond: connect your shop, till and payments to your accounts

A Shopify Xero integration, or any link between where you sell and where you keep your books, has one job: record what you actually sold, what the platform kept in fees and refunds, and the payout that reached your bank, as three separate things. Start with the free app your accounts package already offers. Add a connector such as A2X or Link My Books when you sell on several channels or need cost of goods. Build something only when neither copes with how you trade.

This guide is for business owners, and for the accountants and bookkeepers who keep getting asked about it: we counted more than a dozen forum threads on it since 2024. Agree the set-up with your accountant before you switch anything on. It is far easier to get right on day one than to unpick six months of postings.

Shopify, Amazon, eBay, Stripe, PayPal and the card-reader firms all work the same way: they collect your customers' money, take their fees, deduct any refunds or chargebacks, sometimes hold a reserve, and pay you the rest.

If the deposit is recorded as sales, three things go wrong. Your sales are understated. Your fees, often a real cost line, vanish from the accounts. And your VAT return is wrong, because VAT is worked out on what you sold, not on what the platform passed on. Amazon makes this harder by paying out over settlement periods rather than per order, so one deposit can cover hundreds of orders, refunds and fee types.

The fix accountants use is a clearing account (sometimes called a holding account) for each platform:

1. Record the sales gross, with VAT, into the clearing account.
2. Record the fees as an expense, and refunds as negative sales, against the same account.
3. When the payout lands, match it as a transfer from the clearing account to your bank.

If everything is posted correctly, the clearing account comes back to zero, or to the money still in transit. When it doesn't, something is missing. Every option below is just a way of doing those three steps without typing them in by hand.

Xero. The Shopify integration by Xero is free on all Xero plans. It is built by Xero and supported by Amaka, an integrations specialist. It syncs sales, payouts, fees, taxes and refunds from both the Shopify online store and Shopify POS, and you choose between a daily summary (better for busy stores) or one transaction per sale. Its honest limits: it can only fetch up to 90 days of history, and the listing says nothing about stock or cost of goods, so it covers your sales, not your margins.

QuickBooks Online. Intuit's Shopify Connector by QuickBooks imports individual sales, refunds and payouts, records Shopify fees as expenses, and can look back up to 12 months. Intuit's own guidance is worth repeating to clients: when the payout appears in the bank feed, match it to the imported payout. Don't add it as a new transaction, or the sale gets counted twice.

FreeAgent. FreeAgent's native Shopify integration was withdrawn in April 2025, and Shopify no longer appears in FreeAgent's integrations directory (checked 10 October 2026). Since August 2026 FreeAgent has partnered with Equali, a reconciliation app that posts the sales, refunds, taxes and fees from Shopify, Amazon, eBay and Etsy into FreeAgent (FreeAgent customers get 20% off; Equali sets its own prices, so check them). Otherwise, the usual workaround is a weekly or monthly summary entry taken from Shopify's payout reports, posted through the clearing-account method above. Neither A2X nor Link My Books lists FreeAgent as a supported ledger. If Shopify is a large part of the business, whether to stay on FreeAgent is a conversation to have with your accountant, not a decision to make around an app.

Sage. Sage Accounting has no built-in Shopify link. A2X supports UK Sage Accounting plans, and Sage 50 desktop users rely on third-party connectors such as Tradebox One. Confirm which Sage product a connector supports before you buy, because cloud and desktop are different products.

What each provider's own listing says it does:

• Stripe. Xero offers a Stripe direct feed that imports Stripe transactions, and Stripe can be added as a payment service so customers pay Xero invoices by card. FreeAgent also lists a Stripe integration.
• PayPal. Xero and FreeAgent both connect to PayPal. If you take more than one currency, set each one up separately: PayPal converts at its own rates, which won't always match your accounting software's rates.
• Square. The Square app for Xero posts a daily sales-summary invoice, which can be split to transaction level. It maps categories to your accounts, captures tips, surcharges and tax, and sends Square's fees to a fees account.
• SumUp. SumUp's Xero app sends the previous day's sales overnight, as a summary with a VAT split, by item category or by item. Sales arrive as invoices and fees as bills from SumUp, ready to match to the payout. Reviews on Xero's app store are mixed, so check it against your own figures for a month first.
• Epos Now. The Xero app sends sales, products, stock, customers and suppliers when you close the till. The integration has its own monthly charge, which Epos Now's UK page doesn't publish (it was advertising 50% off for new Xero customers when we checked). An accountant reported £25 a month in 2023, so ask for a current quote.
• Lightspeed Retail (X-Series). Syncs each end-of-day register closure to Xero: daily sales totals and payment-type totals, plus cost of goods as items sell.

The limit shared by all of them: a daily summary is only as good as its VAT split. If you sell zero-rated and standard-rated goods through the same till, check the first few summaries line by line with your accountant before you trust them.

Connector apps sit between your sales channels and your ledger. They read each payout or settlement and post one summary that splits out sales by VAT rate, shipping, discounts, refunds and each fee type, so the summary matches the deposit to the penny. They earn their fee when you sell on more than one channel, when Amazon settlements are eating your bookkeeper's time, or when you want cost of goods posted automatically.

Synder, Amaka and Webgility do similar jobs. A2X prices in US dollars, so the sterling cost moves with the exchange rate.

The honest limit. These apps are very good at one thing: turning a payout into a correct accounting entry. They don't know your business. They won't combine a trade-counter till with an online shop and a wholesale price list into one view of margin. They won't handle a channel they don't support. And they post what you map, so a wrong VAT rate set up on day one gets repeated on every order until someone notices. Have your accountant review the mapping once, right at the start.

Refunds. A refund can land in a later payout than the original sale, sometimes in a later VAT quarter. Gross posting through a clearing account handles this cleanly; netting refunds off the deposit doesn't.

VAT on marketplaces. For goods worth £135 or less sent from outside the UK, and goods already in the UK sold by overseas sellers, the online marketplace accounts for the VAT. Those rules are aimed at overseas sellers. If you're UK-established, check with your accountant how your marketplace sales should be treated, and whether each platform charges VAT on its fees, because providers differ.

Multi-currency. Selling in euros or dollars means currency gains and losses between the sale and the payout. On Xero, multi-currency is only on the Comprehensive (£55 a month) and Ultimate (£70 a month) plans, not Ignite or Grow (prices ex VAT, checked 10 October 2026).

Stock. Sales integrations move money, not stock counts. If your Shopify stock levels and the stock value in your accounts disagree, the answer is usually a stock system that links to both, with a full count on the day you go live. Our guide Outgrown your spreadsheets? Buy, connect or build compares the stock apps and what they cost.

Most businesses never need this. If a free app or a £15–£80-a-month connector does the job, use it. The signs the off-the-shelf route has run out:

• Your till, EPOS or order system has no app for your ledger, so someone types up a daily summary from a printout or a spreadsheet export.
• You trade through several routes the connectors don't combine, such as a trade counter with credit accounts, an online shop and a marketplace, and want one daily journal with the VAT split your accountant asked for.
• Prices are worked out per customer or per job, so the sale needs context no connector holds.
• You need margin by channel, product or customer, and today that means a spreadsheet rebuilt every month-end.

That is where we come in. We're a UK software company that builds the connections between the systems a business already uses, plus the reports that sit on top, for firms that have outgrown spreadsheets. We agree the posting rules with your accountant first, so the books come out the way they want them, and we tell you honestly if an existing app will do. For what a build typically costs, see How much does bespoke software cost in the UK?, or read more about our custom software work.

1. Summary or per-sale? Daily or per-payout summaries keep the ledger readable; per-sale detail is rarely worth the clutter.
2. Which accounts? A clearing account per platform, a fees account, and how shipping, discounts and gift cards are coded.
3. VAT rates. Which products are standard, reduced or zero-rated, and whether each platform's fees carry VAT.
4. A start date. Connect from the first day of a VAT quarter if you can, and don't import history your accountant has already posted by hand.
5. A monthly check. Each clearing account should be at or near zero at month-end. Who looks, and what happens if it isn't?

Still typing sales into your books by hand, with no app that fits? Tell us what you sell through and which accounts package you use. We'll tell you honestly whether an existing app will do it, and if it won't, we'll build a working first version on your own data, free. Get in touch.