This page answers one question: how do you get an online shop’s sales into Xero or QuickBooks so the numbers are right? It’s for a UK seller doing their own books, or handing a shoebox to an accountant and wanting to hand over less of one. Every rule and price below was checked against gov.uk and the vendors’ own UK pages on 15 September 2026. We build Orbit Commerce, so we have a stake in you opening a shop, and Orbit does not sync to Xero or QuickBooks today. More on that below.
Almost all ecommerce bookkeeping pain comes from one mistake, repeated monthly. Your shop took £1,000 on Tuesday. Your bank shows £961 on Thursday. Someone types 961 into the sales column, and from there the books understate turnover, lose a real expense and under-declare VAT. That’s the gross-versus-net problem.
What actually needs to reach your accounts: orders, payouts, fees or all three?
All of them, plus refunds and VAT, as separate things: gross sales split by VAT rate, shipping charged to customers, processing fees as an expense, refunds reducing sales, and the payout recorded as a movement of money rather than income. Several lines, not one deposit.
- Orders (gross sales). What customers paid, before anything came out. Your turnover, and the figure the £90,000 VAT registration threshold is measured against (gov.uk, checked 15 September 2026).
- Processing fees. A deductible expense. Net them off your sales and the deduction is gone.
- Refunds. A reduction of sales in the period you refunded, not a cost, and they claw back the VAT on the original sale.
- Shipping income. Delivery the customer paid for is revenue, normally at the same VAT rate as the goods.
- VAT. Roughly a sixth of a standard-rated gross sale was never yours. Our guide to UK VAT for online sellers covers the thresholds and traps.
- The payout. Not income. Money moving from the processor’s balance into your bank.
Why does your bank deposit never match your sales total?
Because a payout is a bundle, not a transaction: many orders, minus fees, minus refunds issued in that window, minus any chargebacks or reserves, on the processor’s schedule rather than your calendar. It can never equal a sales figure, and chasing a match is wasted evenings.
Three things break it. Fees come out before the money moves. Refunds come out of whichever payout is next, maybe a fortnight later. And Tuesday’s takings land on Thursday, so a month-end payout belongs to last month and can straddle two VAT quarters. Our guide to payouts, fees and tax follows the full path.
The £1,000 day that arrives as £961: a worked example
Assumptions, so you can argue with them: a VAT-registered shop, 60 orders in a day totalling £1,000 including VAT, all standard-rated at 20%, 55 worth £880 on UK cards at Orbit’s Solo rate of 2% + 25p, five worth £120 on Klarna at 4.99% + 30p, and an earlier order refunded at £24.99 the same day.
| Line | Amount | Where it goes in your books |
|---|---|---|
| Gross sales, 60 orders including VAT | £1,000.00 | Sales £833.33 + VAT on sales £166.67 |
| Card processing, 55 × (2% + 25p) | −£31.35 | Merchant fees (expense) |
| Klarna, 5 × (4.99% + 30p) | −£7.49 | Merchant fees (expense) |
| Settled from the day’s sales | £961.16 | Sits in the processor balance |
| Refund of an earlier order | −£24.99 | Reduces sales by £20.83, reduces VAT by £4.16 |
| Payout that reaches your bank | £936.17 | Bank transfer, not income |
Now the cost of getting it wrong. Turnover for the day is £975.01 gross (£1,000 less the £24.99 refund). Post the £936.17 deposit as sales instead and you understate turnover by £38.84, lose that same £38.84 of deductible fees, and declare £156.03 of VAT instead of £162.51. Across 250 trading days that’s a £9,710 turnover gap and roughly £1,620 of under-declared VAT.
Post the fees as your fee statement shows them, VAT treatment included, rather than assuming. For what they should cost in the first place, see what it really costs to take payments on a UK online shop.
How to record shop sales in Xero or QuickBooks, step by step
Use a clearing account: a holding account for money the processor owes you but hasn’t sent. Same method in both, only the menu names differ.
- Create the clearing account. Xero: Accounting → Chart of Accounts → Add Account, type Bank, name it “Payments clearing”. QuickBooks: Transactions → Chart of Accounts → New, type Bank, same name. Do not give it a bank feed.
- Pick your summary period: daily if you’re busy, weekly or monthly if not, but never one that straddles a VAT quarter end.
- Raise one summary entry per period (sales invoice or manual journal, either works) paid into the clearing account. Lines: gross sales split by VAT rate, shipping income separately, refunds negative, zero-rated and exempt sales kept apart. Do not enter individual orders unless you enjoy it.
- Add the fees to the same entry as a negative line coded to a merchant fees expense account. The clearing account now holds what the processor owes you.
- When the payout lands in your bank feed, code it as a transfer from the clearing account. Not sales. Not “other income”. A transfer.
- Check the clearing balance monthly. It should hold roughly a day or two of sales, the money genuinely in transit. A balance that keeps growing means a fee, refund or chargeback is missing from step 3.
- Attach the export. File the CSV of the period’s payouts, fees and refunds against the entry. That is your evidence, and it matters for Making Tax Digital.
Do it once with an accountant watching, then repeat forever. An hour of their time on your first month’s entries is the cheapest thing in this article.
Do you need a connector like A2X or Link My Books, or not?
Honestly: not if you sell through one shop whose dashboard already breaks out payouts, fees and refunds and exports them as CSV. Connectors exist because most channels do not. A marketplace settlement bundles twenty fee types across a period matching neither your month nor your payout, and turning that into a clean journal by hand is miserable. The rule of thumb is about channels, not size:
- One shop, clean payout data, a few hundred orders a month: the steps above take ten minutes a month. A connector is a subscription buying you eight minutes.
- Amazon or eBay in the mix: a connector earns its fee immediately, because marketplace settlements are the hard case. Our post on multichannel selling in the UK covers the rest.
- Several channels or currencies: use a connector, and check your accounting plan handles multiple currencies first.
A2X and Link My Books are the names you’ll see most. Both price per month, generally per channel; we haven’t verified their prices today, so check their own pages rather than anyone’s blog, this one included.
How do you keep VAT right when the platform collects it?
Flag those sales separately, because they are not the same transaction as a sale from your own website. Where a marketplace is the deemed supplier, broadly for goods outside the UK in consignments of £135 or less, or UK goods sold by an overseas seller, it accounts for the VAT rather than you. The money still passes through your books; the VAT line does not.
So keep at least two sales accounts: your own store’s sales, where you charged and owe the VAT, and marketplace sales where the platform handled it. Lump them together and your VAT return is wrong in a way that is hard to spot later. Check gov.uk before relying on any of this. Note too that your processor takes its percentage off the gross figure, so you pay card fees on VAT you are only holding for HMRC.
What does Making Tax Digital mean for how you record shop sales?
It means your records live in software and move between systems digitally, not by retyping. Per gov.uk, “All VAT-registered businesses should now be signed up for Making Tax Digital for VAT. You no longer need to sign up yourself” (gov.uk, checked 15 September 2026). No turnover minimum: VAT registration is the trigger.
The rule that bites ecommerce sellers is digital links. HMRC’s VAT record-keeping guidance says that where you use more than one piece of software, “You cannot manually transfer this data, or ‘copy and paste’, between software”, and lists importing and exporting CSV files as an acceptable digital link (gov.uk, checked 15 September 2026). Typing numbers off your dashboard into Xero breaks the rules. Exporting a CSV and importing it doesn’t. Keep VAT records six years.
Income tax is going the same way. Sole traders and landlords with qualifying income over £50,000 for 2024 to 2025 should have started using Making Tax Digital for Income Tax from 6 April 2026; the threshold drops to £30,000 from 6 April 2027 and £20,000 from 6 April 2028 (gov.uk, checked 15 September 2026). Quarterly updates from software, for plenty of shop owners who currently file once a year. Worth reading sole trader or limited company with those dates in mind.
Xero or QuickBooks for a small UK shop?
For a single UK shop doing the clearing-account method, either is fine, and the tiebreaker is which one your accountant uses. The feature that changes the decision is multi-currency, which sits on a dearer tier in both.
| Checked 15 September 2026 | Xero UK | QuickBooks UK |
|---|---|---|
| Entry plan | Ignite, £18/month excl. VAT | Sole Trader Plus (price did not render) |
| Next tiers | Grow £39, Comprehensive £55, Ultimate £70/month excl. VAT | Simple Start, Essentials, Plus, Advanced (prices did not render) |
| Submit VAT returns to HMRC | All four plans | Simple Start, Essentials, Plus, Advanced |
| Multiple currencies | Comprehensive and Ultimate only | Essentials, Plus and Advanced only |
| Intro offer on the day we looked | 90% off for the first 6 months | A limited-time offer is advertised, amount not shown |
One caveat, and it matters. Xero’s prices came straight off xero.com/uk/pricing-plans today. QuickBooks loads its UK prices dynamically and they did not render on its pricing page on 15 September 2026, so we have not quoted numbers we could not see: check the live page. Both run introductory discounts, so budget on the full price.
What we’d do: selling only in pounds, start on the cheapest plan that submits VAT returns and move up when something forces you. Selling in more than one currency, it’s Xero Comprehensive or QuickBooks Essentials and above from day one.
Where Orbit fits
Being straight, since we sell the platform: Orbit does not sync to Xero or QuickBooks today, and is not HMRC-recognised MTD software. What the finance dashboard does is break out payouts, per-transaction fees and refunds and export them as CSV, which is exactly the input the method above needs. Every payout opens into the transactions behind it, so step 3 is reading a file rather than reverse-engineering a deposit.
Questions people ask about ecommerce bookkeeping in the UK
Do I record the payout or the sale in my accounts?
The sale. Record gross sales split by VAT rate on the day they happen, processing fees as an expense, and refunds as a reduction of sales. The payout is a transfer of money you already recorded, so it goes to a clearing account and then to your bank. Recording the deposit as income understates turnover and under-declares VAT.
Do I need A2X or Link My Books for a single UK shop?
Usually not. If your shop’s dashboard already separates payouts, fees and refunds and exports them as CSV, a monthly summary journal into a clearing account takes about ten minutes. Connectors earn their keep when marketplace settlements are involved, because Amazon and eBay reports bundle many fee types across periods that match neither your month nor your payout.
Does Orbit sync with Xero or QuickBooks?
No, not today. Orbit exports payouts, per-transaction fees, refunds and tax lines as CSV, and you import that file into your accounting software. Orbit is also not HMRC-recognised MTD software, so if you are VAT registered you keep filing through your existing MTD software or bridging tool and feed it with the export.
What does Making Tax Digital mean for an online shop?
If you are VAT registered, your VAT records must be kept digitally and returns filed through compatible software, with no manual retyping or copy-paste between systems (gov.uk, checked 15 September 2026). Importing and exporting CSV files counts as an acceptable digital link. Records must be kept for at least six years.
Is Xero or QuickBooks better for a small UK shop?
Both submit VAT returns to HMRC on their paid plans, so for a single-currency UK shop the honest answer is whichever your accountant uses. Multi-currency is the real dividing line: it sits on Xero Comprehensive and above (£55 a month excl. VAT, checked 15 September 2026) and on QuickBooks Essentials and above.
If you’re picking a platform partly on how easily its numbers reach your books, look at what it exports before you look at its integration list. Build the shop on a 14-day free trial, no card required, run a few test orders, and read the export file before committing to anything.