darikwaAged stock report
Paste your stock by SKU and location to see value by age band, months of cover at the current rate of sale, and a status for every line: healthy, watch, clear or dead stock. Download it as a board-ready Excel workbook.
- 1.How much stock value sits in each age band.
- 2.Which locations hold the oldest stock.
- 3.How many months each line would take to sell at today's rate.
- 4.Which lines are dead, which to clear and which to watch.
- 0–90 days£5,449 22%
- 91–180 days£2,757 11%
- 181–365 days£10,765 43%
- Over 365 days£5,966 24%
| # | SKU | Value at cost | Age (days) | Age band | Months of cover | Days since sale | Status | Description | Location | Units on hand | Unit cost (£) | Date received | Last sold | Units sold, last 12 months |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| £2,590 | 45 | 0–90 days | 2.7 | 1 | Healthy | |||||||||
| £1,776 | 210 | 181–365 days | 7.7 | 3 | Watch | |||||||||
| £407 | 120 | 91–180 days | 4.1 | 9 | Healthy | |||||||||
| £1,575 | 70 | 0–90 days | 4.3 | 2 | Healthy | |||||||||
| £2,478 | 400 | Over 365 days | 47.2 | 48 | Clear | |||||||||
| £1,024 | 300 | 181–365 days | 8.5 | 35 | Watch | |||||||||
| £192 | 150 | 91–180 days | 2.6 | 6 | Healthy | |||||||||
| £912 | 60 | 0–90 days | 3.3 | 1 | Healthy | |||||||||
| £720 | 520 | Over 365 days | No sales | Never | Dead stock | |||||||||
| £5,670 | 230 | 181–365 days | 9.7 | 12 | Watch | |||||||||
| £2,295 | 230 | 181–365 days | 6.4 | 4 | Watch | |||||||||
| £1,520 | 610 | Over 365 days | 240.0 | 120 | Clear | |||||||||
| £298 | 95 | 91–180 days | 2.2 | 2 | Healthy | |||||||||
| £1,860 | 160 | 91–180 days | 12.0 | 20 | Watch | |||||||||
| £372 | 25 | 0–90 days | 1.0 | 0 | Healthy | |||||||||
| £1,248 | 700 | Over 365 days | 104.0 | 400 | Clear | |||||||||
Take it into Excel
The download carries your rows and the same rules as live Excel formulas, so it keeps working as you add lines: yellow cells for your data, blue-grey cells calculated, drop-down lists, red and amber flags, frozen headers and filters. Tabs: Start here · Settings · Stock (with ageing) · Summary by band, location and status.
Your data never leaves this browser: nothing is uploaded, and the workbook is built on your device. Copy rows from Excel or Google Sheets and paste into any cell; include the header row to match columns by name.