Ecommerce Bookkeeping: Set Up Properly From Day One
Starting an ecommerce business has never been easier. You can build a website, upload some products, connect a payment provider and potentially make your first sale before you've given much thought to the bookkeeping. Therein lies the problem because while ecommerce makes selling remarkably easy, it doesn't automatically make the bookkeeping easy.
Your customer pays £100.
Your payment provider takes a fee.
The ecommerce platform records the order.
Perhaps another app sends it to your bookkeeping software.
A refund gets processed.
Several days later, £842.63 appears in your bank account alongside twenty other orders.
Then somebody says “It's fine. We'll just record whatever hits the bank as sales.”
Please don't!
Getting the bookkeeping structure right from the beginning can make running an ecommerce business considerably easier. Getting it wrong can leave you six months down the line with thousands of transactions, duplicated sales, unexplained pay-outs and a VAT return nobody particularly wants to look at. If you're setting up an ecommerce business, here's what we'd want you to think about.
Ecommerce covers more than your own website
When we talk about ecommerce, we're not just talking about a business with its own online shop.
You might sell through your own website, through marketplace platforms such as eBay, Etsy or Vinted, or through several channels at once. The underlying bookkeeping principle is the same:
You need to be able to follow the transaction from the sale through to the money arriving in your bank.
Marketplace selling also brings its own questions around record keeping, tax and platform reporting. We've covered those separately in our guide to selling on marketplaces such as eBay and Vinted, so we won't repeat all of that here. For this article, we're concentrating on getting the bookkeeping behind an ecommerce business right.
Before you make your first sale
Ideally, your financial setup happens before the orders start arriving. Think about:
your business structure;
a separate business bank account;
your bookkeeping software;
where you'll sell;
how customers will pay;
how those systems will connect;
how you'll manage stock;
how sales, fees and refunds will be recorded;
how you'll monitor VAT turnover;
who is actually responsible for keeping everything up to date.
A little planning here can save an enormous amount of tidying up later. Yes, we appreciate that setting up the bookkeeping is considerably less exciting than choosing your packaging. Do it anyway.
Have a separate business bank account
Keeping business and personal transactions separate makes bookkeeping much easier. For limited companies, the company is a separate legal entity, so its finances should be kept separately. For sole traders, even where a separate account isn't legally required, we strongly recommend one. If your supermarket shopping, Netflix subscription, customer receipts, supplier payments and weekend takeaway are all going through the same account, someone eventually has to separate them. A dedicated account gives you a much cleaner starting point.
Choose bookkeeping software that works with your ecommerce setup
We're not going to tell you that every ecommerce business needs one particular bookkeeping package. Different businesses have different requirements. What matters is choosing something capable of dealing with the way your business operates. Think about the website you're using, payment processors, sales volume, stock requirements and other systems that need to connect. Xero, for example, has a wide range of integrations with ecommerce websites, payment providers and connector apps. That can be extremely useful but the existence of an integration doesn't automatically mean it should simply be switched on and forgotten about. Which brings us to one of our favourite ecommerce bookkeeping warnings.
Automation is brilliant. Until it automates the wrong thing.
Integrations can save huge amounts of time but they need setting up properly. If your website sends sales into your bookkeeping software and your payment processor also sends the same transactions across, you can end up recording the same income twice. Congratulations! Your turnover has doubled overnight. Unfortunately, you haven't become an ecommerce sensation. You've just recorded every sale twice. When connecting systems;
Test them.
Understand what information each integration is sending.
Check how it handles VAT.
Check refunds.
Check fees.
Check whether individual sales or summary transactions are being created.
Most importantly, reconcile the results. Automation should reduce work. It shouldn't remove oversight.
The money hitting your bank isn't necessarily your sales
This is probably the single biggest bookkeeping point in this article.
Suppose customers place orders worth £10,000.
During the period there are £400 of refunds, and your payment provider deducts £300 of processing fees before sending the remaining money to your bank.
If you simply record the £9,300 pay-out as sales, you haven't accurately recorded what happened.
Transaction | Amount |
Gross customer orders | £10,000 |
Refunds | (£400) |
Payment processing fees | (£300) |
Net payout | £9,300 |
The exact accounting and VAT treatment will depend on the circumstances, but the principle is important. £9,300 arriving in the bank isn't automatically £9,300 of sales. Your bookkeeping needs to capture the underlying transactions otherwise turnover can be understated, expenses can disappear completely and VAT can be wrong. This becomes particularly important when VAT registration is approaching because HMRC looks at taxable turnover, not simply how much money your payment provider deposited into your bank.
Payment processors are part of the journey
Stripe, PayPal, Shopify Payments, Klarna and other payment providers can sit between your customer and your bank. It's helpful to think of the journey as:
Customer sale → payment processor → fees/refunds/adjustments → pay-out → bank
Depending on the setup, your bookkeeping may use a clearing or control account representing the money held by the processor. That allows you to reconcile what customers paid with what eventually reached the bank. If your records say a payment processor is holding £7,500 for you and the provider says the balance is £73.42, we probably have some investigating to do.
Record your sales regularly
High-volume ecommerce bookkeeping cannot sensibly be left untouched for months. At the very least, retail sales information should be captured regularly and where a VAT retail scheme is being used there are specific rules around Daily Gross Takings (DGT). HMRC describes DGT as a record of retail supplies, rather than simply the cash received or sitting in the bank. That distinction neatly sums up the ecommerce bookkeeping problem. Sales are not the same thing as pay-outs.
For many ecommerce businesses, we'd recommend bookkeeping at least weekly, with sales data being captured on an appropriate and consistent basis. The more transactions you process, the faster a small problem becomes a large one. Finding an integration error after 20 transactions is mildly irritating. Finding it after 20,000 is a rather different Tuesday afternoon.
Set up useful bookkeeping categories
Your accounts should allow you to see what's actually costing money.
Depending on the business, useful categories might include:
product sales;
cost of goods sold;
stock;
platform or marketplace fees;
payment processing fees;
postage and courier costs;
packaging;
advertising;
website and app subscriptions;
refunds and returns.
That doesn't mean creating 147 different expense categories because you enjoy looking at long reports. The information should be detailed enough to be useful. If all the costs of selling online disappear into one enormous category called “Expenses”, it's difficult to understand your margins.
Stock deserves proper attention
Ecommerce businesses can have significant amounts of cash tied up in stock. Buying £20,000 of products doesn't necessarily mean you've simply incurred a £20,000 expense that day. Unsold stock is generally an asset of the business, with the cost recognised appropriately as products are sold. That's why stock records matter. You need to know what you've bought, what you've sold and what remains. There may also be damaged stock, missing stock, customer returns and items that have become obsolete. Occasionally the computer insists there are six left when the shelf very clearly disagrees. Physical stocktakes are therefore still important, even when you have a sophisticated stock-management system. We've covered that subject in much more detail in our guide to stocktaking, why it matters and how to do it.
Keep an eye on VAT from the beginning
This is one area ecommerce businesses can quickly run into trouble. As at October 2026, compulsory UK VAT registration is generally triggered when taxable turnover for the previous 12 months exceeds £90,000, or where you expect taxable turnover to exceed £90,000 in the next 30 days.
Notice that we said 12 months.
Not your financial year.
Not the tax year.
Not January to December.
It's a rolling test.
A rapidly growing ecommerce business therefore needs to monitor turnover regularly. Don't assume that selling zero-rated products means those sales don't count towards the VAT registration threshold. Taxable turnover includes standard-rated, reduced-rated and zero-rated supplies.
VAT isn't necessarily 20% on everything
Once VAT registered, your systems also need to know what you're selling. Imagine an online clothing retailer. Adult clothing will generally be standard-rated but qualifying young children's clothing and footwear can be zero-rated where HMRC's conditions are met. An ecommerce store selling both could have products with different VAT treatments. This is why getting product tax rates and integrations configured correctly matters. If you tell the system everything is 20% VAT and then process thousands of transactions, correcting it later isn't much fun. Equally, zero-rated doesn't mean “nothing to do with VAT.” It is a taxable supply at 0%, which is quite different from an exempt supply.
Selling overseas introduces another layer of rules entirely, as can transactions involving Northern Ireland. That's a subject worthy of its own article, rather than something we're going to squeeze into three paragraphs here. The important point is that if you're planning to sell internationally, get advice on the VAT position before assuming the UK rules simply follow the parcel overseas.
Don't forget refunds, returns and chargebacks
Ecommerce businesses have returns. Lots of them in some sectors. Your bookkeeping process therefore needs to cope with:
full refunds;
partial refunds;
cancelled orders;
customer returns;
discounts;
vouchers;
chargebacks.
The important thing is that these transactions are reflected properly in the records. Don't simply alter something somewhere until the bank reconciliation works. Your accounts should tell the story of what actually happened. If a £100 sale was made and subsequently refunded, that's different information from pretending the sale never existed.
Postage isn't automatically VAT-free
Another common assumption is: “It's postage, so there's no VAT.” Unfortunately, VAT has never been particularly interested in making assumptions convenient. When a business charges its customer for delivery, the VAT treatment can depend on the underlying supply and how the delivery forms part of it. So don't automatically configure every delivery charge as outside VAT simply because you've called it “postage”. This is another area worth checking when the ecommerce platform is initially configured.
Know what selling actually costs you
Turnover can be exciting. “We've done £100,000 in sales!” Fantastic but what did it cost to generate them? Imagine:
Amount | |
Sales | £100,000 |
Product costs | (£40,000) |
Platform/payment fees | (£4,000) |
Postage & packaging | (£10,000) |
Advertising | (£18,000) |
Returns and other direct costs | (£5,000) |
Amount remaining before other overheads | £23,000 |
That isn't intended as a formal Profit & Loss calculation, the actual accounting treatment will depend on the business but it illustrates an important point. Turnover isn't profit.
An ecommerce business can be incredibly busy without being particularly profitable. Platform fees, card charges, advertising costs, free shipping offers and returns can quietly eat away at margins. Good bookkeeping gives you the information to spot that. Selling another 1,000 units isn't particularly exciting if you're losing £2 on every one.
Growth can create a cash-flow problem too
This can feel counterintuitive. Sales are booming. Orders are flying out. Why is there no money? Stock is often part of the answer. Perhaps you've sold most of your current inventory and now need £30,000 to place a larger order with your supplier. That cash has to come from somewhere.
Add advertising expenditure, platform fees, wages, VAT and other overheads and a fast-growing ecommerce business can experience significant cash-flow pressure. Growth consumes cash.
That's another reason accurate, timely bookkeeping matters. You don't just need to know whether sales are increasing. You need to understand whether the business can afford that growth.
Keep the evidence
Good ecommerce bookkeeping isn't just about getting numbers into software, you also need records supporting those numbers. Depending on the business, that might include sales reports, payment processor statements, pay-out reports, supplier invoices, platform fee statements, refund and chargeback information, stock records and relevant VAT documentation.
VAT-registered businesses have specific record-keeping requirements, including records of supplies made and received, the time and value of supplies, VAT and relevant adjustments. Don't assume you'll always be able to log into a platform three years later and download exactly what you need.
Retain the records properly.
Reconcile the whole journey
This is probably our second biggest tip after don't record the bank pay-out as sales. Your reconciliation shouldn't simply be: Money appeared in bank ✓
You want to be able to follow:
Orders
↓
Sales recorded
↓
Payment processor
↓
Refunds and adjustments
↓
Fees
↓
Pay-out
↓
Bank
If £5,000 of sales should ultimately have produced a £4,750 pay-out, you should be able to explain that £250 difference. Not approximately. Not “I think that's probably Stripe fees.” Actually reconcile it. That's how you know your records are complete.
Our ecommerce bookkeeping tips
If we could give a new ecommerce business a handful of rules before it starts trading, they'd be these:
Don't treat net pay-outs as sales. Understand what happened between the customer paying and the money reaching your bank.
Keep business finances separate. Your bookkeeper doesn't need to know that Tuesday's £7.85 transaction was your lunch.
Set integrations up properly before volume increases. Twenty incorrect transactions are easier to fix than twenty thousand.
Check automation rather than blindly trusting it. Computers are extremely efficient at repeatedly doing exactly what you've accidentally told them to do.
Know your VAT rates. Especially if you sell products with different VAT treatments.
Monitor the VAT threshold. Don't wait until year-end.
Keep on top of stock. Cash sitting on a warehouse shelf is still cash tied up in the business.
Know your margins. Turnover is impressive; sustainable profit pays the bills.
Keep the records behind the numbers.
Reconcile, reconcile, reconcile.
Ecommerce bookkeeping doesn't have to be difficult
There are a lot of moving parts in ecommerce but that's exactly why the initial setup matters. A well-designed system can automate huge amounts of bookkeeping while still giving you reliable information about sales, stock, fees, VAT, cash flow and profitability. A badly designed one can automate huge amounts of nonsense and because ecommerce businesses can generate enormous transaction volumes, nonsense scales remarkably well.
Before you concentrate entirely on beautiful websites, advertising campaigns, packaging and getting your first thousand orders through the door, spend some time thinking about what happens after somebody clicks Buy Now.
Set up the bank account.
Choose appropriate bookkeeping software.
Configure your payment providers.
Test the integrations.
Set up your VAT rates.
Decide how stock will be managed.
Make sure sales are being captured correctly.
Build reconciliation into the process from day one.
Six months from now, when thousands of transactions have passed through your systems, you'll be very glad you did. Ecommerce makes selling easy. Good bookkeeping makes sure you actually understand the business you've built.
Comments