How to see stock ageing and dead stock
The Stock ageing report shows how long your goods have been in the warehouse, how much money is tied up and what sells while out of stock.
This report helps you decide what to clear, what to stop buying and what to restock.
Where it is
Go to Reports › Reports and open the Stock ageing tab.
What it shows
- Stock value at average cost, like the inventory valuation.
- Stock age by bracket (0–30, 31–90, 91–180, 181–365 and over 365 days). Age comes from stock-ins: what remains is what came in last (FIFO); lots count from their receipt date.
- Status filters: Dead stock (not sold in the number of days you choose; 180 by default), Never sold and Over a year of sales (stock covering more than a year at the current rate).
- For each product: on hand, value, last sale, last purchase, sales per day and coverage. Daily sales count receipts, deliveries and recipe consumption minus returns over the last 90 days.
- Selling but out of stock: products with no stock that sold recently, a possible lost sale estimated in units.
You can filter by warehouse, category or supplier, sort by value, age or coverage, and Export CSV.
Keep in mind
- To see the tab you need the profit reports permission or the inventory valuation permission.
- SKUs without cost count as 0 € and those with negative stock are left out of the list (the report tells you how many).
- Stock older than the recorded movements is dated with the product's creation.
- It is a cost and units report; it is not money collected.