Depreciation Recalc
Independently recalculate depreciation using cost, useful life, and method.
- Ledger + fixed-asset register
- Key analysis in Fixed assets & leases
How the result is read
The arithmetic is fully checkable, so the recalculation runs on 100% of the register rather than a sample. Three things make the recalculation wrong more often than the ledger: residual value, part-year charges, and components with differing lives. A self-approved catch-up is quantified at the excess over the charge genuinely due, not at the whole entry.
The worksheet, on the demo engagement
Depreciation Recalc, as the application draws it for Harrow Precision Engineering Ltd, the fictional demo engagement — one row per asset.
- Assets recalculated
- 47
- Variances < TE
- 46
- Catch-up entries
- 1
- DEP-1231 excess
- (288)
Recalculation across 100% of the FA register (IAS 16). Depreciable amount is cost less residual, the year of acquisition and the year of disposal are pro-rated, and the building is depreciated by component — without all three the recalculation cannot agree to the ledger. Total recorded charge ties to the 1,072 in the P&L. DEP-1231 is the only exception: the misstatement is the 288 of excess over the run-rate charge properly due, not the whole 350.
Result grid6 of 10 rows
| Asset ID | Class | In-service date | Cost | Residual | Life (y) |
|---|---|---|---|---|---|
| EQ-0042 | Equipment | 2021-03-01 | 4,900 | 400 | 7 |
| EQ-0055 | Equipment | 2023-07-01 | 1,400 | 100 | 5 |
| EQ-0060 | Equipment | 2024-06-14 | 1,100 | 0 | 7 |
| EQ-0031 (disposed 2024-09-30) | Equipment | 2020-09-01 | 1,100 | 0 | 7 |
| EQ-0031 — accum. released on disposal | Equipment | ||||
| BLD-0001 — structure component | Building | 2011-01-01 | 1,600 | 0 | 40 |
In the application
Depreciation Recalc is filed under Fixed assets & leases, index letter F. "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 F, beside an index of the source files with their SHA-256 fingerprints.
Also listed in the application as Depreciation Gap
.
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