Why Spreadsheets Fail for EICR Renewals
Spreadsheets are the default tool for tracking EICR renewals — and they quietly fail electricians within months. Here's why, and what works instead.
Almost every electrician carrying out EICR work for landlords starts the same way: open a spreadsheet, type in the column headers, and start logging. It's the obvious tool. It costs nothing, runs everywhere, and the columns stay where you put them.
For the first few months, it works. Then it doesn't — and the reason it stops working isn't laziness, lack of discipline, or bad data hygiene. The problem is structural. Spreadsheets are the wrong shape of tool for the job, and no amount of effort makes them the right shape.
This is the autopsy: the four ways a renewal-tracking spreadsheet quietly fails, why the failures get worse with portfolio size, and what an actual working system looks like.
The Core Problem: Spreadsheets Are Passive
A spreadsheet only does something when you open it. Until you do, it's a flat file sitting on a hard drive — accurate, organised, and completely silent about the certificate that's expiring next week.
That sounds obvious, but it's the source of every other failure on this list. Renewal tracking is fundamentally an active problem: certificates expire on dates you can't predict the salience of, landlords need to be contacted at specific intervals, and the work that needs doing this week doesn't announce itself unless something forces it to.
A passive tool can't solve an active problem. It can only record what an active human has done. And the active human in this story — you — is also running quotes, invoicing, attending callouts, ordering parts, and managing tenant access. The spreadsheet is competing with all of that for your attention, and it loses every time.
Failure Mode 1: Logging Drift
The first thing that breaks is the habit of adding new certificates the day you issue them.
In month one, every certificate goes in. By month three, the busy weeks start producing gaps — you finish a job on a Friday afternoon, send the invoice, and forget the spreadsheet entirely. By month six, your tracker contains maybe 70% of the certificates you've issued, and the missing 30% are scattered across PDF folders, emails, and your accounting software.
This is the most damaging failure mode because it's invisible. You don't notice the missing rows. The spreadsheet looks complete. Five years later, when those missing certificates come up for renewal, you have no record they exist. The landlord either remembers you (and gets in touch reactively) or doesn't, and you never know which.
For a sole trader carrying out twenty to thirty EICRs a year, this single failure mode quietly drains a meaningful percentage of recoverable renewal revenue out of the pipeline before any reminder ever gets sent.
Failure Mode 2: The Discipline Tax
Even when the data is complete, the spreadsheet still requires you to remember to look at it.
The standard advice is to set a calendar reminder — first Monday of every month, open the file, scan the expiry column, send reminder emails to anything coming up in the next 90 days. On paper this works perfectly. In practice it falls apart inside six months.
The reason isn't that you're bad at calendars. It's that the recurring slot has to compete with whatever else is on your plate the morning of the first Monday — a fault callout, an invoice run, a parts collection, a tenant chasing about access. The spreadsheet review loses every comparison against any time-sensitive operational work, and once it's been skipped twice, the habit is broken.
After that, the tracker only gets opened when something external triggers it: a landlord chases you about their certificate, you remember a specific job from a few years back, or you're trying to close out the financial year. The system has gone from proactive to reactive, which is exactly the state it was meant to fix.
Failure Mode 3: The Single-Touchpoint Cap
Even when you do remember to check the spreadsheet and send reminders, the format of the work caps your reply rate.
Drafting a personalised reminder email for each upcoming renewal takes time. For a portfolio of thirty active certificates with three to five amber rows on a typical Monday, you're looking at anywhere from 30 minutes to an hour of inbox work — looking up addresses, checking last contact dates, copying and pasting from a template, double-checking the expiry maths.
That cost effectively forces you into a single-touchpoint reminder per renewal cycle. There's no realistic world where you also send a follow-up at 30 days and a final reminder at 7 days for every certificate, because the manual workload triples and you're already at capacity.
A single reminder is a coin flip. The landlord either sees it at a moment they can act, or doesn't. Most don't, and the renewal that would have been recovered with a 30-day follow-up never gets booked.
The maths on this is significant. The difference between a one-touch and a three-touch cadence is typically a 2x to 3x improvement in booking rate. On a thirty-certificate portfolio, that's three to six additional renewals per year — well over a thousand pounds of revenue that the spreadsheet structurally can't deliver, no matter how disciplined you are.
Failure Mode 4: Reply Routing
The fourth failure mode hits even when everything else has gone right.
You logged the certificate. You remembered the monthly review. You sent a reminder. The landlord replied — and the reply lands in your inbox alongside the agent chasing you about a fault, the supplier confirming a delivery date, the friend asking about the weekend, and seventeen marketing emails. By the time you scan back through that thread, the renewal reply might be a day or two old. By the time you respond, the landlord has cooled off, called someone else, or simply forgotten that they wanted to book.
A good reply, missed by 48 hours, often becomes a job that goes elsewhere. The spreadsheet has no way to surface the reply or distinguish "renewal lead ready to book" from "tenant complaint that needs a callout this afternoon." Both look the same in your inbox.
What Actually Replaces a Spreadsheet
The replacement isn't a different tool. It's a different shape of tool.
A working renewal system has three properties a spreadsheet structurally can't:
It captures certificates without you doing anything. New certificates get added as part of an existing workflow — the same action that sends an invoice, marks a job complete, or closes out a calendar entry. No separate logging step that competes for attention with operational work.
It surfaces upcoming expiries on its own. You don't open it to check; it tells you. Or, better, it acts on your behalf. The active part of "active problem, active tool" lives in the system, not in your willpower.
It runs a multi-touchpoint cadence at no additional human cost. Sending three reminders per certificate is the same amount of work as sending one — because the work is configuration, not execution.
You can implement those three properties yourself with a combination of CRM, calendar, and email automation tools. Plenty of electricians have done it, and it works — provided the setup time, learning curve, and maintenance overhead are worth the cost for your portfolio size.
The simpler version, designed specifically for the way EICR renewals work, is Recurvia. Import the spreadsheet you already have, check the email addresses are right, and the platform takes over — surfacing upcoming expiries, sending the 90/30/7 cadence in your name, and routing replies straight to your inbox. No manual review slot, no monthly admin, no logging drift, no missed follow-ups.
The free plan covers the first five reminder sends with no card required. If your portfolio is bigger than that — most are — the Lite or Pro plans unlock unlimited reminders. On Pro, the same automation runs for PAT testing and fire alarm certificates too.
A Note on Effort
The instinct, when a spreadsheet starts failing, is to try harder — set more reminders, build more conditional formatting rules, switch to a different spreadsheet tool, sign up for a paid version of Excel.
None of that fixes the structural problem. The tool is passive. Effort is finite. The only durable fix is to move the work from a place where it competes with your operational schedule to a place where it doesn't compete at all.
For a deeper look at where the revenue actually leaks out of a manual pipeline, see the companion post on losing renewal work.
Switch to automated EICR renewal reminders — free, no card required