5 Warning Signs in Your Inventory Turnover Ratio

Inventory turnover is cost of goods sold divided by average inventory, and it goes wrong as a management signal in five specific ways. Turnover can improve because a seller stopped buying. A healthy blended figure can hide a long tail of stock that has not moved in a year. The ratio can be computed on retail value instead of cost. It can exclude units in transit or held in reserve. And it can rise while stockouts rise with it, which is the version that costs the most money.

Each of these produces a number that looks fine on a dashboard and points in the wrong direction.

1. Turnover improved because purchasing stopped

Turnover has two inputs, and only one of them is sales. A seller who pauses purchasing for a quarter watches average inventory fall while cost of goods sold continues at its usual rate. Turnover climbs. Nothing improved.

This happens most often during a cash squeeze, which is exactly when a seller is most likely to misread it as progress. The tell is that turnover rose while units sold stayed flat or fell.

Reading turnover alongside units sold and ending inventory, rather than on its own, makes the difference visible. If the ratio improves while units sold declines, the business is shrinking, not tightening.

2. A blended figure covering dead stock

A business wide turnover of 5.8 sounds respectable. Break it out by SKU and the usual finding is that a handful of products turn 14 times a year while thirty percent of the catalog turns less than once.

The fast movers carry the average. The slow tail sits in a warehouse accruing storage costs, tying up cash, and slowly becoming unsellable. Nothing in the blended number says so.

Turnover is only useful at SKU level, or at minimum by product family. Once computed that way, the distribution runs wider than the owner expected, and the action is obvious: the bottom decile needs a decision, whether that is markdown, bundling, liquidation, or disposal. Storage costs compound on that tail. Amazon’s published seller pricing sets out its fulfillment and storage charges, which continue accruing on units regardless of whether they are selling, and aging stock carries additional surcharges under the current fee schedule.

3. Computed on retail value instead of cost

The ratio requires both terms in the same units. Cost of goods sold is at cost, so average inventory has to be at cost too.

Using retail or list value for inventory inflates the denominator and understates turnover, sometimes by a factor of three. Sellers who pull the inventory figure from a marketplace dashboard, where values are often shown at selling price, get this wrong without noticing, then compare their understated ratio against industry benchmarks computed at cost and conclude something is wrong with their business.

The related error is using ending inventory instead of average inventory. For a seasonal business, ending inventory in January and ending inventory in October describe different companies. Average of opening and closing is the minimum acceptable approach; a monthly average is better.

4. In transit and reserved units left out

Inventory a seller owns is not only what sits in a fulfillment center. There is stock on the water, stock at a prep center, stock in a third party warehouse, and units already sold but not yet shipped or reconciled.

Excluding in transit inventory understates the denominator and flatters turnover. It also understates the cash committed to inventory, which is the number that matters for purchasing decisions. A seller with $180,000 of stock on hand and $140,000 on the water who plans from the first figure is planning with less than half the picture.

Ownership, not location, determines inclusion. If title has passed, the units are on the balance sheet and belong in the calculation.

5. Turnover rising alongside stockouts

High turnover is not the goal. Profitable sell-through with acceptable availability is the goal, and past a certain point those two diverge sharply.

A seller pushing turnover from 6 to 9 by holding less stock will start missing sales during demand spikes, losing rank on the channels where availability drives placement, and paying expedited freight to recover. The revenue cost of those stockouts rarely appears anywhere near the turnover metric, so the ratio keeps improving while the business gets worse.

Pairing turnover with in-stock rate and with lost sales estimates, even rough ones, restores the tension between the two. The right turnover figure for a business depends on lead time, demand variability, and gross margin, which means a benchmark borrowed from another seller’s catalog is close to meaningless.

A worked example

A seller with $2.4 million of annual cost of goods sold and average inventory at cost of $410,000 has turnover of 5.85, or about 62 days of inventory. Reasonable at first glance.

Split by SKU:

• Top 12 SKUs: $1.9 million of COGS on $185,000 average inventory, turnover 10.3, 35 days
• Middle 40 SKUs: $480,000 on $145,000, turnover 3.3, 110 days
• Bottom 60 SKUs: $20,000 on $80,000, turnover 0.25, over three years of cover

That bottom band is $80,000 of cash sitting still, accruing storage, and heading toward write-down. The blended 5.85 said nothing about it. This is the pattern behind inventory that has quietly stopped moving while the summary metrics stay respectable, and it is why the SKU level view is the only version of this ratio worth computing.

Getting the inputs right

Turnover at SKU level requires landed cost per unit, an inventory valuation that ties to the balance sheet, and cost of goods sold recognized when units sell rather than when suppliers are paid. Those three are what most sellers actually lack, and the ratio cannot be repaired without them.

The inventory method underneath is a method of accounting question. IRS Publication 538 notes that a small business taxpayer may account for inventory by treating it as non-incidental materials and supplies or by conforming to its treatment in an applicable financial statement, and that the method chosen must clearly reflect income. Whichever applies, it has to be applied consistently for period comparisons to mean anything.

What to do with the number

Compute turnover by SKU quarterly, at cost, including in transit units, and read it next to units sold and in-stock rate. Then act on the tail rather than the average. Most sellers who do this once find between five and fifteen percent of inventory value in products that should have been cleared a year earlier, and clearing it funds the next purchase order without new financing.

The Small Business Administration’s guidance on managing business finances covers the cash flow framing this sits inside. Inventory is where a product business keeps most of its working capital, and turnover is the one ratio that shows whether that capital is working.