How to identify dead stock and read an inventory ageing report
Who it is forGrocery chain category management, buying, finance
Dead stock sits on the balance sheet as an asset and behaves as an expense. The insidious part is that it never surfaces on its own: inventory turnover is an average and the fast movers hide the slow ones. Dead stock only appears when you look at the distribution. This guide covers how to build an ageing report, what dead stock really costs and how the clearance routes compare.
How to define dead stock
There is no single definition of dead stock; the business has to write its own threshold. Without one, everyone has a different number in mind and the subject is reopened at every meeting.
There are two approaches. The movement-based definition is simple: stock that has not sold during a defined period is dead. The rate-based definition is more accurate: stock that will take longer than a defined period to clear at its current rate of sale is dead. The second does not wrongly condemn items that sell slowly but steadily.
In practice both are used, with an intermediate "slow stock" category defined between them. Slow stock is not dead yet but will be if nothing is done, and the real gain comes from intervening at that stage.
| Class | Movement basis | Rate basis | Intervention |
|---|---|---|---|
| Healthy | Movement in the last 90 days | Cover under 120 days | None |
| Slow | 90-180 days without movement | Cover 120-365 days | Review price and display |
| Dead | 180+ days without movement | Cover over 365 days | Start a planned clearance |
| Obsolete | 365+ days without movement | Rate of sale zero | Bulk exit, donation or disposal |
Seasonal products must be kept outside these thresholds. Barbecue charcoal not moving in November is not dead stock but a normal seasonal cycle. For seasonal lines the clock resets at the start of the period.
How to build an inventory ageing report
An ageing report splits stock into age bands by receipt date and shows each band's share, in both units and value. It carries far more information than inventory turnover alone.
The only technical requirement is that stock movements are tracked by batch. In a system using weighted average cost, stock pools into a single bucket and when each item arrived is lost; in that case age is calculated on a FIFO assumption.
The report is read in two breakdowns. The category breakdown shows which category is ageing; the supplier breakdown shows which buying decision the problem came from. The second is usually more actionable.
- Fix the age bands0-30, 31-90, 91-180, 181-365 and 365+ days. Bands can vary by category; fresh works in days, ambient and non-food in weeks.
- Calculate each band's share of valueThe unit share misleads: cheap products take up a lot of units and little value. Decisions are made on value share.
- Add category and supplier breakdownsAgeing is rarely random; it usually concentrates in a particular category or in a particular supplier's products.
- Track the trendA single monthly snapshot is not enough. If the 180+ band's share is rising month on month the problem is growing; if it is flat it is being managed.
- Set a threshold alertWhen the value share of stock over 180 days passes 15 per cent, an alert is raised and lands on the category manager as a task.
The real cost of dead stock
The cost of dead stock is not limited to the fact that it did not sell. There are four separate items, and together they reach a large share of the goods' own value each year: 43 per cent for the example business in the inventory carrying cost rate calculator.
The first is the cost of capital: that money could have been working elsewhere. The second is the cost of space: it occupies a place in the warehouse or on the shelf that could have gone to something that sells. The third is value erosion: every month, the price at which the goods could be sold falls. The fourth is management load: it is counted, moved, insured and reported.
The practical conclusion is this: waiting for a better price almost never works. Selling at 40 per cent off today beats selling at 60 per cent off six months from now.
Clearance routes and the order to try them
Once dead stock is identified the question becomes how to clear it. The routes are ranked from highest to lowest recovery and each is tried before moving to the next.
The logic of the ordering is that the route doing least damage to the brand and returning most cash is tried first. But each step needs a time limit; persisting with a route that is not working is the most expensive mistake available.
| Route | Typical recovery | Duration | Brand impact |
|---|---|---|---|
| Inter-store transfer | 100% (full price) | 1-2 weeks | None |
| Bundle / cross-sell | 70% - 85% | 2-4 weeks | Low |
| Staged markdown | 50% - 70% | 4-8 weeks | Low |
| Clearance corner / bargain aisle | 35% - 50% | 4-8 weeks | Medium |
| Bulk sale to a wholesaler | 20% - 35% | 1-2 weeks | High |
| Donation | Tax relief | 1-2 weeks | Positive |
| Disposal | 0 | 1 week | None |
When making a bulk sale, be certain the goods will not reappear in your own channel. Seeing your own private label product on another shelf at a quarter of its price costs far more than the dead stock did.
Preventing recurrence
Dead stock is an outcome; the cause sits in the buying decision. Clear it without fixing the cause and the same stock rebuilds within a year.
There are three common causes. The first is over-assortment: as the catalogue grows, sales per product fall and the tail never turns. The second is being drawn in by volume discounts: the extra goods bought to lower the unit cost repay the discount several times over in carrying cost. The third is new product decisions never being tested against historical data.
The durable fix is to add two checks to the buying process: write an expected days-of-cover figure for every new product, and calculate the carrying cost for every volume discount decision. Both are one-line calculations and both change most buying decisions.
- Products with no sales in the last twelve months should not exceed 10 per cent of the catalogue
- A volume discount is not taken unless it exceeds the annual carrying cost of the excess goods
- Every new product order should carry a written expected days-of-cover figure
- Stock left over after a holiday or a weekly specials run should be an input to the next buying budget
Frequently asked questions
- What is dead stock?
- Stock that has not moved for a defined period, or that will not clear in a reasonable time at its current rate of sale. Typical thresholds are 180 days without movement or more than 365 days of cover. Seasonal products are assessed outside these thresholds.
- What is an inventory ageing report?
- A report that splits stock into age bands by receipt date and shows each band's share of total value. Typical bands are 0-30, 31-90, 91-180, 181-365 and 365+ days. It exposes the distribution that inventory turnover conceals.
- What is an acceptable level of dead stock?
- There is no universal threshold; it is set from the business's own ageing history. In industry practice the aim is to keep stock over 180 days below 15 per cent of value; above that, average metrics such as inventory turnover start to mislead. For weekly specials, stock left over after the promotion is a separate measure.
- How should dead stock be cleared?
- The routes run from highest to lowest recovery: inter-store transfer, bundling, staged markdown, clearance corner, bulk sale to a wholesaler, donation and disposal. Each step needs a time limit; persisting with a route that is not working is the most expensive mistake.
- Is it worth holding dead stock for a better price?
- Usually not. The cost of holding for a year — capital, space, value erosion and management load — reaches a large share of the goods' value, and more so in Türkiye, where the cost of capital is high. The decision is a simple comparison: today's discounted value against next year's expected value less the carrying cost and the risk of not selling at all; for products with an expiry date or weekly specials the answer usually favours discounting today.