Tracking Gas Safety, EICR and EPC expiry across a multi-property portfolio

Gas Safety Certificates renew annually, EICRs roughly every five years, and EPCs on their own separate cycle with a minimum standard on top — as covered in our guide to EPC ratings. None of these three dates are linked to each other, and none of them are linked to a tenancy start date either. That's three independent clocks on every single property.

Why a spreadsheet works, until it doesn't

For a handful of properties, a spreadsheet with three date columns and some colour-coding is genuinely fine — someone checks it weekly, the dates are few enough to hold roughly in mind, and a missed renewal is unlikely because there's not much room for one to hide. The problem isn't the spreadsheet itself, it's what happens as the number of rows grows and the person checking it changes over time, inherits it from someone else, or simply gets busy for a fortnight during exactly the wrong week.

Where the failures actually happen

In practice, missed renewals rarely happen because nobody was checking the spreadsheet at all — they happen because a formula broke silently, a row got sorted out of order during an edit, a property changed hands between team members without a clean handover, or the colour-coding stopped being trustworthy once someone forgot to update it for a few months and everyone quietly stopped relying on the colours. The failure is rarely dramatic; it's usually a small, boring administrative slip that compounds.

What good tracking actually needs to do

Whatever the tool, the underlying job is the same: surface what's due soon before it's overdue, make the status visible to more than one person so it doesn't depend on a single individual's memory, and hold the full evidence trail — engineer details, remedial work closed out, delivery to the tenant — against each certificate, not just the date itself.

• –A single view of every property's gas, EICR and EPC status, not three separate places to check
• –Automatic flags for what's due soon, not a manual weekly scan someone has to remember to run
• –Visibility for more than one person, so tracking doesn't depend on one individual staying in post
• –The evidence trail attached to each certificate, not just the renewal date
• –A record that survives a property or a team member changing hands mid-cycle

Where a dedicated platform actually earns its cost

This is really the core case for what a property compliance platform should include — not that it replaces judgement or handles the actual engineer visit, but that it removes the specific, boring failure mode of a manually maintained tracker quietly going stale. The value isn't a new capability so much as removing a fragile dependency on one person's diligence.

Reporting outward, not just tracking inward

For a managing or letting agent, this data also needs to go outward, to landlords who reasonably want to know their properties are compliant without asking for a status update every month — which is its own separate problem, covered in reporting portfolio compliance to landlords.

The spreadsheet that was right last quarter

Certificate tracking is the classic case where a spreadsheet is adequate until suddenly it is not. The transition is rarely dramatic: a second copy appears, someone updates one and not the other, a property is added without its dates, an agent leaves and takes context with them. Nothing breaks visibly — the sheet still opens and still looks authoritative — and its accuracy degrades in a way nobody can date.

The signal worth watching for is when someone asks a simple question, such as which certificates expire in the next sixty days, and the answer requires cross-checking rather than reading. At that point the sheet has become a record of what people remembered to enter.

Common mistakes

• –Multiple copies with no agreed master
• –Properties added to the portfolio without their certificate dates
• –Tracking expiry without tracking whether a renewal is booked
• –No notifications, so the sheet only works if somebody opens it
• –Different certificate types tracked in different places
• –No audit trail, so an error cannot be traced to when it appeared