Moving a facility operation from spreadsheets to CAFM software means migrating five things: the asset register and location hierarchy, PPM plans, open corrective work, the evidence that currently lives in chat groups, and the monthly KPI report. CAFMPRO does this in the Prepare and Configure steps of its delivery path, with a rehearsal before go-live and, where the register is untrustworthy, an on-site tagging and verification survey first.
Why spreadsheets win on day one and lose in month six
A spreadsheet register is free, familiar and immediate. It loses when the second person edits it, when a technician's photo lives in a chat thread instead of against the asset, when the PPM plan and the corrective log disagree about the same pump, and when the client asks why the 2.9% deduction was applied and the answer is spread across four files and a phone.
The failure is not the spreadsheet. It is that identity is lost between steps: the asset in the register, the asset in the work order and the asset in the invoice are three different rows.
What moves, in order
- Location hierarchy — site, building, floor, room. Module 01 codes the estate tree so every later record inherits a place.
- Asset register — codes, classification, attributes, documents. Duplicates and ghost assets are resolved here; if the register is not trustworthy, CAFMPRO Field Services tags and verifies it on site first.
- PPM plans — periodic and meter-triggered tasks moved into module 04 so work generates against the asset.
- Open corrective work — current faults with priority, SLA and owner, so day one has a live queue, not an empty one.
- Evidence — from this point photos, readings, materials and approvals attach to the work order, and the chat groups become optional.
- KPI reporting — contract rules, bands and caps configured in module 06 so the monthly report is generated, not assembled.
What changes for each role
| Role | Before | After |
|---|---|---|
| Technician | Photo in WhatsApp, verbal close-out | Task, reading, photo and time on the mobile work order — in Arabic |
| Supervisor | Chasing status by phone | Live queue by priority and SLA, approved hold time recorded |
| Store keeper | Parts issued on paper | Issue and consumption against the work order |
| Contract manager | Monthly report assembled from files | Finalized KPI period with the evidence behind each deduction |
| Client finance | Deduction disputes by email | Contractor payable amount traceable to the operational records, ready for review and approval |
What stops
- Rebuilding the KPI report every month from separate files.
- Asking a technician which pump a photo belongs to.
- Two versions of the asset register.
- Deductions explained from memory.
The register, the work and the invoice become one thread. That is what "every facility decision, one auditable thread" means in practice.
How the migration is run
Migration is scoped in the delivery path — Discover, Prepare, Configure, Rehearse, Support — and depends on the size and quality of the existing register. The rehearsal step is not optional: supervisors run real work orders on the migrated data before go-live, so the first live day is the second time the team has done it.
Module 01 — Properties and LocationsModule 08 — Warehouse and InventoryAsset tagging and verification
Questions teams ask before leaving spreadsheets
Can we import our Excel asset register into CAFMPRO?
Yes, in the Prepare step. Codes, classification, attributes and locations are mapped, duplicates and ghost assets resolved. If the register is unreliable, an on-site tagging and verification survey produces an upload-ready register first.
Do technicians need to stop using WhatsApp?
No one is forced to. Once photos, readings and approvals attach to the mobile work order, the chat groups simply stop being the record.
How long does migration take?
It is scoped in the delivery path and depends on register size and quality; the rehearsal step happens before go-live in every case.
Can we keep our current KPI report format?
Contract rules, bands and caps are configured in the Contracts and KPI module, and the report is generated from the finalized period rather than assembled by hand.
What if our asset register is wrong?
CAFMPRO Field Services tags assets with an agreed identification method such as QR or RFID, verifies them on site, reconciles the register and hands over an upload-ready result with an exception list.
Bring one spreadsheet to the demo.
We map it live: locations, assets, plans, open work. You see your own data in the platform before any decision.