Explore Dika Ops

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.

Free Runs in your browser No sign-up
At cost, for the whole period.
At cost, at the start.
At cost, at the end.
Used for days of inventory.
Sell-through (optional)

Enter units to see the share of your available stock that was sold.

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.

  1. Enter cost of goods sold Use the cost of the goods you sold during the period, taken from your accounts, not the sales revenue.
  2. 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.
  3. 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.
  4. 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.
  5. Read the result See turnover, days of inventory outstanding, average inventory and, for a period shorter than a year, an annualised turnover.
  6. 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

ParameterValuesWhat it does
cogsnumberCost of goods sold in the period.
opennumberStock value at the start of the period, at cost.
closenumberStock value at the end of the period, at cost.
periodyear · half · quarter · month · custom (default: year)year, half, quarter, month or custom. Sets the number of days.
daysnumberNumber of days in the period. Typing a value switches the period to custom unless it matches a standard one.
currencyEUR · USD · GBP · TRY · CHF · CAD · AUD · SEK · PLN (default: EUR)Currency as a three-letter code.
uopennumberUnits in stock at the start (for sell-through).
urecvnumberUnits received during the period (for sell-through).
usoldnumberUnits sold during the period (for sell-through).

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.