What it means
For non-finance managers, understanding inventory ageing is crucial because unsold stock represents trapped cash. When goods sit on a shelf for months, they do not generate revenue.
Instead, they incur storage costs, risk becoming obsolete or damaged, and eventually require deep discounts to clear. An ageing report typically divides stock into buckets, such as zero to thirty days, thirty to sixty days, and over ninety days.
This helps you spot slow-moving items before they become a financial burden. In daily operations, tracking inventory age allows managers to make better purchasing and pricing decisions.
If you notice a particular product line consistently ending up in the ninety-plus-day bucket, you know immediately to stop reordering it. You can then run targeted promotions to clear out the older stock, recovering working capital that can be reinvested into faster-moving products.
From a financial perspective, ageing reports directly influence your balance sheet and profit calculations. Accountants look at old inventory to determine if its book value needs to be written down.
If goods are unlikely to ever sell at their original price, accounting standards require you to take a loss on them. Regularly reviewing inventory age prevents nasty surprises at the end of the financial year and keeps your business agile and profitable.
In practice
Real-world examples.
Example
An online clothing boutique runs an ageing report and discovers that fifty winter coats have been in storage for over two hundred days, tying up two thousand pounds of cash ahead of the summer season.
Example
A local hardware shop uses an ageing report to identify three boxes of specialized light bulbs that have sat on the back shelf for a year, prompting the manager to return them to the supplier for credit.
Example
A mid-sized medical device distributor tracks inventory age closely because products have strict expiration dates, ensuring that stock older than one hundred and eighty days is discounted to hospitals immediately.
Think of it
“Inventory ageing is like checking the expiration dates in your fridge. The longer food sits at the back, the higher the chance it spoils and has to be thrown away, wasting the money you spent buying it.
Formula
Calculation
Inventory Ageing Analysis = Total Stock Value divided by Cost of Goods Sold, multiplied by 365 days. For example, if you have twenty thousand pounds in stock and sell eighty thousand pounds worth of goods a year, your average age is (20,000 / 80,000) * 365 = 91.25 days.Case study
Seen in the real world.
Oak Furniture Limited, a growing retail business, noticed their bank account was running low despite steady sales. The operations manager reviewed the inventory ageing report and discovered that nearly forty percent of their wooden dining tables had been in the warehouse for over nine months. These bulky items were taking up valuable space and incurring high storage fees.
To fix the issue, Oak Furniture launched a clearance sale specifically targeting the older stock, discounting the tables by thirty percent. While they made less profit on those specific items, the sale generated twelve thousand pounds in cash. The manager used this freed-up capital to purchase popular, fast-moving bookshelves instead. Furthermore, they updated their purchasing policy to order smaller batches of dining tables. Within six months, their average inventory age dropped from one hundred and twenty days to forty-five days, significantly improving their cash flow and storage efficiency.
Watch out
Common mistakes.
- Assuming all stock holds its original value indefinitely.
- Looking only at total inventory value instead of breaking it down by age.
- Failing to take corrective action on slow-moving items before they require a complete write-off.
Questions
People also ask.
What is an acceptable inventory age?
This depends entirely on your industry. Supermarkets need a very low inventory age of days or weeks, whereas specialized machinery manufacturers might hold stock for six months or more.
How often should I review inventory ageing?
Most businesses benefit from a monthly review, though companies dealing in perishable or fast-fashion goods should check their reports on a weekly basis.
What should I do with old inventory?
You can bundle it with popular items, run targeted discounts, return it to the supplier if your contract allows, or donate it for tax write-offs if it cannot be sold.
From the founder's library
Take it further with the book.
Build your financial confidence beyond this definition. Shihan's full-length guide, Accounting Fundamentals, takes the same plain-English approach and turns it into a complete, practical playbook for non-finance managers, business owners and students - with chapter-end quiz answers and presentation slides included.
25% off with code MMHQ25, applied at checkout. Priced in USD - checkout may show the equivalent in your local currency.
View the book and save 25%Related