Inventory aging report: how to build one and what to do with it

An inventory aging report shows how long your stock has been on the shelf, in dollars. Finance uses it to set a reserve for old stock, lenders ask for it before lending against inventory, and operations use it to decide what to sell down. This guide shows how to build one from data you already have.

What the report looks like

Stock at cost is grouped into age bands. The bands below are common, and many reports split the first one into 0–30, 31–60 and 61–90 days.

Age bandWhat it usually meansTypical action
0–90 daysCurrent stockNone
91–180 daysSlowCheck the reorder settings and stop buying more
181–365 daysAgedPromote, bundle, move or return it
Over 365 daysAt risk of being obsoleteSell it down or write it down

How to work out the age

Most systems do not record when each unit arrived. The standard method assumes first in, first out (FIFO): the oldest stock is sold or used first, so what is left is the most recent stock you received.

  1. Take the quantity on hand for the item.
  2. List its receipts, newest first.
  3. Match the stock to the receipts from the newest back, until the quantity on hand is used up.
  4. Age each layer: the days from its receipt date to today.
  5. Value each layer at the unit cost and put it in its band.

A worked example

An item costs $10 and has 100 on hand. Its last three receipts:

ReceivedUnits receivedCounted as on handValue
10 days ago6060$600
70 days ago3030$300
287 days ago50010$100

So $600 is in the 0–30 day band, $300 in 61–90 and $100 in 181–365. The average age, weighted by value, is about 56 days: (600 × 10 + 300 × 70 + 100 × 287) ÷ 1,000.

When the receipts do not add up

Sometimes an item has more on hand than its receipts on file explain. The rest must have arrived before your receipt history begins, so it is at least that old. Age it from the first receipt date in your data and mark it “at least”. An item with no receipt on file at all has no known age: show it separately instead of guessing. Items you make in-house need production receipts, not purchase receipts.

From aging to a reserve

A reserve, also called an excess and obsolete (E&O) reserve, is an allowance for stock that may not sell at full value. A common method takes a percentage of each band:

Reserve = sum of ( value in band × reserve % for that band )

For example 10% of stock 91–180 days old, 25% of 181–365 days and 50% beyond a year. The percentages are a policy, not a formula: base them on how your old stock has actually sold, and agree them with your accountant. Try your numbers in the free inventory reserve calculator.

What to do with the report

  • Start with the largest dollars in the oldest band, not the longest list.
  • Ask why it is there: a forecast that did not happen, a minimum order far above need, a customer who left, an engineering change.
  • Fix the cause. Old stock that is still being reordered will be back next year. See how to find dead stock.
  • Decide item by item: discount, bundle, return to the supplier, use as a substitute, sell to a liquidator, or scrap.
  • Run it every month. The trend matters more than one report. Read it beside your inventory turnover.

Spreadsheet or software?

Matching stock to receipts by hand is slow beyond a few hundred items. Inventory aging report software builds the report from your item list and receipts, and recalculates the reserve as you change the percentages.

See an aging report on sample data

The live demo needs no account. Use the sample company or load your own files, which stay in your browser tab.

Frequently asked questions

What is an inventory aging report?

A report that groups the stock on hand, at cost, by how long it has been in stock, usually in bands of days.

How do you calculate inventory age?

Assume first in, first out: match the quantity on hand to the most recent receipts, then count the days from each receipt date to today.

What is the difference between aged inventory and dead stock?

Aged inventory is old but may still sell. Dead stock has had no sales or use for a long period, often 6 to 12 months. An aging report shows how old the stock is; sales history shows whether it still moves.

Try the Statadventure live tools

Inventory tools for US manufacturers: reorder point, safety stock, EOQ and landed cost, with the inputs and assumptions shown.

Open the live tools

Contact us

Scroll to Top