If the register and the ledger disagree, you can't trust either the depreciation charge or the balance sheet.
Reconcile the fixed asset register to the general ledger every month by asset class. Agree cost and accumulated depreciation separately, not just net book value. Build a movement schedule showing opening balance, additions, disposals, transfers, depreciation and closing balance, and agree each line to the ledger. Investigate differences such as additions posted to the ledger but not the register, or disposals not removed.
Agreeing only net book value can hide two errors that cancel out: an asset missing from the register at cost and the same amount of depreciation missing from the ledger, for example. Reconcile cost and accumulated depreciation as separate lines, for each asset class, every month.
Export the register with asset ID, class, cost, accumulated depreciation and status (active or disposed). Summarise by class with SUMIFS. With class in column B, cost in column D, accumulated depreciation in column E and status in column G:
Cost: =SUMIFS($D:$D,$B:$B,J2,$G:$G,"Active")
Depn: =SUMIFS($E:$E,$B:$B,J2,$G:$G,"Active")
with each asset class listed down column J. Keep accumulated depreciation as a positive number in the register and compare it to the credit balance in the ledger.
| Class | Register cost | Ledger cost | Difference | Register depn | Ledger depn | Difference |
|---|---|---|---|---|---|---|
| Land and buildings | ||||||
| Plant and machinery | ||||||
| Fixtures and fittings | ||||||
| Computer equipment | ||||||
| Motor vehicles |
Every difference should be zero or explained by a listed reconciling item that will be corrected.
For each class, build a roll-forward for cost and for accumulated depreciation:
Cost: opening + additions − disposals +/− transfers = closing
Depn: opening + charge for the period − depreciation on disposals +/− transfers = closing
Agree each line to its source: additions to capital expenditure postings, the depreciation charge to the depreciation expense account, and disposals to the disposal journals. The movement schedule is also what auditors ask for at year end, so building it monthly saves work later. See year-end audit preparation.
A reconciled register can still be wrong if the depreciation is wrong. Each month, do a quick reasonableness test by class: for straight-line assets, the monthly charge should be close to cost divided by useful life in months for assets not yet fully depreciated. Large swings from one month to the next should be explained by additions, disposals or assets becoming fully depreciated. See depreciation schedule in Excel.
Fully depreciated assets still in use stay on the register at cost with matching depreciation. Assets that are no longer in use, or can't be found, should be disposed of in both systems. Periodic physical verification is what catches those.
The person who maintains the register can prepare the reconciliation, but someone else should review it and sign it off. Keep the export, the summary, the movement schedule and the evidence for reconciling items together for each period.
UK teams often say "tangible fixed assets" or "property, plant and equipment"; US teams say "PP&E" or "fixed assets". Recognition and depreciation follow your accounting framework, such as IAS 16, FRS 102 or ASC 360. Tax depreciation, such as UK capital allowances or US MACRS, is calculated separately; check the current rules with HMRC or the IRS.
Reviews every balance sheet reconciliation with an on-device AI and 20 review tests, flags vague and wrong-account reconciling items, and builds a risk-ranked review queue. Runs in your browser on your own computer: nothing is uploaded.
12 questions on how strong your close controls are. 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, by asset class. Doing it only at year end means errors in additions and disposals build up and are harder to trace.
Cost and accumulated depreciation separately. Net book value alone can hide offsetting errors.
Set it up in the register with the correct in-service date and useful life, then catch up the depreciation, and find out why it was missed so it doesn't happen again.
Last updated 04 November 2026. General guidance for finance teams; check it against your own policies, systems and local rules.