At my dad's HVAC company, we built an asset registry three times. The first two times failed. Here's what we learned.
If you're a facility manager, service company, or property manager with equipment everywhere and no centralized record of what you have - this guide is for you. It's not about software. It's about the process of going from "we have no idea what's out there" to "we have a searchable database of every piece of equipment we maintain."
Why Asset Registries Fail
Attempt #1: The Spreadsheet That Nobody Updated
We created a beautiful Excel spreadsheet. Columns for manufacturer, model, serial number, install date, location. We sent techs out with clipboards to collect data. It took weeks. We entered everything.
Six months later, the spreadsheet was worthless. New equipment had been installed. Old equipment had been replaced. Some locations had moved. Nobody kept the spreadsheet current.
Lesson: A registry that's not updated with every service visit decays immediately.
Attempt #2: The CMMS We Couldn't Populate
We bought a CMMS. It had great asset management features. Empty fields everywhere. The system needed data we didn't have, and gathering it was a separate project nobody had time for.
The CMMS sat there, a $500/month reminder of good intentions.
Lesson: Buying a system doesn't populate it. You need a capture process.
What Finally Worked (Attempt #3)
We built the registry as a byproduct of regular work, not a separate project.
Every service call, the tech captured equipment data if it wasn't already in the system. Over 6 months, we built a complete registry without dedicated "data collection" time. The registry stayed current because updating it was part of the job, not an extra task.
The Practical Approach
Step 1: Define What You're Tracking
Start minimal. You can add fields later, but every field you add is data someone has to capture.
Essential fields:
- Asset ID (your internal identifier)
- Location (building/floor/area)
- Manufacturer
- Model number
- Serial number
- Equipment type (HVAC/electrical/plumbing/etc.)
Nice to have:
- Install date
- Capacity/tonnage
- Voltage
- Refrigerant type (for HVAC)
- Last service date
- Warranty expiration
- Photo
Skip for now:
- Detailed specifications beyond the nameplate
- Complete maintenance history
- Replacement cost estimates
You can add these later. Capture the basics first.
Step 2: Create an Asset ID System
Serial numbers aren't enough - you need your own identifier that's stable even when equipment is replaced.
Simple approach: [Building]-[System]-[Sequence]
- BLDGA-HVAC-001 = Building A, HVAC unit #1
- MAIN-ELEC-003 = Main building, electrical panel #3
Physical tags help. Stick or hang a numbered tag on each piece of equipment. When equipment is replaced, the tag stays - it identifies the location/function, not the specific unit.
Step 3: Capture Data During Regular Work
This is the key insight: don't do a separate "inventory project." Make data capture part of normal service visits.
Process:
- Tech arrives at equipment
- Scans/enters asset ID
- If equipment exists in system → data pre-fills, tech verifies
- If equipment doesn't exist → tech captures nameplate data, creates record
- Proceed with normal service/inspection
With this approach, every service call is also a data capture opportunity. After 3-6 months of normal operations, you have a complete registry.
Step 4: Make Capture Fast
If capturing data adds significant time to each service call, techs will skip it. Speed is non-negotiable.
Options:
- Camera-based AI capture: Point at nameplate, data populates (FormField does this)
- Barcode/QR scanning: Scan tag, pull existing data or create new record
- Pre-populated forms: If equipment exists, show current data for verification only
If capture takes 5+ minutes per unit, you'll get resistance. If it takes 30 seconds, compliance is easy.
Step 5: Keep It Current
The registry is only valuable if it's current. Build update triggers into workflows:
- Service visits: Verify data matches, update if needed
- New installations: Capture data as part of install completion
- Replacements: Update serial/model, keep location ID
- Annual audits: Flag units not seen in 12+ months for verification
The Technology Question
You don't need expensive software to build a registry. You need:
- A place to store data - Could be a spreadsheet, could be a CMMS, could be a forms tool
- A way to capture data efficiently - This is where AI capture helps
- A process to keep it current - This is organizational, not technical
FormField can help with #2 - camera-based capture makes building the registry faster. But the process matters more than the tool.
Common Mistakes
Trying to capture everything at once. A dedicated "inventory everything" project is exhausting and doesn't build sustainable habits. Capture during normal work instead.
Too many fields. Every field requires data capture. Start minimal, add later.
No asset ID system. Relying on serial numbers fails when equipment is replaced. Create your own stable identifiers.
No update process. A registry built once and never updated is worthless within a year.
Making capture slow. If it's painful, people won't do it. Invest in tools that make capture fast.
Realistic Timeline
For a property with 100 pieces of equipment, assuming normal service frequency:
- Month 1: Set up system, train techs, start capturing. Maybe 20% coverage.
- Month 3: 60-70% coverage. Common equipment captured.
- Month 6: 90%+ coverage. Stragglers found and captured.
- Ongoing: New equipment added as installed. Registry stays current.
This timeline assumes capture happens during regular service visits, not dedicated inventory work.
The Payoff
A complete, current asset registry enables:
- Faster service: Tech arrives knowing exactly what equipment to expect
- Better PM scheduling: Schedule by equipment type, age, or last service date
- Warranty tracking: Know what's covered before you dispatch
- Replacement planning: See equipment age distribution, plan capital
- Historical trending: Which units have the most issues?
None of this is possible without the registry. Building it is an investment that pays dividends forever.
Make capture fast with AI
FormField's camera reads nameplates automatically. Build your registry faster.