Asset Inventory: a practical guide to a project that does not end in a spreadsheet

Why inventory projects fail after they succeed

Most inventory projects end with an accurate, reconciled file being handed over. Six months later the drift is back: devices moved between offices, custody transferred to new employees, equipment sent for maintenance and never returned.

The problem is not the quality of the count. It is that the project was designed as a one-off event rather than as a system. That distinction determines whether the investment produced a lasting effect or a snapshot.

Step one: classify before you count

The common mistake is to start counting immediately. The result is a long list of free-text names in which one asset appears in three different spellings across three sites, making aggregation and comparison impossible.

Start by building a hierarchical classification tree: main class, sub-class, type, then specification. Attach to each class a useful life and depreciation rate agreed with the finance function and its external auditor. Counting then becomes the filling of defined fields rather than the writing of descriptions.

Step two: count under a documented methodology

A count the external auditor cannot re-test on a sample is not evidence. It must therefore be:

• Independent of the function that holds custody.
• Movement-controlled: asset movement is frozen during the round or documented on a movement form.
• Double-counted for high-value classes, by two teams with no sight of each other's results.
• Photographically documented for every asset, with precise location and the responsible custodian.

Step three: reconcile explicitly

Do not deliver an asset list. Deliver three lists:

1. Assets present and recorded — the healthy state.
2. Assets present but unrecorded — requiring evidence and accounting treatment.
3. Assets recorded but missing — requiring investigation and disposal evidence.

The second and third lists are the real value of the project. The first reassures; the other two repair.

Step four: tagging

Without a machine-readable number on the asset itself, every later count remains a full-cost manual exercise. Barcode or QR tagging turns the next round from a complete count into a fast scan.

Choose the label by operating environment rather than by price: polyester for offices, heat- and oil-resistant labels for plants, and engraved metal plates for heavy equipment and outdoor settings.

Step five: after handover

This is where success and failure are decided. The register stays accurate only if every asset movement is logged as it happens: location transfer, custody change, maintenance out, disposal.

That requires three simple things: a system that logs movement by scan, clear authority over who approves a movement, and a short periodic reconciliation round that surfaces drift early rather than waiting for year end.

In summary

A successful inventory project is not measured by how many assets were counted, but by the accuracy of the register one year after handover. Where classification is sound, tagging is in place and movement is logged, the next annual count takes a fraction of the effort of the first.