A useful first step. No signup.

Free Inventory Turnover Calculator

See how many times you sell through your stock and how long it sits. Set a target to see how much cash reaching it would free up.

Free to useNo email requiredYour entries stay in this page

Calculate your inventory turnover

Example values are shown. Use cost values throughout, in one currency.

The inventory turnover formula

Inventory turnover = cost of goods sold ÷ average inventory

Days of inventory on hand = days in the period ÷ inventory turnover

Average inventory is usually the start value plus the end value, divided by two. Turnover tells you how many times you sold through your stock. Days on hand tells you how long stock sits before it sells.

A worked example

A store's cost of goods sold for the year is 180,000. Its stock was worth 40,000 at cost on the first day and 50,000 on the last.

  1. Average inventory: (40,000 + 50,000) ÷ 2 = 45,000
  2. Turnover: 180,000 ÷ 45,000 = 4 times a year
  3. Days on hand: 365 ÷ 4 = 91 days

If that store reached 6 turns a year on the same sales, it would need only 30,000 of stock on average, which frees 15,000 in cash.

Three mistakes that distort the number

  • Using sales instead of cost. Sales include your margin while inventory is valued at cost, so dividing one by the other inflates turnover. A store with a 50% margin would appear to turn its stock twice as fast as it really does.
  • Averaging two unusual dates. If your year ends after the holiday rush, both figures can be far below what you held most of the year. Paste month-end values into the calculator for a fairer average.
  • Trusting the book value. Turnover is only as good as the inventory figure behind it. If you have not counted stock recently, a shrinkage problem can look like healthy turnover.

What a good turnover looks like

There is no single good number, because it depends on what you sell. Fresh food turns over far faster than furniture or jewellery. A more useful comparison is your own number over time, along with trusted benchmarks for your own trade.

High isn't automatically good either. Very high turnover can mean you run out of stock often and lose sales, so read it alongside your stockout rate. Low turnover ties up cash and raises the risk of markdowns, so look at it product by product: a store-wide average can hide a few fast sellers carrying a lot of dead stock.

To raise turnover

  • Find stock that has not sold in 90 or 180 days, and decide whether to mark it down, bundle it or stop buying it.
  • Order smaller quantities more often. The EOQ calculator shows what that does to your costs.
  • Review how much buffer you hold with the safety stock calculator.

Frequently asked questions

What is the inventory turnover formula?

Inventory turnover = cost of goods sold ÷ average inventory. Average inventory is usually the opening value plus the closing value, divided by two, both at cost.

How do I calculate days of inventory on hand?

Divide the number of days in the period by the turnover. A turnover of 4 over a 365-day year means about 91 days on hand.

Should I use sales or cost of goods sold?

Use cost of goods sold. Inventory is valued at cost, so using sales mixes in your margin and overstates turnover.

What is a good inventory turnover ratio?

It depends on what you sell, so no single number applies to everyone. Compare your own trend over time and look at it by product, since a store-wide average can hide dead stock.

How do I calculate turnover for a month or quarter?

Enter that period's cost of goods sold and its number of days. The calculator shows the turnover for the period and the yearly pace, so you can compare periods of different lengths. Seasonal stores should treat the yearly pace with care.

Take the next step

Start from a stock figure you can trust.

Turnover is only as good as the inventory value behind it. Stocktake lets you count WooCommerce stock with a phone scanner, review the differences in units and money, then apply them with a backup and one-click undo.

Explore Free and Pro →Read the step-by-step guide

More free tools

Free browser tool

Inventory count sheet

Open a WooCommerce stock CSV, count products in a browser worksheet, or download a printable inventory count sheet PDF. Review differences and export your count record.

Open tool →
Free browser tool

EOQ calculator

Find the cheapest order size, rounded to your pack size and supplier minimum, and compare it with what you order now.

Open tool →
Free browser tool

SKU generator

Turn product names and attributes into readable, unique SKUs, with a list or a WooCommerce import file to download.

Open tool →