The Spreadsheet Trap: Why Certificate Tracking Breaks Down as Your Portfolio Grows

Most landlords and letting agents start the same way: a spreadsheet with a column for each certificate and a colour code for "expiring soon." It works. For a while.

The trouble isn't that spreadsheets are a bad tool. It's that they're the wrong tool for a job that has a deadline attached to it. A spreadsheet doesn't know today's date. It doesn't know when a tenancy changes hands, when a contractor books, or when a certificate a colleague uploaded three weeks ago actually expires. It only knows what you last typed into it. Everything else — the checking, the chasing, the noticing — is still work a person has to do, every single time.

Why it feels fine at first

At five or ten properties, a spreadsheet is genuinely manageable. One person owns it, checks it weekly, and has enough context in their head to catch most problems before they become urgent. The colour coding does its job because the portfolio is small enough that nothing slips out of view for long.

That's the trap. The spreadsheet doesn't fail because it was always broken — it fails because it scales linearly with effort while your portfolio scales with growth. Add more units, add a second person managing them, add a few months where you're busy with something else, and the gap between "the sheet says it's fine" and "it's actually fine" starts to widen without anyone noticing.

Where it actually breaks

A few patterns show up again and again in conversations we've had with landlords and agents who've made the switch to something more structured:

The single owner problem. One person maintains the sheet. When they're on leave, change roles, or simply forget to update a row after a contractor visit, there's no second check. The sheet keeps looking authoritative even when it's quietly wrong.

Conditional formatting isn't a deadline system. Colour changes tell you something is close to expiring only if someone opens the sheet and looks. There's no reminder that reaches into an inbox unprompted, no escalation if the first reminder gets ignored, and no record of who was supposed to act on it.

Certificates and evidence live in different places. The spreadsheet says a Gas Safety check was done on a given date, but the actual CP12 PDF is in an inbox, a shared drive folder, or a contractor's own records. When you need to produce it — for a tenant, a mortgage lender, or a local authority — you're searching, not retrieving.

No audit trail. If a certificate lapses and something goes wrong, "the spreadsheet said it was fine" isn't much of a defence, and there's usually no record of when the row was last updated, by whom, or based on what evidence.

None of this is a criticism of the people running it. A spreadsheet genuinely can't do the things a deadline-driven system needs to do: check the date against today, notify the right person automatically, escalate if nothing happens, and keep the evidence attached to the deadline it belongs to.

What good compliance admin actually looks like

The properties that stay consistently compliant tend to share a few habits, regardless of what software they use:

Every certificate has one home — not a folder that duplicates a spreadsheet row, but a single record that holds the document, its expiry date, and the reminder that fires against it. Reminders go out automatically and escalate if ignored, rather than depending on someone remembering to check. And the record survives staff changes: if the person who normally handles compliance is away, the deadline still gets tracked and the reminder still fires, because it isn't sitting in their personal inbox or their head.

This is really the core of what CertMinder UK is built to do — not to replace your judgement about which contractor to book or how to handle a tricky tenant, but to make sure the dates, the documents, and the reminders don't depend on one person's memory. We don't take referral fees or kickbacks from the contractors in our system either, which matters here: a tool that's meant to keep you compliant shouldn't have a financial reason to steer who you book.

Making the switch without a big project

You don't need to migrate everything at once. Start with whatever's closest to expiring — pull those rows out of the spreadsheet first, set them up with proper reminders, and let the rest follow as certificates come up for renewal naturally. Within one full compliance cycle (roughly a year, given Gas Safety checks are annual and EICRs run on a five-year cycle), the spreadsheet becomes redundant on its own.

The goal isn't a more impressive system for its own sake. It's removing the single point of failure that a spreadsheet always has: one person, one file, one moment of forgetting.

This article is informational and not legal advice. For current compliance obligations and deadlines, always check official government guidance.