Stock Ageing

What Is Stock Ageing?

Ageing turns an inventory balance into a distribution, which is a far more useful thing to look at than a total. Grouping items by how long they have been held shows where value is accumulating without moving, and it is the standard starting point for any assessment of obsolescence, because nothing else identifies which lines are worth examining out of a catalogue that may run to thousands.

What it cannot do is establish value, and treating it as though it could is the recurring error. A high-value spare deliberately held against a long-lead-time failure may not move for years and remain worth every rupee; a fast-moving line may be about to be superseded and worth very little. Ageing also depends entirely on a date field, and those fields are unreliable in one direction: a re-receipt, an inter-location transfer, a count adjustment or a system migration can each reset the clock on stock that has not actually moved, so recently dated items are frequently the ones worth sampling.

What Stock Ageing Means at a Physical Count

The ageing report is one of the documents requested before the visit, and it shapes what the team looks at.

• Reconciling the report's total to the ledger first, since a schedule failing to agree is measuring some other set of goods entirely.
• Using it to prioritise the walk, so aged high-value items are examined physically rather than left to a sample.
• Inspecting those items for condition, since ageing identifies candidates and only the floor establishes whether goods are damaged, superseded or perfectly saleable.
• Sampling deliberately from the newest bands as well, since a movement between sites, a re-booking or a post-count correction will each refresh the date on stock nobody has touched.
• Recording what was found against each aged item, which is the evidence supporting whatever provision follows.

How Stock Ageing Works in Practice

1. A reference date is chosen and, for each item, the date taken as the start of the holding period is identified, usually whichever is later, when it came in or when it was last drawn on.

1. The elapsed period is computed and each item falls into a band, commonly running from under three months through to over a year.

1. Quantities and values are totalled by band, and the report's grand total is reconciled to the stock figure in the ledger. A report that does not tie is describing a different population.

1. Items in the older bands are examined, but so are a sample from the newest, because a transfer, re-receipt, count adjustment or migration can reset a date on stock that never moved.

1. What the analysis produces is a shortlist. Realisable value is then established for those items individually, and the provision follows from that rather than from the band.

Stock Ageing: A Worked Example

A Gurugram consumer durables distributor ages its stock by receipt date rather than by SKU.

The oldest band is the one that changes the figures. Rs 56 lakh has sat for more than a year in a category where the model year turns over, so it is unlikely to move at full price. The provision indicated is a judgement based on what comparable stock has actually realised, not a percentage applied mechanically to the band. The 181-365 band is left for individual review because it contains both slow lines and genuinely long-cycle items that are perfectly saleable. Ageing by receipt date rather than by SKU matters here: a code that is constantly replenished can look young in aggregate while specific batches inside it are old.

Common Mistakes With Stock Ageing

The analysis is reliable only if its inputs are, and they frequently are not.

• Treating the report as a statement of value, when it identifies what to examine and settles nothing about what anything is worth.
• Trusting the date field without testing it, since re-receipts, transfers between sites, adjustments after counting and system migrations all restart the clock on goods that never moved.
• Sampling the oldest bands only, when goods showing a fresh date are often exactly the ones whose clock was restarted, making them the population to sample.
• Running the analysis without reconciling its total to the ledger, so any provision computed from it is wrong in the same proportion as the report.
• Applying a single provision percentage across a band containing both a critical spare and a superseded line, which describes neither.

Related Stock Audit Terms

What aged stock is actually worth is settled by realisable value, not by its age, so net realisable value (nrv) is the entry to read next. Every other term in this cluster is listed in the stock audit terms, grouped by the part of the work it belongs to.