Movement & Dead Stock Analyzer
For stores and distributors whose history is spread over several yearly Excel exports. The analyzer works out the last qualifying movement of every item and places it in one band: Active, Slow-moving, 1–2, 2–3, 3–5 or 5+ years without qualifying movement — or Uncertain when the records cannot support a band.
What you need
- One .xlsx workbook or a CSV file, up to 50 MB and 300,000 rows; sheets can have different column orders and wording.
- Per row: item code, date, movement type (or Qty in / Qty out columns), quantity. Location, reference, unit cost and status help.
- Or monthly consumption: one row per item code, one column per month (any year layout), current stock if you have it. Total rows are left out; missing months are never counted as zero.
- Optional stock-on-hand lists give current stock, value and a reconciliation check.
What counts as movement
You confirm how every movement wording in your file is classified. The default rule:
| Movement | Counts? | Why |
|---|---|---|
| Issue, sale, consumption | Yes | Stock used or sold |
| Receipt from supplier or production | Yes (default) | New stock is not called dead just because it has not been issued yet |
| Transfer between your own locations | No | Moving stock is not using it |
| Return, write-off, scrap | No | Not demand |
| Adjustment, count correction | Never | Administrative, not physical movement |
| Opening balance | Never | A checkpoint, used to reconcile |
| Reversal / cancelled row | Never | Paired with the row it cancels; both ignored |
You can switch to “issues only” or “any physical movement”. Results never say “confirmed”: they say “no qualifying movement found in the available records”, with an evidence level.
What you get
Charts can be switched off, and a light style that prints better can be chosen before you download.
- Dashboard: counts and value by band, reliability panel, “investigate first” list, searchable item table.
- Excel report: Dashboard with key figures and charts, Summary, Dead Stock Analysis (with Decision / Reviewed by / Notes columns), Movement History, Data Quality, Method.
- Error report: every row not used, with sheet, row and reason.
Beta limits
- Tested on synthetic data; please check results against your own knowledge of the stock.
- Items are analysed across all locations together.
- .xlsx or CSV (save .xls as .xlsx first). Your settings are not saved between visits.
- Works best in a current Chrome or Edge on a computer; phones work for viewing results.
Free to use, no account needed
Open the tool and try it with invented sample files first. Your files are read in your browser and are not uploaded. The tool is in beta and has been checked on synthetic data: compare its results with what you know. Privacy