Build a useful plumbing maintenance asset register
A plumbing asset register is a working list of the equipment and pipework arrangements you maintain. It is useful when someone can locate the asset, understand what it serves, find the relevant records and see the next action. Start with a simple, maintained record rather than a large spreadsheet full of unverified detail.
Loyal Plumbers · Updated
Discuss your property workUse the planning template
Download the plumbing asset register template (CSV) ↓Choose what belongs in the register
Begin with the systems you are responsible for: incoming supplies, accessible isolation arrangements, hot water equipment, pumps, major valves and groups of fixtures where that level of detail supports maintenance. An office washroom does not necessarily need a separate row for every identical screw or fitting. A cylinder, booster pump or repeatedly failing valve usually needs an identifiable record because the history affects future decisions.
Define the property boundary before collecting detail. A tenant may maintain fixtures while the landlord controls the supply or shared plant. Record that interface rather than absorbing somebody else’s equipment into an assumed service contract. Where ownership or responsibility is uncertain, mark it for clarification and name the person who will obtain the answer. A blank field with an action is more useful than a confident guess.
Give each asset a stable name and location
Use an asset reference that remains useful when a contractor or manager changes. A simple building, floor and sequence reference can work, provided the same identifier appears in visit records and document names. Avoid naming an asset only after a current tenant or staff member. Those names change and do not tell a new engineer where the equipment is located.
Describe the physical location in ordinary language, including the relevant room or cupboard reference. Where access is restricted, record the access procedure or responsible role, not an unsecured entry code in a widely shared file. A photograph can help distinguish similar equipment, but inspect it for personal information and link to the controlled record rather than embedding customer documents into a general maintenance spreadsheet.
Record verified details and leave uncertain fields open
Manufacturer, model and serial information can help identify suitable instructions and parts. Use labels or existing records that can be obtained safely. Nobody should remove electrical covers, climb into an unsafe space or dismantle equipment solely to complete a spreadsheet field. The next competent visit can confirm details that are not safely visible.
Separate the asset’s function from its identity. “Cylinder supplying second-floor washrooms” tells the reader something different from a model number. Include what the equipment serves, the relevant isolation reference where established and any known interface with another system. Do not turn a register into a speculative drawing of concealed pipe routes; an unverified route should remain clearly unverified.
| Field | Useful entry | Avoid |
|---|---|---|
| Asset reference | A stable building and equipment identifier | A name that changes with the tenant |
| Location | Floor, room and cupboard reference | “Somewhere upstairs” |
| Serves | Known outlets or system served | Assumed connections recorded as fact |
| Documents | Link or reference to the current instructions and record | An unexplained folder of old versions |
| Next action | Task, named owner and agreed date | “Monitor” with no owner or review point |
Link maintenance tasks to the actual asset
A register says what exists; a maintenance schedule says what is to be done and when. Keep those purposes distinct but connected. For each asset, the schedule can identify the task, frequency or due date, required access and the person arranging it. The completion record then states what was actually done and any finding that needs action.
Set tasks using the equipment instructions, condition, use and any relevant specialist requirements. A single annual interval is not a maintenance strategy for every component in a building. Water Regs UK guidance for non-household premises addresses maintenance of plumbing installations, while HSE guidance covers management of relevant water-hygiene risks. The register can link those arrangements; it does not replace the assessment or competent decisions behind them.
Turn findings into assigned actions
A useful visit record distinguishes an observation from a completed repair. “Valve stiff to operate” and “valve replaced and checked” describe different states. Give unresolved findings an owner and a next step, such as investigation, quotation or planned replacement. This stops a recurring note from appearing in successive reports without anyone deciding what happens next.
Keep the current status understandable: open, planned, completed or awaiting information can be enough for a small operation. Record who agreed that an item could be closed and where the supporting job record is stored. If access prevented a task, record the restriction rather than marking the inspection complete. That distinction matters when a manager later relies on the spreadsheet to plan a shutdown or order work.
Use the history to make repair decisions
Repeated problems at one asset or location deserve a view of the history. Three separate call-outs may concern a recurring supply issue, a connection repeatedly disturbed by other work or several unrelated faults. A stable asset reference lets the contractor see the sequence and investigate the relevant pattern without assuming that every return visit has the same cause.
The history can also support replacement planning. Record the nature of the repairs, the practical access burden and any recommendation to review the wider system. A spreadsheet does not decide when replacement is economical, but it gives the survey a better starting point. Keep actual repair findings separate from quotations that were proposed but never accepted.
Keep one controlled version that people will update
Choose a place where the responsible team can find the current register and agree who can edit it. An export attached to an old email should not quietly become the active version. Record the date of a meaningful update and retain important completed-work documents even when equipment is removed. This preserves the explanation for a changed layout without keeping obsolete assets in the live task list.
Review the register after refurbishment, replacement or a change of management. A new bathroom, divided tenancy or altered plant arrangement may change what an asset serves. The handover should identify those changes, not merely transfer the old list. For a small building, a short accurate register with a clear owner is better than an elaborate database nobody maintains.
Start with the template and a defined survey
The downloadable CSV contains headings and one clearly marked example row. Replace that example with verified information for your property. It opens in common spreadsheet applications; add fields only when they support a real maintenance or access decision. The template contains no customer records and is not a certificate of inspection.
If the current system is poorly documented, begin with an agreed survey of the accessible assets rather than filling the gaps from memory. Loyal Plumbers can discuss planned plumbing maintenance for commercial premises, landlords and managed buildings across London and inside the M25. Send the property type, systems involved and the records you already hold so the survey and maintenance scope can be defined.
Common questions
- Do I need expensive maintenance software?
- Not necessarily. A controlled spreadsheet can work for a small property if the asset references, documents and follow-up actions are kept current. More complex portfolios may benefit from software that supports their actual workflows.
- Is an asset register a legionella risk assessment?
- No. It can help identify equipment and link to the relevant documents, but it does not replace a risk assessment, a control scheme or competent water-system management.
- Should removed equipment stay in the live list?
- Mark it as removed and retain the useful history separately from active maintenance tasks. Record the replacement asset and any changed connections or service boundaries so old instructions are not applied to the new arrangement.
Sources and further reading
Need help with this in London?
Emergency repairs, investigations and planned installations across London and inside the M25. Tell us what you need so we can agree the next step.
Discuss your job