Free spreadsheet template — Excel & Google Sheets

Know when every
certificate expires —
before it becomes a fine.

Plug in your certificates. Colour-coded expiry warnings do the rest. The free spreadsheet template that keeps landlords out of trouble — across as many properties as you need.

✅ 6 certificate types🟢 Auto expiry warnings📊 Excel & Google Sheets📄 PDF report included
6
Cert types
4
Alert levels
Free
Forever
Auto
Colour-codes

Set up your calendar now

Instant access — no spam, ever.

By signing up you agree to our Privacy Policy. Unsubscribe any time.

Preview — what you'll get

Compliance Calendar — 2 Properties2 need attention
PropertyCertificateStatus
14 Clover StGas Safety✓ Safe
14 Clover StEICR✓ Safe
14 Clover StEPC⚠ Due Soon
22 Oak AvenueGas Safety🔴 Urgent
22 Oak AvenueEICR● Expired
22 Oak AvenueEPC✓ Safe
Download CSV + PDF Report

What's at stake when a certificate expires

£30,000

Penalty for renting without a valid EICR

🔥
£6,000

Fine for missing gas safety certificate

📄
Void S21

No How to Rent guide makes a Section 21 unenforceable

💰
RRO

Rent repayment order — up to 12 months' rent

Penalties are indicative. Actual enforcement varies. The template helps you avoid reaching this point.

How it works

20 minutes to complete visibility

1

Enter your properties

Add each property and the certificates you need to track. The template comes pre-loaded with two example properties so you can see how it works immediately.

2

Plug in expiry dates

Enter each certificate's expiry date once. Days remaining calculates automatically. Warnings apply: amber at 90 days, red at 30, black when expired.

3

Book renewals before they slip

Use the renewal notes column to log engineers and booked dates. Download a PDF compliance report any time you need it on file.

What's included

Every certificate type tracked

Six compliance areas, colour-coded expiry warnings, and a renewal notes column — across as many properties as you need.

🔥

Gas Safety (CP12)

Annual. Copy to tenants within 28 days of renewal. £6,000 fine if missing.

EICR

Every 5 years. £30,000 penalty for non-compliance. Must be given to new tenants before move-in.

📋

EPC

Every 10 years. Minimum Band E required. Tracked with full expiry date.

🦠

Legionella Assessment

No fixed interval — risk-based. Findings must be documented even for low-risk properties.

🪪

Selective Licence

Required in designated areas (e.g. Liverpool L4). Tracked per property — renewal cannot lapse.

🔔

Fire & CO Alarms

Annual test recommended. CO alarm legally required in every room with a gas appliance.

How the colour-coding works

Green
> 90 days — safe
Amber
30–90 days — book now
Red
< 30 days — urgent
Expired
Act immediately

Why landlords use this

Stop keeping compliance in your head

  • All certificate expiry dates in one place — nothing overlooked
  • Colour-coded warnings update automatically from your expiry dates
  • Works in Excel and Google Sheets — no new software to learn
  • Pre-loaded with 2 example properties to show you how it works
  • Renewal notes column to log engineers and booked dates
  • Download a branded PDF compliance report any time
  • Completely free — no credit card, no sign-up fee

Honest note: This template works well for 2–5 properties. Once you're tracking 6 or more across multiple cert types, spreadsheet management becomes slow and error-prone. That's when HomeDash starts paying for itself — it does all of this automatically, with reminders.

"My gas certificate for one property had quietly expired. I only found out when I filled in this template. It was 47 days overdue — I had no idea."

Private landlord4 properties, Liverpool

"I thought I was on top of it. The calendar showed two ambers I hadn't noticed — a legionella assessment and an EPC renewal I'd completely lost track of."

BTL investor6 properties, Manchester

"Simple, clear, and actually useful. Took about 20 minutes to fill in properly. Now I can see exactly where everything stands at a glance."

Self-managing landlordLeeds
Takes 20 minutes · Excel & Google Sheets

Set it up in 20 minutes.
Never miss a renewal again.

Every landlord should have this on file. Free, instant access, no credit card required.

Get your free template

No credit card. No spam. Instant access.