Key takeaways
- Use COGS, not revenue. Revenue-based turnover is inflated by your markup and cannot be compared with another company.
- Use an average, not the closing balance. A year-end count taken before a seasonal build flatters the ratio.
- Turns and days are reciprocal. 6.67 turns is 54.8 days; there is no extra information in one form.
- Averages hide dead stock. One obsolete pallet can sit inside a healthy-looking ratio for years.
- Turnover only means something against margin and industry. A jeweller and a grocer are not comparable.
Two inputs, one ratio
Inventory turnover = cost of goods sold ÷ average inventory
Cost of goods sold is the cost of the units actually sold in the period, including freight in and direct labour for a manufacturer. Average inventory is the average investment held to support those sales. Both figures must cover the same period, in the same currency, and on the same cost basis: matching a FIFO cost of sales against a LIFO inventory balance produces a ratio that means nothing.
The output is a count of cycles. A turnover of 5 means the business sold and replaced its average stock five times during the period. It is not a percentage and it is not a rate of return; it is a frequency.
Turns and days describe the same fact
Days inventory = 365 ÷ inventory turnover, or equivalently average inventory ÷ COGS × 365.
A turnover of 6.67 becomes 365 ÷ 6.67 = 54.8 days: on average, a unit sits in stock for about eight weeks before it is sold. For a quarterly calculation, divide 90 by the quarterly turnover instead of 365; using 365 on a quarterly figure understates days by a factor of four.
Days are usually the more useful form because they are comparable with payment terms. If inventory sits for 55 days and customers pay in 45, cash is committed for 100 days before a supplier invoice falls due, and that gap has to be funded.
A worked table
| Cost of goods sold | Average inventory | Turnover | Days inventory |
|---|---|---|---|
| $500,000 | $100,000 | 5.00 | 73.0 |
| $1,000,000 | $150,000 | 6.67 | 54.8 |
| $1,000,000 | $250,000 | 4.00 | 91.3 |
| $200,000 | $50,000 | 4.00 | 91.3 |
| $750,000 | $125,000 | 6.00 | 60.8 |
The third and fourth rows have the same turnover at very different scale: a small shop and a mid-sized distributor can share a ratio while sharing nothing else. Turnover compares businesses only when the product, the margin, and the accounting basis are similar.
What “average” inventory should mean
The standard approximation is (opening inventory + closing inventory) ÷ 2. It is cheap and it is wrong whenever inventory swings inside the period. A retailer that builds stock in September for a December season has a September balance far above its February balance, and a two-point average can land mid-swing.
A monthly average of thirteen points (the opening balance plus twelve month-ends) is more faithful and is easy to pull from any accounting system. For a seasonal business it is worth the effort, because the ratio drives reorder decisions.
The closing balance matters too. Taking the count after a sell-down, rather than before the build, produces a smaller denominator and a better-looking ratio that did not exist for most of the year.
Why cost of goods sold, not revenue
Revenue includes markup, so a revenue-based turnover measures pricing as much as movement. Take a company with $1,500,000 of revenue, $1,000,000 of COGS, and $150,000 of average inventory. On COGS the turnover is 6.67; on revenue it is 10.0, and the apparent 36.5 days is fiction.
The distortion is not constant. A business with a 50% gross margin and one with a 20% margin can hold identical stock and identical COGS while showing revenue-based turnovers that differ by a factor of 1.6. This is why published turnover figures should always be checked for which numerator was used.
Dead stock and the average
An average is a summary, and summaries hide outliers. Suppose $30,000 of a $150,000 inventory has not sold in twelve months: obsolete components, a discontinued colour, last season’s model. The ratio still counts it in the denominator and still looks respectable, which is precisely the problem.
Age the stock instead. A simple report groups inventory by last sale date, or by days since receipt where the item has never sold, and values each bucket at cost. Anything beyond a defined horizon, commonly 180 or 365 days, is a candidate for markdown, bundling, return to supplier, or write-off.
Removing dead stock from the calculation is not a fix: dropping it from average inventory would lift the ratio to 8.33 turns and 43.8 days while the cash is still gone. The honest treatment is a write-down, which reduces both inventory and profit, and then a ratio computed on what remains.
Turnover, margin, and gross margin return on inventory
Turnover on its own can be gamed by cutting stock, which raises the ratio and produces stockouts. The pairing that resists this is GMROI = gross margin ÷ average inventory at cost. A category with a 40% margin and $100,000 of average inventory at cost generating $400,000 of gross margin returns 4.00; a category with a 20% margin and the same inventory generating $200,000 returns 2.00.
Read together, turnover and GMROI answer the two questions that matter: how fast does stock move, and how much margin does each dollar of stock earn? A fast-moving, thin-margin line can be less profitable per dollar of shelf space than a slow, fat-margin one, and only the pair shows it.
Common mistakes
- Dividing revenue by inventory and calling it turnover.
- Using the closing balance as the denominator, especially after a seasonal sell-down.
- Applying 365 to a quarterly or monthly turnover.
- Mixing a cost-basis numerator with a retail-value denominator.
- Comparing across industries: grocery and jewellery operate on different physics.
- Ignoring write-downs, which raise turnover by shrinking the denominator.
- Celebrating a rising ratio that came from stockouts rather than better planning.
Accounting caveats
Cost formulas change the ratio. FIFO, weighted average, and specific identification produce different COGS and different inventory in the same year; LIFO is permitted in the United States but not under IAS 2. IAS 2 requires inventory to be measured at the lower of cost and net realisable value, so a write-down raises turnover in the period it is recognised, and the following year’s comparison is distorted.
Tax rules add their own layer. The IRS requires inventories to be valued consistently and allows some small business taxpayers to treat inventory as non-incidental materials and supplies; a change in method needs the appropriate filing. Check the basis before comparing two years of your own figures, and never compare a set prepared under different methods.
Using turnover to release cash
The arithmetic of improvement is simple. On $1,000,000 of COGS, moving from 6.67 to 7.67 turns cuts the inventory needed from $150,000 to $130,378, releasing about $19,600 of cash. The same improvement applied to a $10 million COGS business releases roughly $196,000.
Getting there is operational, not financial: fewer SKUs, smaller and more frequent replenishment, a reorder point based on lead time and demand variability, and a clearance routine that runs on a calendar rather than on intuition. The ratio is the scoreboard, not the lever.
Frequently asked questions
Should I use 365 or 360 days?
Use 365 to match an annual COGS figure. Some credit models use 360; whichever you choose, apply it to every period so comparisons stay valid.
What is a good inventory turnover?
There is no universal number. Compare with your own history, your direct competitors, and your margin; a grocery chain and a custom furniture maker are both healthy at very different ratios.
Does a higher turnover always mean better performance?
No. Stockouts also raise turnover and lose sales. Pair the ratio with fill rate, backorders, and GMROI before concluding that faster is better.
Can inventory turnover be negative?
No, because both inputs are positive for a going concern. It can be undefined when average inventory is zero, and meaningless when COGS is distorted by a write-down.
What is GMROI?
Gross margin return on inventory investment: gross margin divided by average inventory at cost. It shows how much margin each dollar of stock earns, which turnover alone cannot.
How do I handle a mid-year acquisition?
Use a pro-forma COGS and a pro-forma average inventory for the combined business, or compute on organic operations only. Mixing pre- and post-acquisition balances produces a ratio that describes neither.
Further reading
Keep exploring
Decision path