How to Value Ecommerce Inventory Accurately

A stock report can show thousands of units on hand and still give a misleading picture of profit. For a growing online retailer, knowing how to value ecommerce inventory accurately is not simply a bookkeeping exercise. It affects reported profit, corporation tax, cash-flow planning, buying decisions and the price you can afford to pay for the next order.

The challenge is that ecommerce stock rarely follows a neat journey from supplier to shelf. Goods may be ordered in one currency, shipped through several countries, held by a fulfilment partner, transferred to Amazon FBA, returned by customers or bundled into new products. A reliable valuation needs to reflect that commercial reality while remaining compliant with UK accounting requirements.

Why inventory valuation matters to ecommerce businesses

Inventory is often one of the largest assets on an ecommerce balance sheet. If it is overstated, profit may appear stronger than it really is. If it is understated, management accounts can suggest a weaker business, distort gross-margin reporting and lead to poor purchasing decisions.

The timing matters too. Paying a supplier does not necessarily create an immediate expense in the profit and loss account. Where goods are held for resale, their cost normally remains in inventory until they are sold. At that point, the relevant cost is recognised as cost of sales. This matching of revenue and cost gives a more meaningful view of trading performance than treating each stock purchase as an expense on payment.

For UK businesses applying FRS 102, stock is generally measured at the lower of cost and estimated selling price less costs to complete and sell, often referred to as net realisable value. This is a prudent rule with very practical consequences for slow-moving, damaged, obsolete and heavily discounted products.

What should be included in inventory cost?

The purchase price is only the starting point. The cost of inventory should include costs directly attributable to bringing goods to their present location and condition. For an ecommerce retailer, this commonly includes supplier invoices, non-recoverable import duties, freight to the warehouse and customs clearance costs.

If your business is VAT registered and can recover input VAT, recoverable VAT is not usually part of stock cost. It should be recorded separately through the VAT account. Conversely, irrecoverable VAT may need to be included in cost. The correct treatment depends on the business's VAT position and the nature of the purchase.

Costs that are usually not included in inventory are selling and administrative expenses. Marketplace commission, payment processing fees, digital advertising, customer-delivery charges, head-office salaries and general warehouse overheads are normally recognised in the period incurred. They matter greatly when assessing contribution and profitability, but including them in inventory can artificially defer costs and inflate profit.

There are exceptions and judgement calls. For example, direct costs of converting raw materials into finished goods may form part of inventory for a business that manufactures or materially assembles products. The key question is whether the cost was necessary to bring the goods to their current condition, rather than to market, administer or sell them.

Landed cost needs a consistent method

A single shipment may contain many products with different values, weights and quantities. Freight, duty and clearance charges must therefore be allocated across the goods on a rational and consistent basis. Allocation by purchase value may be appropriate for some ranges; allocation by weight, volume or units may better reflect the economics for bulky or low-value products.

There is no universal method that suits every retailer. What matters is that the approach reflects how costs are incurred, is applied consistently, and is reviewed if the supply chain changes. A business importing high-value cosmetics and a business importing low-margin furniture should not necessarily use the same allocation basis.

How to value ecommerce inventory accurately at period end

An accurate year-end or month-end valuation starts with quantity. Your accounting records cannot correct a stock count that is wrong at source. Reconcile the inventory system to physical stock, supplier records and fulfilment-provider reports, then investigate material differences rather than posting unexplained adjustments.

This is especially important where stock is held in multiple locations. Include inventory in your own warehouse, at a third-party logistics provider, in Amazon FBA warehouses, in transit where ownership has passed, and at any overseas fulfilment centre. Do not include stock that belongs to a supplier or another seller simply because it is stored in your facility.

Ownership terms deserve close attention. Goods may be physically in transit at the reporting date but owned by your business, meaning they should be included in inventory. Equally, goods may have been delivered but remain the supplier's property under the agreed terms. Purchase orders, Incoterms, shipping documents and supplier contracts provide the evidence needed to make that judgement.

Once quantities are established, apply the chosen cost-flow method. For interchangeable items, weighted average cost is common and often practical for ecommerce businesses with frequent purchases. First-in, first-out, or FIFO, can also be suitable where it better reflects the movement of goods. The method should be consistently applied from one period to the next unless there is a sound reason to change it.

Treat returns, bundles and stock transfers carefully

Customer returns should not be treated as automatically saleable stock. A returned item may be unopened and ready for resale, require repackaging, be suitable only for clearance, or have no recoverable value at all. Its condition should determine whether it returns to saleable inventory, is written down or is written off.

Bundles can also create avoidable errors. When separate items are combined into a gift set or subscription box, the cost of each component must remain traceable. If stock is transferred between Shopify, Amazon, TikTok Shop and a fulfilment partner, it has not been sold merely because it has moved location. Transfers should be recorded as transfers, with quantities and costs preserved.

Test stock for net realisable value

Cost is not always the final answer. If a product can no longer be sold for enough to recover its recorded cost, its value must be reduced. This is where ecommerce operators need commercial data alongside accounting discipline.

Review ageing reports, sales velocity, return rates, damage records, expiry dates, planned promotions and current competitor pricing. A product that has sat untouched for nine months, or one that now requires a deep discount to sell, may need a provision. The relevant comparison is not the original selling price but the estimated selling price less the costs required to complete and sell the item.

For example, inventory with a landed cost of £24 per unit may look profitable at a listed price of £40. But if it can only realistically be cleared for £22 and will incur £3 of fulfilment and selling costs, its net realisable value is £19. The stock should be written down by £5 per unit.

A write-down is not a failure. It recognises a commercial position promptly, prevents overstated profit and gives management a clearer basis for clearance activity, reordering and cash planning. Where circumstances improve, a previous write-down may sometimes be reversed, but not above the original cost.

Build a monthly process, not a year-end scramble

Annual stocktakes alone are rarely enough for a business that is buying, advertising and selling continuously. A monthly close process gives directors current margin information and makes year-end work more efficient. It also highlights data issues before they become material.

A disciplined process should bring together sales-platform reports, inventory software, warehouse or 3PL reports, supplier invoices, freight and duty documentation, returns data, and the general ledger. Reconcile quantities and values, investigate variances, post landed-cost adjustments, review aged lines and document material valuation judgements.

Automation can reduce manual handling, particularly where Xero is connected to ecommerce and inventory systems. However, software cannot decide whether goods in transit are owned, whether a return is saleable, or whether an ageing product can recover its cost. Those decisions require oversight from someone who understands both the records and the trading model.

Avoid the reporting mistakes that obscure margin

The most common error is expensing all purchases immediately, which can cause large swings in reported profit as buying patterns change. Another is relying entirely on a marketplace inventory report without reconciling it to landed cost, returns and stock held elsewhere.

Businesses also run into difficulty when foreign-currency purchases are converted inconsistently, or when inventory systems use an outdated unit cost after a supplier price rise. Record purchases using an appropriate exchange rate, retain clear supporting evidence and ensure the inventory system reflects the actual cost of each replenishment.

For founder-led businesses, the priority is not theoretical perfection in every minor line. It is establishing a method that is accurate enough for the scale and risk of the business, consistently applied, well evidenced and reviewed as operations grow. A retailer with one UK warehouse has different controls from a multi-channel seller importing containers and holding stock across several countries.

Accurate inventory valuation turns stock from a number you hope is right into information you can use. With reliable quantities, properly allocated landed costs and timely provisions for slow-moving goods, directors can protect margins, plan purchasing with greater confidence and make decisions from accounts that reflect the business as it truly operates.