Skip to content

Working Capital · Inventory Health

Dead Stock & Slow-Moving Inventory: Find It and Free Your Cash

Every unit sitting untouched on a shelf is cash you can't spend. Here's how to define, detect and clear dead stock and slow-moving inventory — and free the working capital trapped inside it.

Ask any operator where their money is, and they'll point to the bank. But for most product businesses, a surprising share of it is stacked in a back room, a cold store or a forgotten bin — bought once, counted every quarter, and never sold. That is dead stock and slow-moving inventory, and it quietly drains the working capital you need to grow. The good news: it is one of the most measurable, fixable problems in your entire operation.

Dead vs. slow-moving vs. excess: get the definitions right

These three terms get used interchangeably, but they call for different actions, so it pays to separate them clearly.

The distinction matters because the remedy differs: excess stock needs demand-matched selling, slow-movers need a nudge, and dead stock needs clearance or a write-off.

Why it hurts more than it looks

A dusty carton feels harmless. The costs are anything but.

Dead stock isn't a storage problem — it's a cash problem wearing a storage costume. The fastest balance-sheet win most businesses ignore is the inventory they already own.

How to detect it: three lenses

You can't clear what you can't see. Three simple, complementary measures surface the problem.

1. Days-since-last-movement

For every item, record the date of its last real movement — a sale, transfer, or consumption (not a stock count). The number of days since that date is your single most powerful early-warning signal. Sort your catalogue by it, descending, and the worst offenders float straight to the top.

2. Inventory turnover ratio

Turnover tells you how many times you sell through your average stock in a period. The formula is simple:

Inventory turnover = COGS ÷ Average inventory value

If your annual cost of goods sold (COGS) is ₹1.2 crore and your average inventory value is ₹20 lakh, turnover is 6 — you cycle your stock six times a year, or roughly every 61 days. Run the same calculation per category or per item, and low-turnover lines expose themselves. A related view, days inventory outstanding (365 ÷ turnover), converts the ratio into an intuitive "how many days of stock am I holding" figure.

3. Aging report

An aging report buckets stock value by how long it has been sitting, so you can see the shape of the problem — and its rupee weight — at a glance.

Inventory aging and turnover example by item
SKU · ItemDays since last movementOn-hand valueItem turnoverStatus
INV-002 · Onions2₹24,00032.0Healthy
INV-118 · Basmati 25kg41₹1,80,0008.4Healthy
INV-207 · Branded gift box112₹96,0001.9Slow-moving
INV-233 · Seasonal syrup156₹42,0001.2Slow-moving
INV-051 · Old-label sauce214₹1,35,0000.4Dead stock
INV-089 · Discontinued mug301₹58,0000.0Dead / obsolete

In this small sample, ₹2.51 lakh sits in slow-moving and dead lines — nearly half of it in just two obsolete SKUs. That's the cash you're going after.

Setting sensible thresholds

Thresholds turn raw data into decisions. A widely used starting point:

Tune these to your industry. A cloud kitchen might flag dead stock at just 30 days because ingredients perish; an industrial spare-parts distributor may reasonably use 365 days because low-frequency, high-value parts are the whole business model. The exact number matters less than having one, measuring against it consistently, and reviewing it on a fixed cadence.

See it in your own stock

Find your dead stock in minutes, not spreadsheets

BPIN flags slow-moving and dead SKUs automatically with live aging and turnover — so you know exactly what to clear.

Strategies to clear what you've already got

Once flagged, dead and slow-moving stock needs a deliberate exit plan. Work down this ladder from best cash recovery to last resort:

Prevention: stop dead stock at the source

Clearing dead stock is treatment; the real win is prevention. Three disciplines keep it from forming again.

None of this requires a data team. It requires an inventory system that timestamps every movement, values stock in real time, and computes aging and turnover for you — so the dead-stock report is a click, not a weekend of VLOOKUPs.

Frequently asked questions

What is the difference between dead stock and slow-moving inventory?

Slow-moving inventory still sells, just slowly — typically stock with no movement for 90 to 180 days. Dead stock has had no movement for longer than about 180 days and is unlikely to ever sell at full price. Both trap working capital, but dead stock usually needs active clearance or a write-off, while slow-movers can often be revived with better placement, bundling or discounting.

How do I calculate inventory turnover?

Inventory turnover = cost of goods sold (COGS) ÷ average inventory value for the same period. If your COGS for the year is ₹1.2 crore and your average inventory value is ₹20 lakh, turnover is 6 — you cycle through your stock six times a year. A low turnover ratio on a specific item or category is an early warning of slow-moving or dead stock.

What threshold defines dead stock?

A common rule is that stock with no sales, transfers or consumption for more than 180 days is dead, 90 to 180 days is slow-moving, and under 90 days is healthy. Thresholds should be tuned to your industry — a perishable kitchen might flag dead stock at 30 days, while a spare-parts distributor may use 365 days. The key is to set a threshold, measure days-since-last-movement per item, and review it regularly.

Free your working capital

Turn trapped stock back into cash

BPIN surfaces dead and slow-moving SKUs, live aging and turnover, and automated reorder points — so you buy smarter and clear faster.