An aging report shows how long your stock has been sitting and how much money is tied up in it. This free analyzer takes the items you type or paste, works out each one's age in days, groups the stock into age buckets and totals the value at cost in each bucket. It then ranks the stock worth acting on first and suggests Hold, Promote, Markdown or Clear for every item, using thresholds you can see and change.
Aged inventory costs more than the price you paid: it takes shelf space, gets handled at every count and can go out of season. The editable sample is a fictional shop's review as of October 31, 2026. Nothing you enter is uploaded, and the tool never reads your stock records.
Make an aging report in six steps
- Name the report, set the as-of date, usually the day you counted, and choose the currency for all costs.
- Choose whether to age each item from the Date received or the Date last sold. For an item that has never sold, enter the date it was received.
- Add up to 200 items, each with a name, an optional SKU, units on hand, unit cost and the date. Add the units sold in the last 90 days if you have them.
- To bring in a spreadsheet, open Import from a spreadsheet and paste cells or choose a CSV with columns such as Item, SKU, Units on hand, Unit cost, Date and Units sold. Write dates as YYYY-MM-DD, so 03/04 cannot be read the wrong way round.
- Check the age buckets, the action each one suggests and the two sell-through levels.
- Review the report, then print it or download a text or CSV copy.
Each date must be on or before the as-of date, units on hand must be above zero and a SKU can appear only once. The report check lists items with no sales figure, a last-sold date that disagrees with the sales figure and items with no cost. It never blocks printing.
How to calculate inventory age
Age in days = as-of date − date received (or date last sold)
Value at cost = units on hand × unit cost
Ages count whole calendar days, so a delivery on October 1 is 30 days old on October 31. Each item goes in the first bucket whose last day is at or above its age, and anything older than the last limit goes in the open-ended bucket. Values are rounded to the cent per item, so the bucket totals add up to the items shown. A bucket's share is its value divided by the total value.
The report shows the average age weighted by value, so the items holding the most money count the most. Age from the date received to see how long stock has been on hand. Age from the date last sold to see how long it has gone without a sale.
Inventory aging buckets and suggested actions
The default buckets are 0–30, 31–60, 61–90, 91–180 and 181+ days. Each bucket ends on the day you enter, and you can change a limit, remove a bucket or add one, up to eight. Each bucket suggests one action:
- Hold: keep the price and keep selling as normal.
- Promote: give it a better spot, a display or a bundle before cutting the price.
- Markdown: lower the price to speed up sales.
- Clear: sell at a clearance price, return it to the supplier, donate it or write it off.
Sales then adjust the suggestion. Sell-through = units sold in the last 90 days ÷ (units sold + units on hand) × 100. At or above the selling-well level, 50% by default, a suggestion moves one step gentler. Below the selling-slowly level, 10% by default, it moves one step stronger. Hold never moves and Clear is the strongest step. An item with no sales entered uses its age alone, and setting the levels to 0% and 100% turns both adjustments off.
Worked example
This inventory aging analysis uses the sample's seven items and default settings:
The stock is worth $1,595.00 at cost, with an average age of 91 days by value. The scented candle is 122 days old, so its bucket suggests Markdown, but it sold 1 of 19 units, 5.3%, so it moves to Clear. The notebook is 133 days old and sold 70 of 130 units, 53.8%, so it moves to Promote. The four items to act on hold $885.00, or 55.5% of the value, led by the summer picnic blanket at $264.00 and 194 days.
What to do with old inventory
Start with the most valuable items at the top of the ranked list. Find the stock and check its condition before you plan a sale around it, since a wrong count changes what it is worth. The dead stock review guide covers checking whether missing sales mean missing demand.
For a reduction, work out the markdown percentage and its total cost with the markdown calculator, then print the new price with the sale sign maker. Advertising a "was" price has rules. In the US, the FTC's guide on former price comparisons says the former price should be one you offered openly for a reasonably substantial period. In the UK, the CMA's guidance on unfair commercial practices covers the law on unfair trading.
Writing stock down affects your accounts. IRS Publication 538 says goods you cannot sell at normal prices because of damage, shop wear or changes of style should be valued at their bona fide selling price minus the direct cost of disposition. Rules vary by place; this page is not legal or tax advice.
To buy less of what ages, compare stock with sales in the days of supply calculator and the inventory turnover calculator. The ABC inventory analyzer shows which items carry the most annual value.
Print or download the report
Print / PDF gives the report with the bucket summary and its value bars, the ranked items to act on, every item oldest first with the reason for its suggestion, and what each action means. The text download keeps a readable copy. The CSV has one row per item, oldest first, with the age, bucket, value at cost, sell-through, the bucket's action, the suggested action and the reason, ready for a spreadsheet.
Frequently asked questions
Can I make an aging report without an account?
Yes. The analyzer runs in your browser and needs no sign-up. Your draft stays in this tab through a refresh; download or print the report to keep it.
Is this the same as a slow moving inventory report?
Close. Age each item from the date last sold and the oldest buckets list the stock that has gone longest without a sale. Add units sold for the last 90 days and the sell-through levels separate slow sellers from items that still sell.
Does it read my stock or sales records?
No. It uses only the items you type or paste. It changes no records, and nothing is uploaded or sent.