The most reliable way to handle utilities authorisation tracking is to move every certificate out of spreadsheets and into a dedicated competency management system. A purpose-built platform stores each authorisation against the individual worker, monitors expiry dates automatically and alerts managers before anything lapses. That single change removes the version-control errors, missed renewals and audit panic that spreadsheet tracking creates.
If your gas, water, power or telecoms teams still rely on a master workbook to record who is authorised to do what, this guide explains why that approach breaks down, what it puts at risk, and how to replace it with a process that stands up to scrutiny.
Why spreadsheets fail at utilities authorisation tracking
Spreadsheets feel free and familiar, which is why so many utility contractors start with them. The problems appear as soon as the workforce grows beyond a handful of operatives.
A spreadsheet cannot tell you who is authorised to work on a live network today. It can only tell you what someone typed into it the last time it was updated, which may have been weeks ago.
The common failure points are consistent across the sector:
- Version chaos. Multiple copies circulate by email, and nobody is certain which one is current.
- No expiry alerts. A cell containing a renewal date does nothing until a human remembers to look at it.
- Single points of failure. One administrator owns the file, and knowledge leaves with them.
- No evidence trail. A date in a cell is not proof. Auditors and clients want to see the certificate itself, who verified it and when.
- No site-level visibility. Supervisors at the point of work rarely have access to the file, so authorisation checks happen back at the office, after crews have already been deployed.
Each of these is an inconvenience on a quiet week. During an incident investigation or a client audit, they become serious liabilities.
What authorisation certificates cover in the utilities sector
Authorisations sit on top of training. A qualification shows that someone passed a course; an authorisation is your company formally permitting a named individual to carry out specific work on specific assets. In UK utilities that typically includes:
- Electrical authorisations such as Authorised Person (AP) and Senior Authorised Person (SAP) status for switching and access to high-voltage equipment
- Authorisation certificates issued by contractors accredited under the NERS (electricity), GIRS (gas) and WIRS (water) registration schemes, which require companies to formally authorise named operatives for the work they carry out
- Street works qualifications and supervisor accreditations
- Confined space, excavation and safe digging permissions
Every one of these carries a defined scope and an expiry or revalidation date. Workforce authorisation tracking in utilities means knowing, for every individual, exactly which authorisations they hold, the scope of each, the evidence behind it and the date it ceases to be valid. Purpose-built authorisation certificate software is designed to track exactly this, from creation and assessment through to sign-off and annual review.
The real cost of a lapsed authorisation
The stakes in this sector are not theoretical. According to the Health and Safety Executive, 124 workers were killed in work-related incidents in Great Britain in 2024/25 (HSE, “Work-related fatal injuries in Great Britain”, published July 2025), and utilities work involves some of the highest-consequence hazards there are: live electricity, pressurised gas, deep excavations and confined spaces.
If an operative carries out work after an authorisation has expired, the consequences ripple outwards:
- Safety exposure. The control that authorisation provides, confirmation of current competence for high-risk tasks, is gone.
- Legal exposure. Under the Health and Safety at Work etc. Act 1974 and supporting regulations, employers must ensure work is done by competent people. A lapsed authorisation discovered after an incident is exactly what investigators look for.
- Commercial exposure. Network operators and principal contractors audit their supply chains. Failed audits can mean suspension from frameworks that took years to win.
- Operational cost. Crews stood down at the gate because their authorisations cannot be verified cost money every hour they wait.
A lapsed certificate that nobody noticed is never an administrative footnote; it is evidence that the management system failed.
What good authorisation certificate tracking looks like
Replacing the spreadsheet is not about buying software for its own sake. It is about meeting a clear operational standard. Utilities compliance audit software should give you:
- One record per person. Every authorisation, qualification and training record held in a single profile, with the certificate document attached as evidence.
- Automatic expiry alerts. Notifications to the worker, their manager and the training coordinator at sensible intervals before renewal, for example 90, 60 and 30 days out.
- Scope and asset detail. Not just “authorised”, but authorised for what, on which networks and at what voltage or pressure level.
- Instant audit reporting. The ability to produce a live competency matrix for any team, contract or site in minutes rather than days.
- Access in the field. Supervisors should be able to confirm an operative’s authorisation status from a phone or tablet at the point of work.
- An audit trail. Who uploaded each certificate, who verified it and every change since.
This is the core of modern utilities training management in the UK: a single source of truth that connects training, competence and authorisation, rather than three disconnected spreadsheets.
Platforms built for this job, such as the Competency Cloud platform, manage the full NERS, GIRS and WIRS certificate lifecycle, from creation and assessment through to sign-off and annual review, and combine it with dedicated training records software so that authorisations, qualifications and course history live in one place.
Moving off spreadsheets: a practical four-step plan
- Audit what you have. Consolidate every spreadsheet, shared drive folder and filing cabinet into one list of people and authorisations. Expect to find gaps and duplicates; that discovery is the point.
- Verify the evidence. For each authorisation, locate the actual certificate or issuing-body confirmation. Anything that cannot be evidenced should be treated as expired until proven otherwise.
- Load and assign ownership. Import verified records into your chosen system, attach the documents and make named managers responsible for each team’s compliance.
- Switch off the spreadsheet. Set a hard cut-over date. Running both systems in parallel for months recreates the version-control problem you set out to solve.
Most teams can complete this within a single quarter, and the first automated expiry alert usually pays for the effort by itself.
FAQ
What is utilities authorisation tracking? Utilities authorisation tracking is the process of recording, evidencing and monitoring the formal authorisations that permit utility workers to carry out specific high-risk tasks, such as high-voltage switching or gas network operations, and ensuring each one is renewed before it expires.
Why are spreadsheets a problem for tracking authorisation certificates? Spreadsheets offer no automatic expiry alerts, no evidence trail, no field access and no protection against version errors. They record what someone typed, not what is currently true, which makes them unreliable for safety-critical compliance.
How far in advance should we be alerted before an authorisation expires? A common approach is staged alerts at around 90, 60 and 30 days before expiry, giving enough time to book refresher training or reassessment without taking the worker off productive duties at short notice.
What should we show an auditor to prove our workforce is authorised? Auditors typically expect a current competency matrix, the certificate or issuing-body evidence behind each authorisation, and a record of who verified it and when. A system that produces this on demand turns audit preparation from days of work into minutes.
Conclusion: make utilities authorisation tracking automatic
Spreadsheets did a job while your business was small, but they cannot provide the live visibility, automated alerts and audit-ready evidence that utilities authorisation tracking now demands. Moving certificates into a dedicated competency management system protects your people, your contracts and your reputation, and it removes a quiet, persistent risk from the business. The companies that handle this best are the ones that made expiry dates impossible to miss.
See how workforce management software for utilities handles the whole lifecycle, or book a demo to see it running against your own certificate workflows.