Inventory turnover and days of inventory calculator
Enter cost of goods sold and your opening and closing stock to see how many times stock turned over, how many days it sat on the shelf and what share was sold.
Enter units to see the share of your available stock that was sold.
The working
How to calculate inventory turnover
Inventory turnover compares what you sold, at cost, with the stock you carried to sell it. Enter three amounts and the period and the tool does the rest, with every formula shown.
- Enter cost of goods sold Use the cost of the goods you sold during the period, taken from your accounts, not the sales revenue.
- Enter opening and closing stock Use the value of stock at the start and at the end of the period, at cost. The tool averages the two.
- Choose the period Pick a year, half-year, quarter or month, or type the number of days. The days are used for days of inventory.
- Add units for sell-through Optionally enter the units in stock at the start, the units received and the units sold to calculate sell-through.
- Read the result See turnover, days of inventory outstanding, average inventory and, for a period shorter than a year, an annualised turnover.
- Read the notes The tool describes what your numbers say in plain language and suggests comparing them with your own history.
Tips for using turnover well
- Compare turnover with your own earlier periods and with similar product lines, not with an unrelated business.
- Use cost of goods sold and stock at cost on both sides, so the ratio compares like with like.
- Calculate turnover by product group, because one fast line can hide slow stock in another.
- Watch the closing stock for seasonal businesses, because a single date can mislead. Averaging several months gives a better picture.
- Read turnover together with availability, because very high turnover can mean you run out of stock.
Common inventory turnover mistakes
- Using revenue instead of cost Sales revenue includes your margin, so it overstates turnover. Use cost of goods sold.
- Using stock at selling price Stock must be valued at cost to match cost of goods sold.
- Mixing periods A quarter of cost of goods sold against a year of average stock gives a number that means nothing. Keep the period consistent.
- Using one date only Closing stock right after a large delivery makes turnover look worse than the year was. Average several points where you can.
Open it pre-filled with a link
Every field accepts a query parameter with the same name, so a link, a script or an AI agent can fill the tool in and run it. Open an example: /tools/inventory-turnover-calculator/?cogs=600000&open=100000&close=140000
| Parameter | Values | What it does |
|---|---|---|
cogs | number | Cost of goods sold in the period. |
open | number | Stock value at the start of the period, at cost. |
close | number | Stock value at the end of the period, at cost. |
period | year · half · quarter · month · custom (default: year) | year, half, quarter, month or custom. Sets the number of days. |
days | number | Number of days in the period. Typing a value switches the period to custom unless it matches a standard one. |
currency | EUR · USD · GBP · TRY · CHF · CAD · AUD · SEK · PLN (default: EUR) | Currency as a three-letter code. |
uopen | number | Units in stock at the start (for sell-through). |
urecv | number | Units received during the period (for sell-through). |
usold | number | Units sold during the period (for sell-through). |
What this inventory turnover calculator includes
It calculates standard ratios from the figures you enter and explains them without outside benchmarks, because a good value depends on your products and your market.
- Inventory turnover Cost of goods sold divided by average inventory, shown as the number of times stock turned over in the period.
- Days of inventory outstanding The days in the period divided by turnover, which is the average number of days an item sits in stock.
- Annualised turnover For a month or a quarter, turnover scaled to a year so that you can compare periods of different length.
- Sell-through rate Units sold as a share of the units you had available, from the units at the start plus the units received.
- Flexible period Year, half-year, quarter, month or any number of days, with the days kept in step with the period you choose.
- Plain-language notes A short reading of your own numbers, including whether stock grew or shrank, with no invented benchmarks.
- Nine currencies Amounts follow the page language and the selected currency.
- Private by design All figures are calculated in your browser and are never uploaded.
The formulas used
| Measure | Formula | Example |
|---|---|---|
| Average inventory | (opening + closing) ÷ 2 | (100,000 + 140,000) ÷ 2 = 120,000 |
| Inventory turnover | cost of goods sold ÷ average inventory | 600,000 ÷ 120,000 = 5.0 |
| Days of inventory | days in period ÷ turnover | 365 ÷ 5 = 73 days |
| Annualised turnover | turnover × 365 ÷ days in period | a quarter at 1.5 gives about 6.0 |
| Sell-through | units sold ÷ (opening units + units received) | 3,600 ÷ (1,000 + 4,000) = 72 percent |
Who uses an inventory turnover calculator
Turnover is one of the first measures people look at when they ask whether stock is working for them or sitting idle.
Retailers and online shops
See how long stock takes to sell and which ranges tie up cash.
Wholesalers and distributors
Compare turnover across product groups and decide where to hold more or less.
Manufacturers
Measure how quickly raw materials and finished goods move through the business.
Finance teams
Report days of inventory next to receivables and payables to understand working capital.
Buyers and planners
Test the effect of a bigger order on days of inventory before you commit.
Owners preparing for a bank or an investor
Show that you understand how fast stock moves and how much money it holds.
The ratios are only as good as the stock values and the cost of goods sold you enter. Use them to compare your own periods and ranges over time.
How this connects to running the business
Turnover is calculated at the end of a period, but stock is moving every day. When stock, purchasing and accounting use different files, the closing figure arrives late and cannot be trusted. We build Dika Ops so that stock, purchases and cost of goods sold come from the same records, and the ratios are available whenever you ask. Find out more at dikaops.com
Frequently asked questions
What is inventory turnover?
It is the number of times you sell and replace your stock during a period. It is calculated as cost of goods sold divided by average inventory.
What are days of inventory outstanding?
It is the average number of days stock stays in your business before it is sold. It is the days in the period divided by inventory turnover.
What is a good inventory turnover?
It depends on what you sell, how you buy and how fast your market moves, so this tool does not claim a universal figure. Compare your result with your own earlier periods and with similar product lines.
What is sell-through?
Sell-through is the share of the units you had available that you actually sold in the period. Here it is units sold divided by opening units plus units received.
Why does the tool average opening and closing stock?
A single date can be unrepresentative. The average of the opening and closing value is a simple, widely used approximation of the stock you carried. If you have monthly values, averaging them is more accurate.
Should I use cost of goods sold or sales?
Use cost of goods sold, because stock is valued at cost. Using sales revenue includes your margin and overstates turnover.
What if turnover looks very high?
It can mean efficient buying, but also that you run out of stock. Check availability and lost sales alongside the ratio.
Can I link to a calculation?
Yes. Every control accepts a query parameter, so a link can open the tool with your numbers filled in. The list is in the first tab.
Have a project in mind? Let us talk it through.
Tell us what you want to build or improve. We reply with a clear next step.