Most organisations operating in hazardous industries believe they have a handle on workforce compliance. They have a payroll system. They have an HR platform, perhaps a large ERP rolled out by head office. They track employees, manage contracts, and process training invoices.
And then, somewhere in an overworked training manager’s laptop, there is a spreadsheet.
That spreadsheet is where the real compliance data lives. The certifications. The expiry dates. The evidence of competence. The record of who has done what, and whether they’re qualified to be where they’re going
The space between that enterprise HR system and that spreadsheet is what Chorus calls the Competency Gap. And it is precisely where incidents happen.
Two Systems, One Critical Blind Spot
To understand the Competency Gap, you first need to understand what large HR and ERP systems are actually designed to do. SAP, Workday, Oracle HCM and their equivalents are enterprise-grade tools built to manage the employment relationship at scale. They are excellent at processing payroll, managing leave, tracking headcount, and organising contracts.
What they are not built to do is track whether a particular worker’s confined space entry certification expired last month, whether a subcontractor on-site today has a current offshore survival certificate, or whether the team being deployed to a new infrastructure project have completed the mandatory site induction for that specific location.
These systems deal in employment data. The compliance and competency layer, the granular, role-specific, regulation-aligned record of whether each person is genuinely qualified to perform safely, exists somewhere else. Usually in a spreadsheet. Sometimes in a custom database. Often across multiple systems, none of which talk to each other.
Where Data Lives — and Where It Falls Apart
ERP / HR System | Training Records (Spreadsheet) | Subcontractor Data | Site Requirements |
|---|---|---|---|
Headcount | Cert expiry dates | Emailed spreadsheets | Location-specific rules |
Payroll & contracts | Competency evidence | Unverified certificates | Induction records |
Job titles & roles | Manual renewal reminders | Onboarding gaps | RAMS compliance |
⚠️ THE COMPETENCY GAP: None of these systems automatically share data with each other. This is where incidents occur. | |||
The Subcontractor Problem: When 80% of Your Workforce Is Off the Radar
The Competency Gap becomes significantly more dangerous when subcontractors are factored in. In many high-hazard operations, subcontractors can account for up to 80% of the people on site.
Those workers don’t sit in the employer’s HR system. They’re not in the payroll. Their certifications arrive via email, attached to a spreadsheet that the subcontracting firm manages. Whether that spreadsheet is accurate, current, or version-controlled is an open question. Whether it matches the compliance requirements for the specific site they’re heading to is often never checked in any systematic way.
Under UK health and safety law, responsibility for everyone on a site belongs to the site operator. A subcontractor’s improperly maintained certification record is not their problem alone; it is the principal contractor’s problem too. When something goes wrong, the investigation will follow the chain of accountability regardless of who sent the spreadsheet.
How the Data Breaks Down: A Real-World Example
When they arrive on site (potentially an offshore platform, a high-voltage substation, or a remote pipeline installation), there is no easy way to catch the error. The checks have been done. The spreadsheet said so. And now someone is working in a high-hazard environment without the training they were assumed to have.
In health and safety, practitioners use the Swiss cheese model to explain how incidents happen: individual layers of protection each have holes, and when those holes line up, harm gets through. A stale spreadsheet is one of those holes. And when it lines up with human error, a near-miss, or a moment of uncertainty on site, the consequences can be catastrophic.
Who Pays When the Spreadsheet Gets It Wrong?
Chorus worked with a utilities company in the south of England that was in the process of being acquired by a large US multinational. As part of the due diligence process, the acquiring company needed to understand the existing workforce, its size, structure, and competency levels.
What they found when they consolidated the data was alarming. Certificates dating back to the mid-1990s that had never been renewed. Compliance records are scattered across multiple spreadsheets for different sites, with no reconciliation between them. A workforce that appeared, on paper, to be certified, but whose certifications had in many cases never been tracked beyond initial issue.
No incident had occurred. But the exposure was substantial. Had a regulator audited the company, or had an incident triggered an investigation, the gap between what the HR system showed and what the compliance records actually contained would have been indefensible.
The issue was not that anyone had been dishonest or careless. The issue was that the systems they used were never designed to catch this kind of drift. The Competency Gap is not always visible until you look directly at it.
The Moment of Audit: When the Gap Becomes Undeniable
When an HSE inspector arrives, potentially unannounced or with minimal notice, the question they ask is not “do you have a training programme?” It is “Can you demonstrate, right now, that the people working on this site are competent and certified to be here?”
If your answer is to open a spreadsheet, you already have a problem.
Spreadsheets cannot generate an instant, reliable audit trail. They cannot confirm in real time that all records are current. They cannot integrate with your operational rotas to flag that a worker on today’s shift has an expired certification. They cannot show the inspector a live training matrix with gaps clearly identified and corrective actions in progress.
The work required to close those gaps overnight, such as updating records, contacting delegates, or verifying subcontractor data, is not manageable in the time available. Which means that organisations relying on spreadsheets typically face one of two outcomes when audited: a corrective action plan at best, or a significant enforcement notice at worst.
Closing the Gap: What a Proper Competency Management System Actually Does
The solution to the Competency Gap is not a better spreadsheet. It is a system purpose-built to manage the space that HR platforms cannot reach — one that connects directly to operational reality rather than sitting alongside it.
That means a platform that can ingest data from your existing HR and ERP systems and enrich it with the competency and certification layer that those systems are missing. It means a tool that gives individual workers visibility of their own compliance status and allows them to upload evidence directly. It means automated expiry alerts that go to the right people at the right time, not because someone remembered to check a spreadsheet, but because the system is designed to catch it.
Critically, it means a system that encompasses subcontractors as well as directly employed staff. So that the 80% of your workforce who may not sit in your HR system are still subject to the same rigour of compliance oversight. Recruitment agencies and subcontracting firms can upload certificates directly. Line managers get oversight. Administrators can run a compliance report at the click of a button.
And increasingly, AI plays a role, not to make decisions that belong to qualified professionals, but to surface gaps, identify training requirements, and take the administrative burden off the people who should be focused on safety judgement rather than spreadsheet maintenance.
The Competency Gap is real, it is widespread, and it carries genuine risk. The organisations that close it are not those with the biggest HR systems. They are the ones who recognised the gap for what it was and decided to do something about it.
Chorus bridges the gap between your HR system and operational reality. To see what that looks like for your organisation, get in touch with our team.
Article tags:
