Why Spreadsheet Compliance Tracking Fails (and What to Use Instead)

If you track your compliance obligations in a spreadsheet, you are not alone. Most landlords start there. A row for each property, columns for gas safety, EICR, EPC, deposit protection — maybe some conditional formatting to highlight dates in red when they are overdue.

It works until it does not. And when it fails, it fails silently. You do not get an error message telling you a certificate has lapsed. You get a letter from the local authority, a tenant complaint to the First-tier Tribunal, or a civil penalty notice for up to £30,000.

Here are the specific ways spreadsheets fail at compliance tracking, illustrated with a scenario that plays out across the country every week.

The scenario: 3 properties, 39 compliance items

Meet a landlord with three rental properties in England:

Property A — A 2-bed flat with a gas boiler. Standard AST.
Property B — A 3-bed house, all-electric (no gas). Two tenants on separate ASTs.
Property C — A 4-bed HMO with mandatory licensing, gas, and shared facilities.

Across these three properties, the landlord is tracking approximately 39 individual compliance items:

Obligation	Property A	Property B	Property C
Gas safety certificate (annual)	1	0	1
EICR (5-yearly)	1	1	1
EPC (10-yearly)	1	1	1
Smoke alarms (annual check)	1	1	1
CO alarms (annual check)	1	1	1
Deposit protection (per tenancy)	1	2	4
Prescribed information (per tenancy)	1	2	4
Right to Rent checks (per tenant)	1	2	4
Legionella risk assessment	1	1	1
HMO licence	0	0	1
HMO fire safety compliance	0	0	1
How to Rent guide (per tenancy)	1	2	4
Total per property	10	13	24

That is 47 individual items to track (even more than 39 once you count per-tenant obligations in the HMO). Each has its own renewal cycle, its own set of rules, and its own penalty for non-compliance.

Now consider what happens when the spreadsheet fails.

Failure mode 1: No automatic reminders

A spreadsheet sits on your hard drive (or in Google Sheets) doing nothing until you open it. It does not tap you on the shoulder 90 days before your EICR expires. It does not alert you when a tenant's Right to Rent follow-up check is due.

What actually happens: The landlord opens the spreadsheet in January, sees that Property C's EICR expires in August, and thinks "plenty of time." Life gets busy. The next time they check the spreadsheet is September. The EICR expired three weeks ago. Property C is an HMO, so the local authority inspects regularly. They discover the lapse. A remedial notice is issued, followed by a civil penalty.

The cost of an EICR inspection: £200–£350. The cost of the civil penalty: £2,000–£30,000 under the Electrical Safety Standards in the Private Rented Sector (England) Regulations 2020.

Failure mode 2: No jurisdiction logic

A spreadsheet does not know that Property C is in a selective licensing area. It does not know that HMO licensing conditions in one borough differ from another. It does not know that the Smoke and Carbon Monoxide Alarm (Amendment) Regulations 2022 require CO alarms in rooms with a fixed combustion appliance, not just rooms with gas. It does not know that the Renters' Rights Act 2025 is changing Section 21 rules.

What actually happens: The landlord assumes all three properties have the same obligations. They miss that Property C requires a specific HMO licence condition to be met — say, fire doors to be maintained to FD30 standard — because that obligation does not have a row in their generic spreadsheet. The licensing authority discovers the non-compliance during a routine inspection. The landlord faces prosecution for breach of licensing conditions.

Failure mode 3: No evidence linking

Your spreadsheet records that Property A's gas safety certificate was completed on 14 March 2025. But where is the actual certificate? In an email attachment from the engineer? On a hard drive folder called "Property stuff"? In a physical filing cabinet? Could you produce it within 7 days if your local authority requested it?

Under the Gas Safety (Installation and Use) Regulations 1998, you must provide a copy of the gas safety record to existing tenants within 28 days and to new tenants before they move in. You must keep records for 2 years. The spreadsheet tells you the date. It does not store the document.

What actually happens: A tenant makes a complaint. The local authority asks for copies of your gas safety records, EICR, and EPC. You spend two hours searching through email, finding that the 2024 gas safety certificate was sent from an engineer's personal email that you have since deleted. You cannot produce the document. The authority treats this as non-compliance.

Failure mode 4: Version control nightmares

You update the spreadsheet on your laptop. Your partner (who co-owns the portfolio) has an older version on theirs. Your letting agent has a PDF export from six months ago. Nobody is working from the same data.

Even with Google Sheets, version control issues persist: someone accidentally deletes a row, overwrites a date, or sorts a column without sorting the others. There is no audit trail showing what was changed, when, or by whom.

What actually happens: The landlord updates the EICR expiry date for Property B but accidentally types the date into the wrong row (Property A's row). Property B now shows the old, expired date for Property A — but that row already had its own correct date, which has now been overwritten. Property A shows a future date that belongs to Property B. Neither is correct. The error sits undetected for months.

Failure mode 5: Formula and formatting errors

Conditional formatting that turns cells red when a date is past due is only as reliable as the formula behind it. A common setup is =IF(B2<TODAY(), "OVERDUE", "OK"). This works until:

Someone changes the date format in a cell (UK vs US date formats — 03/04/2026 is 3 April or 4 March depending on your locale settings)
A cell contains text instead of a date value (it looks like a date but the formula treats it as text and never flags it)
The formula references the wrong cell after rows are inserted or deleted

These errors are invisible. The cell looks fine. The date appears correct. The formatting just... does not trigger. And you do not find out until after the deadline passes.

What the alternative looks like

Spreadsheets can work for a single property with a handful of obligations. But as your portfolio grows, the failure modes above become increasingly likely. The alternative is a system designed from the ground up to track landlord compliance obligations. That means:

Automatic reminders — Graduated alerts at 90, 60, and 30 days before expiry, plus overdue notifications. You do not have to remember to check.
Jurisdiction-aware logic — The system knows which obligations apply to each property based on its type, location, and features. An all-electric flat gets different requirements from a gas-heated HMO.
Evidence storage — Upload certificates and reports directly linked to the relevant obligation and property. Produce them in seconds if asked.
Per-tenancy tracking — Right to Rent checks, deposit protection, and prescribed information are tracked per tenant, not per property. When a tenant changes, the system creates new obligation entries.
Audit trail — Every change is logged with a timestamp. No silent overwrites.

Check your exposure now

Use the Compliance Deadline Calculator to see exactly when each of your certificates expires, and whether any are already overdue.

If you want to understand the financial risk of each gap, the Landlord Fine Calculator shows you the maximum penalties across all compliance areas.

How DueProper will help

DueProper is building exactly this — compliance tracking software designed for UK landlords, with jurisdiction logic, automated reminders, evidence storage, and per-tenancy tracking. No spreadsheets. No silent failures.

Coming soon — join the waitlist for early access.

Free tools

Compliance Deadline Calculator — check when your certificates expire
Landlord Fine Calculator — estimate your penalty exposure

This article is for information only and does not constitute legal advice. Always verify your obligations with current legislation at legislation.gov.uk.