Shopify bookkeeping in 2026: the complete guide for international sellers using Xero & A2X
Shopify is the world's most popular ecommerce platform for a reason — it just works. But the same simplicity that makes Shopify easy to sell on makes the bookkeeping harder than it looks. Payment gateways stack on top of each other, sales tax rules differ by country, and every payout combines dozens of orders, refunds, and fees into a single number that lands in your bank. This guide walks through the workflow we use across Shopify sellers based in the UK, US, Australia, and elsewhere — and addresses the specific question we hear most often: does it matter that we're a UK-registered practice serving international sellers? Short answer: no, and here's why.
Why Shopify bookkeeping is different from a normal retail business
If you've ever done books for a regular retail shop, the mental model is straightforward: customers pay, cash goes into the till or the bank, you record it as revenue. Shopify breaks this model in three ways at once.
First, there's a gap between the sale and the money arriving. A customer buys something on Tuesday. Shopify processes the payment. Two or three business days later, the net amount (after processing fees) lands in your bank account — bundled with hundreds of other orders, refunds, and adjustments from that same period. Reconciling that single bank deposit back to individual sales is where most self-taught Shopify bookkeeping falls apart.
Second, Shopify usually isn't your only payment processor. Even sellers who use Shopify Payments as their default often also have PayPal, Klarna, Afterpay, Apple Pay, or Amazon Pay running alongside. Each processor has its own payout schedule, its own fee structure, and its own reconciliation quirks. Miss any of them and your books won't balance.
Third, Shopify is a global platform but every country has different tax rules. A UK Shopify seller doing dropshipping to US customers has a completely different tax picture from a US Shopify seller doing wholesale into the EU. The platform is the same; the accounting isn't.
The honest reality: Manual monthly reconciliation from Shopify CSV exports is genuinely feasible up to about 50-100 orders per month. Above that, the time cost of doing it by hand exceeds the cost of proper integration tools — and mistakes compound.
Does it matter that we're based outside your country?
This is the question we're asked most often by prospective Shopify clients, particularly those based in the US, Australia, and Canada. The concern is understandable: "You're a UK-registered practice — can you really help me with my US Shopify business?"
The honest answer requires distinguishing two different things:
What we do: bookkeeping, accounting preparation, Shopify-to-Xero/QuickBooks integration setup, monthly reconciliation, management reporting, year-end accounts preparation. This work is technical, platform-based, and largely country-agnostic. A properly set-up Xero file for a US Shopify seller is prepared identically whether the bookkeeper sits in London, Sydney, or Dhaka. We've been doing this for sellers across the UK, US, Australia, Canada, and the EU for a decade.
What we don't do: act as your registered tax agent before the tax authority in your country. In the US, that's typically a CPA or Enrolled Agent handling your IRS filings. In Australia, a registered tax agent. In Canada, a CPA. This is why our engagements with international clients typically follow a "preparation-only" model — we prepare your books, deliverables, and draft tax computations to a professional standard, and you (or your local CPA/tax agent) submit them.
In practice, this structure works well for most international Shopify sellers. You get the technical bookkeeping expertise of a decade-experienced ecommerce practice, plus the local filing relationship of a country-specific tax agent. Many of our long-term clients pay us monthly for bookkeeping and pay their local CPA a much smaller annual fee just for filing — which is usually cheaper than paying a local generalist accountant to do everything.
What this means in practice: if you're a US or Australian Shopify seller reading this, we can absolutely handle your day-to-day and month-end bookkeeping in Xero or QuickBooks Online. We'll produce the books, reports, and draft tax figures. You keep (or find) a local CPA or tax agent for the actual filing. Everyone plays to their strengths.
The toolkit: Xero or QuickBooks + A2X + Shopify Payments (or not)
For the majority of Shopify sellers, the right stack is:
- Xero or QuickBooks Online as your accounting platform. Both work well for Shopify. We tend to recommend Xero for sellers in the UK, Australia, and New Zealand; QuickBooks Online for sellers primarily in the US. For sellers spanning multiple regions, either is fine — the deciding factor is usually which one your future accountant or in-house team is more comfortable with.
- A2X for Shopify as the integration between Shopify and your accounting software. A2X reads each Shopify payout report, breaks it apart into individual revenue, refund, fee, tax, and gift-card categories, and posts a clean summary journal per payout. A2X for Shopify plans start from roughly £15–£30 per month depending on volume.
- A dedicated business bank account in the currency of your primary Shopify payout. UK sellers: a GBP business account. US sellers: a USD business account. Australian sellers: AUD. If you sell into multiple currencies, add a multi-currency provider like Wise or Airwallex.
- Bank feeds connected into your accounting platform so payouts arrive automatically for reconciliation against the A2X journals.
Some sellers ask whether they can skip A2X and use Shopify's native Xero or QuickBooks integrations. In our experience, the answer is: only if your order volume is very low (under about 30-50 orders per month) and you never take refunds. The native integrations don't break out Shopify fees, refunds, or tax properly, and the reconciliation gets messy fast.
Disclosure: we are A2X Certified for Accountants and Bookkeepers. We recommend A2X because we use it across the majority of our ecommerce engagements and have seen it consistently outperform alternatives — but the certification does not affect what we recommend, and we do not earn commissions from A2X subscriptions.
Chart of accounts setup for Shopify
Before connecting any tools, your chart of accounts needs to be set up to receive the data A2X will send. Here's the structure we typically build for a Shopify seller:
Revenue accounts
- Shopify Sales — Domestic
- Shopify Sales — International (if you sell cross-border)
- Shopify Shipping Income (customer-paid shipping is revenue)
- Shopify Refunds (contra-revenue — reduces revenue on the P&L)
- Shopify Discounts (contra-revenue)
- Gift Card Sales (a liability until redeemed — see below)
Cost of goods sold
- COGS — Products
- Shopify Payment Processing Fees
- Third-party Payment Processing Fees (PayPal, Klarna, etc.)
- Shopify Shipping Costs (what you pay to fulfil)
- Transaction Fees (Shopify's fee if you don't use Shopify Payments — this is separate from processing fees)
Operating expenses
- Shopify Subscription Fees
- Shopify App Subscriptions (Klaviyo, Loox, ReCharge, etc.)
- Shopify Advertising (if running Shopify's ad network)
- Facebook/Google/TikTok advertising (typically categorised separately)
Balance sheet accounts
- Shopify Payments Clearing Account (current asset) — money in your Shopify balance that hasn't yet paid out to your bank
- PayPal Clearing Account (current asset) — same for PayPal
- Gift Card Liability — money you've received for gift cards that haven't been redeemed yet
- Sales Tax/VAT Collected — a liability, not revenue
The gift card treatment often catches sellers out. When someone buys a £50 gift card, you've received £50 cash but you haven't earned it yet — you've taken on a liability to deliver £50 of goods later. Revenue is only recognised when the gift card is redeemed. Skipping this treatment overstates revenue in the month of sale and understates it in the month of redemption.
The payment gateway problem (and how to solve it)
The single biggest source of Shopify bookkeeping headaches is having multiple payment gateways running simultaneously. Consider a typical setup: Shopify Payments as default, PayPal as an option at checkout, and Klarna for buy-now-pay-later.
Each gateway operates independently:
| Gateway | Typical payout cadence | Fee structure |
|---|---|---|
| Shopify Payments | Every 1-3 business days | ~1.5-2.9% + fixed fee per transaction (varies by country and plan) |
| PayPal | Immediate to PayPal balance; manual or scheduled transfer to bank | ~2.9% + fixed fee (higher for international) |
| Klarna | Weekly or monthly settlement depending on region | ~3-5% depending on plan type |
| Amazon Pay | Every 3-7 days | ~2.9% + fixed fee |
Each of these needs its own clearing account in your chart of accounts. Each needs its own reconciliation workflow. And critically: an order paid via PayPal shouldn't appear in your Shopify Payments account, and vice versa. A2X for Shopify handles this correctly by default — the summary journal identifies which gateway processed each order and posts to the appropriate clearing account.
The manual approach — trying to reconcile all payment gateways from CSV exports each month — becomes impractical above about 100 orders per month. This is where proper tooling pays for itself.
A UK Shopify seller doing about £45k/month came to us after their previous bookkeeper had lumped all payment gateway revenue into a single "Shopify sales" line. When we broke it out properly, we discovered that Klarna transactions carried nearly 3x the processing cost of Shopify Payments transactions — but the seller had no visibility into this. After the setup, they were able to see channel profitability clearly and adjusted their checkout to encourage Shopify Payments as the default. Within three months, their effective processing cost dropped by about 0.6% of revenue.
Sales tax and VAT for Shopify sellers by country
Tax treatment on Shopify depends heavily on where you're based, where your customers are, and what you sell. A brief primer by country:
UK sellers
If your total Shopify turnover exceeds £90,000 in any rolling 12 months, you must register for VAT with HMRC. Once registered, you charge VAT on UK sales (currently 20% standard rate). For sales into the EU, the post-Brexit landscape is complicated — the EU One Stop Shop (OSS) scheme lets you register once and report EU-wide, but only if you meet certain conditions. Below €10,000 total EU B2C sales you can use your home-country VAT rules; above that, OSS or country-by-country registration is required.
US sellers
Shopify now collects sales tax automatically in most US states under marketplace facilitator laws — but the seller still needs to understand nexus (which states you have tax obligations in), file information returns, and reconcile what Shopify collected against what was owed. Physical nexus (offices, warehouses, employees) and economic nexus (revenue thresholds in each state) both matter. Shopify's Tax dashboard is helpful but not a substitute for proper tax filings.
Australian sellers
GST registration is required once your annual turnover exceeds AU$75,000. Once registered, you charge 10% GST on domestic sales. For international sales, the picture is more complex — inbound low-value goods and digital services have specific rules that shifted in 2018 and have been refined since.
EU sellers
VAT rules vary by member state but the OSS scheme applies broadly. Cross-border B2C sales above €10,000 total annually into other EU countries require OSS registration or country-by-country VAT numbers.
None of this is something to figure out at year-end. If you're a Shopify seller doing meaningful volume — say, above the equivalent of $30,000-$50,000 per year — sales tax positioning needs to be set up correctly from month one, or you'll be unwinding mistakes later.
The monthly reconciliation workflow
Once the setup is done, the recurring monthly workflow is genuinely simple. For a mid-volume Shopify seller with A2X, it takes about 45-90 minutes per month:
1. Review A2X-generated payout journals
A2X posts a journal for each Shopify (and PayPal, Klarna, etc.) payout. Review the breakdown, check totals against the Shopify dashboard, and approve to post to Xero or QuickBooks.
2. Match bank deposits to A2X journals
The actual payouts arrive in your business bank account via the bank feed. Match each deposit against the matching A2X journal. Amounts should match to the penny.
3. Reconcile clearing account balances
At month-end, the balance of each payment gateway clearing account in your accounting platform should equal the pending balance in the gateway's dashboard. If they match, your books are clean.
4. Reconcile inventory
Adjust your inventory asset account to match your actual stock on hand at month-end. The change becomes cost of goods sold for the month. This step is skipped by most self-managed sellers and is the single biggest source of misleading P&Ls.
5. Review the P&L
Open the profit & loss for the month. Is gross margin sensible? Are payment processing costs in line with revenue? Are advertising expenses tracking against budget? This is where bookkeeping becomes decision-support, not just data entry.
Common mistakes we see
Treating Shopify payouts as revenue
Same core mistake as Amazon FBA: the £3,247 that landed in your bank isn't your revenue — it's the net of gross sales, refunds, and processing fees. Recording it as a single revenue line throws away every piece of useful information.
Not tracking gift cards as a liability
Gift card sales are cash-in-hand liabilities, not revenue. Recognise revenue only when the gift card is redeemed, not when it's purchased.
Mixing personal and business Shopify accounts
Every seller we onboard who used a personal PayPal or personal bank account for their Shopify payouts regrets it. Set up dedicated business accounts before your first sale.
Ignoring app subscriptions as expenses
The typical mid-sized Shopify store runs 10-20 paid apps. Klaviyo, Loox, ReCharge, Judge.me, Yotpo — these add up to hundreds of pounds monthly and need to be tracked as operating expenses, not lost in miscellaneous.
Not planning for the VAT/sales tax threshold
Sellers who scale fast can hit VAT or sales tax registration thresholds mid-year without realising. By the time HMRC or the state tax authority contacts them, months of unpaid tax may have accumulated. Regular monthly bookkeeping catches this early.
Reconciling FX gains and losses inside revenue
If you sell in multiple currencies, exchange rate movements between sale date and payout date create FX gains and losses. These belong in their own account, not buried inside revenue. Otherwise your reported gross margin fluctuates unpredictably with currency markets.
This is where most scaling Shopify sellers call us. Setup and monthly workflow are straightforward once you know what to do — but the specifics vary meaningfully by country, gateway mix, and volume. Book a free 20-minute Shopify bookkeeping review and we'll walk through your specific situation.
When to get professional help
An honest assessment. For very simple Shopify usage — a side business doing under $2,000-$3,000 per month, one payment gateway, no international sales — DIY bookkeeping with Xero + A2X is a perfectly reasonable place to start. You'll learn how the numbers work and it costs under £50/month all-in.
The point where professional setup pays for itself is any of these:
- More than $5,000-$10,000 per month in Shopify revenue
- Multiple payment gateways (Shopify Payments + PayPal + anything else)
- International sales in multiple currencies
- Meaningful physical inventory that needs proper cost-of-goods tracking
- Approaching your country's VAT or sales tax registration threshold
- You spend more than an hour a month on bookkeeping and still feel unsure of the numbers
Setting things up correctly at the start takes a few hours. Cleaning up mistakes after 12-24 months takes weeks and costs many times more. This is the pattern we see repeatedly.