Fixed Asset Roll-Forward Prompt
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: [PASTE: Asset | Cost | Date placed in service | Useful life | Category — or write "none"] Disposals this period: [PASTE: Asset | NBV at disposal | Sale proceeds | Date — or write "none"] 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 it 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.
Watch out for
Risks: AI cannot verify physical existence of assets. Control: Annual physical count required; Controller approves all disposal and impairment entries.
Used by
Finance Teams