Inventory turnover ratio: how to calculate it and free up cash tied up in stock

In short

• Inventory turnover ratio measures how many times you sell and replace your stock over a period. The formula is the cost of goods sold divided by average inventory.
• A higher ratio generally means efficient inventory management and healthy cash flow. A lower ratio means cash is sitting on shelves instead of moving through the business.
• The levers that move it most: demand forecasting, inventory management software, just-in-time ordering, an ABC analysis to prioritise and clear dead stock, and closer supplier partnerships.
• Travelbags used this combination to reach 95% availability on its A-products while cutting total inventory value by 22%.
  ‍

What is inventory turnover ratio?

Inventory turnover ratio is a key performance indicator that measures how fast your inventory sells and gets replaced over a given period, usually a year. It is one of the clearest signals of how hard your working capital is actually working. Stock that turns over quickly converts back into cash fast. Stock that does not just sits in the warehouse, tying up money you could be spending on the products that do sell.

‍

How do you calculate inventory turnover ratio?

To calculate the inventory turnover ratio, use the following formula:

Inventory turnover ratio = Cost of goods sold (COGS) ÷ Average inventory

Cost of goods sold is the direct cost of the products you sold in that period, pulled straight from your accounting or inventory system. Average inventory is usually calculated as beginning inventory plus ending inventory, divided by two, to smooth out seasonal swings within the period.

Say your annual cost of goods sold is 1,200,000 EUR and your average inventory value sits at 500,000 EUR. Your inventory turnover ratio is 1,200,000 ÷ 500,000 = 2.4. 

For most e-commerce categories, a ratio of 2.4 times a year is slow, and it is the kind of number that should trigger a hard look at what is actually sitting on the shelf, not just a shrug at the maths.

That same ratio also tells you how long your stock sits before it sells, using a related formula:

Days Inventory Outstanding (DIO) = (Average inventory ÷ Cost of goods sold) × Number of days

For the example above, that is roughly 365 ÷ 2.4, about 152 days. The higher your turnover ratio, the fewer days your cash is tied up in unsold stock, which directly shortens your cash conversion cycle.

Turnover ratio, DIO and sell-through rate all use similar inputs but answer different questions, so it helps to know which one to reach for:

According to APQC's Open Standards Benchmarking, holding inventory costs roughly 10% of its value per year, once you add up capital, storage, insurance and shrinkage. The more days your stock sits unsold, in other words the higher your DIO, the more of that yearly cost actually applies to it.

Measuring this once gives you a snapshot. Measuring it continuously and acting on the trend with Optiply is what actually moves the number, instead of leaving it to a monthly spreadsheet check.

‍

What does a high or low inventory turnover ratio mean?

A high ratio generally indicates efficient inventory management and quick sales, since products are selling fast enough to replenish stock frequently. It is worth watching closely rather than treating it as an unqualified win, though. 

Pushed too far, a high ratio usually means buffers are running too thin to protect against normal demand variation, and the first symptom is more frequent stockouts on exactly the SKUs that were turning over fastest. 

An unusually high ratio can also come from a temporary stock shortage rather than genuine sales efficiency, since the ratio looks great for the wrong reason if there was barely any stock to divide into.

A low ratio creates a different set of problems:

• Excess stock ties up cash and storage space, increasing your holding costs.
• It raises the risk of obsolescence, especially for products with a limited shelf life.
• It hinders cash flow, since money stays invested in inventory that remains unsold for extended periods.
  

The goal is not to maximise the ratio in isolation. It is to raise it while availability holds steady or improves, which is the balance demand forecasting and safety stock planning are meant to strike together.

‍

What is a good inventory turnover ratio for e-commerce?

There is no single universal target. It depends heavily on category and price point, so comparing your ratio to a generic industry average is often the wrong move. The table below is not a benchmark to hit. It shows how much that "good" number swings by category, which is exactly why chasing one external figure rarely works.

A furniture retailer benchmarking itself against fashion-accessory turnover would conclude it has a serious problem when it doesn’t. Most e-commerce retailers get more signal from watching whether their own ratio has been trending down for several consecutive periods than from chasing an external number that may not fit their category at all. 

A falling ratio against your own historical baseline is usually the earlier, more reliable warning sign.

‍

How do you improve inventory turnover ratio?

Five changes move this number more than anything else, and they compound when used together rather than one at a time.

1. Forecast demand instead of ordering on gut feel

Forecast demand more accurately by analysing historical data, market trends, customer behaviour, supplier lead times and seasonal patterns, rather than repeating last year's order quantities or a purchaser's intuition.
This aligns your inventory levels with what customers actually buy, reducing the risk of both stockouts and excess stock, and it is the single biggest lever on turnover because every unit ordered above real demand sits in your denominator dragging the ratio down.

If you’re not doing this systematically yet, this guide to improve forecast accuracy covers it in more depth.

2. Use inventory management software to spot patterns you would miss by hand

Software with AI agents can analyse far more historical data than a person reasonably can by hand, spotting seasonal patterns, slow movers and demand shifts long before they show up as a problem in a monthly report. 

That kind of pattern detection is where AI-powered inventory management software earns its keep: automating routine reorder decisions, reducing manual errors, and keeping average inventory closer to what will actually sell without someone re-running the numbers every week.

Good software does not just crunch historical numbers. It keeps adjusting as customer demand shifts, supplier lead times move, and market conditions change, without someone re-running the calculation by hand. The exceptions still worth a human look get handled once and set as the new baseline, so the same adjustment does not need to be made again next month.

3. Implement just-in-time ordering

Ordering smaller quantities more frequently, timed against actual sell-through instead of large infrequent batches, keeps average inventory lower without increasing stockout risk, as long as supplier lead times are reliable enough to support it. It works best on predictable, fast-moving SKUs. On erratic or seasonal ones, a smaller buffer often just causes more frequent stockouts, not a leaner cycle.

4. Prioritise with an ABC analysis, not a one-off audit

A regular ABC analysis sorts your SKUs by how much they actually contribute, so you always know which ones are quietly dragging the ratio down. This works best as a recurring part of how you set purchasing strategy, not a quarterly project handed to a consultant. Once you know which items are dead weight, clear the dead stock you already have: discount it, bundle it, or stop reordering it deliberately, instead of carrying it by accident for another quarter. This also directly reduces the inventory holding costs tied up in that same dead stock.

5. Strengthen supplier partnerships and lead times

Collaborating closely with reliable suppliers streamlines procurement, reduces lead times, and ensures a steadier supply of inventory when you need it. A supplier that ships late or with inconsistent lead times forces you to hold more safety stock than you would otherwise need, which lowers turnover even when your forecasting and ordering logic is sound. Calculating safety stock correctly against your suppliers' real, measured lead-time performance avoids over-buffering in the first place.

Travelbags applied this same combination of tighter forecasting and closer supplier coordination. The company reached 95% availability on its A-products, up from 80%, while cutting total inventory value by 22%, a direct improvement in turnover without sacrificing what customers could actually buy.

‍

Turn this into a number you track, not one you calculate once a year

Understanding your inventory turnover ratio, calculating it correctly, and interpreting what it tells you are three separate skills, and they compound once you start acting on the trend rather than checking the number once a year.

Optiply's supply chain agent does exactly that automatically. It tracks your turnover ratio, adjusts orders as the trend moves, and turns every exception you handle once into the new baseline, so you are not re-running the calculation by hand every month.

This makes calculating and tracking the inventory turnover ratio essential for e-commerce businesses looking to optimise their inventory management practices.