Talk to an expert

Tell us what you need and we will call you back.

🇮🇳 +91

    Stock audit glossary · Valuation

    Stock Ageing

    noun · also “inventory ageing” or an aged stock analysis

    Definition

    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.

    • Reviewed by CA Puja Pradhan · Chartered Accountant
    • Last reviewed 23 October 2026
    • 6 min read

    See related terms

    At a glance

    Groups stock by
    Time held In age bands
    Counted from
    Later of receipt and last issue Up to a reference date
    Typical bands
    0-3, 3-6, 6-12, 12+ months Set by the business
    Is not
    A valuation It is a shortlist
    Lenders
    May exclude old stock From drawing power

    Meaning

    01 What stock ageing is

    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

    02 What stock ageing means at a physical count

    A shortlist for the walk, tested on the floor.

    How the report is used at the count

    • Agree it to the ledger first. If the totals differ, the report describes a different set of goods.
    • Plan the walk with it. Old, high-value lines are inspected in person.
    • Sample the newest bands too. In case their dates were reset by a transfer or adjustment.

    What the report cannot tell you

    • What the goods are worth. Only the floor shows whether they are damaged, outdated or perfectly saleable.
    • Whether a date is genuine. A reset date looks exactly like a real receipt.
    • Why the stock is old. A slow season, an over-order and a dead product look the same in the report.
    The report says where to look; the count says what is there. What was found against each old line is recorded as evidence for any write-down.

    In practice

    03 How stock ageing works in practice

    Reference dateStart dateAge
    Input Where it comes from Sample
    Reference date The date the report is run to 31 March
    Start date The later of receipt and last issue 14 August
    Age Placed in the six-to-twelve-month band 229 days

    14 August to 31 March is 229 days, about seven and a half months. Sample dates for illustration only.

    Five steps, in order

    1. Pick a reference date

      And for each item, the start of its holding period.

    2. Work out the age

      Days held, placed in bands such as up to three months, three to six, six to twelve, and over a year.

    3. Total each band

      By quantity and value, and agree the grand total with the stock ledger.

    4. Examine the old bands

      And a sample from the newest band, for reset dates.

    5. Value item by item

      Use the result as a shortlist; each listed line is assessed on its own.

    Worked example

    04 A distributor’s stock in four bands

    Sample figures.

    A consumer durables distributor ages its stock by batch receipt date; the total agrees to the ledger at ₹7,00,00,000
    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

    The oldest band matters most

    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

    05 Common mistakes with stock ageing

    The report is easy to produce and easy to over-read.

    Treating the report as a valuation

    Age says where to look, not what anything is worth.

    Value each old line against what it will fetch.

    Trusting the date field

    Transfers and adjustments reset dates on stock that never moved.

    Test a sample of dates against movement records.

    Sampling only the oldest bands

    Old stock with a reset date sits in the newest band.

    Sample the newest band as well.

    Not agreeing the total

    The report may describe a different set of goods from the ledger.

    Agree the grand total before using it.

    One percentage per band

    A band can mix a critical spare with an outdated line.

    Decide each line on its own evidence.

    Ageing by item code

    Regular restocking makes a code look new while older batches stay inside it.

    Age stock by batch or receipt where the system allows.
    CA Puja Pradhan

    Reviewed by CA Puja Pradhan · Chartered Accountant

    Patron Accounting LLP. The bank-practice statement on this page signed off by CA Sundram Gupta: 23 October 2026

    Last reviewed: 23 October 2026 Applies to: businesses that hold stock, and borrowers whose drawing power rests on it

    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.

    Talk to an expert

    Tell us what you need and the right person calls you back.

    🇮🇳 +91

      By sending this form you agree to our privacy policy.