E-commerce is data-intensive in ways that traditional retail accounting is not. A small Shopify store might process 200 orders a day, each with platform fees, payment gateway fees, refunds, shipping costs, and increasingly multi-currency settlements. An Amazon FBA business adds storage fees, fulfilment fees, advertising spend, and complex payout reconciliation. Multi-channel sellers (Shopify + Amazon + eBay) multiply the integration work. Generic bookkeeping breaks under this volume.
This guide covers the specific operational accounting challenges for UK online retailers. Each section links to a detailed spoke.
Reconciling against payouts, not orders
A common e-commerce bookkeeping error is recording each order as revenue without reconciling against the payout. The platforms (Stripe, Shopify Payments, PayPal) hold transaction fees back, take chargebacks, hold reserves. Real revenue is the net payout, not the gross order value. Reconciling at the payout level is essential.
Reconciling payment gateways
The payment gateway reconciliation flow:
- 1Order placed: gross amount captured by Shopify/Amazon/etc.
- 2Customer paid: payment processor (Stripe, PayPal, etc.) processes the payment.
- 3Payout: a few days later, processor pays out the net amount (gross less fees, less refunds, less chargebacks, less held reserves).
- 4Bank receives the payout amount.
- 5Bookkeeping records: gross revenue per order in Sales; processor fees as Cost of Sales; refunds as adjustments; reconciliation between expected payout and actual receipt.
Tools that automate this: A2X (specifically for Shopify, Amazon, eBay → Xero/QuickBooks), Zapier-based custom flows, the native integrations within Xero and QuickBooks. Manual reconciliation is impractical above ~50 orders per month.
Multi-currency accounting
UK e-commerce sellers increasingly accept payments in multiple currencies (USD from US customers, EUR from EU customers). The accounting treatment:
- Use multi-currency accounting software (Xero, QuickBooks Online, Sage 200) — not single-currency variants.
- Each foreign-currency transaction recorded at the exchange rate on the date of transaction.
- Foreign-currency bank accounts maintained separately; revaluation at period-end produces FX gains or losses.
- Settlement to GBP creates a realised FX gain or loss recorded in the income statement.
- For VAT: foreign-currency invoices need GBP equivalents at the date of supply for the VAT return.
Inventory valuation: FIFO vs AVCO
Inventory valuation matters for both COGS calculation and balance sheet presentation. The two main methods:
| Method | Description | When it fits |
|---|---|---|
| FIFO (First In, First Out) | Sell oldest stock first; closing stock valued at most recent costs | Most common; matches physical flow for perishables and slow-moving stock |
| AVCO (Weighted Average Cost) | Weighted average cost across all units; closing stock at average | Useful where stock is interchangeable and prices are stable |
| Specific identification | Each unit costed individually | High-value items (jewellery, art, custom-built) |
UK GAAP (FRS 102 Section 13) permits both FIFO and AVCO. LIFO (Last In, First Out) is not permitted. The choice should be applied consistently and disclosed in the accounting policies.
Amazon FBA accounting
Amazon FBA businesses face specific reconciliation complexity:
- Multiple fee categories: referral fees, FBA fulfilment fees, monthly storage, long-term storage, removal/disposal, returns processing, advertising spend.
- Payouts are bi-weekly (every 14 days for Pro Sellers).
- Reserves: Amazon holds back funds for refunds and chargebacks.
- A2X and similar tools categorise each line of the Amazon settlement file into the right GL account in Xero/QuickBooks.
- VAT: Amazon collects and remits some VAT directly to HMRC under the OSS scheme; UK-only sellers need to handle UK VAT themselves.
COGS tracking for true margin
Many e-commerce sellers report inflated profit because they do not separate COGS (Cost of Goods Sold) from operating expenses. True gross margin = (Revenue - COGS) / Revenue, where COGS includes the product cost plus the fulfilment cost (or FBA fees). Operating margin then deducts marketing, software, salaries, and overheads. Without the COGS split, the business cannot tell which products are profitable and which are subsidising the others.
Inventory cash cycle
For overseas-sourced inventory businesses, the cash flow cycle is particularly tight:
- 1Order placed with supplier (China, Vietnam, etc.) — typically 30% deposit upfront.
- 2Production takes 30-60 days.
- 3Balance paid before shipment.
- 4Shipping takes 30-45 days.
- 5Inventory clears customs and arrives.
- 6Inventory sells over the following 30-90 days.
- 7Customer payments received over the following 1-30 days (depending on platform).
Total cycle: typically 4-7 months from initial deposit to last customer cash collected. For businesses growing rapidly, the working capital pull is substantial. Cash flow forecasting needs to model the inventory cycle explicitly.
Integrating e-commerce platforms with accounting software
The integration patterns:
- Shopify → A2X → Xero/QuickBooks: industry standard for Shopify sellers.
- Shopify native integrations: built-in connectors to Xero and QuickBooks but less granular than A2X.
- Amazon → A2X → Xero/QuickBooks: handles the complexity of Amazon settlement files.
- Multi-channel: A2X handles multiple channels; Linnworks adds order management.
- Custom: Zapier and similar tools for non-standard requirements.
E-commerce accounting setup or clean-up?
A Harrow e-commerce specialist will set up the integrations, configure A2X, and structure the COGS tracking for true margin visibility. Free initial assessment.