Inventory Turnover: How to Calculate and Improve It
Every item sitting on your shelves is cash you cannot spend on anything else. Inventory turnover tells you how quickly that cash comes back as sales. Here is how to calculate it, how to read the result for your own business and the practical moves that help stock sell faster without leaving customers facing empty shelves.
Key takeaways
- Inventory turnover equals cost of goods sold divided by average inventory for the same period.
- A higher turnover usually means stock sells faster and less cash is tied up, but too high can mean frequent stockouts.
- Compare your result with your own past periods and calculate it by product or category, not just for the whole business.
- You can improve turnover by ordering smarter, clearing slow movers, tightening your range and watching reorder points.
Mid-December is a revealing time for anyone who sells physical products. Some items have flown off the shelves for the holidays, while others are still sitting exactly where you put them in October. Before you place orders for the new year, it is worth asking a simple question: how fast does my stock actually sell?
Inventory turnover answers that with one number. It is one of the most useful ratios for retailers, makers, online shops and wholesalers, and you only need two figures from your books to calculate it.
A quick note: this article is general information, not accounting or tax advice. How you value inventory and calculate cost of goods sold can depend on your accounting method and local rules, so check with an accountant if you are unsure.
What inventory turnover means
Inventory turnover measures how many times you sell through and replace your average stock during a period, usually a year. If your turnover is 4, you sold the equivalent of your average inventory four times over that year.
Why it uses cost, not sales price
The formula uses cost of goods sold (COGS) rather than revenue because your inventory is recorded at cost. Comparing cost with cost keeps the ratio consistent. If you used revenue instead, your markup would inflate the result.
Days of inventory
Many owners find it easier to think in days. Divide the number of days in the period by your turnover to get the average number of days an item sits in stock. For a year, that is 365 divided by turnover. A turnover of 4 means stock sits for roughly 91 days on average.
How to calculate inventory turnover step by step
- Pick the period. A full year is most common, but you can also calculate it quarterly or monthly to spot seasonal changes.
- Find cost of goods sold. Take it from your profit and loss statement for that period. It covers the cost of the products you actually sold.
- Find opening and closing inventory. Use the inventory value at cost at the start and end of the period, from your balance sheet or stock count.
- Calculate average inventory. Add opening and closing inventory and divide by 2. If your stock swings a lot during the year, averaging monthly values gives a more accurate picture.
- Divide. COGS divided by average inventory is your turnover.
- Convert to days. Divide the days in the period by your turnover to see how long stock sits on average.
Example
Imagine Nadia, who runs a small homeware shop. Last year her cost of goods sold was $120,000. She started the year with $25,000 of inventory at cost and ended it with $35,000. Her average inventory is ($25,000 + $35,000) / 2 = $30,000. Her turnover is $120,000 / $30,000 = 4, which means stock sits for about 365 / 4, or roughly 91 days. When she breaks it down by category, candles turn over much faster than ceramics, which helps her decide where to put next year's buying budget. (Nadia and her numbers are made up for illustration.)
Common mistake
Using only the closing inventory from a busy season. If you count stock just before a holiday rush, when shelves are fullest, your average will look high and your turnover low. If you count just after, the opposite happens. Use an average across the period, ideally from several points in the year.
What is a good inventory turnover?
There is no universal "good" number. A shop selling fresh food needs stock to move very quickly, while a business selling furniture, jewelry or spare parts may reasonably hold items much longer. The most useful comparison is with yourself.
- Compare over time. Is your turnover rising or falling year on year? A steady decline often means you are buying more than you sell.
- Compare by product or category. A healthy overall number can hide a category that barely moves.
- Compare with your plans. If you aim to hold about two months of stock, your days of inventory should be close to that.
When low turnover is a problem
Low turnover means cash is tied up in stock. You may be paying for storage, insurance and handling, and some items may become outdated, damaged or go out of fashion. Eventually, they may need deep discounts to sell at all.
When high turnover is a problem
Very high turnover sounds great, but it can mean you are running too lean. If customers often find items out of stock, you lose sales and goodwill. You may also pay more by ordering small quantities frequently. The aim is balance: stock that moves steadily without regular gaps.
Pro tip
Track stockouts next to turnover. If turnover improves and stockouts stay low, you are getting leaner in a healthy way. If both go up together, you may have cut too far.
An inventory turnover tracker you can copy
Calculating turnover by category is where the real insights appear. Copy this layout into a spreadsheet and add one row per product line. All amounts are made-up examples.
| Category | Annual COGS (example) | Opening inventory (example) | Closing inventory (example) | Average inventory | Turnover | Days in stock |
|---|---|---|---|---|---|---|
| Candles | $40,000 | $4,000 | $6,000 | $5,000 | 8.0 | About 46 |
| Ceramics | $30,000 | $12,000 | $18,000 | $15,000 | 2.0 | About 183 |
| Textiles | $50,000 | $9,000 | $11,000 | $10,000 | 5.0 | About 73 |
Use these formulas: average inventory equals opening plus closing divided by 2, turnover equals COGS divided by average inventory, and days in stock equals 365 divided by turnover. Sort by days in stock to see your slowest movers at the top.
How to improve inventory turnover
Improving turnover does not have to mean slashing stock. It usually means buying more of what sells and less of what does not.
Buy and reorder smarter
- Use sales history. Base orders on how much of each item actually sold in the same period last year, adjusted for trends.
- Set reorder points. Decide the stock level that triggers a new order for each key item, based on how fast it sells and how long suppliers take to deliver.
- Order smaller, more often for steady sellers, if your suppliers allow it and the extra delivery cost is worth it.
- Ask suppliers about flexibility. Lower minimum order quantities, faster delivery or returns on unsold stock can all help.
Clear slow movers
- Bundle slow items with best sellers.
- Move them to better shelf space or feature them online.
- Run a planned clearance in a quiet period. January is a natural moment after the holidays.
- Stop reordering items that have not sold for a long time, and record why.
Tighten your range
Many small shops carry too many variations of the same product. Look at sizes, colors and versions that rarely sell and consider dropping them. A smaller, sharper range is often easier for customers to shop and easier for you to manage.
Improve your stock records
You cannot manage what you cannot see. Regular stock counts, even partial cycle counts of a few categories each week, help keep your records accurate. If your point-of-sale or online store system tracks inventory, make sure sales, returns and deliveries are recorded consistently.
Common mistake
Chasing a higher turnover with heavy discounts on everything. Turnover will rise, but your margin may fall further than the cash you free up is worth. Target discounts at genuinely slow stock and keep best sellers at full price.
Example
Using the tracker above, the made-up homeware shop sees ceramics sitting for about 183 days. For the new year, the owner cuts the number of ceramic designs, keeps only the three best sellers, runs a January clearance on the rest and redirects part of the ceramics budget to candles, which turn over far faster. She checks the numbers again each quarter to make sure the change is working. (This scenario is made up for illustration.)
Your inventory turnover action plan
- Pull cost of goods sold for the last 12 months
- Find opening and closing inventory at cost, or monthly values if you have them
- Calculate average inventory, turnover and days in stock
- Repeat the calculation by category or product line
- Sort categories by days in stock and flag the slowest
- Plan a targeted January clearance for slow movers
- Set reorder points for your best sellers
- Track stockouts alongside turnover each quarter
Frequently asked questions
Can I use sales instead of cost of goods sold?
Some people do, but it overstates turnover because sales include your markup while inventory is valued at cost. Using COGS keeps both sides of the formula on the same basis.
How often should I calculate inventory turnover?
Yearly gives you the big picture, but calculating it quarterly or monthly helps you spot seasonal patterns and catch problems before your next big order.
Does inventory turnover matter for service businesses?
Only if you hold stock, such as parts, materials or products you resell. If you do, the same formula applies to that stock.
What should I do with stock that will not sell at all?
Options include deep clearance, bundling, donating or recycling. Talk to your accountant about how to record written-down or written-off stock, because the rules depend on your accounting method and location.
Related reading
The bottom line
Inventory turnover is cost of goods sold divided by average inventory, and it shows how quickly your stock turns back into cash. Calculate it for the whole business and by category, compare it with your own past results and watch stockouts so you do not cut too far.
Before you place your new-year orders, spend an hour with the tracker. Buy more of what moves, clear what does not and you will start the year with leaner shelves and more cash to work with.
