Explore Dika Ops

How do I calculate inventory turnover for my stock?

How do I calculate inventory turnover? Divide cost of goods sold by average stock, read the result by product group, and check it with our free calculator.

7 min read Business software
Person working a calculator at a desk while reviewing stock figures

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.

TermWhat it meansWhere to find it
Cost of goods sold (COGS)The cost of items sold to customers in the periodYour ledger or stock system
Opening stockValue of stock on the first day of the periodThe previous period's closing stock valuation
Closing stockValue of stock on the last day of the periodStock count or stock valuation report
Average stock(Opening stock + closing stock) ÷ 2Calculated
Days inventory outstandingDays in the period ÷ turnoverCalculated

Step-by-step: how to calculate inventory turnover

  1. Choose the period. A year, a quarter or a month. Use the same period for every figure and write it on the report.
  2. Find cost of goods sold for that period. Use cost, not selling price.
  3. Find opening and closing stock at cost. Use the same valuation method at both dates, such as FIFO or weighted average.
  4. Calculate average stock. Add opening and closing stock, then divide by two.
  5. Divide COGS by average stock. The answer is the number of times your stock turned over in the period.
  6. 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.
  7. 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.

StepFigureCalculation
Cost of goods sold for the year£60,000Input from the ledger
Opening stock£18,000Input from last year's closing valuation
Closing stock£12,000Input from the count
Average stock£15,000(£18,000 + £12,000) ÷ 2
Inventory turnover4.0 times£60,000 ÷ £15,000
Days inventory outstandingAbout 91 days365 ÷ 4 = 91.25
Calculator and pen resting on a worksheet with handwritten figures
Keep the four inputs written down with the date and valuation method, so the figure can be checked later.

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 seeWhat it may meanWhat to check next
Turnover falls for several periods in a rowStock is building up or demand is slowingAgeing report and the date of the last sale for each item
Turnover is high but you often run outStock levels may be too leanReorder points and supplier lead times
Turnover varies a lot between groupsA few lines carry sales while others sitTurnover calculated per product group
Turnover rises while sales stay flatStock may have been reduced, or cost of sales changedThe 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.

Have a project in mind? Let us talk it through.

Tell us what you want to improve. We will reply with a clear next step.