Accounting Software for E Commerce: A UK SME Comparison

Choose fully functional Making Tax Digital software that posts sales, fees, refunds and VAT directly into your ledger, because businesses using fully compatible software saved an estimated 26-40 hours per year on finance and record keeping. For most UK stores moving towards seven figures, that means Xero or QuickBooks Online with a proper payout connector, not spreadsheets with bridging software bolted on.

You're probably not short of sales data. You're short of data you trust. Shopify says one number, the bank shows another, Amazon settles something else two weeks later, and your accountant is asking why VAT doesn't reconcile to either. That's the point where accounting software for e-commerce stops being a subscription decision and becomes a control decision.

The Real Finance Problem Behind an Online Store

A high street retailer takes payment, banks it and records the sale. You don't. Your customer pays a platform or gateway, the gateway deducts fees, holds money for a few days, mixes in refunds from last month and a chargeback from a sale you barely remember, then pays you a net lump sum. If your bookkeeper records that lump sum as sales, your profit and loss is wrong from line one.

That single problem creates four others. VAT gets calculated on the wrong amount or at the wrong rate for the destination. Stock in your warehouse, at a fulfilment centre and in transit drifts away from what's in the ledger. Refunds reverse income in a different month from the original sale, so monthly margin swings for no operational reason. And you can't tell which channel makes money.

Why Payment Costs Deserve Management Attention

Payment fees aren't admin noise you can bury in bank charges. The British Retail Consortium payment survey reporting £1.48bn in card fees in 2024, more than twice the 2019 amount while transactions fell from 20.9bn to 20.4bn shows why payment cost discipline is now a management accounting problem, not just a bookkeeping entry.

If you don't split processor fees by channel and payment method, you can't price properly, you can't judge a marketplace fairly and you can't spot fee creep. Growth then looks healthy on turnover while cash gets tighter.

The Lens I Use With Clients

Ignore feature count at the start. Judge every option against three tests.

• MTD-ready records: Does it keep a complete digital trail from order to VAT return without re-keying?
• Channel contribution: Does it show profit after fees, refunds, fulfilment and cost of goods sold, channel by channel?
• Clean month-end: Can an outsourced accountant close the month quickly without chasing spreadsheets from you?

If a platform fails the first test, stop. If it passes the first but fails the second, it'll keep you compliant and still leave you guessing. You need both.

What MTD for VAT Means for Your Software Choice

Since April 2019, VAT-registered businesses above the taxable-turnover threshold have had to keep digital records and file through compatible software, and from April 2022 that extended to all VAT-registered businesses. For an e-commerce company, that isn't a background compliance detail. It's the filter that should narrow your shortlist before you look at dashboards or app marketplaces.

HMRC draws a clear line. Fully functional software keeps the digital records and submits the VAT return directly. Bridging software connects a spreadsheet to HMRC so you can file what's already in the spreadsheet. Bridging can be legal, but for a store processing daily settlements from several gateways it's usually the wrong answer because the spreadsheet remains your real system, with all its copy and paste risk.

The evidence backs that judgement. In HMRC's final evaluation showing 76% of fully compatible software users reported at least one MTD benefit compared with 54% using bridging software, alongside estimated savings of 26–40 hours per year, the better setup wasn't just more compliant. It was less work.

What Digital Records Mean In Practice

For your store, digital links should cover the whole journey. Orders import automatically, VAT codes survive the import, adjustments happen inside the software, bank and gateway accounts reconcile to settlements, and the return submits from the same records. Any step where someone downloads a CSV, edits it and uploads it elsewhere is a weak point your accountant will have to unpick.

Practical rule: If your VAT return depends on a spreadsheet tab only one person understands, you don't have a finance system. You have a key person risk.

Read the detail on making tax digital for VAT and what digital records require before you buy anything. Then ask vendors to demonstrate a live settlement going through to a VAT box, not a slide about integrations. If they can't show that trail cleanly, remove them from the list.

Comparing Xero, QuickBooks Online, Sage and a Mid-Market Option

For most UK SMEs, the choice is Xero versus QuickBooks Online, with Sage Accounting as a credible UK-focused alternative and a mid-market system such as Sage Intacct or Microsoft Dynamics 365 Business Central only when stock, entities or approvals have outgrown small business software. Don't buy mid-market complexity to solve a connector problem.

Where Each One Earns Its Place

Choose Xero if you want the cleanest bank reconciliation experience and the deepest UK app marketplace around the ledger. It's my default recommendation for a Shopify-led business using A2X or Link My Books, because your accountant can standardise month-end and add inventory or reporting tools as you grow. Its weakness is stock. Once you need proper landed cost, bundles across locations or disciplined purchase ordering, you'll add an inventory system or outgrow it.

Choose QuickBooks Online if built-in inventory, multi-currency handling and channel tracking matter inside the core product and you want fewer add-ons at the start. It handles a busy multi-channel operation well, especially on higher tiers where inventory and more detailed reporting are available. The trade-off is discipline. Its flexibility with categories and classes can become messy quickly if nobody owns the chart of accounts.

Choose Sage Accounting if UK payroll heritage and a familiar Sage environment matter more than marketplace breadth, and your channel mix is relatively simple. It's dependable for VAT and day-to-day bookkeeping. I wouldn't choose it for a complex Amazon operation where the quality and choice of specialist connectors will determine how painful reconciliation feels.

Move to a mid-market platform when you have multiple warehouses, wholesale alongside direct sales, several entities or stock valuation problems that are costing real money. You'll gain control, but you'll pay in implementation time, training and ongoing administration. That move is justified by operational complexity, not by turnover alone.

The E-Commerce App Stack Around Your Ledger

Your ledger won't do every job well, and it shouldn't try. A growing store usually needs layers around it, each owning one job and feeding clean summaries back to the accounts. The mistake is buying apps in isolation so two tools both claim to control stock, or a connector posts sales that your inventory system posts again.

Scale explains why this stack matters. The ONS digital economy survey reporting £459.2 billion in website sales in 2021, up £102.8 billion or 28.8% from 2019, with £77.8 billion in cross-border sales and 96.9% through businesses' own websites or apps points to transaction volumes and overseas sales that manual entry can't handle reliably.

The Five Layers That Matter

• Payout connector: A2X or Link My Books translates Shopify, Amazon, eBay and Etsy settlements into summarised journals split by sales, VAT, fees and refunds.
• Inventory system: Tools such as Cin7, Unleashed or Linnworks manage stock by location, purchase orders and cost of goods sold where the ledger is too light.
• VAT support for cross-border sales: Specialist VAT tools or adviser-led processes handle destination rules so your ledger receives the right tax codes first time.
• Payroll: Xero Payroll, QuickBooks payroll or Sage payroll should post journals cleanly and keep director and staff costs out of messy manual entries.
• Reporting layer: Fathom, Syft or a well-built ledger report pack turns reconciled data into KPI and cash-flow information you can act on monthly.

One layer must be the source of truth for each data type. Let the inventory system own stock quantities and cost, let the connector own settlement splits, and let the ledger own the final financial record.

Good accounting software integration that defines what each app owns prevents duplicate postings, VAT codes being overwritten and month-end arguments about which report is right. Map the flows on one page before you connect anything. If two apps write to the same nominal code for the same transaction, redesign it now, not after a quarter of bad data.

Reconciling a Gateway Payout and Reading Channel Profit

Take one Shopify Payments or Amazon payout. It isn't one transaction. It's a bundle containing gross sales across several days, shipping income, VAT at possibly more than one rate, processor or marketplace fees, refunds, maybe a chargeback or reserve, and a timing difference because orders near the payout cut-off settle next time.

Reconcile it in this order. First agree the payout report to the exact amount hitting the bank. Then post gross sales by channel to income codes, not the net receipt. Split VAT using the tax codes from the underlying orders, post fees to separate payment or marketplace fee codes, put refunds against sales or a dedicated refunds code consistently, and park timing differences in a gateway clearing account. That clearing account should return close to zero once the next payout lands. If it keeps growing, something's posting incorrectly.

Build A Chart Of Accounts That Answers Questions

You don't need hundreds of codes. You need separation where decisions happen: sales by channel, refunds by channel, marketplace fees, payment processing fees, fulfilment and shipping, and cost of goods sold that includes landed cost rather than supplier price alone. Burying Amazon fees inside cost of goods sold flatters or distorts product margin and makes channel comparison impossible.

Stock discipline sits behind those numbers, and these inventory turnover tips for resellers are useful context when you're deciding how tightly to link stock movement, reorder points and COGS postings. Slow stock ties up cash even when the profit and loss looks acceptable.

This walkthrough shows the reconciliation logic in a live system before you apply it to your own settlements.

Once payouts reconcile, report five KPIs monthly by channel: net revenue after refunds, refund rate, payment cost as a share of sales, days to payout and contribution after fulfilment. Those numbers tell you whether a channel creates cash or just activity. Our guidance on what accounts reconciliation involves and why clearing accounts matter covers the control basics behind this process.

If you can't explain every line in one settlement without opening three spreadsheets, your channel profit figure is an estimate, whatever the dashboard says.

Run a quick self-check today. Pick last month's largest payout, trace it to the bank, split every deduction and confirm the VAT treatment. If that takes hours or relies on guesswork, fix the connector and nominal mapping before you spend more on advertising.

Matching the Software to Your E-Commerce Scenario

There's no single right answer, but there are wrong answers for your stage. Match the system to the complexity you have now and the complexity you're clearly adding within the next year, not to a five year fantasy.

Single-Channel Shopify Store Moving Beyond Six Figures

Use Xero with Link My Books or A2X, a tidy chart of accounts and the ledger's own reporting to start. You'll get MTD filing, automated payout splits and an accountant-friendly month-end without paying for stock software you don't yet need. Add a reporting tool only when you're reviewing KPIs monthly and acting on them.

This stops fitting when stock is held in more than one location, purchase ordering becomes painful, or you add Amazon and the settlement logic changes completely. At that point review the inventory layer first, not necessarily the ledger.

Shopify Plus Amazon Crossing Seven Figures

Use Xero or QuickBooks Online with A2X, because Amazon settlements need a connector that handles fees, refunds and tax splits in summarised journals your accountant can audit. Add an inventory system if FBA, your own warehouse and incoming supplier shipments can't be reconciled from the ledger alone. QuickBooks Online may edge it if you want more inventory function inside the core product, while Xero often wins on accountant workflow and app choice.

This stops fitting when you need multi-entity reporting, complex landed cost by shipment or approval controls that small business software can't enforce. That's the point to scope a mid-market move properly rather than stacking more apps onto a creaking base.

Wholesale And Online Hybrid

Start with QuickBooks Online on an inventory-capable tier or a mid-market system if wholesale invoicing, credit control, accruals and stock accounting all matter. You need customer-level receivables discipline alongside marketplace settlements, and those are different finance rhythms. Don't force wholesale through a connector designed only for consumer payouts.

In this scenario, Stewart Accounting Services is one option among UK firms that can set up Xero-based e-commerce bookkeeping, map sales channels and produce regular KPI reporting for owners. Whoever you use, involve them before migration. This recommendation stops fitting if wholesale becomes a minor side line, in which case simplify back towards the Shopify-led stack and remove cost you aren't using.

Common Mistakes When Choosing E-Commerce Accounting Software

The most expensive mistake is buying the longest integration list. Fifty connected apps mean nothing if settlements post as net receipts, VAT codes are wrong or two systems duplicate sales. Count clean outcomes instead: reconciled payouts, correct VAT boxes and a month-end your accountant can close without rebuilding your data.

Underestimating MTD is next. Owners assume that because software can submit a return, their records are sorted. They aren't if the digital journey breaks at a spreadsheet, a manual journal with no supporting settlement or refunds coded wherever the bookkeeper had space that day. That weakness surfaces at the worst moment, usually during a VAT review, a loan application or due diligence.

Price per seat is another false economy. Across businesses using fully functional software, HMRC's impact research estimating 32–49 million hours saved in 2022–23, valued at £603 million–£915 million with a £759 million central estimate, shows the saving comes from the workflow, not shaving a small amount off the subscription. Cheap software that creates manual reconciliation is expensive software.

A Short Audit You Can Run Today

• Trace one payout: Can you split sales, VAT, fees and refunds to the bank amount without manual detective work?
• Check accountant access: Can your accountant see live data, lock periods and review journals, or do they receive exports from you?
• Test channel profit: Can you produce contribution by channel for last month and explain the movement from the month before?
• Review migration timing: Are you waiting for year-end because it feels tidy, while another year of poor data builds up?

If you fail two or more, don't buy another app yet. Fix the selection criteria and the posting logic first.

What to Do This Month, This Quarter and This Year

This Month

Agree your three selection tests in writing: MTD-ready digital records, channel contribution and clean month-end. Audit one payout from each major channel, list where manual work or spreadsheet edits occur, and book an accountant review before you choose or switch platforms. That conversation should cover VAT codes, chart of accounts design and who owns each app in the stack.

This Quarter

Migrate or reconfigure the chosen platform at a month-end, not mid-month. Connect the payout tool, map every settlement line to a nominal code, set up gateway clearing accounts, and run one parallel month so you can compare old and new numbers before trusting the new reports. Launch a simple KPI pack covering net revenue, refunds, payment costs, payout timing and contribution by channel.

This Year

Review the stack against volume and complexity every quarter, not just at renewal. Check whether your pricing tier still fits, whether inventory now needs its own system, whether cross-border VAT support is adequate and whether reporting has kept pace with the decisions you're making. Plan the move to a more capable platform early if stock locations, entities or wholesale terms are pushing the current setup beyond its limits.

Don't wait for year-end to discover your numbers don't reconcile. Start with one payout, one VAT trail and one honest channel profit report.

Ready to stop guessing which channel actually makes you money? Book an accountant review this month to audit your current setup, test one full gateway settlement through to your VAT return, and agree the Xero or QuickBooks configuration and app stack that'll give you a clean month-end, reliable channel contribution and MTD records you can defend.