Inventory Aging Report
From data to decisions
Analyze remaining quantities per receipt batch, not the latest receipt date for the entire SKU. Use unit cost rather than selling price. This is inventory aging, not an expiry report.
How to use
- Identify the branch, reporting date and the currency used in your records.
- Add one row per product batch, then reconcile total value to your inventory ledger.
- Review results, record an action, owner and due date, then export the report.
Autosaved in this browser only; no account synchronization. Keep a CSV copy.
Formulas and worked example
Age = reporting date − receipt date in days. Value = quantity × unit cost. In the example at 15 October 2026, values are 500, 400, 300 and 200, totaling 1,400; over-90-day stock is 200, or 14.29% of total.
How to act on the report
Prioritize older, higher-value batches: verify stock and demand, review replenishment, then coordinate transfers, returns or promotions under company policy. Age alone does not mean stock is damaged. Review expiry and storage separately, and follow up weekly.