Treating the report as a valuation
Age says where to look, not what anything is worth.
Stock audit glossary · Valuation
noun · also “inventory ageing” or an aged stock analysis
Stock ageing groups inventory by how long each item has been held, counted from the date it was received or last moved. It shows where value is sitting still. It tells you which items to examine; it does not by itself decide what they are worth, which is settled item by item.
Meaning
An ageing report turns one stock total into bands by age, which is far more useful. It is the usual starting point for finding slow-moving or obsolete stock, because it picks out the lines worth checking from a list that may run to thousands. Lenders read it too: under their own policy and sanction letter, many banks leave obsolete, expired or slow-moving stock out of drawing power, using age cut-offs.
Two cautions apply. Age is not value: a costly spare kept for a rare breakdown may not move for years and still be worth its full cost, while a fast-moving line may be about to be replaced. And the date can mislead: a transfer between sites, a re-receipt, a count adjustment or a system change can reset the date on stock that never moved.
On the day
A shortlist for the walk, tested on the floor.
In practice
And for each item, the start of its holding period.
Days held, placed in bands such as up to three months, three to six, six to twelve, and over a year.
By quantity and value, and agree the grand total with the stock ledger.
And a sample from the newest band, for reset dates.
Use the result as a shortlist; each listed line is assessed on its own.
Worked example
Sample figures.
| Age band | Value (Rs) | Next step |
|---|---|---|
| Up to three months | 4,20,00,000 | Sample a few lines for reset dates |
| Three to six months | 1,40,00,000 | No action |
| Six to twelve months | 84,00,000 | Review each line |
| Over a year | 56,00,000 | Inspect and value each line |
In a category where models change every year, stock over a year old is unlikely to sell at full price. How much to write down is decided from what similar stock has actually sold for, not from a fixed percentage per band.
The bands also tell a lender how much of its security is ageing. Here ₹1,40,00,000, a fifth of the stock, is more than six months old.
Watch out
The report is easy to produce and easy to over-read.
Age says where to look, not what anything is worth.
Transfers and adjustments reset dates on stock that never moved.
Old stock with a reset date sits in the newest band.
The report may describe a different set of goods from the ledger.
A band can mix a critical spare with an outdated line.
Regular restocking makes a code look new while older batches stay inside it.
Patron Accounting LLP. The bank-practice statement on this page signed off by CA Sundram Gupta: 23 October 2026
Sources: general stock-control and audit practice; the lender point is bank practice set by each bank’s policy and sanction letter, not an RBI rule. General information, not professional advice; read your own sanction letter before acting.
Need help with stock ageing? See our stock audit service. A stock audit uses the ageing report to plan the walk.