Slow-Moving (SLOB)
Test for slow-moving and obsolete inventory based on movement history, not price.
- Ledger + 2 client documents
- Key analysis in Inventory
What it checks
- Bands by days since last issue: 0-90 · 91-180 · 181-365 · over 365.
- A nil / watch / 50% / 100% matrix is a policy assumption tested against realisation history, not evidence.
- The band is an assignment, not a conclusion — overrides run in both directions, each with a reason.
- An item also carrying an NRV write-down takes the higher of the two, never the sum.
How the result is read
Implied provision against recorded provision; nil provision on a year-plus stagnant population is a strong understatement indicator. Last issue date starts the assessment and does not finish it — a firm order, a recent receipt, an expiry date or an alternative use moves an item out of its band either way. The rates are a policy proxy tested against what the entity actually realised.
The worksheet, on the demo engagement
Slow-Moving (SLOB), as the application draws it for Harrow Precision Engineering Ltd, the fictional demo engagement — one row per SKU.
- SLOB >180d
- 840
- SLOB >365d
- 380
- Provision recorded
- 0
- Implied provision
- (610)
SLOB matrix (IAS 2.28): 50% provision 181-365 days, 100% beyond, aged from the period-end date rather than today. Values are in thousands, the same scale as the statements, so the exposure carried to the misstatement schedule is the figure shown. Management recorded nil. HW-4402 is both aged and priced below cost — it is provided for once, at the higher of the two, and sits under NRV rather than here.
Result grid6 of 7 rows
| SKU | Description | Qty on hand | Unit cost | Value | Days since last issue |
|---|---|---|---|---|---|
| HW-4310 | Legacy PCIe card v1.0 | 4,000 | 53.75 | 215 | 412 |
| FG-1205 | Legacy unit (discontinued) | 2,200 | 75.00 | 165 | 389 |
| HW-4408 | Power supply 40W (superseded) | 5,000 | 22.00 | 110 | 198 |
| RM-0055 | Wire harness (old spec) | 100,000 | 3.50 | 350 | 187 |
| HW-4301 | Connector RJ45 bulk | 2,400,000 | 0.80 | 1,920 | 62 |
| Total SLOB >180d | 840 |
In the application
Slow-Moving (SLOB) is filed under Inventory, index letter E. "Run all analyses" runs it with every other analysis the ledger and the documents loaded can answer. The worksheet states the population it tested on its face — or "Not applicable" with the reason when a column it depends on is empty — and the Excel workbook the engagement exports files it under E, beside an index of the source files with their SHA-256 fingerprints.
Read it with
Run your next audit file test without the Excel crash.
One free engagement to evaluate, valid 60 days. The ledger never leaves the machine.
- 20 minutes
- Runs on a fictional engagement
- No client data required