The question that saves half the work
Before adding anything, ask yourself: will I make decisions about this piece of equipment on its own?
If the answer is no, it does not need its own record. The 340 light fixtures in a building are not 340 assets. They are one, “second floor lighting,” or they are not there at all. An inventory with 12,000 records, of which 800 are actually managed, is an inventory nobody maintains.
Start small. It is easier to add later than to clean up a bloated inventory.
What goes on a record, in order of importance
- Code and identification. Without this, there is nothing.
- Exact location: site, floor and room. It is the first thing the technician needs.
- Family or type. It lets you group, compare and apply task lists.
- Customer who owns it, if you service third-party equipment.
- Technical data: make, model, serial number, installation date and warranty.
- Criticality.
The first four are essential. The rest can be filled in as you go. A photo of the nameplate, taken while walking past, covers item 5 in two seconds.
Coding: one afternoon that saves years
A convention like CUSTOMER-BUILDING-TYPE-NUMBER:
CUS-BLD3-HVAC-014 ELV-TWR2-LIFT-007 FRG-PLT1-CMP-002
The technician knows where the asset is without opening anything. The list sorts itself by customer and building, and you can search by segments.
Rules: fixed length, no special characters, no spaces, and never reuse the code of a retired asset.
How to build it in practice
What usually does not work: sending someone to walk every site for three weeks with a tablet. It gets tedious, it gets dropped and it stays half done.
What works:
- Start with what you already have: an imperfect spreadsheet, the contract list, the installation invoices. Import it even if it is messy.
- Clean up duplicates and retired assets during the import. This is where the surprises show up: the same asset under two names, and equipment that was removed years ago.
- Fill in the gaps as you go. Every time a technician visits an asset, they complete what is missing. Within a few months the inventory is up to date without full days spent on it.
- Put QR labels on the equipment you touch often. You do not need to label everything on day one.
The three mistakes that kill it
1. Not retiring assets. Ghost equipment generates impossible preventive work and drags compliance down. Retiring is not deleting: it means marking the asset as retired and keeping its history.
2. Creating duplicates. Two records for the same asset split its history in two, and neither is useful. Searching before creating has to be a habit. And search must find assets by partial code and by name.
3. Asking for fields nobody fills in. If you have defined 40 fields and 6 get filled in, remove the other 34. A long form is the most reliable way to make sure no record gets created.
How to tell it is alive
- Last month’s work orders point to records that exist, not to “miscellaneous” or “other.”
- New equipment is added the week it is installed.
- This year’s retirements are marked as retired, with their history.
A living inventory with 800 assets is worth more than a complete, dead one with 12,000. What keeps it alive is not discipline: it is making updates easier than skipping them.
Last updated: