To calculate inventory turnover, divide the cost of goods sold (COGS) for a period by the average value of your stock over the same period. Average stock is the opening stock plus the closing stock, divided by two. If you sold goods that cost you £60,000 in a year and your average stock was £15,000, your turnover is 4 times a year.
The result tells you how quickly the money you put into stock comes back as sales. Read it with care. A high turnover can mean lean, fast-moving stock, or it can mean you run out too often. A low turnover can mean slow lines, overbuying or stock that will soon need to be written down. This guide shows the steps, the data you need and how to read the figure for each product group.
You can work the sum by hand, or enter the same figures into our free inventory turnover calculator. The tool takes cost of goods sold, opening stock, closing stock and the period, then returns turnover and days inventory outstanding in your browser.
What inventory turnover measures
Inventory turnover compares the cost of what left your warehouse with the value of stock you held on average. Both sides are valued at cost, so your mark-up does not distort the ratio. That is why the calculation starts from cost of goods sold, not from sales revenue.
Before you start, check that you have these four terms clear, because most mistakes come from mixing them up.
| Term | What it means | Where to find it |
|---|---|---|
| Cost of goods sold (COGS) | The cost of items sold to customers in the period | Your ledger or stock system |
| Opening stock | Value of stock on the first day of the period | The previous period's closing stock valuation |
| Closing stock | Value of stock on the last day of the period | Stock count or stock valuation report |
| Average stock | (Opening stock + closing stock) ÷ 2 | Calculated |
| Days inventory outstanding | Days in the period ÷ turnover | Calculated |
Step-by-step: how to calculate inventory turnover
- Choose the period. A year, a quarter or a month. Use the same period for every figure and write it on the report.
- Find cost of goods sold for that period. Use cost, not selling price.
- Find opening and closing stock at cost. Use the same valuation method at both dates, such as FIFO or weighted average.
- Calculate average stock. Add opening and closing stock, then divide by two.
- Divide COGS by average stock. The answer is the number of times your stock turned over in the period.
- Optional: calculate days inventory outstanding. Divide the number of days in the period by the turnover. A turnover of 4 in a 365-day year gives about 91 days.
- Check the result in the tool. Enter the same four figures into the inventory turnover calculator and compare the answer with your sum.
A worked example
The example below uses invented figures so you can follow the arithmetic. Replace them with your own numbers.
| Step | Figure | Calculation |
|---|---|---|
| Cost of goods sold for the year | £60,000 | Input from the ledger |
| Opening stock | £18,000 | Input from last year's closing valuation |
| Closing stock | £12,000 | Input from the count |
| Average stock | £15,000 | (£18,000 + £12,000) ÷ 2 |
| Inventory turnover | 4.0 times | £60,000 ÷ £15,000 |
| Days inventory outstanding | About 91 days | 365 ÷ 4 = 91.25 |

How to read the result
A single number means little until you compare it. Look at your own figure over the last four to six periods, then compare product groups with each other. A fresh food line and a set of machine spares should not be expected to turn at the same speed, so judge each group against its own history.
| What you see | What it may mean | What to check next |
|---|---|---|
| Turnover falls for several periods in a row | Stock is building up or demand is slowing | Ageing report and the date of the last sale for each item |
| Turnover is high but you often run out | Stock levels may be too lean | Reorder points and supplier lead times |
| Turnover varies a lot between groups | A few lines carry sales while others sit | Turnover calculated per product group |
| Turnover rises while sales stay flat | Stock may have been reduced, or cost of sales changed | The count, write-offs and the COGS entries |
Our free tools index lists the other calculators we publish, including the break-even and margin tools, which help you judge whether slow stock is still worth carrying.
Common mistakes that distort the ratio
- Using sales revenue instead of cost of goods sold. Revenue includes your margin, so the turnover looks higher than it is.
- Mixing periods. A monthly cost of goods sold divided by an annual average stock gives a figure that means nothing.
- Using a count taken on an unusual day. A stock count after a large delivery or before a sale event can shift the closing figure.
- Ignoring write-offs and damaged stock. If these are not recorded correctly, closing stock can look healthier than the shelves.
- Comparing one product line with total company stock. Calculate each group against its own stock, then compare the groups.
Using turnover to make stock decisions
Turnover becomes useful when it changes what you do. Slow lines are candidates for a promotion, a smaller reorder quantity or a supplier return. Fast lines may need a higher safety stock so they do not run out. Track the figure monthly for fast movers and quarterly for slower items, so you see a change early rather than at year end.
Keep a note of what you did after each review. Within a few cycles you will know which actions move the number and which do not.
A practical routine is to pull the cost of goods sold and the stock valuation on the same day each month, so the inputs come from the same cut-off. Put the four figures and the result on one line in a shared sheet, together with a short comment on any product group that moved more than usual. Over a year, that single table becomes a record of how your buying decisions affected cash, and it gives you something concrete to discuss with your accountant or supplier.
Turnover also helps when you plan a promotion or a seasonal buy. If a line turns four times a year on average, a buy that covers six months of demand ties up half a year of cash in that line. Checking the figure before you place the order is often more useful than checking it after the stock has sold, or has not sold.
Frequently asked questions
What is a good inventory turnover ratio?
There is no single good figure. It depends on the product, its shelf life and your industry. Compare your own figures over time and by product group, and only use outside benchmarks if you can check where they came from.
Should I use cost or selling price in the calculation?
Use cost. Stock is held at cost in your records, and cost of goods sold is also measured at cost. Mixing in selling price makes the ratio look better than it really is.
How often should I calculate inventory turnover?
Monthly works well for fast-moving items and quarterly is usually enough for slower lines. Calculate the year-end figure too, because it is the one most lenders and accountants ask about.
What is the difference between inventory turnover and days inventory outstanding?
They describe the same thing in two ways. Turnover counts how many times stock was replaced in the period, while days inventory outstanding converts that into the average number of days stock stays in the business.
Does inventory turnover apply to a service business?
Not in the usual sense. The ratio needs stock you hold and sell at cost. A service business that holds consumables can calculate it for those items only, and should not add service hours into the figure.
Next step
Pick one product group, calculate its turnover for the last three periods and write down what you will change. Use our inventory turnover calculator to check each figure, then repeat the review next month.
If stock, purchasing and finance sit in separate files, Dika Ops keeps inventory, purchasing and accounting on one record, so the cost figures you need are already in the same system. For stock workflows that need custom integration, see our enterprise applications work, or talk to us about your setup. Dika Design, the team that builds these tools and Dika Ops, can help with the wider picture. You can also read our guide to how to do a stock count before you calculate closing stock, and our overview of inventory management methods to choose a valuation approach.



