How to Build a Compliance Calendar So You Never Chase a Certificate Deadline Again

Why a spreadsheet works until it doesn't

Most landlords start with a spreadsheet. One column per property, one row per certificate, a date, maybe a colour code if you're feeling organised. It works fine for two or three properties. It stops working the moment you're managing eight, or you've taken on a portfolio from another agent, or you're juggling Gas Safety, EICR, EPC and HMO renewals that all land in different months for different properties.

The failure mode isn't dramatic. Nobody forgets on purpose. What happens is the spreadsheet gets a week out of date, then a month, then a tenant calls about a boiler fault and you realise the gas certificate expired six weeks ago and nobody caught it. That's not a filing problem. It's a system problem, and it's worth fixing properly rather than buying a better spreadsheet template.

The three dates every property actually needs tracked

Before building anything, it helps to be honest about what you're actually tracking, because "compliance" isn't one date, it's several, and they don't move together:

• Gas Safety (CP12) — annual, tied to the anniversary of the last check, not the calendar year.
• EICR — generally every five years for a tenancy, though intervals can differ for HMOs, so check current government guidance for your specific setup.
• EPC — valid for ten years, easy to forget precisely because the gap is so long.
• Smoke and carbon monoxide alarms — not a renewal date as such, but a testing and record-keeping obligation at each tenancy change.
• HMO licence — renewal windows set by the local authority, and they vary council to council.

The point of listing these separately is that a single "next renewal" column per property hides risk. A property can be fully compliant on gas and badly overdue on EICR, and a system that only shows you one date per row will let that sit unnoticed.

Building the calendar: one system, not five

The fix isn't a better spreadsheet, it's collapsing every certificate type into one calendar view that's organised by date, not by property. When you can see "everything due in the next 60 days" across your whole portfolio in one screen, gaps become visible instead of buried in row 47 of a sheet nobody's opened since March.

This is the basic job CertMinder UK does: every certificate you upload gets its expiry tracked automatically, and the system surfaces what's coming due regardless of which property it belongs to. You're not relying on remembering to check — the calendar comes to you. For agents managing several landlords' portfolios, the same view works across branches, so a renewal at a property in one office doesn't get missed because it wasn't the office that was watching that week.

Reminders that reach the right person, not just your inbox

A reminder that only goes to one inbox is a single point of failure. If that person is on leave, or the email lands in a folder nobody checks, the reminder achieves nothing. A workable reminder system needs to escalate: an early notice with plenty of runway (60 or 90 days out, depending on the certificate), a second reminder as the date closes in, and ideally the option to loop in whoever's actually responsible for booking the contractor — which for a managed property might be your agent, and for a self-managed one might be you directly.

Worth saying plainly: we don't get paid by your contractors. CertMinder UK doesn't take a referral fee or a kickback for pointing you toward a gas engineer or an electrician. The reminder's job is to tell you something needs booking — who you book is entirely your call, and it stays that way.

Work orders: closing the loop between "reminder" and "done"

A reminder that fires and then nothing happens is only half a system. The other half is tracking whether the job actually got booked, completed, and the new certificate uploaded — because "I meant to sort that" is how gaps happen even in portfolios with good reminders.

This is where a work-order flow earns its keep. Turning a reminder into a work order gives you a record of who was asked to do the job, when, and whether it's been closed out with a new certificate attached. It also means that if a tenant or a council asks for proof six months later, you're not searching email threads — you've got a paper trail that shows the property was never actually left uncovered, or shows exactly when and why there was a gap, which matters if you ever need to explain one.

Keeping records for when a tenant or council asks

Compliance is the floor, not the ceiling, and part of managing that floor well is being able to produce evidence quickly. A council enforcement query, a deposit dispute, or a new tenant asking to see the current EICR shouldn't require you to dig through old emails or ring a contractor to ask for a duplicate. Certificates stored against the property record, with dates and version history, mean you can answer in minutes rather than days.

The bottom line

None of this requires more effort than a spreadsheet — it requires a system that does the remembering for you and shows every certificate type in one place, with reminders that reach more than one person and a work-order trail that proves the job got done. That's the difference between hoping nothing slips and knowing it can't slip quietly.

This article is informational and doesn't constitute legal advice. Always check current UK government guidance for the compliance rules that apply to your specific properties.