Inventory Turnover: The Number Behind Stock Efficiency

Every example and amount on this page is illustrative. It shows the method and is not a benchmark, a quote or advice.

What the Metric Actually Measures

Inventory turnover measures how many times the inventory held by a business is sold and replaced during a defined period, such as a month, quarter or financial year. It describes the movement of stock through the business, not simply the volume of orders. A turnover of 4 means the period’s inventory flow was equivalent to four cycles of the average inventory investment; it does not mean every item sold exactly four times.

The metric is based on inventory value at cost and the cost of the goods that moved, rather than on selling price or revenue. That distinction matters because a £20 product and a £200 product cannot be treated as equal units when assessing how much capital passed through stock. Inventory turnover therefore connects an income-statement flow with a balance-sheet stock: the cost associated with goods sold during the period compared with the value tied up in inventory.

Units sold answers a different question: how many physical items left the warehouse or were included in completed sales. A store can sell many low-cost units but turn inventory slowly in value terms, or sell fewer high-cost units while moving substantial stock investment. Turnover also does not show whether the sales were profitable, whether particular SKUs are stagnant, or how much cash is trapped in remaining stock. Those questions need product economics and inventory measures such as remaining stock value and dead stock, covered in Ecommerce Inventory Analytics.

Build the Calculation from Two Numbers

The basic formula is:

Inventory turnover = cost of goods sold (COGS) for the period ÷ average inventory for the same period.

COGS is the cost assigned to the units sold during the measurement period, not their sales revenue. Inventory is measured at cost as well, so the calculation compares like with like. Using revenue in the numerator would produce a different ratio because it includes the selling margin.

Average inventory is normally used in the denominator because inventory is a changing balance, not a fixed amount. A closing balance is only a snapshot and may be unusually high after a purchase or unusually low after a strong sales period. The simplest average is:

Average inventory = (opening inventory + closing inventory) ÷ 2.

Both opening and closing inventory should be valued on the same cost basis. If stock levels move materially during the period, use more observations instead: for example, average the inventory balances recorded at the end of each month. That better represents the stock tied up while the business generated the period’s sales.

The time periods must match. For a quarter, use COGS recognised during that quarter and inventory balances that define the quarter’s average. For a year, use annual COGS and the average inventory held across that year. Do not divide twelve months of COGS by a single month-end balance unless that balance is deliberately being used as an approximation.

The result is expressed as a multiple, such as 4.0×. That means the period’s COGS was four times the average inventory held at cost during the period. The number describes stock movement relative to the inventory investment; it does not, by itself, show whether the business made a profit or generated cash.

A Worked Example from Opening Stock to Year-End

Consider a Shopify merchant selling home-organising products. Its financial year starts with inventory valued at £60,000 at cost. During the year, it records £240,000 of COGS, and its closing inventory is valued at £40,000 at cost. The figures are summarised below.

The calculation must use inventory at cost, not the retail price customers paid. That keeps the numerator and denominator on the same basis: COGS measures the cost of products sold, while inventory measures the cost tied up in products still held.

First, calculate average inventory: (£60,000 opening inventory + £40,000 closing inventory) ÷ 2 = £100,000 ÷ 2 = £50,000.

Next, divide annual COGS by average inventory: £240,000 ÷ £50,000 = 4.8. The merchant’s annual inventory turnover is therefore 4.8 times.

The arithmetic means the business sold inventory equal to 4.8 times its average inventory investment during the year. It does not mean every individual product sold exactly 4.8 times, or that the merchant physically replenished the same units in a perfectly even cycle. A seasonal store, for example, may have materially different stock levels during the year even when the opening and closing values produce this ratio.

For a more useful operating view, keep the underlying values alongside the ratio. A turnover result without the opening stock, closing stock and COGS can hide whether the number came from strong sales, unusually low stock, or a change in product mix. Inventory analytics can extend this view to remaining stock value and dead stock at product level.

The Data Errors That Distort the Result

The numerator must be cost of goods sold (COGS), not revenue. For illustration only, £240,000 of sales with £120,000 of COGS and £40,000 of average inventory produces turnover of 3. Using revenue instead produces 6, even though the stock was only sold and replaced three times at cost. The same issue occurs when inventory is recorded at retail selling prices rather than cost: £120,000 of COGS divided by £60,000 of retail-priced stock gives 2, while £40,000 of cost-valued stock gives the correct 3.

The denominator should represent the inventory held across the period. If opening stock is £60,000 and closing stock is £20,000, the simple average is £40,000. With £120,000 of COGS, turnover is 3. Using only the £20,000 ending balance gives 6, overstating efficiency because it ignores the larger stock position held earlier. Where inventory moves sharply, a monthly or daily average can be more representative than a two-point average.

The dates must also match. Comparing a quarter's COGS with year-end inventory, or a promotional month's sales with an inventory balance from before the promotion, combines different operating conditions. Stockouts create another distortion: they can suppress COGS because fewer orders are fulfilled while the temporary lack of stock makes the remaining balance look small. The resulting ratio may look strong while the store was unable to make available sales.

Returns need consistent treatment. If refunded orders remain in sales or their returned units are not restored to inventory, both the numerator and denominator can be wrong. Cancelled orders should not be treated as completed sales. Accounting changes can break comparisons too: switching from FIFO to weighted-average cost, changing product cost assumptions, or recording a write-down changes COGS or inventory without changing physical movement. Check these inputs before interpreting the number; inventory analytics should reconcile turnover with remaining stock, dead stock and stock value.

How to Judge the Result in Context

There is no universal healthy inventory turnover ratio. A ratio of 4 could indicate efficient replenishment for one business, but excessive stock for another. Product shelf life, lead time, seasonality, minimum order quantities, sales volatility and buying strategy all change what the number means. A furniture merchant carrying higher-cost, slower-moving items should not use the same target as a cosmetics merchant selling repeat-purchase products.

Start with the same business over time. Compare the current period with equivalent periods, such as this quarter against the same quarter last year, because a seasonal business can produce misleading month-to-month changes. Keep the calculation basis consistent: the same COGS treatment, inventory valuation method and period length. A rise from 3.0 to 4.5 may mean stock is moving faster, or that inventory has been cut too far and sales are being constrained.

Then compare the result with genuinely comparable categories, not a blended store-wide figure. Within one store, footwear, supplements and homeware may have different economics. A category-level comparison can show that an acceptable overall ratio hides slow-moving stock in one collection and unusually fast movement in another. Inventory analytics can add the related view of velocity, days of stock and dead stock through Ecommerce Inventory Analytics.

Read turnover alongside the measures that explain its quality. Gross margin shows what remains from each sale after product cost; a high turnover with a thin margin may generate less gross profit than slower stock with stronger pricing. Sell-through, calculated as units sold divided by units available during the period, shows how much of the buy actually moved. Stockout units or days show when low inventory may have restricted sales. For illustration only, turnover rising from 4 to 6 while sell-through falls and stockouts increase is not automatically an improvement.

What Decision the Number Can Support

Inventory turnover is useful as a planning signal, not as an instruction to buy or cut stock. A rising ratio can support more frequent purchasing reviews because units are moving through inventory faster. A falling ratio can justify longer review intervals, smaller purchase quantities or a closer check on open orders. But turnover alone cannot set a reorder point: that also requires lead time, expected demand during lead time, minimum order quantities and a safety-stock policy.

For assortment reviews, compare turnover across products or collections using the same period, cost basis and inventory method. A product with materially lower turnover may deserve a smaller future buy, a different placement decision or a dead-stock review. That comparison is stronger when paired with remaining stock value and units, as shown in Ecommerce Inventory Analytics. A low ratio does not prove that an item should be discontinued; it may be seasonal, newly launched or intentionally held for availability.

For working-capital planning, turnover helps connect COGS to the capital tied up in average inventory. If annual COGS is £240,000 and average inventory is £60,000, the business turns stock 4 times. Moving from 4 to 6 turns, with COGS unchanged, would imply average inventory of £40,000 (£240,000 ÷ 6), releasing £20,000 in stock value in a simplified model. The actual cash effect depends on purchase timing, supplier terms, sell-through and inbound commitments. See Ecommerce Cash Flow for why accounting profit and cash availability can diverge.

Turnover cannot prove profitability, demand quality or service levels. It uses COGS, so it says nothing by itself about gross margin, advertising cost, returns, fulfilment or overhead. A high ratio may come from heavy discounting, a one-off order or stockouts that prevented further sales. A low ratio may reflect excess stock, but it may also reflect a deliberate range strategy. Pair it with product profitability, contribution after advertising, return rate, stockouts and dead-stock value before taking action. Inventory intelligence provides those inventory-position and dead-stock measures alongside the turnover signal.

Inventory turnover is useful when its inputs are consistent and its result is read alongside margin, availability, and cash data. Calculate it from COGS and average inventory, validate the number against the merchant’s operating context, then use the trend to decide where inventory policy needs attention.