Most landlords don’t get fined because they never did a Gas Safety check or never bothered with an EICR.
They get fined because something quietly expired three weeks ago, and no-one noticed.
A simple compliance tracker solves that. It doesn’t need to be fancy. It just needs to answer one basic question:
“What is due next, where, and by when?”
This guide walks through the key certificates UK landlords should track, how often they renew, and a structure you can drop straight into Excel or Google Sheets. You can pair it with your existing preventive maintenance checklist and digital maintenance log to cover both repairs and legal paperwork.
Why You Need a Compliance Tracker (Not Just a Folder of PDFs)
Even careful landlords can end up with:
- Gas certificates in one email inbox
- EICRs in a letting agent’s portal
- EPCs buried in an old solicitor bundle
- HMO licence letters in a drawer somewhere
That’s fine until:
- a tenant complains to the council
- a damp or mould issue triggers an inspection
- or you try to remortgage or sell and the lender wants “everything” yesterday.
A basic compliance tracker gives you:
- Visibility – one view of every property and every key certificate
- Early warning – 30/60/90-day notice before expiry dates
- Proof – an audit trail that shows you took your duties seriously
- Less panic – no more “when did we last do the EICR on Flat 3A?” at 11pm
If you’ve already started digitising your repairs using tools from 5 Signs You Need Maintenance Management Software, this is the natural next step.
What Should Go in a Landlord Compliance Tracker?
You don’t have to track every scrap of paper. Focus on the certificates and checks that are time-bound, legally loaded, or both.
1. Gas Safety Certificates (CP12)
For any property with gas:
-
What to track
- Date of last inspection
- Expiry / next due date (usually 12 months from the previous check)
- Engineer name and Gas Safe registration number
- Notes on any remedial work required
-
Why it matters
- Mandatory for most rented properties with gas appliances
- Required evidence if there’s an incident or complaint
2. Electrical Installation Condition Reports (EICR)
For the fixed wiring and consumer unit.
-
What to track
- Date of inspection
- Recommended next inspection date (often 5 years)
- Result (e.g. “Satisfactory” vs “Unsatisfactory – C2 defects”)
- Remedial works required and completion date
- Contractor / scheme details
-
Why it matters
- Evidence that the electrical installation is safe
- Councils and insurers pay attention to this one
3. Energy Performance Certificates (EPC)
Even though EPCs renew less often, they’re easy to forget.
-
What to track
- EPC rating (e.g. “D 63”)
- EPC expiry date (10-year validity)
- Whether the property currently meets minimum standards
- Notes on planned upgrades
-
Why it matters
- Needed for marketing the property to let
- Ties into longer-term standards and future regulation
4. HMO and Selective Licences (Where Applicable)
If you operate HMOs or fall under selective licensing schemes.
-
What to track
- Type of licence (HMO / additional / selective)
- Maximum permitted occupants
- Issue and expiry dates
- Any conditions (e.g. fire alarm testing schedule)
-
Why it matters
- Operating without a licence or breaching licence conditions can be very expensive
- Often inspected alongside damp, mould and overcrowding issues flagged in New Regulations: What Landlords Must Track in 2026
5. Fire, Smoke & CO Safety Checks
Even where there isn’t a formal certificate, track anything that involves life safety:
- Smoke alarm installation and replacement dates
- CO alarm installation where required
- Fire door checks and emergency lighting testing in HMOs / blocks
- Formal fire risk assessments and follow-up actions
6. Legionella and Other Risk Assessments
For most single lets, a basic written Legionella assessment is enough; higher-risk buildings may need more.
- What to track
- Date of last assessment
- Risk level and recommended actions
- Dates those actions were completed
When you combine all of the above, you’ve got a snapshot of whether each property is genuinely “fit for human habitation”, not just “probably fine”.
One Tracker, Many Properties: How to Structure It
You have two main options:
-
One row per property
- Big wide sheet with columns like “Gas due”, “EICR due”, “EPC due”.
- Easier to scan at a glance, harder to show history.
-
One row per certificate (recommended)
- Each row represents one event: “Gas Safety – 12 High Street – 03/09/2025 – Expires 02/09/2026”.
- You can filter by property, certificate type, status, or contractor.
For most landlords and small agents, option 2 is much more flexible.
Suggested Columns
Set these up in an Compliance Tracker tab:
Property– a friendly name (“Flat 2B, 12 High Street”)Unit / Room– optional, for HMOs and blocksCertificate Type– Gas, EICR, EPC, HMO, Fire Risk, Legionella, etc.Legal Frequency– Annually, 5-yearly, 10-yearly, “As per risk assessment”Completed DateExpiry / Next Due DateStatus– Compliant, Due Soon, OverdueContractor / CompanyEvidence Link– URL to the PDF in Google Drive/OneDriveNotes– any recommendations or conditions
If you’re already using a digital maintenance log for repairs, keep the columns and field names as similar as possible so they play nicely together.
Adding “Due Soon” and “Overdue” Logic
You don’t need complex formulas to make this useful.
In Excel or Google Sheets:
- Create a
Statuscolumn and use data validation for “Compliant”, “Due Soon”, “Overdue”. - Add conditional formatting on the
Expiry / Next Due Datecolumn:- Red if the date is before today
- Amber if the date is within 60 days of today
- Green otherwise
Even if you never touch anything else, being able to filter “Status = Due Soon OR Overdue” on a Monday morning puts you miles ahead of most landlords.
Pair this with the cost thinking from The True Cost of Delayed Maintenance: £2,400 per Property and you can quickly see where an £80 scheduled visit might dodge a £3,000 emergency bill.
Linking Compliance with Damp, Mould and 2026 Rules
New rules around damp and mould, and the wider changes covered in New Regulations: What Landlords Must Track in 2026, all point in the same direction:
- Faster investigations for health-related issues
- Better records of what you knew and when
- Clear timelines showing when work was completed
You can either bolt this onto your compliance tracker or keep a second tab for “Issues and Investigations”, logging:
- Date and time the issue was reported
- Who reported it and how (portal, email, SMS)
- Photos or evidence links
- Investigation date and outcome
- Dates work was instructed, started and completed
When your maintenance tracker, compliance tracker and communication history line up, you have exactly the kind of joined-up audit trail that regulators wish more landlords had.
For damp and mould specifically, the Damp and Mould Checklist for UK Landlords is a useful companion: it tells you what to look for when you attend, while this tracker records when you attended and what you did.
When a Spreadsheet Starts to Creak
For a couple of single lets, a spreadsheet plus calendar reminders is perfectly fine.
You start to feel the pain when:
- You manage 10+ properties and the sheet becomes uncomfortably long
- Letting agents, contractors and co-owners all hold different bits of the data
- Certificates live in several cloud drives and email threads
- You want to slice the data by portfolio, region, or officer without breaking formulas
- You’re trying to line this up with your repair log, costs and contractor performance from UK Property Maintenance Trends in 2025
That’s the point where dedicated maintenance software stops being a “nice to have” and turns into “this keeps me sane”.
Turning Your Tracker into a System
Here’s a simple progression path:
- Today: Build the basic tracker in Excel or Google Sheets using the structure above.
- This week: Backfill all existing Gas, EICR, EPC, HMO and risk assessment dates.
- This month:
- Add simple colour-coding and filters
- Tie your tracker to your preventive maintenance checklist so every inspection triggers updates to both repairs and certificates.
- This year: Decide whether manual updates are still workable or whether you’re ready for tooling that:
- pulls contractor documents into one place
- automatically chases renewals
- ties certificates directly to jobs and costs, as discussed in 5 Signs You Need Maintenance Management Software.
The goal isn’t to build a masterpiece spreadsheet. It’s to have something structured that proves you run your portfolio like a professional, not on vibes and memory.
If you’d rather skip straight to the “joined-up system” stage, you can join the Maintaro waitlist. We’re building a platform where certificates, works orders, photos, and communications all live on the same timeline—so when the council knocks, you already have the answer on screen.