Inventory aging
Inventory aging report software
See how long your stock has been on the shelf, in dollars, and what a reserve for old stock comes to. The Statadventure Optimization Lab builds the aging report from your item list and your receipts, first in, first out.
What an aging report does for you
Old stock is cash that stopped moving. Your accountant wants to know how much of it to reserve, your lender wants an aging report before it lends against inventory, and you want to know what to sell down before it is worth less. An ERP can tell you what is on hand, but many small systems cannot say how long it has been there. The Inventory aging page works it out from the receipts you already have.
What the Inventory aging page shows
- Stock at cost in six age bands: 0–30, 31–60, 61–90, 91–180, 181–365 and over 365 days, with the units, value and number of items in each.
- Average age, weighted by value.
- What is older than 180 days and older than a year, in dollars and as a share of stock.
- A reserve at the percentage you set for each band.
- Every item, oldest value first, with its average age, its oldest stock and its value in each band.
- Stock with no receipt on file, shown on its own, so an unknown age is never passed off as a known one.
- A download of the whole report as a CSV file.
How age is worked out
The page assumes first in, first out: what is on the shelf is the most recent stock you received. Each item’s quantity on hand is matched to its receipts from the newest back. Take an item with 100 on hand:
| Received | Units received | Counted as on hand | Age today |
|---|---|---|---|
| 10 days ago | 60 | 60 | 10 days |
| 70 days ago | 30 | 30 | 70 days |
| 287 days ago | 500 | 10 | 287 days |
So 60 units sit in the 0–30 day band, 30 in 61–90 and 10 in 181–365. If the receipts on file do not add up to the stock on hand, the rest arrived before your first receipt on file. The page ages it from that day and marks it “at least”. Read our guide to the inventory aging report.
The reserve percentages to start from
| Age of stock | Reserve |
|---|---|
| 0–90 days | 0% |
| 91–180 days | 10% |
| 181–365 days | 25% |
| Over 365 days | 50% |
These are a starting point, and every number can be changed. A reserve policy is a decision for you and your accountant: the Lab only does the arithmetic. Try the free inventory reserve calculator.
How it works
- Load your item list with stock on hand and unit cost.
- Load your receipts: PO history with received dates and quantities, or a receipts file. A receipt in both is counted once.
- Set your reserve percentage for each age band.
- Download the report for your month-end close, your auditor or your lender.
What it is not. It is not accounting advice, and it does not post a reserve to your books. Items you make rather than buy have no purchase receipts: load their production receipts in the receipts file, or they are shown with an age that is not known. Stock in all locations is pooled.
Which plans include it
Inventory aging is in every plan, Basic included, from $297 a month. See plans and pricing.
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 by how long it has been in stock, usually in bands such as 0–30, 31–60 and 61–90 days, with the value in each band.
How is the age of inventory calculated?
Under first in, first out, the stock on hand is taken to be the most recent stock received. The age of each unit is the number of days since the receipt it came from.
What is an inventory reserve?
An accounting allowance for stock that may not sell at full value. A common method takes a percentage of the value in each age band, rising with age.
What reserve percentages should we use?
That is a policy for you and your accountant, based on how your old stock has actually sold. The Lab starts at 0% up to 90 days, 10% to 180 days, 25% to a year and 50% beyond, and you can change every number.
What data do I need?
An item list with stock on hand and unit cost, and receipts with dates and quantities, from PO history or a receipts file.