How to Build an EICR Renewal Pipeline From Old Certificates

If you've been carrying out EICR work for landlords for three or more years and don't currently have a tracking system, the data you need is already sitting in your accounting software. You just haven't extracted and structured it yet.

This post is the practical playbook. One focused afternoon — typically two to three hours — turns five years of EICR invoices into a working renewal pipeline you can act on. No new tools required for the audit step itself, just methodical extraction and a structured spreadsheet at the end.

Once the pipeline exists, you have two choices: run it manually, or hand it to software. We'll cover both, with honest notes on which makes sense for which portfolio sizes.

What You'll End Up With

By the end of the audit, you'll have:

A complete inventory of every EICR you've issued in the last five years
The expiry date for each certificate, calculated and structured
A view of which renewals are coming up in the next 6, 12, and 18 months
A rough estimate of the revenue value sitting in your back catalogue
A starting point for an active reminder system

The output is one CSV file. From there it's either the input to a manual spreadsheet workflow or the import file for software. Either way, the audit itself produces real, immediate visibility into a portfolio you currently can't see clearly.

Step 1: Pull the Last Five Years of EICR Invoices

Open whatever you use for invoicing — Xero, QuickBooks, FreeAgent, a folder of PDFs — and filter for EICR jobs over the last five years.

The reason for five years is simple: residential EICRs are typically valid for that long, so any certificate older than five years is either already past its renewal point or has been renewed by someone else. The renewable pipeline is the work you've issued in the last 60 months.

Most accounting software lets you filter by line-item description or by job category. If you've been consistent about tagging EICR work in your invoices ("Electrical Installation Condition Report," "EICR," or similar), the filter is one click. If you haven't been consistent, you may need to export everything and skim line by line — slower but the same end result.

For each EICR job, you need five fields:

The property address (full, including postcode)
The landlord's name
The landlord's email address
The date the inspection was carried out
Calculated expiry date (typically inspection date + 5 years)

If your invoices don't include landlord email addresses, you have a separate problem to solve — see Step 4 below.

Step 2: Build the Spreadsheet

Open a fresh CSV in Excel, Numbers, or Google Sheets. The columns should match an importable schema, so if you later move to software you don't need to reformat. The free EICR expiry tracker template gives you a ready-made format with the right columns:

landlord_name, landlord_email, landlord_phone, address_line_1, address_line_2,
city, postcode, property_type, certificate_type, issued_date, expiry_date,
estimated_renewal_value

Type one row per certificate. For inspections where the landlord owns multiple properties, add one row per property — even if you carried them all out on the same day. Each property has its own expiry date, its own access requirements, and its own renewal cycle.

A few small habits while you do this:

Standardise the date format. Use YYYY-MM-DD throughout. Mixing formats makes sorting unreliable later.

Include the postcode. Critical for landlords who own multiple properties on similarly-named streets — the postcode disambiguates.

Calculate expiry mechanically. For standard residential EICRs, expiry is inspection date + 5 years. For HMOs in some councils, properties with C2 observations on the previous report, or properties where you issued a shorter certificate at the time, override the calculated expiry with the actual one.

Estimate renewal value if you can. Optional column, but populating it turns the spreadsheet from a list into a pipeline — when you sort by expiry date you can see exactly how much guaranteed revenue is coming up in the next quarter.

Step 3: Sort and Look

With the inventory complete, sort the spreadsheet by expiry date — earliest first.

What you're looking for is the shape of the next eighteen months.

Already expired (past today's date): these are certificates that have already lapsed. Some of these landlords have renewed elsewhere. Some let the certificate run out and haven't renewed at all. A small fraction will still book if you reach out — but the recovery rate on already-expired certificates is significantly lower than on certificates approaching expiry, so don't spend disproportionate effort here.

Expiring in the next 90 days: the urgent pipeline. These need a 90-day reminder right now, ideally within the next few days. This is the highest-value group in the audit because they're recoverable and the timing is right.

Expiring in 90 to 365 days: the medium-term pipeline. You have time to plan, but these need to be in a system that will surface them at the right moment. If you don't have one yet, this is the group that motivates building one.

Expiring beyond 365 days: the steady-state pipeline. Logged and tracked, but no immediate action required. This is what your portfolio will look like once you're operating with a complete tracker — most certificates sitting quietly until they enter the active reminder window.

Most electricians who do this exercise for the first time discover something specific: between 5 and 15 certificates in the urgent window that they weren't actively tracking, plus a handful of already-lapsed ones that quietly went elsewhere. The urgent-window count is the immediate revenue opportunity. The lapsed count is the cost of not having had a system sooner.

Step 4: Fill the Email Gaps

You'll almost certainly find rows where the landlord email address is missing.

This is the single biggest data-quality problem in retrospective audits. Three or four years ago, you didn't necessarily think of email addresses as a critical field — the job got done, the invoice got sent, and the landlord's email was in the email thread but not in your invoicing software.

For each missing email, three options work in order of preference:

Option 1: Search your email archive for the landlord's name or property address. The original quote, booking, or invoice email almost always contains their address. Pull it from there.

Option 2: Send a brief text message asking for the email — "Just updating my records, what's the best email for property correspondence?" — to the phone number you have on file. Most landlords reply within a day.

Option 3: Letter to the property address (rare but useful for landlords you've lost all digital contact with). Lower response rate than the first two but recoverable.

It's worth doing this exercise even for landlords whose certificates aren't due to expire for another two years. Email addresses don't go off, and getting them now saves work later.

Step 5: Plan the Outreach

With a sorted, populated spreadsheet, you now have a working pipeline. The question is what cadence to run it on.

For the urgent-window group (next 90 days): send the 90-day reminder within the next few days — these landlords need a reminder regardless of where else you are in your audit. Use one of the three templates in the email template post and adapt to your business.

For the medium-term group (90 to 365 days): schedule the 90-day reminder for each one, set a calendar event for 60 days before each expiry to send the 30-day reminder, and another for 23 days before for the 7-day reminder. This is the labour-intensive part of the manual workflow.

For the steady-state group (beyond 365 days): these don't need immediate action, but they do need to be in a system that will surface them when they enter the active window.

If your portfolio is fewer than fifteen certificates total, the manual approach above is sustainable. The discipline tax is real but manageable.

When the Manual Pipeline Stops Working

For portfolios bigger than fifteen certificates, the manual cadence above is honestly hard to sustain.

Three reminders per certificate × fifteen-plus active certificates × across a rolling cadence of dates = a meaningful amount of admin every week, forever. Most electricians who set this up manually drop back to a single reminder per renewal within six months — usually the 30-day one — because the workload of running a full three-touchpoint cadence outpaces the available admin time.

That's the point at which it makes sense to hand the pipeline to software. The whole point of the audit step you've just done is to produce a CSV that imports cleanly into an automated system without further reformatting.

Importing the Pipeline Into Recurvia

Recurvia accepts the CSV format above directly. Drop the file into the importer and the platform validates every row, maps the columns automatically, and loads your full back catalogue in one go.

From that point, the platform takes over the parts that don't scale: it surfaces upcoming expiries automatically, sends a three-touchpoint cadence at 90, 30, and 7 days before each renewal in your name and from your business, and routes landlord replies straight to your inbox. You go back to doing the parts of the work that actually need you — the inspections, the bookings, the relationships — instead of the admin.

The free plan covers your first five reminder sends with no card required. For a portfolio bigger than that — most are — Lite or Pro plans unlock unlimited reminders. On Pro, the same automation runs for PAT testing and fire alarm certificates too, so the whole portfolio runs from one upload rather than three separate trackers.

For the underlying maths on what the pipeline you've just built is worth, see the hidden revenue in your old EICR certificates.

Import your existing certificates into Recurvia — free, no card required