- Connect Shopify to Xero via a bridge (A2X or Link My Books), not a raw payout bank-feed, the raw feed collapses sales, fees, refunds and VAT into one net number.
- The bridge splits each payout into clean journal lines and posts a summary that matches the bank deposit for auto-reconciliation.
- Map Shopify tax to the right Xero VAT rates (20%, 0%, and PVA for imports); separate UK / EU / RoW for OSS/IOSS.
- Shopify is never a marketplace for VAT, you are always VAT-responsible on Shopify sales.
- Want it set up right? Match with a Shopify-Xero specialist accountant →
Why you need a bridge, not just a payout feed
A Shopify payout to your bank is a single net figure: gross sales, minus refunds, minus Shopify Payments (Stripe) fees, plus or minus adjustments. If you simply categorise that deposit in Xero, you lose everything underneath it, you cannot see gross revenue, you cannot see fees as a cost, and your VAT is wrong because VAT is due on gross sales, not net payouts.
A bridge fixes this. Tools like A2X or Link My Books pull the Shopify settlement detail, break it into proper accounting lines, apply VAT, and post a single clean journal to Xero that still reconciles to the bank deposit. Monthly bookkeeping drops from hours of guesswork to minutes of review.
Native connector vs A2X vs Link My Books
| Option | What it does | Verdict for UK ecommerce |
|---|---|---|
| Raw bank feed only | Imports the net payout figure | Inadequate, loses gross sales, fees and VAT detail |
| A2X | Summarised, VAT-aware journals; mature multi-currency | Strong, especially Amazon-heavy or multi-currency sellers |
| Link My Books | UK-built, UK VAT wizard, flat pricing, COGS built in | Strong, often the pick for Shopify-first UK sellers |
See the full A2X vs Link My Books comparison. Both integrate natively with Xero; the choice depends on your platform mix and stage.
What a clean Shopify-Xero setup looks like
- Xero as the accounting ledger, with a chart of accounts that has separate lines for sales, Shopify/Stripe fees, refunds and shipping income.
- A bridge (A2X or Link My Books) connected to both Shopify and Xero, configured to post a summarised settlement journal per payout.
- VAT rates mapped so Shopify tax flows to the correct Xero rates (next section).
- Bank reconciliation where each Shopify deposit matches the posted journal, one-click reconcile.
- Per-channel tracking (Xero tracking categories) if you also sell on Amazon/eBay, so Shopify margin is visible separately.
VAT mapping (the bit that goes wrong)
The integration must map Shopify's tax collection to the right Xero VAT rates:
- UK standard sales: 20% VAT.
- Zero-rated goods (most children's clothing, books): 0%.
- Imports: use the PVA rate so import VAT flows to the right boxes, see import VAT.
- EU consumer sales: separated for OSS/IOSS treatment, not lumped with UK sales.
Remember: Shopify is not a marketplace under HMRC's rules, so unlike Amazon, you are always the VAT-responsible party on Shopify sales. The integration has to reflect that.
Common Shopify-Xero mistakes
- Relying on the raw payout feed. The number one error, it destroys VAT accuracy and cost visibility.
- Wrong VAT rates on the bridge. Standard-rated products mapped as zero-rated (or vice versa) understates or overstates VAT.
- Double-counting. Running both a Shopify app feed and a bridge, so sales post twice. Pick one source of truth.
- Ignoring fees. Shopify/Stripe fees are a deductible cost and carry VAT treatment, do not bury them in the net figure.
- Not separating EU sales. Breaks OSS/IOSS reporting.