Shopify's native Xero integration is widely used and almost always set up incorrectly. It books every payout as revenue, mishandles VAT, and gives you a P&L that has nothing to do with your actual profitability. Here's what proper Shopify accounting looks like — and how to fix it.
The Problem with How Most Shopify Sellers Do Their Books
When Shopify pays you, you receive a net payout — after Shopify has deducted transaction fees, payment processing fees, and any refunds processed that period. Many accountants book that net payout as revenue. That's wrong for three reasons:
- Revenue is understated. Gross sales are the real revenue figure. Shopify fees are an expense — they should show on your P&L as a cost, not be silently netted off income.
- VAT is wrong. VAT is calculated on gross sales value, not net payout. If you've been calculating VAT on the payout figure, you've been underdeclaring.
- Margin analysis is meaningless. If you can't see what Shopify fees cost you as a percentage of revenue, you can't make informed decisions about pricing or whether to switch payment processors.
Why the Native Shopify-Xero Integration Falls Short
Shopify's built-in Xero connection books each payout as a single transaction. It doesn't break out gross sales, refunds, fees, and adjustments separately. Your Xero ledger looks tidy but is conceptually wrong — you're seeing a cash flow summary, not your actual business.
The correct approach is to use Link My Books or a similar tool that sits between Shopify and Xero, pulls the detailed settlement data, and maps each component to the right account: gross sales to revenue, Shopify fees to the appropriate expense account, refunds to a refunds account, tax collected to a VAT liability account.
VAT for UK Shopify Sellers
VAT on UK sales
If you're VAT registered, you charge VAT on sales to UK customers and account for it on your quarterly VAT return. VAT collected through Shopify must flow correctly to your Xero VAT liability account. If your integration is booking net payouts, this isn't happening.
VAT on sales to EU customers
Post-Brexit, selling to EU consumers is governed by the EU OSS scheme for goods under €150 shipped from the UK, or individual country VAT registrations for higher-value goods or goods shipped from within the EU. Most Shopify sellers with significant EU sales either don't know about this or have set up the wrong thing.
VAT on Shopify fees
Shopify charges VAT on its subscription and transaction fees for UK businesses. You can reclaim this on your VAT return — but only if your accountant has set up the VAT codes on those transactions correctly.
What Good Shopify Accounting Looks Like Monthly
Every month your books should show you:
- Gross revenue by channel (Shopify, Amazon, wholesale — separately)
- Refunds and returns as a separate line
- COGS — what you paid your supplier for units sold that month
- Gross margin percentage
- Shopify fees, payment processing, and advertising as separate expense lines
- Net profit after all costs
- VAT liability accrued that month
If you're not seeing all of that monthly, your accounting setup isn't giving you what you need to run your business.
Questions to Ask Any Shopify Accountant
- Do you use Link My Books or a similar tool? (Not the native Shopify-Xero integration.)
- How do you handle EU VAT for Shopify sellers shipping internationally?
- Can you show me what a monthly P&L looks like for a Shopify seller? (Should show gross sales, not net payouts.)
✓ We recovered £20,000 in overpaid VAT for a Shopify seller in the first month of taking them on. Their VAT setup was fundamentally wrong — Shopify's tax collected was being included in the return twice. This is not unusual.
Running a Shopify store and not sure your books are right?
We'll review your current setup — integration, VAT position, and margin reporting — and tell you exactly what needs fixing. Free, 30 minutes.
Book a free call →