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 IDClassIn-service dateCostResidualLife (y)
EQ-0042Equipment2021-03-014,9004007
EQ-0055Equipment2023-07-011,4001005
EQ-0060Equipment2024-06-141,10007
EQ-0031 (disposed 2024-09-30)Equipment2020-09-011,10007
EQ-0031 — accum. released on disposalEquipment
BLD-0001 — structure componentBuilding2011-01-011,600040

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.

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

Cookie settings

This site sets no cookies. It keeps one preference in your browser's localStorage — the currency you chose on the pricing pages — and its analytics are cookieless, so there is nothing to opt in or out of.

View Cookie Policy