Asset Register Reconciliation: A Step-by-Step Method

Export the register as at a fixed date and freeze it. Reconciling against a register that continues to change during fieldwork guarantees differences nobody can explain.

Clean the obvious problems first: duplicate rows from a past migration, blank descriptions, items with no location. Every one of those resolved in advance is an exception your field team will not have to chase.

Decide in advance what constitutes a match. Tag number is the primary key. Where a tag is missing, serial number is the fallback, and where both are absent you match on description, model and location together, flagged as a weaker match.

Write the hierarchy down and apply it mechanically. Discretionary matching by whoever holds the spreadsheet is how reconciliations become unauditable.

Confirmed items are found and matched. Found-not-recorded items exist physically but are absent from the register. Recorded-not-found items are in the register with nothing located against them. Changed items are found but with a different location, custodian or condition.

Those four categories cover everything, and each has a different owner and a different remedy. Mixing them into one list of problems is what makes reconciliation feel unmanageable.

Recorded-not-found items need a search, a conversation with the last known custodian and a check of transfer and disposal records. Many resolve as items moved without paperwork, and a resolved item is far better than a written-off one.

Found-not-recorded items need a purchase trail so they can be capitalised at the right value. Where no trail exists, document the basis used. An auditor accepts a reasoned estimate with a note; they do not accept a silent addition.

Physical accuracy and accounting accuracy are separate exercises. Once the physical position is settled, agree the register totals by category to the general ledger and explain each difference in writing.

Depreciation is a frequent source of variance, especially where items were disposed of in the books but never in the register, or added mid-year with an inconsistent convention. Resolve those before closing the exercise, not during the audit.

Write-offs and additions need named approval at the right level. Assemble the count date, the exception list with resolutions, the approvals and the final reconciled register into one pack, and keep it with the year's audit file.

Then set the next count date. A reconciliation is only worth its cost when it becomes the baseline for a shorter exercise next year rather than a one-off rescue.