Free Inventory Aging Report
Find slow-moving & dead stock
Paste your product list with purchase dates to generate an instant aging report. Stock is bucketed into 0–30, 31–60, 61–90, and 90+ days to identify dead stock before it drains cash.
Format: Name, Date (YYYY-MM-DD), Quantity, Unit Cost. Unit Cost is optional.
Aging buckets:
🟢 0–30 days — fresh stock
🟡 31–60 days — monitor
🟠 61–90 days — slow moving
🔴 90+ days — dead stock risk
What Is an Inventory Aging Report?
An Inventory Aging Report is a snapshot of how long your current stock has been sitting unsold. By grouping items into age buckets — 0–30, 31–60, 61–90, and 90+ days — it gives you an immediate view of which products are moving well and which are at risk of becoming dead stock. Dead stock ties up working capital, occupies expensive warehouse space, and may eventually need to be written off. Running regular aging reports (monthly or quarterly) helps you take early action: run promotions, adjust reorder quantities, return items to suppliers, or liquidate before the problem worsens.
How to Generate an Inventory Aging Report in 2 Steps
Step 1 — Paste Your Inventory Data
Prepare a CSV list with columns: Product Name, Purchase Date (YYYY-MM-DD format), Quantity, and optionally Unit Cost. Export from your inventory system or copy from a spreadsheet. Use the Load Sample button to see the exact format.
Step 2 — Set the Report Date & Generate
Choose the 'as of' date (defaults to today) and click Generate Aging Report. Products are sorted by age and bucketed into 0–30 days (fresh), 31–60 (monitor), 61–90 (slow moving), and 90+ days (dead stock risk).
Who Uses This Inventory Aging Report Tool?
Warehouse & Store Managers
Run monthly aging reports to identify products that need promotional pushes or clearance before they become dead stock.
Finance & Procurement Teams
Quantify the value of slow-moving stock for balance sheet write-downs and provisioning decisions.
Pharmacy & Healthcare
Identify medicines approaching or past their reorder freshness window to prevent expiry waste.
E-commerce Sellers
Find ASINs or listings that have sat in FBA or 3PL warehouses too long and are incurring long-term storage fees.
Frequently Asked Questions
What is an inventory aging report?
An inventory aging report shows how long each batch of stock has been sitting unsold. It groups items into age buckets (e.g. 0–30, 31–60, 61–90, 90+ days) so you can quickly see which products are slow-moving or at risk of becoming dead stock.
What is dead stock?
Dead stock is inventory that has not sold for an extended period (typically 90+ days) and is unlikely to sell in the foreseeable future. It ties up capital, occupies storage space, and may lose value through expiry, obsolescence, or damage.
How do I use the aging report to take action?
90+ day items: consider discounting, returning to supplier, or liquidating. 61–90 day items: reduce reorder quantities and promote actively. 31–60 day items: monitor and avoid reordering until stock clears. 0–30 day items: healthy — maintain current reorder patterns.
What date format should I use?
Use YYYY-MM-DD format (e.g. 2026-03-15) for purchase dates. This is the international standard and avoids ambiguity between DD/MM/YYYY and MM/DD/YYYY regional formats.
Can I include the stock value in the report?
Yes. Add a Unit Cost column to your data. The report will calculate and display the total stock value for each item, helping you see which dead stock has the highest financial impact.
Is this inventory aging tool free?
Yes, fully free. No account or sign-up required.