Reconciling e-commerce revenue is the most under-engineered area in UK online seller accounting. The disconnect between Shopify's order count, Stripe's payouts, and the bank statement creates a settlement gap that compounds across hundreds of orders per day. Add BNPL providers (Klarna, Clearpay), multi-currency from US/EU customers, chargebacks and refunds delayed by 60-180 days, and the multi-channel reality (Shopify + Amazon + Etsy + TikTok Shop), and the manual reconciliation that worked at 50 orders/month is unworkable at 500.
This pillar covers the major reconciliation patterns for UK e-commerce. Each section links to a detailed companion piece on the specific issue.
Generic Xero/QuickBooks setups break above 200 orders/month
Most generic small-business accounting setups treat each Shopify order as a separate sales transaction. Above 200 orders/month, transaction limits, sync delays, and reconciliation overhead overwhelm the system. A2X, Link My Books, or similar settlement-summary tools are essential — not optional.
Why the settlement gap exists
Shopify orders are placed daily. Stripe (or Shopify Payments) processes the customer card, holds the funds for 1-3 days, deducts processing fees, deducts refunds and chargebacks accumulated since the last payout, and remits the net amount to the seller's bank. By the time the funds arrive, the gross revenue (orders), the fees, the refunds, and the chargebacks are all aggregated into a single bank deposit. Reconciling that deposit against the underlying line items is what produces meaningful accounting.
The reconciliation stack
- 1Sales channel (Shopify, Amazon, Etsy, TikTok Shop): produces gross orders, returns, refunds, fees.
- 2Payment processor (Stripe, Shopify Payments, PayPal): produces net payouts after fees, refunds, chargebacks.
- 3Settlement-summary tool (A2X, Link My Books): aggregates the channel + processor data into journal entries posted to accounting.
- 4Cloud accounting (Xero, QuickBooks): receives journal summaries; reconciles to bank feed.
- 5Bank reconciliation: matches each payout to the journal summary and the bank deposit.
BNPL providers and the merchant fee complication
Klarna, Clearpay (Afterpay UK), and similar BNPL providers operate on different fee structures from card processors. Typical Klarna fee: 4.99% + 20p per transaction (vs Stripe's ~1.4-2.9%). The fee is deducted before payout, but the payout cadence and reporting differ from Stripe. Reconciliation needs separate streams for each BNPL provider.
Multi-currency: the unrealised gain/loss problem
A US customer pays $100 in USD. Stripe converts to GBP at the spot rate (less Stripe's currency margin). The seller records the sale at the GBP equivalent at the order date. By the time the payout lands, the rate has moved. The difference is an unrealised exchange-rate gain or loss. For high-volume sellers, these add up to thousands per year.
Gross vs net revenue recognition
Recording only the net payout in revenue (the most common error) understates true turnover and obscures the cost structure. Correct treatment: record gross revenue at the order amount; record processor fees as a separate cost line; record refunds against revenue; record payouts as a bank receipt offset against the gross-fees-refunds calculation. The bookkeeping cost is higher but the management reporting is dramatically better.
Reconciliation system needs review?
Free, no obligation. Matched with a vetted specialist.
Specialist E-commerce Accountant Matching Service
All guides on this site are reviewed for technical accuracy by qualified accountants in our network before publication.