Reflexion CAFM logo
How-To Guide

How to Build an Asset Register That Survives an Audit

By Lattice Software Solutions10 min read

Most facility management findings that surface in an audit trace back to the same document: the asset register. This is a practical guide to asset register facility management, written for UAE FM managers and property owners. The register is not an inventory kept for its own sake. It is the list your PPM schedules are generated from, your contracts are priced against and your compliance is evidenced by. If a fire pump is missing from it, that pump is never serviced on paper, whatever happens in the plant room.

Key takeaways

  • Asset data is the schedule. PPM work orders are generated from the register, so every gap or duplicate becomes a missed or phantom job.
  • Build the location hierarchy before you count anything. Site, building, floor, room, then asset. Without it, nothing can be found or verified.
  • Keep the asset ID permanent and meaningless. Location belongs in the hierarchy, not baked into the tag number.
  • Criticality is the field most often skipped. It drives response priority, PPM frequency and the order auditors look at things.
  • Clean the spreadsheet before migrating it. A CAFM loaded with bad legacy data produces bad schedules faster.

Why asset data is the schedule

In a CAFM system, maintenance regimes are attached to asset types. A chilled water pump carries a quarterly inspection and an annual service; a fire alarm panel carries its own testing regime. When an asset is added to the register and classified, the system generates its planned preventive maintenance visits automatically. Each visit becomes a work order with a checklist, a trade and a due date.

Asset recordedType classifiedRegime attachedPPM generatedWork order issuedEvidence filed

That chain means register errors do not stay in the register:

  • A missing asset produces no PPM at all. Nobody notices until it fails or an inspector asks for its records.
  • A duplicate asset produces two sets of jobs. One gets closed without a visit, which is worse than a missed job because the record now says the work was done.
  • A misclassified asset gets the wrong regime: a sprinkler pump set up as a general water pump misses its fire-system testing.
  • A decommissioned asset left active keeps generating jobs, and technicians learn to close them without looking.

The same logic applies commercially. Hard FM contracts are typically priced against the register and the PPM schedule that follows from it (see hard and soft FM). An inaccurate register means the owner is paying for the wrong scope, and the provider is delivering it.

Build the hierarchy first

Before anyone walks a plant room with a tag printer, agree the location hierarchy. Every asset sits at the bottom of a tree, and every level of that tree has a defined code:

SiteBuildingFloorRoom or spaceAsset

Rooms should include the spaces people forget: risers, roof plant areas, basement pump rooms, ceiling voids and external areas such as the car park or the landscaped podium. If an asset physically sits somewhere, that somewhere needs a code.

Alongside the location tree, most registers also group assets into systems: the chilled water system, the fire alarm system, the domestic water system. A pump belongs to a floor and room by location, and to a system by function. You need both views. Location tells a technician where to go; the system tells a planner what else is affected when it fails, and it is how many compliance regimes are organised.

Decide the depth once

Decide where the register stops. A common rule is to register anything that has its own maintenance task, its own failure consequence or its own compliance record. A fan coil unit qualifies; its filter does not, because the filter is a task on the unit. Write the rule down, because every survey team will otherwise draw the line in a different place.

A naming and coding convention that lasts

The most common coding mistake is embedding the location into the asset ID. It reads well on day one and breaks the first time a unit is moved, swapped or relocated during a fit-out. The more durable approach separates three things:

  • A permanent asset ID printed on the tag. It never changes and is never reused, even after disposal.
  • A location code held in the hierarchy, which changes when the asset moves.
  • A display name built from the two, for humans reading reports.
SegmentExampleRule
SiteDXB01Emirate or city prefix plus a two-digit sequence. Assigned centrally, never reused.
BuildingT1Short and unique within the site: T for tower, V for villa cluster, P for podium.
FloorL03, B1, RFFixed format: L plus two digits, B for basements, RF for roof, GF for ground.
Room or spaceR012, RSR-EUse the architectural room number where one exists; add codes for risers and plant areas.
Asset typeAHU, CHWP, FAPA controlled list of type codes, agreed before the survey starts. No free text.
Permanent asset ID000482Sequential or system-generated, printed on the tag, independent of location.
Display nameDXB01-T1-L03-R012 AHU-02Generated by the system from location plus type and sequence. Never typed by hand.
Illustrative convention. The codes are examples; what matters is that each segment has one owner, one format and a controlled list.

The asset type list deserves the most care. It is what regimes attach to, so it should be fine enough to separate assets with different maintenance needs (a sprinkler pump from a booster pump) and coarse enough that surveyors can choose correctly on site. If you use a published library such as SFG20 for maintenance schedules, align your type codes to its asset classifications from the start.

The fields every asset record needs

A register with sixty columns that are half empty is weaker than one with twenty columns that are complete. Split fields into those required at go-live and those that can be enriched over time, and do not load an asset until its mandatory fields are filled.

FieldWhy it mattersAt go-live
Asset ID and tag numberThe permanent key every job, inspection and cost is recorded againstMandatory
Location (full hierarchy)Lets a technician find it and an auditor verify itMandatory
Asset type and systemDecides which maintenance regime and compliance rules applyMandatory
Criticality ratingSets response priority and justifies PPM frequencyMandatory
StatusActive, standby, out of service or decommissioned; controls whether jobs are generatedMandatory
Manufacturer, model, serialNeeded for spares, warranty claims and recall checksMandatory where readable
Installation dateBasis for remaining life and replacement planningMandatory, or flagged as estimated
Warranty expiry and supplierStops you paying for work the installer still owesMandatory for newer assets
Maintaining contractorShows who is responsible, especially for specialist and statutory systemsMandatory for outsourced assets
Capacity or ratingKilowatts, tonnage, flow rate, load; used for energy and replacement sizingEnrich over time
Condition scoreSupports capital planning and reserve fund workEnrich over time
Linked documentsO&M manuals, certificates, test reports and photographsEnrich over time
A practical minimum. Add fields your contracts or compliance regime require, but keep the mandatory set short enough that surveyors actually complete it.

Where the fixed asset register fits

Finance keeps its own fixed asset register of capitalised items, with cost, depreciation and net book value. The maintenance register is broader: it includes low-value items finance never capitalised, and it describes assets at the level they are maintained rather than the level they were purchased. Under IFRS, which UAE companies generally report under, IAS 16 expects significant components with different useful lives to be depreciated separately, which pushes the two registers closer together. The practical rule for fixed asset register facility management is to share IDs where the registers overlap, so that a replacement or disposal recorded by the FM team reaches finance too.

Ranking asset criticality

Asset criticality answers one question: what happens if this fails? Score each asset type against four factors and take the highest result, not the average. A pump that is cheap to replace but feeds the sprinkler system is critical, whatever its cost.

  • Life safety and statutory exposure. Does failure put people at risk or breach a legal obligation?
  • Operational impact. Does it stop the building, a tenant's business or a clinical, food or data service?
  • Redundancy. Is there a duty and standby arrangement, or is this a single point of failure?
  • Cost and lead time. How expensive and how slow is repair or replacement, including imported parts?
RatingDefinitionTypical examplesTreatment
A: CriticalFailure endangers life, breaches a statutory requirement or stops the whole buildingFire pumps, fire alarm panels, sprinkler systems, lifts, generators serving life safety loadsHighest response priority; full PPM regime with no deferral; statutory records kept
B: HighFailure stops a significant service or tenant operation, with no immediate backupChillers, main LV panels, BMS controllers, kitchen extract in F&B, medical gas plantFast response; full PPM; critical spares considered
C: MediumFailure causes discomfort or local disruption; a workaround or standby existsStandby pumps, fan coil units, AHUs serving single floors, domestic water heatersStandard response; PPM at recommended frequency
D: LowFailure is an inconvenience with little cost or riskLocal extract fans, non-essential lighting, small appliancesRun to failure or minimal inspection; repair on demand
Illustrative four-level matrix. The examples show typical ratings; the right rating for a specific asset depends on its role and redundancy in that building.

Rate by asset type first, then adjust individual assets where their role differs. A chiller in a hospital or a data hall is not the same as a chiller in a car showroom. Sector context matters here, which is why hospitals and hotels typically carry more A and B assets than an office tower of the same size. SFG20 applies its own colour-coded criticality to maintenance tasks; that is complementary, not a substitute, because it rates the task rather than the consequence of the asset failing in your building.

A QR and barcode tagging strategy

Asset tagging is what turns a register into something a technician can verify in front of the equipment. For fixed building plant, QR codes are usually the default: cheap, readable by a phone camera from any angle and tolerant of some damage. RFID and NFC are better suited to assets that move and need counting in bulk. Whatever you choose, decide these points before printing:

  • Encode only the ID. The tag points to the record; it should not carry data that goes out of date.
  • Specify the material for the environment. Rooftop plant in UAE summer heat and direct sun needs UV and heat resistant labels, or engraved or metal tags. Paper labels fade.
  • Fix a placement rule. Same position on every asset of a type, visible without removing panels, and reachable without a ladder where possible.
  • Tag the location too. A tag on the plant room door lets a technician confirm they are in the right space and see every asset in it.
  • Make scanning part of the job. If the mobile app asks for a scan to open or close a PPM visit, every visit becomes a small verification of the register.

Cleaning legacy data before a CAFM migration

Most registers start life as a spreadsheet inherited from the contractor, the developer's handover pack or a previous system. Importing it as-is is the fastest way to make a new CAFM look broken, because the system will faithfully generate schedules from every error. Clean it first, in this order:

  • Standardise locations. Map every free-text location ("Roof", "roof top", "RF plant") to one code in the agreed hierarchy.
  • Map asset types to the controlled list. Anything that cannot be mapped goes on an exceptions list for survey, not into an "Other" category.
  • Remove duplicates. Match on serial number, then on type plus location. Duplicates are common where assets were listed once by the MEP contractor and again by the FM provider.
  • Separate assets from tasks and spares. Filters, belts and consumables often sit in legacy registers as if they were assets.
  • Flag, do not invent. Where an installation date or serial number is unknown, mark it as unknown or estimated. A plausible guess is harder to catch later than an honest blank.
  • Verify on site. Walk down the critical assets at minimum before go-live, confirming each exists, is where the register says and carries a tag.

If you are choosing the system at the same time, ask each vendor how they handle import validation and exceptions; it is one of the practical tests in our guide to the best CAFM software in the UAE.

Migrating an asset register into a new CAFM?

Bring a sample of your current spreadsheet. We will show how it maps to a site, building, floor and room hierarchy, which records would fail validation, and how PPM schedules would generate from the result.

What auditors and inspectors actually check

Different reviewers come with different questions, but they share a method: pick a sample from the register and ask for the evidence behind it, or pick an asset in the building and look for it in the register. A register survives an audit when both directions work.

ReviewerWhat they are looking forWhat the register must show
Civil Defence inspectionFire and life safety systems maintained under the UAE Fire and Life Safety Code of Practice, by an approved contractor, with current recordsEvery fire and life safety asset listed, its maintaining contractor, and dated test and service records linked to it
Insurer or risk surveyorThat high-value and high-hazard plant is maintained and that risks are understoodCriticality, maintenance history and inspection records for major plant such as lifts, generators and pressure systems
Owner's technical auditWhether the FM provider is delivering the contracted scopeRegister reconciled to the contract scope, PPM compliance by asset, and completed work orders with evidence
Service charge and reserve fund reviewThat common-area costs and replacement forecasts are based on real assetsCommon-area assets with installation dates, condition and remaining life, split by building or community
Financial auditThat capitalised assets exist and disposals were recordedIDs shared with the fixed asset register and a record of replacements and disposals
A summary of common review types. Scope varies by emirate, authority, policy and contract, so confirm the specific requirements that apply to your buildings.

Two of these deserve a closer look in Dubai. For fire and life safety, buildings are expected to hold a maintenance contract with a Dubai Civil Defence approved contractor and keep testing records, so inspectors follow the evidence trail from system to report. For jointly owned property, owners associations maintain a reserve fund for the eventual replacement of major common-area equipment. As Gulf News has described, the reserve fund study behind it assesses each asset's type, location, installation and maintenance to estimate remaining useful life. A register with installation dates and condition scores makes that study faster and easier to defend.

The findings that come up most often are predictable: assets in the building that are not in the register, PPM marked complete with no evidence attached, fire and life safety assets without a named contractor, and decommissioned plant still listed as active. Photo evidence and checklists captured on site close most of these gaps, which is the job of an inspection app such as FieldINSPECT. For portfolios run across several owners or buildings, the same discipline applies at scale; see how it works for multi-property owners and IFM providers.

The two-way test

Before any audit, run it yourself. Pick ten assets from the register and find them in the building. Then pick ten assets in the building and find them in the register. If either direction fails, fix the process that let it happen, not just the ten records.

Frequently asked questions

What is an asset register in facility management?

An asset register in facility management is the structured list of every maintainable item in a portfolio, such as chillers, pumps, lifts, fire panels and air handling units, recorded against its location, type, specification, criticality and service history. It is the base record that PPM schedules, work orders, contracts and compliance reports are built on.

What should be included in an asset register?

At minimum: a permanent unique asset ID, location down to the room or riser, asset type and classification, manufacturer, model and serial number, installation date, warranty expiry, criticality rating, the parent system it belongs to, the maintenance regime that applies to it, and its status (active, standby, decommissioned). Compliance-relevant assets also need the responsible contractor and links to certificates and test records.

What is the difference between an asset register and a fixed asset register?

A fixed asset register is a finance record of capitalised items, holding cost, depreciation and net book value. A maintenance asset register is an operational record of everything that needs servicing, including low-value items finance never capitalised. The two should share IDs where they overlap so that a replaced or disposed asset is updated in both, but they will never contain exactly the same items.

How do you determine asset criticality?

Score each asset type on the consequence of its failure: risk to life safety or statutory compliance, impact on occupants or the business, whether there is redundancy such as a duty and standby arrangement, and the cost and lead time to repair or replace. The highest score across those factors sets the rating. Rate by asset type first, then adjust individual assets where their role differs, such as a single pump with no standby.

Should asset tags use QR codes or barcodes?

For fixed building plant, QR codes are usually the better choice. They cost about the same to print, scan from any angle with a standard phone camera and tolerate some damage. Barcodes work but need line of sight and a dedicated scanner in many cases. RFID and NFC make sense mainly for assets that move and need to be located or counted in bulk.

How often should an asset register be verified?

Continuously, through day-to-day work: every PPM visit where the technician scans the tag and confirms the asset is a small verification. On top of that, most organisations plan a full physical walk-down on a fixed cycle, commonly annually, and always before a CAFM migration, a contract retender or a major audit. There is no single mandated frequency in the UAE, so set one in your FM policy and follow it.

Editorial note: this article is a practical guide to asset data, not legal or compliance advice. Inspection, service charge and insurance requirements vary by emirate, authority and policy, and change over time. Confirm the specific obligations for your buildings with the relevant authority, your insurer or your adviser.

Request a Demo

See what Reflexion
can do for you.

Trusted by leading property developers and FM companies across the GCC — including marquee owners like Emaar, Dubai Sports City, and Al Mouj. Tell us about your portfolio and we'll show you exactly how Reflexion fits your operations.

450M+
Sqft under management across the GCC
100+
Reflexion projects delivered successfully
18+
Years of focused FM expertise in the GCC