Are your asset inventories telling different stories?

This is an old problem. The U.S. Government Accountability Office (GAO) reported years ago that utility asset information came from separate departmental sources, including finance records, work-order systems, engineering drawings, and GIS, and that utility managers found it hard to settle on a standardized format for a central inventory.

Those systems can legitimately differ in detail. A financial register tracks cost and depreciation, while the CMMS tracks work history, ongoing costs, and condition. The goal isn’t to make them identical. The same physical asset should be identifiable in each system, and wherever the records differ, someone should be able to say why.

Why the lists drift apart

Part of it comes down to definitions. Finance and Operations may define an asset differently, and a capital project recorded in the financial register as one asset can appear in the CMMS as several maintainable pieces of equipment and components. That difference is fine on its own. It turns into a problem when nobody has documented how the records relate.

Age plays a role, too. Some equipment went in before the CMMS existed or before the financial register was computerized. Some new assets are installed and the new assets are entered into the CMMS and financial register, but old assets in the systems may not be properly retired.

Then there are day-to-day processes. A replacement gets entered into one system and isn't promptly retired in the other. Field changes don't consistently make it back to Finance, GIS, or CMMS administrators. Departments use different naming conventions and hierarchies; each owns its own data, and the utility ends up with multiple sources of truth.

For a finance director, that can mean a fixed-asset register that doesn't reconcile the physical assets in service. Asset managers see the other side of it, with condition and risk data that should be supporting capital planning and renewal decisions, but isn't tied to the financial records.

Not every field has to match. Book value in the financial register and work-order cost in the CMMS measure different things, though they should be reconcilable where it makes sense.

A handful of items should line up in both places.

• Asset identity, through a shared ID or a documented crosswalk
• Ownership and service status
• Location and facility
• Installation and replacement dates
• Retirement and disposal records, linked through a controlled process

A roadmap for reconciliation

We have developed a stepwise asset inventory and register reconciliation process that starts with a thorough baseline and then becomes routine upkeep. There are four steps in this process:

1. Agree on what counts as an asset. Define the utility's asset hierarchy and terminology before reconciling anything. Decide which asset classes must match one-to-one across systems and which can use parent and child or grouped relationships.

2. Connect the systems. Establish a unique enterprise asset ID or a controlled cross-reference between financial, CMMS, and GIS records. Assign an owner for each critical data field and name the system of record for that field.

3. Reconcile once, thoroughly. Complete a baseline reconciliation using financial records, the CMMS, GIS, engineering records, and field verification. Sort the differences into exception categories, such as financial-only, CMMS-only, GIS-only, duplicate, retired but still active, active but not capitalized, and hierarchy mismatch.

4. Keep it reconciled. Build asset changes into Standard Operating Procedures (SOPs) for capital project closeout, commissioning, work orders, replacements, transfers, and retirements. Then reconcile periodically, with automated or semi-automated checks where possible, and report the exceptions that remain open.

What success looks like

A reconciled inventory gives the utility one starting point for condition assessment, risk analysis, capital improvement planning, asset valuation, and long-range financial planning. Finance and asset management still keep their own systems and their own level of detail. What changes is that the relationships between those records are documented, checked, and updated on a regular schedule.

Raftelis has former utility and local government asset management and finance program practitioners that have faced and overcome these same challenges. We recommend treating asset inventories, operations and maintenance, and long-range financial planning as parts of the same practice, one aimed at minimizing the total cost of owning and operating infrastructure while delivering the desired level of service.