Template · Stock and products · Opening soon
Inventory aging report from your stock on hand
Split every product's stock by how long it has sat since it arrived, 0-30, 31-60, 61-90 and over 90 days, in value or units. Refreshed from your stock system.
You bring
Stock on hand31 rows
ProductReceived dateUnits on hand
Mammoth does the work
You get
One table10 rows
Each product's stock split by how long ago it arrived: 0-30, 31-60, 61-90 and over 90 days.
Product0-30 days31-60 days61-90 daysOver 90 daysTotalUnitsOldest (days)
- Not a spreadsheet to fill inIt is a ready-made workflow in Mammoth. You bring the files, and it does the work.
- Your files, as they areUpload a file or connect a source. Your column names do not have to match.
- Runs again by itselfWhen new data arrives, every step runs again and the result updates.
What you get back
The real result of this template, run on sample data.
Inventory aging: the resultSample data10 rows
12,392 in total3,110 over 90 days
| Product | 0-30 days | 31-60 days | 61-90 days | Over 90 days | Total | Units | Oldest (days) |
|---|---|---|---|---|---|---|---|
| SKU-1009 | 430 | 1,268.50 | 774 | 0 | 2,472.50 | 115 | 73 |
| SKU-1010 | 855 | 0 | 0 | 1,353.75 | 2,208.75 | 93 | 400 |
| SKU-1008 | 288.75 | 0 | 0 | 1,212.75 | 1,501.50 | 78 | 323 |
| SKU-1006 | 649 | 0 | 840.75 | 0 | 1,489.75 | 101 | 84 |
| SKU-1007 | 884 | 0 | 0 | 493 | 1,377 | 81 | 184 |
| SKU-1004 | 225.50 | 779 | 0 | 0 | 1,004.50 | 98 | 51 |
| SKU-1005 | 362.50 | 400 | 0 | 50 | 812.50 | 65 | 99 |
| SKU-1002 | 235.75 | 471.50 | 0 | 0 | 707.25 | 123 | 35 |
What is an inventory aging report?
An inventory aging report groups stock on hand by how long ago it was received, so slow-moving and dead stock shows up before it has to be written down.
How it works
How to use the inventory aging template
- 1Bring your dataConnect a source, or upload a file.
- 2Check the columnsMammoth matches each column the template needs and asks only when it is unsure.
- 3Choose where it goesA table, a sheet, or a dashboard. It rebuilds on every refresh.
See the exact columns and steps ›
What it needs
Stock on hand by lot: product, date received, units (and value)
Stock on hand
- Product
- Received date
- Units on hand
- Stock value(optional)
The steps it runs
- 1Match columns
- 2Days in stock
- 3Total by product and age
Every step is an ordinary Mammoth step you can open and change.
Inventory aging: questions
Can I change the buckets?
Yes. Type the days that end each bucket, for example 60, 120, 180.
Does it update by itself?
Yes. The template becomes an ordinary workflow in Mammoth. When your data refreshes, from a connector, a scheduled pull or a new file, every step runs again and the result table updates.
Can I change the steps?
Every step is an ordinary Mammoth step you can open and edit. Mammoth remembers which steps came from the template, so an update never overwrites your changes.
Do my column names have to match?
No. You point the template at your columns once. Mammoth suggests a match for each one and asks only when it is unsure.
Get early access to this template
Bring your data, check the columns, and the result rebuilds on every refresh.
More stock and product templates
Find the few products that make most of your sales, what sells together, and the stock that sits too long.
- Pareto (ABC) analysisEvery item ranked by its total, with its share, the running share and an A, B or C classSee the template
- Market basket analysisEvery pair of products bought together, with support, confidence and liftSee the template
- Inventory turnover and days on handEach product's turnover and days of stock on hand, month by monthSee the template
- Sell-through rateEach product's units received, units sold, what is left and its sell-through rateSee the template