How to Identify Slow-Moving Inventory and Dead Stock
By My Inventory Items · Updated
How do you identify slow-moving inventory?
Compare stock on hand with recent demand, last sale date, receipt age and expected selling season. Use an aging report to find older stock, then check demand and future commitments before marking products as slow-moving or dead stock.
Worked examples are illustrative calculations, not customer outcomes. Tools use the inputs and definitions shown on their individual pages.
Separate inventory age from lack of demand
Receipt age measures time since stock arrived. Last sale measures customer demand activity. Last movement may include transfers or adjustments, so it can make unsold stock appear active. Keep these dates separate. An old receipt is a review signal, not proof that the item cannot sell.
Build an aging report by receipt batch
Collect SKU, location, remaining quantity, unit cost, receipt date and last sale date. Group remaining receipt batches into chosen age buckets such as 0–30, 31–60, 61–90 and over 90 days. Multiply remaining quantity by unit cost for the value at risk. A single product purchase date can hide a mix of new and old batches.
Check coverage against recent demand
Illustrative example: 120 units on hand at a cost of 10 each represent 1,200 in stock value. If recent demand averages 2 units per day, coverage is 60 days. If the expected remaining selling window is 30 days, demand over that window is 60 units and 60 units need review, before allowing for commitments and uncertainty. With zero observed demand, coverage cannot be calculated as a finite number.
Use ABC analysis to set review priority
Review high-value exceptions first, but check how the groups were built. The linked ABC tool ranks annual revenue; a consumption-value classification instead ranks annual units used multiplied by unit cost. Low-revenue critical spares may still need stock because a shortage has a high operational cost.
Choose an action based on the cause
Check for duplicate SKUs, hidden locations, incorrect stock counts, seasonal timing and replacement products. Consider stopping unnecessary reorders, moving stock to a location with demand, supplier returns, bundles or markdowns. Verify margin and demand before discounting. Treat disposal and accounting write-offs as separate approved decisions.
Measure whether the action worked
Save the baseline quantity and value of reviewed stock, action date and owner. Recheck net units sold, remaining aged value and margin over a comparable period. A warehouse transfer changes location; it does not by itself reduce company-wide excess stock.
Run the calculations
Frequently asked questions
Is all stock older than 90 days dead stock?
No. Ninety days can be a useful review bucket, but seasonal goods, long-lead parts and essential spares may legitimately remain longer. Use category demand, lifecycle and future requirements to decide.
What is the difference between slow-moving and dead stock?
Slow-moving stock sells less frequently or has more coverage than intended. Dead stock has no realistic expected demand under the business’s chosen review policy. Both classifications require context beyond a receipt date.