If you manage electrical compliance across a portfolio of buildings — whether care homes, schools, commercial properties, or mixed estates — there is a reasonable chance your compliance tracking lives in a spreadsheet. A shared Excel file, updated manually, with colour-coded cells indicating which sites are compliant, which are overdue, and which are somewhere in between.
This guide explains why spreadsheet-based compliance tracking creates risk, what portfolio-level compliance management actually requires, and what you should demand from your electrical contractor in terms of reporting and visibility.
The Spreadsheet Problem
Spreadsheets are not compliance management systems. They are data entry tools being used for a purpose they were not designed for. The specific risks:
Version control: When multiple people update the same spreadsheet, version conflicts are inevitable. The compliance manager updates the master copy. The regional manager updates their local copy. The contractor sends a separate update by email. Within weeks, no single version reflects the actual compliance position.
Missed renewals: A spreadsheet does not send alerts. If an EICR expiry date passes without anyone noticing, the site becomes non-compliant silently. For a portfolio of 50+ sites, manually checking expiry dates against a spreadsheet every month is error-prone and time-consuming.
Inconsistent formats: Different contractors provide documentation in different formats. Some send PDFs, some send paper certificates, some send nothing until chased. Collating this into a consistent spreadsheet format requires manual data entry — which introduces transcription errors.
No audit trail: A spreadsheet does not record who changed what, when, or why. In a compliance dispute or regulatory investigation, you cannot demonstrate the history of compliance decisions. The spreadsheet shows the current position — it does not prove the process that got you there.
Single point of failure: If the person who maintains the spreadsheet leaves the organisation, the compliance knowledge leaves with them. The spreadsheet remains, but the context — which sites have known issues, which contractors are underperforming, which remedials are in progress — is lost.
What Portfolio Compliance Actually Requires
Managing electrical compliance across a multi-site portfolio requires five capabilities that spreadsheets cannot reliably provide:
Certificate Tracking
Every site in the portfolio has multiple certificates with different expiry dates: EICRs (typically 5-yearly), emergency lighting certificates (annual), and potentially PAT testing records. Certificate tracking requires:
- A centralised register of every certificate for every site
- Automated expiry alerts — 90 days, 60 days, 30 days before expiry
- Status visibility — compliant, expiring soon, overdue — at portfolio level
- Document storage — the actual certificates linked to each site record, not filed separately
Remedial Scheduling
When an EICR identifies C1, C2, or C3 findings, those remedials need to be tracked from identification through to completion and re-test. Remedial scheduling requires:
- Every finding logged with its condition code, location, and recommended action
- Priority-based scheduling — C1 findings resolved immediately, C2 within 28 days, C3 planned into the next maintenance cycle
- Progress tracking — assigned, in progress, completed, verified
- Photographic evidence of completed remedials linked to the original finding
Budget Forecasting
Estates managers need to forecast electrical compliance spend across the portfolio. This requires visibility of:
- Testing costs for the next 12-24 months based on EICR expiry schedules
- Estimated remedial costs based on historical data from similar sites
- Capital replacement forecasting for distribution boards, emergency lighting systems, and other infrastructure approaching end of life
- Variance tracking — actual spend against budget at site and portfolio level
Regulatory Reporting
Different portfolio types have different reporting requirements:
- Care home groups report to CQC under Regulation 12 and Regulation 15
- Multi-academy trusts report to the Education and Skills Funding Agency
- Social housing providers report to the Regulator of Social Housing
- Commercial landlords report to insurers and tenants
Each requires compliance data in a specific format. Extracting this data from a spreadsheet for each reporting cycle is manual, time-consuming, and error-prone.
Real-Time Visibility
The fundamental limitation of spreadsheet tracking is that it shows the compliance position at the time the spreadsheet was last updated — not the compliance position right now. For a portfolio where testing, remedials, and certificate renewals are happening continuously, the spreadsheet is always out of date.
"Compliant at Last Check" vs "Compliant Now"
This distinction matters more than most estates managers realise. A spreadsheet can tell you that a site was compliant when the data was last entered. It cannot tell you whether:
- A certificate has expired since the last update
- A remedial work order has been completed and verified
- A new finding has been identified during a recent inspection
- A contractor has uploaded updated documentation
In a regulatory investigation or insurance claim, "compliant at last check" is not a defence. The question is whether the site was compliant at the time of the incident — and whether the duty holder had systems in place to maintain continuous compliance visibility.
Contracts OS: Replacing Spreadsheets with Structured Compliance
Pro Energise's Contracts OS platform provides the capabilities described above — live compliance dashboards, automated certificate expiry alerts, centralised documentation, and portfolio-level reporting. For managing agents and estates teams, this replaces manual spreadsheet tracking with a structured digital compliance layer.
Structured compliance platforms like Contracts OS provide:
- Automated certificate expiry alerts sent to the responsible person and their manager
- Centralised document storage with every certificate, report, and photograph linked to the site record
- Live compliance dashboards showing portfolio-wide status — compliant, expiring, overdue — updated in real time
- Remedial tracking from identification through to completion with photographic evidence
- Audit trails recording every change, update, and decision
- Reporting templates aligned to regulatory requirements (CQC, ESFA, RSH)
The transition from spreadsheet to platform is not a technology upgrade — it is a governance upgrade. It changes compliance management from a periodic manual exercise to a continuous, automated process.
Our delivery for Connells Group demonstrated centralised programme management across a dispersed national branch portfolio — EICR testing, remedial works, and LED retrofits with consolidated monthly reporting through Contracts OS.
What to Demand From Your Contractor
If you appoint an electrical contractor to manage testing and compliance across a multi-site portfolio, the reporting capability should be a contractual requirement, not an afterthought. Demand:
- A live compliance dashboard accessible to your team — not a monthly PDF report
- Automated alerts for certificate expiries and overdue remedials
- Digital handover packs uploaded within 48 hours of each inspection
- Remedial tracking with status updates and photographic evidence
- Quarterly compliance reports in a format aligned to your regulatory reporting requirements
- A named compliance manager responsible for portfolio-level oversight
The contractor who can provide this level of reporting visibility is managing your compliance proactively. The contractor who sends you a spreadsheet update once a month is transferring the compliance management burden back to you.
If your electrical compliance tracking currently lives in a spreadsheet, the risk is not theoretical. See our governance and compliance framework for how we structure compliance delivery, or read why organisations choose Pro Energise for the broader delivery model.