E-commerce bookkeeping has quirks that generic small business accounting software doesn't always handle well — from inventory valuation to reconciling dozens of small marketplace payouts. Getting the setup right early saves significant pain later.
Why e-commerce bookkeeping is harder than it looks
A typical online retailer processes far more individual transactions than a comparable-turnover service business — hundreds or thousands of small orders a month, often across multiple sales channels (your own site, Amazon, eBay), each with its own payment processor, fee structure and payout schedule. Reconciling this manually, transaction by transaction, quickly becomes impractical, which is why most successful stores invest early in accounting software with genuine e-commerce integrations rather than relying on spreadsheets past the very earliest stage.
Choosing accounting software
Xero and QuickBooks are the two dominant UK small business accounting platforms, both Making Tax Digital-compliant and both with mature integrations for Shopify, WooCommerce and major payment gateways via direct connections or middleware apps like A2X or Link My Books, which correctly categorise sales, fees, refunds and taxes from each channel into clean accounting entries rather than a single lump payout figure that obscures what actually happened.
For stores with more complex multi-channel or multi-currency needs, dedicated e-commerce accounting middleware (A2X in particular is widely used specifically for its accurate handling of Amazon and Shopify settlement reports) is often worth the modest monthly cost purely in bookkeeping time saved and error reduction.
Inventory accounting methods
How you value inventory affects your reported cost of goods sold and profit — most UK e-commerce businesses use either FIFO (First In, First Out, assuming the oldest stock sells first) or weighted average cost, and consistency matters more than which method you pick, since switching methods can distort year-on-year comparisons and needs to be disclosed correctly to HMRC and your accountant if it happens.
Whichever method you use, your accounting system should track inventory value as an asset (not just an expense when purchased), since inventory sitting unsold is genuinely a balance sheet asset — this distinction matters for accurately understanding your real profitability and cash position, not just how much stock you happen to have paid for this month.
Reconciling multi-channel and multi-currency sales
If you sell across your own website and marketplaces, or to international customers in multiple currencies, reconciliation gets meaningfully harder — a single Amazon payout might bundle two weeks of sales, referral fees, FBA fees, refunds and advertising spend into one net figure, and correctly unpacking that into accurate revenue, cost and fee lines (rather than just recording the net deposit) is essential for understanding true channel-by-channel profitability.
This is precisely the problem e-commerce-specific accounting middleware is built to solve, and it's one of the clearest cases where a modest monthly software cost pays for itself many times over in both bookkeeping time and the quality of the financial data you're basing decisions on.
Building a monthly close routine
- Reconcile bank and payment processor accounts against your accounting software weekly, not just at month end, to catch discrepancies early.
- Review gross margin by product/category monthly — aggregate margin figures can hide individual loss-making SKUs.
- Track and categorise returns and refunds separately from gross sales, since a rising return rate is an early warning sign worth catching quickly.
- Reconcile inventory counts (physical or system) against accounting records at least quarterly to catch shrinkage or data errors.
- Review outstanding supplier and customer balances monthly to stay ahead of cash flow surprises.
Where This Fits Into Your Wider Strategy
As with most things covered in Starting & Scaling, e-Commerce bookkeeping and accounting software: what UK retailers actually need works best when it's revisited periodically rather than decided once and forgotten. For the practical mechanics, see Headless Commerce and Composable Tech Stacks Explained (And When You Actually Need One).
Timing matters as much as the decision itself. Many of the choices within Funding & Finance are far cheaper to get right in the first few months than to unwind later, once suppliers, customers, contracts or search engine rankings have already formed around your original setup. Where possible, build in a short review point — 90 days is a reasonable default — to check the assumptions you made are still holding before you commit further capital.
None of this happens in isolation. The decisions covered under Funding & Finance tend to interact with almost every other part of a new UK online business — your cash position, your legal structure, and the platform you eventually choose all shift depending on the path you take here. Founders who treat this as a one-off box to tick, rather than a decision to revisit as the business grows, usually end up re-doing the work six or twelve months later at a higher cost in time and money.
For related reading: It's worth reading this alongside Business Insurance Essentials for UK Online Retailers: What You Actually Need and What You Don't before making a final decision. For a closer look at this, see our guide to Writing a Lean E-Commerce Business Plan That You'll Actually Use. Many of the same principles come up again in PIM Explained: Do UK Online Retailers Need Product Information Management Software?, which is worth bookmarking for later.