FA Rollforward
Build a complete bridge from prior year PP&E to current year so the closing balance is provably derived.
- General ledger alone
- Key analysis in Fixed assets & leases
What it checks
- Opening gross + additions − disposals + transfers = closing gross; transfers sum to nil across classes.
- Opening accum. depreciation + charge − depreciation on disposals = closing accum. depreciation.
- Net book value = closing gross − closing accum. depreciation.
- By asset class, tangible and intangible rolled separately.
How the result is read
The cost bridge alone does not prove net book value — it needs the parallel accumulated-depreciation bridge beside it, or the depreciation charge is never tied to the balance sheet. Transfers are the trap: recorded as an addition in one class and a disposal in another, both bridges still tie while additions, the source of CapEx, are overstated.
The worksheet, on the demo engagement
FA Rollforward, as the application draws it for Harrow Precision Engineering Ltd, the fictional demo engagement — one row per asset class.
- Opening
- Closing
- Closing gross PP&E
- 27,100
- Net Book Value
- 18,900
- CAPEX spend (additions)
- 2,800
- CAPEX / Depn ratio
- 2.61
FA rollforward (IAS 16). Transfers sit in their own column and net to nil across classes, so the AUC brought into service never inflates additions — additions are what CapEx is derived from, and the 2,800 here is the same figure the cash-flow statement uses. The accumulated-depreciation bridge runs alongside the cost bridge, which is what makes net book value provable rather than asserted.
Result grid6 of 12 rows
| Asset class | Opening gross | Additions | Disposals | Transfers | Closing gross |
|---|---|---|---|---|---|
| Equipment (1700) | 12,500 | +2,800 | (1,100) | +500 | 14,700 |
| Buildings (1710) | 9,800 | — | — | — | 9,800 |
| Land (1720) | 3,100 | — | — | — | 3,100 |
| Assets under construction | 500 | — | — | (500) | — |
| Total tangible PP&E | 25,900 | +2,800 | (1,100) | 0 | 27,600 |
In the application
FA Rollforward is filed under Fixed assets & leases, index letter F. "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 F, 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