Warehouse Operations

Obsolete Inventory: How to Spot It, Clear It and Prevent It

Obsolete inventory ties up cash and space while slowly losing value. Finding it early is the difference between a discount and a write-off.

Obsolete inventory is inventory that has stopped selling and shows no sign of starting again. It sits in prime racking, ties up cash you have already spent, and quietly loses value every month nobody touches it.

The cost is easy to underestimate because it never appears as a single line on a report. It shows up as space you cannot use, counting time you cannot avoid, and eventually a write-off that surprises everyone.

Spotting it early is what separates a modest discount from a total loss. Below is how to find obsolete inventory, clear it sensibly, and stop the same pattern repeating.

Diagram showing how to identify obsolete inventory, clear it through discount or liquidation and prevent it recurring
Flag, confirm, clear, write off, then fix the rule that created the obsolete inventory.

What counts as obsolete inventory

Most operations define it by time without movement. A common rule treats anything with no sales for twelve months as dead. Anything untouched for six months counts as slow moving.

Pick a definition that suits your products and then apply it consistently. A seasonal garment and an industrial spare part need different thresholds. One blanket rule across a mixed catalogue will mislabel both.

Why obsolete inventory builds up

Over-ordering to reach a volume discount is the most common cause. The unit price falls, the total cash committed rises, and the surplus never sells through at the rate the discount assumed.

Product changes create another wave. A supplier updates a model, or a regulation shifts. The previous version then becomes much harder to move.

Forecast drift does the rest. Demand softens gradually, nobody revisits the reorder quantity, and replenishment keeps firing at a level the market no longer supports.

Finding obsolete inventory in your data

Run a report showing last sale date and quantity on hand for every item. Sort by the oldest last-sale date, then multiply the remaining quantity by unit cost to see the money involved.

That second step matters. A hundred dead items worth a few cents each is a tidying job. Three dead pallets of a high-value component is a serious cash problem.

Confirming an item is genuinely dead

Check before you act. An item may show no movement for innocent reasons. Perhaps you hold it as a spare, perhaps it sold under a different code, or perhaps a stock error hid it from pickers.

Seasonality deserves particular care. Judging a winter line in July will always make it look dead. Compare against the same period last year instead.

Clearing obsolete inventory without wrecking margin

Work through the options in order of value recovered. Bundling slow items with popular ones usually recovers the most, because the customer sees added value rather than a discount.

Straight discounting comes next, and it works best in steps rather than one deep cut. After that, consider liquidators, trade channels or returning goods to the supplier if your terms allow it.

Donation is worth considering before disposal. It may carry a tax benefit, and it avoids the cost of scrapping.

Knowing when to write it off

Holding obsolete inventory carries a real annual cost. Most estimates put it at twenty to thirty per cent of value, once you count space, handling, insurance and tied-up capital.

So keeping something for three years in the hope of full price often costs more than selling it today at half. Run that comparison honestly, because the sunk cost makes people hold far longer than the maths supports.

Stopping obsolete inventory from returning

Clearing the current pile achieves nothing if the buying rule stays the same. Review the order quantities and reorder points on every item you just cleared, because those settings created the problem.

Add an early warning. A monthly report of items with no movement in ninety days catches problems while discounting still works. That is long before the twelve-month threshold bites.

Tighten purchasing on new lines too. Buy a small first quantity and reorder quickly. That beats a large volume discount on a product with no sales history.

How obsolete inventory fits your wider numbers

Dead items drag down your inventory turnover ratio and distort category averages. Exclude them before drawing conclusions. Ranking items with an ABC analysis shows quickly where the trapped cash sits.

Accuracy underpins the whole exercise. An item can look dead simply because the records are wrong, and regular cycle counting rules that out. Most inventory management systems can produce an aged stock report automatically. For external benchmarks, the US Census Bureau publishes inventory to sales ratios by sector, and ASCM maintains the standard planning definitions.

Frequently asked questions about obsolete inventory

How long before stock counts as dead?

Twelve months with no movement is the usual threshold, with six months marking slow movers. Adjust both figures to match your product life cycles rather than adopting them blindly.

Is it better to discount or write off?

Discount first, in stages, because any recovery beats none. Write off once the carrying cost over a realistic holding period exceeds what you could still recover.

Can obsolete inventory ever be worth keeping?

Yes. Critical spares and service parts for equipment still in the field often sit unused for years by design, so exclude them from your reports rather than clearing them.

The practical takeaway

Run an aged stock report monthly and value the result in cash rather than units. Confirm an item is genuinely dead before acting. Clear it in stages, write it off once carrying cost overtakes recovery, and always fix the order quantity that created it.