How to Sync Shopify and Xero (and Automate Your Ecommerce Accounting)

If you run a Shopify store and keep your books in Xero, you've probably felt the monthly grind: exporting orders, working out which payout covers which sales, chasing down payment fees, and quietly hoping the VAT lines up. Done by hand, it's slow and error-prone. Done well, it's almost invisible — your sales, fees, refunds and payouts land in Xero cleanly, and reconciliation takes minutes.

This guide walks through how to sync Shopify and Xero properly: what actually needs to flow between them, the realistic options (off-the-shelf apps, Zapier/Make, or a custom integration), how to handle Stripe, PayPal and Shopify Payments payouts, and the multi-currency and VAT gotchas that trip people up.

What "syncing Shopify and Xero" actually means

The phrase sounds simple, but it hides several different jobs. Before you pick a tool, get clear on which of these you actually need.

• Sales revenue — your daily or per-order takings, ideally split by product type, region, or tax rate.
• Payment fees — what Shopify Payments, Stripe or PayPal deduct before paying you.
• Refunds and chargebacks — money going back out, which has to reduce revenue and often reverse VAT.
• Payouts — the actual lump sums that hit your bank, which rarely match a single day's sales.
• COGS and inventory — the cost of goods sold, and stock levels if you manage inventory in (or alongside) Xero.
• Customers and contacts — usually optional, and often best left out of Xero for a high-volume store.

The single biggest mistake is pushing every individual Shopify order into Xero as its own invoice. For a shop doing 30 orders a day, that's roughly 900 invoices a month, none of which match your bank deposits. Your accountant will not thank you.

Per-order vs summarised: pick the right granularity

There are two broad models for getting sales into Xero.

1. Per-order invoices or sales receipts. Each Shopify order becomes a Xero transaction. This suits low-volume, high-value businesses (think bespoke furniture, B2B wholesale) where you genuinely want order-level detail in the ledger.
2. Summarised journals or invoices. Shopify activity is grouped — usually per day or per payout — into a single summary entry with lines for sales, shipping, discounts, fees and tax. This is the right answer for the vast majority of ecommerce stores, and it's what tools like A2X are built around.

If you're doing more than a handful of orders a day, summarised is almost always correct. It keeps Xero clean and makes reconciliation trivial.

The three ways to connect Shopify and Xero

There's no single "best" tool — it depends on volume, complexity and how much you care about clean reconciliation. Here's an honest comparison.

Approach	Best for	Strengths	Weaknesses
Dedicated apps (A2X, Bold, etc.)	Most ecommerce stores	Payout-level reconciliation; fees and VAT handled; accountant-friendly summaries	Monthly fee scales with order volume; limited to supported scenarios
Native / connector apps	Simple, low-volume stores	Often cheap or free; quick to set up	Frequently per-order; weak on payout matching and fees
Zapier / Make	Light glue, notifications, edge workflows	Flexible; no code; connects many apps	Per-order by default; hard to reconcile payouts; gets expensive at volume
Custom integration	Complex, high-volume, multi-store/multi-channel	Exactly your logic; full control; scales	Build cost; needs maintenance; only worth it past a certain complexity

Option 1: Dedicated apps (A2X and similar)

For most stores, a purpose-built connector like A2X is the pragmatic starting point. Rather than syncing orders, A2X groups your Shopify sales by settlement/payout and posts a summarised journal or invoice into Xero. Each entry breaks out gross sales, discounts, shipping, gift cards, payment fees and tax — and crucially, the total matches the deposit that lands in your bank.

That last point is the whole game. When the Xero entry equals the bank deposit, reconciliation becomes a one-click match. No detective work.

The trade-off is cost, which typically scales with order volume, and a ceiling on how much custom logic you can apply. If your tax or revenue-recognition rules are unusual, you may hit the edges.

Option 2: Native and connector apps

Shopify's app store and Xero's marketplace list several lighter connectors. Some are genuinely fine for a small, single-currency UK store with straightforward VAT. But many default to creating a Xero invoice per order and stop short of proper payout reconciliation or fee handling. Read the detail before committing: ask specifically how the app handles payouts and payment fees, because that's where the cheap options usually fall down.

Option 3: Zapier or Make

Zapier and Make are excellent for lightweight automation, and both have Shopify and Xero connectors. They're a reasonable fit when you want to, say, create a draft invoice for each B2B order, post a Slack alert on large orders, or handle a specific edge case the main tool misses.

Where they struggle is the core accounting job. Out of the box they tend to fire one action per order, which recreates the per-order problem and doesn't reconcile against payouts. You can build payout-aware logic in Make, but you're effectively rebuilding what A2X already does — and at volume, the task pricing adds up fast. Use them as glue, not as your primary ledger sync. We cover where these tools genuinely shine on our AI automation page.

Option 4: Custom integration

A custom build talks directly to the Shopify Admin and Payments APIs and the Xero API, applying exactly the rules your business needs. More on when that's worth it below.

Reconciling payouts: the part everyone underestimates

Here's the core truth of ecommerce accounting: the money that hits your bank is not the same as your sales.

When a customer pays £100 via Shopify Payments, you don't receive £100. You receive £100 minus the processing fee, and not immediately — payouts are batched and arrive a day or several days later. A single payout might cover dozens of orders, partial refunds, and fees, all netted together.

So a clean sync has to reconstruct that. For each payout, you need:

• Gross sales for the orders included
• Less payment processing fees
• Less refunds and chargebacks settled in that batch
• Plus any adjustments

…to arrive at the net payout amount that matches your bank line in Xero.

Shopify Payments, Stripe and PayPal each behave differently

• Shopify Payments exposes payout and balance-transaction data, so fees and timing can be reconstructed cleanly. This is the easiest case, and what most dedicated apps handle best.
• Stripe (if you use it as a separate gateway) pays out on its own schedule with its own fee structure, reported through Stripe's payout and balance objects — a separate reconciliation stream.
• PayPal is the classic headache. Funds can sit in a PayPal balance, fees are deducted per transaction, currency conversions happen inside PayPal, and withdrawals to your bank are separate events. PayPal usually needs its own clearing account in Xero.

A robust setup uses a clearing (holding) account per payment method. Sales post to the clearing account; payouts move money from the clearing account to the bank. The clearing account balance at any moment represents money earned but not yet paid out. If it drifts to a strange number, something's wrong — which makes it a useful early-warning signal.

Multi-currency and VAT: the UK gotchas

This is where well-meaning setups quietly go wrong. Watch for these.

Multi-currency

• If you sell in multiple currencies, decide whether you're recording in the store/presentment currency or your settlement currency. Mixing them creates phantom gains and losses.
• Xero's multi-currency feature (on higher-tier plans) handles foreign-currency invoices and revaluation — but your sync needs to feed it consistent currency and exchange-rate data.
• Payment gateways apply their own FX rates, which won't match Xero's daily rate. Those differences are real realised FX gains and losses and need an account to land in, not to be ignored.

VAT

• Tax rates by product and region. Standard-rated, zero-rated and exempt items must map to the correct Xero tax rates. A summarised journal that lumps everything into one VAT rate will misstate your return.
• Refunds reverse VAT. A refund isn't just negative revenue — it reverses the output VAT too. Make sure your tool handles this.
• Post-Brexit and cross-border rules. Sales to EU consumers, the OSS/IOSS schemes, and sales to non-UK customers all have different VAT treatment. If you sell internationally, this needs deliberate mapping rather than a default.
• Marketplace facilitator rules. If you also sell via Amazon or eBay, the platform may account for VAT on certain sales — so those amounts must be treated differently from your direct Shopify sales.

A good principle: your Shopify tax settings and your Xero tax mapping have to agree. Most VAT errors come from a mismatch between what Shopify charged and what the sync recorded.

COGS and inventory

Two related but separate questions.

• Cost of goods sold (COGS). To see true gross margin, you want the cost of items sold reflected against revenue. Some setups post a periodic COGS journal; full perpetual inventory tracking is more involved and often lives in dedicated inventory software rather than Xero itself.
• Stock levels. If Shopify is your single source of truth for stock, you may not need to sync inventory into Xero at all. If you sell across multiple channels, a dedicated inventory tool (Cin7, Cin7 Core/DEAR, Unleashed and similar) usually sits between your channels and Xero. Trying to force Xero to be your multi-channel inventory hub is usually a false economy.

Be honest about whether you need COGS automation now. Many growing stores start with a simple monthly cost journal and only move to perpetual inventory once margins by SKU genuinely drive decisions.

When is a custom integration worth it?

Off-the-shelf tools cover the common cases well. A custom integration earns its keep when you outgrow them. Signs it's time to consider one:

• High volume where per-order app pricing has become painful, or summarisation needs to be smarter than the standard tools allow.
• Multiple stores or sales channels (Shopify plus Amazon, eBay, a B2B portal, EPOS) that need consolidated, consistent posting into one Xero file.
• Unusual revenue recognition — subscriptions, deposits, deferred revenue, bundles — that standard summaries can't express.
• Bespoke tax logic across regions and schemes that no single connector maps correctly.
• Operational coupling — you want the same pipeline to also update a warehouse system, trigger fulfilment, or feed a data warehouse for reporting.

A custom build talks to the Shopify and Xero APIs directly, applies your exact mapping and reconciliation rules, and writes clean, payout-matched entries. The cost is real — design, build and ongoing maintenance — so it typically makes sense once the cost of getting it wrong (misstated VAT, hours of manual reconciliation, margin you can't see) clearly exceeds the build. As an indicative UK market guide, a focused Shopify-to-Xero integration build commonly sits in the low-to-mid five figures depending on channels and complexity — but treat that as a range to sanity-check quotes against, not a price.

There's often a sensible middle path: use a dedicated app for the standard flow, and add a small custom piece only for the edge case it can't handle. You get most of the value at a fraction of the cost. That's the kind of pragmatic, vendor-neutral call we help make in our API integration work, and we tie it into your wider data integration where reporting matters.

A practical rollout checklist

1. Map your accounts first. Decide your Xero accounts for sales, shipping, discounts, fees, refunds, FX, and clearing — before you connect anything.
2. Choose granularity (per-order vs summarised) based on volume.
3. Pick the lightest tool that does the job — usually a dedicated app for the core flow.
4. Set up clearing accounts per payment method and confirm payouts reconcile to the penny.
5. Verify VAT mapping against a known order, including a refund.
6. Run a parallel month alongside your old process before you trust it fully.
7. Document the setup so the next person (or your accountant) understands it.

How APIwise can help

Getting Shopify and Xero talking is rarely the hard part — getting them to reconcile cleanly, with the right VAT treatment and payouts that match your bank to the penny, is. As the UK's API and AI integration specialists, we're vendor-neutral: if a tool like A2X plus a small tweak is the right answer for you, that's exactly what we'll recommend. If your volume, channels or tax rules genuinely call for a custom build, we'll scope and price it up front, fixed.

The simplest next step is our fixed-price Integration Health Check — we review how your systems connect today, find the gaps and risks, and give you a clear, costed plan to automate your ecommerce accounting properly. The fee is credited against any build Sprint that follows.

Book your Integration Health Check and let's make your Shopify-to-Xero sync something you never have to think about again.