Inventory turnover ratio shows how many times you sell and replace stock in a period. A higher ratio usually means you are moving goods efficiently and tying up less cash in unsold inventory.
Tracking this metric helps UK early-stage founders and ecommerce sellers make better buying, pricing and promotion decisions. This guide explains the formulas, realistic benchmarks and concrete steps that free up working capital without relying on guesswork.
Understanding Inventory Turnover Ratio
Inventory turnover ratio measures the efficiency of your stock management. It answers how often your average inventory is sold during a year, quarter or month. For ecommerce sellers, a low ratio can signal overstocking, weak demand or poor product selection. A very high ratio may indicate stockouts and lost sales.
The ratio is especially important for small brands because excess inventory ties up working capital that could be used for marketing, product development or cash-flow buffers. Improving it releases funds without needing external finance.
The Basic Formulas
Use this standard formula for annual inventory turnover:
Inventory Turnover = Cost of Goods Sold (COGS) ÷ Average Inventory
COGS is the direct cost of producing or purchasing the goods you sold in the period. Average Inventory is usually (Opening Stock + Closing Stock) ÷ 2. Use the same time period for both figures.
An alternative version uses sales value: Sales Revenue ÷ Average Inventory. This produces a higher number but is less accurate for efficiency analysis because it ignores your gross margin. Stick to the COGS version for most decisions.
To calculate monthly turnover, divide the annual figure by 12 or use monthly COGS and average inventory.
UK Benchmarks for Ecommerce
Benchmarks vary by product category. Fashion and beauty brands often target 4–6 turns per year. Homewares and electronics typically aim for 3–5. Fast-moving consumables such as supplements or snacks can reach 8–12 turns.
Many small UK ecommerce operations start with ratios between 2 and 4. Below 2 usually means too much capital is locked in slow-moving lines. Above 8 can risk frequent stockouts unless you have very reliable suppliers and short lead times.
Compare your ratio against your own historical performance and against similar products rather than treating any single number as a rigid target. Review it every quarter as product mix and market conditions change.
Step-by-Step Tracking Process
- Choose consistent accounting periods and record opening and closing inventory values at cost price.
- Calculate COGS accurately by adding purchases to opening stock and subtracting closing stock, adjusting for returns, shrinkage and supplier credits.
- Divide COGS by average inventory to get the turnover ratio.
- Break the calculation down by product category, supplier or individual SKU to identify which lines perform well.
- Record the ratio monthly in a simple spreadsheet alongside units sold, days of stock on hand and gross margin.
- Automate where possible by linking your ecommerce platform and accounting software so stock values update automatically.
Review trends rather than single-month figures. A sudden drop may reflect seasonal buying or a failed product launch.
Actions to Improve Turnover and Free Working Capital
Reduce order quantities for slow-moving items. If a product turns three times a year, consider ordering enough for four months instead of six. This lowers average inventory and improves the ratio.
Run targeted promotions on lines with turnover below your category average. Bundle them with bestsellers, offer time-limited discounts or use email marketing to existing customers. The goal is to sell through without permanently lowering prices.
Improve demand forecasting by analysing at least 12 months of sales data. Adjust reorder points so you hold less safety stock on predictable items. For seasonal goods, plan phased deliveries rather than one large pre-season order.
Negotiate shorter lead times or smaller minimum order quantities with suppliers. Even a reduction of two weeks can noticeably cut the inventory you need to hold.
Consider dropshipping or print-on-demand for testing new products. This removes inventory risk while you gather real sales data before committing to stock.
Carry out regular stock audits to remove obsolete or damaged items. Write them off or sell them at clearance prices rather than letting them inflate average inventory.
Raise prices selectively on low-turnover items that still have strong margins. Higher prices can improve gross profit even if unit sales fall slightly, which in turn supports a healthier turnover ratio.
Calculating Days Sales of Inventory
Days Sales of Inventory (DSI) translates turnover into a more practical number: how many days stock you have on hand.
DSI = 365 ÷ Inventory Turnover Ratio
A DSI of 90 days means you hold roughly three months of stock. Aim to reduce DSI on non-core lines while protecting fast sellers. Track DSI weekly during busy periods to avoid stockouts.
Use both ratio and DSI together. The turnover figure shows efficiency; the days figure helps with reorder planning and cash-flow forecasts.
Reviewing Progress and Next Steps
Set a realistic target based on your current ratio and product mix. Increase turnover by half a point in the next six months rather than aiming for industry-leading figures immediately. Monitor the impact on cash flow each month.
Adjust marketing spend to support slower lines without increasing inventory further. Use your platform’s search and category data to improve visibility of underperforming products.
When your turnover improves, the freed working capital can fund new product development or larger marketing tests. Repeat the calculation process each quarter and refine your product range based on the results.
Many small UK ecommerce teams find that consistent tracking alone highlights quick wins. Simple changes in ordering discipline and promotion focus often produce measurable improvements within two or three stock cycles.
Frequently asked questions
What is a good inventory turnover ratio for ecommerce?
It depends on your niche. Fashion and beauty often target 4-6 turns per year while home goods may aim for 3-5. Below 2 usually signals excess stock tying up cash. Track your own trend and compare within your product categories rather than chasing a universal number.
How do I calculate cost of goods sold for inventory turnover?
Add your opening inventory to purchases made during the period, then subtract closing inventory. Adjust for returns to suppliers, shrinkage and any supplier credits. Use the resulting COGS figure divided by average inventory to find your turnover ratio.
Does inventory turnover affect working capital?
Yes. A low turnover means more cash is locked in stock that has not yet sold. Improving the ratio by reducing excess inventory or selling slow lines faster releases working capital that can be used for marketing, new products or operational buffers.
How often should I calculate my inventory turnover?
Calculate it monthly for visibility and review the trend quarterly. Monthly figures help spot problems early while quarterly reviews give enough data to make ordering, pricing and promotion decisions.
Can improving inventory turnover reduce storage costs?
Yes. Holding less stock reduces fees charged by fulfilment centres or 3PL providers. It also lowers the risk of damage, obsolescence and insurance costs, further protecting your margins and cash position.
Related reading: Ecommerce holiday delivery deadlines for UK sellers, Creating a partial shipment policy for UK ecommerce stores, What are the best fulfilment options for UK ecommerce startups?. Browse all fulfilment & logistics guides or apply to Loomworks.