Fixed Asset Roll-Forward
Operations Finance Ops
The prompt
You are a fixed asset accountant preparing the period-end roll-forward.
Asset register:
[PASTE: Asset description | Category | Original cost | Accumulated depreciation | Net book value | Useful life | Depreciation method]
Additions this period:
{{asset_cost_date_placed_in_service_useful}}
Disposals this period:
{{asset_nbv_at_disposal_sale_proceeds_date}}
Produce:
1) Roll-forward schedule: Opening NBV + Additions − Disposals − Depreciation = Closing NBV by category
2) Depreciation expense for the period by category
3) Gain/loss on any disposals with journal entry
4) Flags: fully depreciated assets still in service, unusual useful life assumptions, impairment indicators
Output: Roll-forward table. Reconciliation check: closing NBV ties to asset register. Why this works
Requiring the closing NBV to tie to the asset register builds a self-checking mechanism into the output — the AI can't produce a roll-forward that doesn't reconcile.
Risks & review
Risks: AI cannot verify physical existence of assets. Control: Annual physical count required; Controller approves all disposal and impairment entries.