Ecommerce Bookkeeping Setup for UK Businesses

An online order can look simple: a customer pays, a product leaves the warehouse, and the money arrives a few days later. In the accounts, however, that single sale may involve platform fees, delivery charges, VAT, refunds, payment-processor deductions and stock costs. A sound ecommerce bookkeeping setup turns those moving parts into current, reliable figures rather than a month-end reconciliation problem.

For construction businesses, this matters where a trade counter, materials business, plant-hire operation or specialist supplier sells products online alongside contract work. The online sales operation must be visible, but it should not distort job profitability, CIS records or VAT reporting for the wider business.

Start with the reporting you need

Bookkeeping should be built around management decisions, not simply annual accounts. Before choosing integrations or creating ledger codes, decide what you need to know each month. For example: which sales channel produces the best margin, whether delivery is being recovered properly, how much cash is tied up in stock, and whether online trading is profitable after advertising and platform fees.

For a contractor that also sells materials online, it is usually sensible to separate ecommerce income from construction income. This makes it easier to see whether a dip in overall margin comes from a fixed-price project, a poorly priced product range or rising fulfilment costs.

Keep the chart of accounts detailed enough to answer those questions, but not so detailed that routine coding becomes inconsistent. Separate sales channels where the volume justifies it. Record product sales, delivery income, platform commissions, merchant fees, refunds, packaging and advertising in clearly defined accounts. If stock is material to the business, establish categories that reflect how it is bought, held and sold.

Build an ecommerce bookkeeping setup around source data

The accounting software should be the financial record, but it cannot be expected to recreate information that was not captured at the point of sale. Your ecommerce platform, payment provider, bank account, purchasing system and stock records each hold part of the picture.

A practical setup feeds sales data into cloud accounting software such as Xero in a controlled way. The objective is not to post every individual transaction blindly. It is to ensure that daily or periodic sales summaries agree to the platform reports, payment settlements and bank receipts.

Payment providers rarely pay the exact amount shown as sales revenue. They may deduct card-processing charges, refund payments, dispute fees or reserve balances before settlement. Posting only the net payment to sales will understate turnover and hide costs. Instead, reconcile the gross sales, VAT, refunds and fees against the settlement received. A clearing account can make this process easier, particularly where money arrives several days after the sale.

The same discipline applies to marketplaces. Their reports may include commission, fulfilment costs, promotional charges and amounts withheld for returns. These deductions are business costs, not reductions in the price charged to the customer. Recording them separately protects the quality of your sales and gross-margin reporting.

Set a clear reconciliation routine

Automation reduces data entry, but it does not remove the need for review. At least monthly, reconcile the following:

• ecommerce platform sales reports to the accounting system;

• payment-provider and marketplace settlements to clearing accounts and bank receipts;

• refunds, chargebacks and credit notes to the original sales activity; and

• stock records to purchases, cost of sales and periodic stock counts.

Where order volumes are high, weekly reconciliation gives better control and identifies errors before they become difficult to trace. Businesses with lower volumes may manage monthly, provided records are kept promptly and the bank is reconciled in full.

Get VAT treatment right before sales grow

VAT is often where an apparently tidy ecommerce process fails. The correct treatment depends on what is sold, where the customer is based, where goods are located and whether the sale is to a consumer or a VAT-registered business.

For UK sales, the VAT rate depends on the product or service. Do not assume that every product carries the same treatment simply because most construction supplies are standard-rated. Product descriptions, invoices and accounting codes must support the rate applied.

Online sales also need to be kept distinct from construction services subject to the VAT domestic reverse charge. The reverse charge can apply to certain supplies of construction services between VAT-registered businesses, but it does not automatically apply because a construction business is involved. A sale of goods through an online shop and a qualifying construction-service invoice have different VAT considerations. Mixing them in one generic sales code creates avoidable VAT-return risk.

If goods are sold to customers outside the UK, take advice before setting tax rules or expanding advertising activity. The VAT position can change according to the destination, the value of the consignment and the role of the marketplace. A configuration copied from another business may be wrong for yours.

For VAT-registered businesses, digital records and compatible software are required under Making Tax Digital for VAT. The figures submitted on the return need a clear audit trail back to sales reports, purchase invoices and reconciled settlements. That trail is especially valuable if HMRC asks questions about a sudden movement in turnover or VAT recovery.

Treat stock and delivery costs as commercial information

An online product line can generate regular sales while losing money. This often happens when businesses focus on the purchase price and selling price but overlook postage, packaging, payment fees, marketplace commission, returns and the staff time involved in fulfilment.

Your bookkeeping should therefore distinguish between the cost of inventory and the costs of getting it to the customer. The precise treatment depends on the nature of the costs and the accounting policy used, but management reporting should show the full economic cost of a sale. This allows directors to review margins by product group or channel and adjust prices before losses become embedded.

Physical stock needs controls outside the accounting ledger. Maintain accurate purchase records, goods-received processes and periodic stock counts. Investigate differences promptly. They may reflect damaged items, supplier shortages, unrecorded returns or theft, and each has a different operational response.

For businesses selling made-to-order items or materials alongside installation, it is equally important to separate stock sold online from materials consumed on a job. Otherwise, job-costing reports may overstate project costs and conceal the performance of the ecommerce operation.

Protect cash flow from settlement delays and returns

Sales revenue is not the same as cash available to pay suppliers. Payment processors may settle on a delay, marketplaces may hold funds, and customer returns can arise after the original sale. Meanwhile, stock suppliers often require payment before goods can be sold.

A short-term cash forecast should include expected settlements, VAT liabilities, stock purchases, delivery costs and known refunds. For a construction business already funding labour and materials ahead of staged contract payments, an ecommerce channel can add further pressure if stock purchasing is not planned carefully.

Use a separate business bank account for trading activity and avoid paying personal costs from it. Where online sales are significant, a dedicated bank account or clearing-account structure can improve visibility, though it is not always necessary. The right approach depends on transaction volume and the wider finance process.

Assign ownership and keep evidence

A system works only when someone is accountable for keeping it current. That may be an owner-manager in a small business, an administrator who processes orders, or an outsourced finance team. Responsibilities should be clear: who checks integrations, approves refunds, uploads supplier invoices, performs stock counts and reviews monthly reports.

Keep invoices, receipts, platform statements, refund evidence and delivery documentation in an organised digital record. This supports VAT compliance, makes year-end work more efficient and gives management confidence in the numbers.

Fortis Accounting helps businesses put disciplined bookkeeping processes around the way they actually trade, so directors can see the cash position, tax exposure and margin behind their sales. The most useful ecommerce records are not those with the most automation. They are the ones that explain, clearly and promptly, where each pound came from, what it cost to earn, and what the business can do next.