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.
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.
In practice
Real-world examples
Example 1
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 $2,000 of cash ahead of the summer season. The owner bundles the coats with a spring jacket promotion. The cash released is used to buy lightweight summer lines that sell far faster.
Example 2
A local hardware shop uses an ageing report to identify three boxes of specialised light bulbs that have sat on the back shelf for a year, prompting the manager to return them to the supplier for credit. The credit note recovers most of the original cost and frees shelf space. The manager then lowers the minimum reorder quantity for that item.
Example 3
A mid-sized medical device distributor tracks inventory age closely because products have strict expiry dates. Any stock older than 180 days is offered to hospitals at a discount immediately. This policy keeps write-offs low and protects relationships with customers who need reliably in-date products.
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
Average Inventory Age (days) = (Total Stock Value / Cost of Goods Sold) x 365
For example, if you hold $200,000 of stock and your annual cost of goods sold is $800,000, your average age is (200,000 / 800,000) x 365 = 0.25 x 365 = 91.25 days.
Ageing report example: the $200,000 of stock is split into $90,000 aged 0 to 30 days, $60,000 aged 31 to 60 days, $30,000 aged 61 to 90 days and $20,000 aged over 90 days (90,000 + 60,000 + 30,000 + 20,000 = $200,000). The over-90-day bucket is 20,000 / 200,000 = 10% of stock value. If the business decides that half of that old stock may never sell at full price, it should write down 50% x $20,000 = $10,000.Case study
Seen in the real world
This is a fictional, illustrative scenario. Oak Furniture Limited, a growing retail business, noticed its bank account was running low despite steady sales. The operations manager reviewed the inventory ageing report and discovered that nearly 40% of its 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 30%. While it made less profit on those specific items, the sale generated $12,000 in cash. The manager used this freed-up capital to purchase popular, fast-moving bookshelves instead. Furthermore, the company updated its purchasing policy to order smaller batches of dining tables.
Within six months, its average inventory age dropped from 120 days to 45 days, significantly improving its cash flow and storage efficiency. If the company had stock worth $150,000 and cost of goods sold of $450,000 a year, this change is the gap between holding about 120 days of stock and only about 45 days. This frees roughly 75 days of purchases, or around $92,000 of cash. That is an illustrative result, but it shows why finance teams watch this report so closely.
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 specialised 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.