Categories
Retail POS

Inventory Turnover Ratio: Formula, Example and What a Good Ratio Looks Like

Quick answer: Inventory turnover ratio shows how many times you sell and replace your stock in a period. The formula is Inventory turnover = Cost of goods sold ÷ Average inventory, where average inventory is (beginning inventory + ending inventory) ÷ 2. Divide 365 by the ratio to see how many days stock sits on your shelves.

Stock that sits on a shelf is cash you cannot use. It ties up money, takes up space, and risks expiring, going out of fashion or being marked down. Inventory turnover is the simplest way to see how hard your stock is working, and which products are quietly holding your cash hostage.

This guide covers the formula, a worked retail example, how to turn the ratio into days, what a good ratio looks like, and practical ways to improve it.

Key takeaways

  • Inventory turnover = cost of goods sold ÷ average inventory.
  • Average inventory = (beginning inventory + ending inventory) ÷ 2.
  • Days in inventory = 365 ÷ inventory turnover.
  • Higher turnover usually means healthier cash flow, but too high can mean frequent stockouts.
  • Always check turnover by category or item. A good store-wide number can hide slow lines.
  • A POS with real-time stock and item-level reports lets you check turnover any day, not once a year.

What is inventory turnover ratio?

Inventory turnover ratio (also called stock turnover or stock turn) measures how many times a business sells through its average stock in a period, usually a year. A turnover of 6 means the store sold and replaced its average inventory six times, or roughly every two months.

It connects two numbers every retailer already has: what the goods you sold cost you, and how much stock you held to sell them. The faster stock turns, the less cash is tied up on your shelves for every sale you make.

Inventory turnover ratio formula

Inventory turnover = Cost of goods sold ÷ Average inventory

Average inventory = (Beginning inventory + Ending inventory) ÷ 2

Here is what each part means:

  • Cost of goods sold (COGS): what you paid for the stock you sold during the period, not the selling price. The IRS Tax Guide for Small Business explains how COGS is worked out.
  • Beginning inventory: the cost value of your stock at the start of the period.
  • Ending inventory: the cost value of your stock at the end of the period, based on a count or your system’s stock levels.

Some retailers use sales instead of COGS. That is fine if inventory is also valued at selling price, but mixing sales with stock valued at cost makes turnover look better than it is. Pick one basis and stick to it.

How to calculate inventory turnover step by step

  1. Choose a period. A year is standard. Quarterly or monthly works too, as long as you compare like with like.
  2. Find your cost of goods sold for the period from your accounts or POS reports.
  3. Get your opening and closing stock values at cost.
  4. Work out average inventory: (opening + closing) ÷ 2. If stock swings a lot through the year, average the month-end values instead.
  5. Divide COGS by average inventory to get your turnover.
  6. Divide the days in the period by the turnover to see how long stock sits before it sells.

Inventory turnover example

Here is one year at a small retail store:

ItemAmount
Cost of goods sold$480,000
Beginning inventory$90,000
Ending inventory$70,000
Average inventory$80,000
Inventory turnover6.0
Days in inventory61 days

The calculation is ($90,000 + $70,000) ÷ 2 = $80,000 average inventory, then $480,000 ÷ $80,000 = 6.0 turns a year. In days, 365 ÷ 6.0 = about 61 days, so the average product sits in the store for around two months before it sells.

How to convert turnover into days

Days in inventory = 365 ÷ Inventory turnover

This number, also called days sales of inventory (DSI), is often easier to act on than the ratio. Owners and staff instantly understand “this stock takes 120 days to sell” in a way they rarely understand “a turnover of 3”.

Check turnover by category, not just store-wide

A single store-wide figure can look healthy while whole categories are stuck. Here is how the same store’s turnover breaks down:

CategoryTurns a yearDays
Snacks and drinks15.024
Household6.061
Personal care3.0122
Small appliances1.2304

Snacks and drinks sell through in under a month, while small appliances take about ten months. That slow category is where cash is tied up, and where dead stock is most likely to build. Going one level deeper, to individual items and SKUs, shows exactly which products to reorder less often.

What is a good inventory turnover ratio?

There is no single good number, because it depends on what you sell. Stores selling fast-moving or perishable goods, such as groceries, fruit and vegetables, or convenience items, turn stock many times a year. Jewellery, electronics, furniture and other high-value items turn far more slowly. As a very rough rule of thumb, many small general retailers aim for somewhere around 4 to 8 turns a year, but the most useful benchmark is your own trend and the turnover of each category over time.

If you want a wider reference point, the US Census Bureau’s Monthly Retail Trade data tracks retail inventories against sales across the industry.

What low turnover tells you

  • You are over-ordering or buying in sizes and quantities that do not sell.
  • Cash is tied up in stock instead of being available for rent, wages or better-selling lines.
  • Risk of expiry, damage, theft and markdowns is rising.

What very high turnover can tell you

  • You may be running out of popular items and losing sales.
  • Frequent small orders can raise delivery and admin costs.
  • It is usually a good sign, but check stockout reports before celebrating.

Related metrics: sell-through rate and GMROI

Sell-through rate shows how much of what you received has sold in a set period: Sell-through % = Units sold ÷ Units received × 100. If you received 200 units of a new line and sold 130 in 30 days, sell-through is 65%. It is especially useful for fashion and seasonal stock, where sizes and colours sell at very different speeds.

GMROI (gross margin return on inventory investment) shows how much gross profit each unit of money in stock earns: GMROI = Gross margin ÷ Average inventory at cost. In the example above, with sales of $720,000 and COGS of $480,000, gross margin is $240,000 and GMROI is $240,000 ÷ $80,000 = 3.0. Every dollar held in stock earned three dollars of gross margin. Turnover tells you how fast stock moves, and GMROI tells you whether that movement is profitable.

7 ways to improve inventory turnover

  1. Reorder by data, not habit. Set reorder points for each item based on how fast it actually sells.
  2. Cut or clear slow movers. Discount, bundle or return slow stock to suppliers before it becomes dead stock, and stop reordering it.
  3. Order smaller, more often for lines where suppliers allow it, so less stock sits waiting.
  4. Balance stock across branches. Transfer surplus from a slow store to one where the item sells, instead of buying more.
  5. Keep counts accurate. Wrong stock levels lead to wrong orders. These tips to improve inventory accuracy help.
  6. Reduce shrinkage. Theft, damage and admin errors quietly distort both your stock value and your reorders. See how to prevent shrinkage in retail.
  7. Review turnover by category every month, not once a year, so problems surface while you can still act.

How POS software helps you track inventory turnover

Working this out in a spreadsheet once a year tells you what went wrong after the fact. A retail POS with built-in inventory keeps the numbers current as you trade. In LithosPOS, you can:

  • Track stock in real time across products, sizes, colours and other variants.
  • Set reorder points and get daily low-stock email alerts, and send purchase orders to vendors. See inventory management.
  • Transfer stock between locations based on demand, and record stock adjustments for damage and losses.
  • See sales by item and inventory reports that show which items make or lose you money, and export them to Excel. See reports and analytics.
  • Check every branch from one place with multi-store management, or from your phone with the LithosPOS Dashboard App.

For more on running several branches, read our guide to multi-store retail management. Running a restaurant instead? The same idea applies to ingredients, measured as food cost percentage.

Frequently Asked Questions

What is the formula for inventory turnover ratio?
Inventory turnover = cost of goods sold ÷ average inventory, where average inventory = (beginning inventory + ending inventory) ÷ 2. Use cost values for both, for the same period.

What is a good inventory turnover ratio for retail?
It depends on what you sell. Grocery and convenience stores turn stock many times a year, while jewellery and electronics turn much more slowly. Many small general retailers aim for around 4 to 8 turns a year, but your own trend by category is the best benchmark.

Is a higher inventory turnover always better?
Usually, but not always. High turnover means stock sells quickly and less cash is tied up. Very high turnover can also mean frequent stockouts and lost sales, so check it alongside stockout reports.

How do I convert inventory turnover into days?
Divide 365 by your annual inventory turnover. A turnover of 6 means stock sits for about 61 days on average before it sells.

Should I use sales or cost of goods sold in the formula?
Cost of goods sold is more accurate, because inventory is normally valued at cost. If you use sales, value inventory at selling price too, otherwise the ratio will look higher than it really is.

What is the difference between inventory turnover and sell-through rate?
Inventory turnover measures how often average stock is sold and replaced over a period. Sell-through rate measures what percentage of the units you received has sold, which is useful for new, seasonal or fashion lines.

How often should I check inventory turnover?
Calculate it yearly for your accounts, but review it monthly by category so slow-moving stock is caught early.

Can POS software calculate inventory turnover?
A POS with inventory management tracks sales and stock levels in one place, and its item and inventory reports give you the figures you need for turnover by product, category or store.

Start tracking your stock turnover

Inventory turnover is a simple ratio, but it only helps if you check it often and act on what it shows. Start with your top five categories, convert their turnover into days, and decide what to reorder less, clear out or move between branches.

If you want real-time stock, item-level reports and reorder alerts in one system, book a free LithosPOS demo or compare plans on the pricing page. You can also browse more retail POS guides on our blog.