Shopify Xero integration for UK and Australian merchants

A Shopify Xero integration posts your Shopify sales, refunds, fees and payouts into Xero so that your bank feed reconciles and your VAT return or BAS is right. For UK and Australian merchants, which is where Xero is strongest, the details that matter are tax-inclusive pricing, VAT or GST mapping per product, and payouts that match the bank line. Connector apps handle this for most stores. You need a custom integration when your tax, currency, multi-store or B2B set-up is beyond what the connector can map.

What moves from Shopify to Xero

• Sales, split into product revenue, shipping income, discounts and VAT or GST collected.
• Refunds, as credit notes or negative lines, with the tax reversed at the right rate.
• Payment fees, as an expense per payout or per transaction.
• Payouts: the net deposit that appears on your Xero bank feed.
• Gift cards: sold as a liability, redeemed as revenue.
• B2B sales on terms: a Xero invoice to the company, paid later by bank transfer.
• Optionally inventory and cost of sales, if Xero tracks your stock items.

Tax: VAT in the UK, GST in Australia

Most UK and Australian Shopify stores show prices including tax. The integration has to split that inclusive price into net and tax, using the same rate Shopify applied, and assign the right Xero tax rate.

For UK merchants, check how the connector handles:

• products at different VAT rates (standard, reduced, zero-rated) and exempt items;
• sales to other countries that are outside the scope of UK VAT, or taxed under another country's rules;
• shipping, which normally follows the VAT treatment of the goods it ships;
• the tax on refunds and partial refunds.

Getting this right in Xero matters because Xero is where many UK merchants prepare and file VAT returns under Making Tax Digital.

For Australian merchants, check:

• GST and GST-free items, and whether GST applies to shipping for mixed orders;
• sales to overseas customers;
• how refunds reverse GST, so your BAS figures are correct.

If your tax set-up in Shopify is wrong, no integration will fix it in Xero. Check Shopify's tax settings first.

Payouts and bank reconciliation

The approach that works best with Xero's bank feed:

1. Sales, refunds and fees post to a clearing account (a bank-type account in Xero, or a current asset).
2. Each Shopify Payments payout posts as a transfer from the clearing account to your real bank account.
3. The transfer amount matches the line on your bank feed exactly, so reconciliation is one click.

Payouts reach you in your store's payout currency, GBP or AUD for most readers of this page. If you sell in other currencies, the difference between the order currency and the payout currency needs a home, usually an FX gains and losses account.

Off-the-shelf options

There are several Shopify apps and Xero-marketplace integrations for this. Some, such as A2X, summarise per payout. Others post individual transactions. Choose based on:

• summary vs per-order posting;
• how they handle VAT/GST-inclusive prices and multiple tax rates;
• support for payment providers other than Shopify Payments, such as PayPal and marketplaces;
• multi-store and multi-currency support;
• what happens when you edit an order after it has been posted.

Where Xero connectors struggle

• Mixed tax rates in one order, for example a zero-rated item plus a standard-rated item plus shipping.
• Multiple stores feeding one Xero organisation, each with its own currency and payouts.
• B2B customers who need a Xero invoice with their own payment terms, while D2C sales go in as summaries.
• Marketplace orders imported into Shopify that are settled by the marketplace, not by Shopify Payments.
• Tracking categories: splitting revenue by channel, market or brand in Xero reporting.
• Order edits and exchanges after the original order has already been posted.

How a custom Shopify Xero integration is built

A custom integration keeps what works, such as the clearing-account model, and adds rules for your business:

1. Shopify events: order, refund and payout data via webhooks and the GraphQL Admin API, including the balance transactions behind each Shopify Payments payout.
2. Rules in config: accounts, Xero tax rates and tracking categories by product type, market, channel or customer type. B2B companies get invoices, D2C gets summaries.
3. Posting through the Xero API with OAuth 2.0. Each posted record carries the Shopify reference, and a local map prevents a retry from posting twice. The Xero API has rate limits, so posting is batched and queued.
4. Checks: each payout's clearing balance should net to zero. Any that don't are flagged with the orders involved.
5. An error list in the app, showing Xero's validation messages, with a retry button.

Worked example: a UK order with mixed VAT

A UK store sells a standard-rated item at 24.00 including VAT (UK standard rate 20%), a zero-rated children's item at 10.00, and charges 4.80 shipping including VAT. Shipping is usually taxed in proportion to the goods it ships, so check your own position with your accountant. The integration has to post:

• the standard-rated item as 20.00 net plus 4.00 VAT;
• the zero-rated item as 10.00 net with zero-rated VAT;
• shipping split between standard-rated and zero-rated in the same proportion as the goods, if that's the treatment you apply.

A connector that applies one tax rate to the whole order, or treats shipping as all standard-rated, will make your VAT return wrong in a way that's hard to spot. The same test applies in Australia with GST (10%) and GST-free items. Put two or three orders like this through any connector before you trust it.

Decision checklist

• Are your Shopify prices tax-inclusive? Which VAT or GST rates do your products use?
• Do you sell to customers outside your country?
• Which payment providers and marketplaces settle your sales?
• One Xero organisation for several stores, or one each?
• Do B2B customers need Xero invoices?
• Do you need tracking categories for channel or market reporting?
• Who reconciles the bank feed, and how often?