Most register errors enter the books on day one, as an addition nobody looked at closely.
A fixed asset additions review checks every item capitalised in the month before the register is closed. Confirm each addition meets the capitalisation policy, is supported by an invoice and approval, is in the right asset class with the right useful life, has the correct in-use date for depreciation, excludes recoverable VAT or sales tax, and that total register additions agree to the ledger additions.
Export two lists for the month:
The two totals must agree, by asset class. With the register additions in a table named Register and the ledger additions in a table named Ledger, each with a Class column:
=SUMIFS(Register[Cost],Register[Class],A2)-SUMIFS(Ledger[Amount],Ledger[Class],A2)
listing each class down column A. Any non-zero result is an item in one list but not the other. See fixed asset reconciliation to the ledger.
Errors go both ways. Run a list of expense postings above the capitalisation threshold to repairs, IT, equipment hire and similar accounts. Each is a possible missed asset. A simple filter on the expense ledger:
=FILTER(Expenses,Expenses[Amount]>=Threshold,"None")
where Threshold is a named cell holding your capitalisation amount. FILTER needs Excel 365 or Excel 2021; in older versions use an AutoFilter instead.
Record the review on the additions list itself: a column for each test, the reviewer's initials and the date. A reviewer independent of the person who posted the additions should sign it off before the register is closed for the month. Keep the evidence with the month-end file; auditors usually sample additions.
In the UK, recoverable input VAT is excluded from cost and irrecoverable VAT is included; in the US, sales tax paid on an asset is usually part of its cost because it is not recovered. Tax capital allowance or tax depreciation claims are separate from the book register, so check current HMRC or IRS rules for how each addition is treated for tax.
Straight-line vs reducing balance depreciation year by year, with net book value and the journal entry. Free to use online.
The Fixed Assets & Depreciation System calculates straight-line and reducing-balance depreciation, stops depreciation at the disposal date with the profit or loss calculated, and ties a full movement schedule back to the register. Excel, no macros, one-time price.
Every month, before the register is closed. Leaving it to year end makes the review larger and the evidence harder to find.
Someone independent of the person who posted them, usually the financial controller or a senior accountant.
A repair restores an asset to its original condition and is expensed. An improvement extends its life, increases its capacity or adds a new part, and is capitalised.
Last updated 08 November 2026. General guidance for finance teams; check it against your own policies, systems and local rules.