Outsourced Bookkeeping for UK eCommerce Businesses — Shopify, VAT, and Reconciliation

Why eCommerce Bookkeeping Is More Complex Than Standard Bookkeeping

Standard bookkeeping involves coding bank transactions and reconciling them to invoices. eCommerce bookkeeping involves everything that happens before the money hits the bank — and the UK regulatory changes post-Brexit have added significant complexity to the VAT side.

The added complexity in UK eCommerce bookkeeping includes:

• Platform reconciliation: Shopify, Amazon, and eBay pay out net amounts after deducting fees, refunds, and adjustments. The payout to your bank is not the same as gross sales. Reconciling gross sales, fees, refunds, and VAT from payout reports to bank deposits is a multi-step process that requires understanding how each platform calculates its net settlement.
• Multiple VAT rates: Most eCommerce products are standard-rated (20%), but some are zero-rated (children's clothing, books, food) or reduced-rated (5%). Getting VAT rates wrong on thousands of transactions creates significant exposure.
• Post-Brexit EU VAT: Since Brexit, UK businesses selling to EU consumers face new VAT obligations — per-country registration or the EU One Stop Shop scheme.
• Multi-currency: International sales in EUR, USD, or other currencies require exchange rate treatment in your accounts.
• Inventory accounting: For product-based businesses, stock movement needs to be reflected in cost of goods sold, which requires linking purchasing records to sales records.

VAT for UK eCommerce — What Has Changed Since Brexit

Brexit changed the VAT rules for UK eCommerce businesses selling goods to EU consumers significantly. Understanding these rules is essential — the penalties for non-compliance are applied per EU country.

For most UK eCommerce businesses selling physical goods to EU consumers, the practical implication is that goods under £135 are exported zero-rated and the EU buyer handles VAT — but you must ensure your platform is configured correctly to reflect this in your accounts and not overcharge UK VAT on EU sales.

The OSS Scheme and EU Sales — What Your Bookkeeper Must Handle

The EU One Stop Shop (OSS) scheme simplifies VAT compliance for businesses selling digital services or goods to consumers across multiple EU countries. Instead of registering for VAT separately in each of 27 EU countries, a business registers in one and files a single quarterly return covering all EU sales.

UK businesses cannot use the EU OSS scheme directly — they must register in one EU member state (most commonly Ireland or Germany) and file through that country's OSS portal.

An Indian CA firm handles the preparation side of OSS compliance:

• Identifying which sales are subject to OSS (digital services to EU consumers, or goods below £135 where the seller has opted to collect EU VAT)
• Segmenting sales by EU country and applicable VAT rate
• Calculating VAT due in each EU member state based on that country's standard, reduced, or super-reduced rate
• Preparing the quarterly OSS return data for filing

The actual OSS return submission goes through the portal of your EU registration country — this is typically handled by your EU VAT agent or tax adviser in the country of registration. Your Indian bookkeeper provides the prepared data.

Shopify and WooCommerce Reconciliation — How Indian Firms Work with Platform Data

The most time-consuming part of eCommerce bookkeeping is reconciling platform payouts to your bank. Here is how it works with an Indian team:

The A2X Method (Recommended)

A2X is an integration tool that connects Shopify, Amazon, WooCommerce, eBay, and Etsy to Xero or QuickBooks. It automatically imports summarised settlement data — gross sales, fees, refunds, and VAT — and posts it to your accounting software in a format that reconciles directly to bank payouts.

With A2X in place, your Indian bookkeeper reconciles the A2X-posted entries to the bank feed in Xero. The gross-to-net reconciliation is handled by A2X; your Indian team validates the entries and handles any exceptions.

Manual Platform Report Method

Without A2X, reconciliation requires downloading payout reports from each platform, matching gross sales to fee deductions, identifying refunds, and coding everything to the correct accounts manually. This is feasible for low-volume sellers (under 100 orders/month) but becomes unmanageable at higher volumes. Most businesses processing 200+ orders/month benefit from A2X — the cost (£19–£69/month depending on volume) is recovered in bookkeeper time savings within the first month.

Amazon, eBay, and Multi-Channel Seller Bookkeeping

Multi-channel sellers — businesses selling on Shopify, Amazon, and eBay simultaneously — face the most complex reconciliation challenge. Each platform has its own payout schedule, fee structure, and refund mechanism. A2X supports all three and posts to Xero in a consolidated format.

For Amazon UK sellers specifically, your Indian bookkeeper handles:

• Amazon FBA (Fulfilled by Amazon) fee reconciliation — storage fees, fulfilment fees, referral fees
• Amazon VAT Calculation Service integration if enabled
• Amazon's bi-weekly payout reconciliation to bank
• Amazon Reserve amounts — the portion Amazon holds back, which does not appear as income until released
• Reimbursements for lost or damaged FBA inventory

For UK businesses selling on multiple platforms, a combined bookkeeping package covering all channels is more cost-effective than managing each platform separately. Your Indian team builds a consolidated chart of accounts that tracks revenue and cost of sales by channel.

Cost: UK eCommerce Bookkeeper vs Indian CA Firm

These figures include platform reconciliation, UK VAT preparation, and monthly management accounts. A2X subscription cost (£19–£69/month) is additional but typically covered within the first month's saving versus a UK bookkeeper.

Frequently Asked Questions