Inventory Summary
Inventory balances and movements by group, against the comparative period.
- General ledger alone
- Compares with last year
How the result is read
Every valuation test downstream is computed on the subledger and reported against the GL, so an unreconciled difference invalidates all of them and is a scope limitation. Growth is read against cost of sales, not revenue — inventory is carried at cost. Days of inventory comes in two non-interchangeable versions, on closing and on average.
The worksheet, on the demo engagement
Inventory Summary, as the application draws it for Harrow Precision Engineering Ltd, the fictional demo engagement — one row per inventory category.
- CY
- PY
- Total Inventory
- 7,310
- YoY Delta
- +22.2%
- Days inventory
- 67d vs 74d PY
- Total exposure
- (3,141)
Inventory overview (IAS 2). Growth is read against cost of sales, not revenue: stock rose 22.2% while cost of sales rose 35.0%, so days of inventory fell from 74 to 67 — the build is defensible, the valuation is not. Three exposures feed M-06 and are each stated once: NRV write-down (1,900), SLOB provision (610), unadjusted count variances (631), with HW-4402 carried at the higher of SLOB and NRV rather than in both.
Result grid4 rows
| Category | CY Value | PY Value | Delta % | Days stock | SLOB risk |
|---|---|---|---|---|---|
| Raw materials | 2,800 | 2,300 | +21.7% | 42 | |
| WIP — subassemblies | 1,510 | 1,180 | +28.0% | 61 | build-up, no output 60d+ |
| Finished goods — hardware | 3,000 | 2,500 | +20.0% | 45 | 840 SLOB >180d |
| Total | 7,310 | 5,980 | +22.2% | 67 | (610) SLOB provision |
In the application
Inventory Summary is filed under Inventory, index letter E. "Run all analyses" runs it with every other analysis the ledger 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