Free Rental Certificate Reminder System for Letting Agents

Letting agents managing multiple properties can track every EICR, EPC, gas safety certificate and HMO licence renewal for free using nothing more than Google Sheets, Google Calendar and a Trello board. The systems that prevent compliance lapses are not complicated — the problem is most agents never build them. This guide walks you through exactly how to do it, from someone who spends his working week testing electrical installations across the North East and watching what happens when certificates are missed.

---

Why Letting Agents Get Caught Out by Expiring Electrical Certificates

The most common reason certificates lapse is not negligence — it is volume. An agent managing 40 properties across Newcastle, Sunderland and Durham might have 40 EICRs, 40 gas safety records, 30-odd EPCs and a handful of HMO licences all on different renewal dates. Add selective licensing requirements in certain local authority areas and the number of live documents climbs further.

The second problem is handover. When a property moves between landlords, or when a member of staff leaves, the paper trail breaks. Nobody inherits the reminders. A certificate that was current 18 months ago quietly expires and nobody notices until a tenant complains, a council inspector calls, or worse — something goes wrong.

The Electrical Safety Standards in the Private Rented Sector (England) Regulations 2020 made this harder to ignore. Local authorities can now issue remediation notices and civil penalties of up to £30,000 per breach for non-compliance. That is not a hypothetical. Councils in England have been using these powers.

---

What Certificates Need Tracking: The Full UK Rental Compliance List

Before building any system, you need a complete list of what you are tracking. For most English residential lets, that includes:

EICR (Electrical Installation Condition Report) — required under the Electrical Safety Standards in the Private Rented Sector (England) Regulations 2020
Gas Safety Certificate — required annually under the Gas Safety (Installation and Use) Regulations 1998
Energy Performance Certificate (EPC) — required at letting, currently valid for 10 years
Portable Appliance Testing (PAT) — not legally mandated for private residential lets but strongly advisable where landlord-supplied appliances are present
Legionella risk assessment — required under the Health and Safety at Work etc. Act 1974; frequency depends on property type and risk factors
HMO licence — where applicable, typically renewed every 5 years but varies by local authority
Selective licensing registration — where applicable, check your specific local authority
Smoke and carbon monoxide alarm compliance record — under the Smoke and Carbon Monoxide Alarm (Amendment) Regulations 2022

---

Step 1: Build Your Free Master Compliance Spreadsheet (Google Sheets Template)

Open a new Google Sheet and set up the following columns:

For the Days Remaining column, use a formula like `=EXPIRY_DATE_CELL - TODAY()`. Apply conditional formatting: red for anything under 30 days, amber for 31–60 days, yellow for 61–90 days, green for over 90 days.

One row per certificate per property. A 40-property portfolio will generate roughly 150–200 rows when fully populated. That sounds like a lot, but once it is built, maintenance is minimal — you update a row when a job is done and the colour coding does the alerting for you.

Share the sheet with your whole team so that whoever books the job can update the record immediately. Keep it in a shared Google Drive folder rather than on a personal account that walks out the door when a staff member leaves.

---

Step 2: Set Automated Email Reminders Using Google Calendar or Outlook

Your spreadsheet tells you what is expiring. Your calendar tells you when to act.

In Google Calendar, create a separate calendar called "Property Compliance" and add recurring events for each renewal. Set email notifications at 90, 60 and 30 days before expiry. This takes roughly 10 minutes per certificate the first time you set it up.

In Microsoft Outlook, use recurring appointments with reminder alerts. You can set multiple reminders on a single event — something most people do not realise. Set one at 90 days out, flag it for follow-up, and add a note with the contractor's name and the property address.

Neither of these costs anything. Neither requires a subscription.

---

Step 3: Add a 90-Day, 60-Day and 30-Day Warning Tier System

A tiered warning system gives you time to act rather than react.

90 days out: Contact your preferred NICEIC approved contractor or NAPIT registered electrician to provisionally book the EICR. Electrical contractors across the North East are often booked several weeks in advance, particularly in busy periods.
60 days out: Confirm the booking. Notify the landlord. If the property is tenanted, give appropriate notice for access.
30 days out: If the work is not booked and confirmed, escalate to a senior staff member. Do not let this tier pass without action.

Colour-code your spreadsheet to match these tiers and review the sheet at your Monday morning team meeting. That is genuinely all the process you need.

---

Step 4: Use Free Tools Like Trello or Notion to Assign Contractor Tasks

Once a certificate is flagged for renewal, you need a way to assign the job and track it through to completion without chasing emails.

Trello works well for this. Create a board called "Property Compliance Jobs" with columns: To Book | Booked | Access Arranged | Certificate Received | Spreadsheet Updated. Create a card for each job, add the property address, due date and assignee, and move it through the columns as the job progresses.

Notion is slightly more powerful if you want to link your property database to a task tracker, but it has a steeper learning curve. For most small letting agencies, Trello is quicker to set up and easier to maintain.

Both tools are free at the level most small agencies need.

---

How Often Does an EICR Need Renewing? A Qualified Electrician Explains

Under the Electrical Safety Standards in the Private Rented Sector (England) Regulations 2020, an EICR is required at least every five years for private rented properties in England, or more frequently if the report itself specifies a shorter interval.

Here is the part people sometimes miss: the EICR itself carries a "next inspection recommended" date set by the inspecting electrician based on the condition of the installation. If the installation is older, has had previous remedial work, or receives a C3 code (improvement recommended) for multiple items, the inspector may recommend reinspection in three years or even sooner. That recommendation is not optional guidance — it reflects the actual condition of the installation assessed against BS 7671 18th Edition Wiring Regulations.

Where a report identifies C1 codes (danger present) or C2 codes (potentially dangerous), the installation must be made safe before a valid certificate can be issued. A landlord cannot simply hold a report showing unsatisfactory results and consider the obligation discharged. The remedial work must be completed and verified.

---

What Happens If an EICR Expires Mid-Tenancy in England

If an EICR expires during an ongoing tenancy, the landlord is in breach of the Electrical Safety Standards in the Private Rented Sector (England) Regulations 2020 from that point. The local housing authority can issue a remediation notice requiring a new inspection within 28 days, and if that is not complied with, they can arrange the inspection themselves and recover the cost from the landlord — plus issue a civil penalty of up to £30,000.

As a managing agent, you may also have contractual liability to the landlord depending on the terms of your management agreement. This is worth checking with your professional indemnity insurer.

The safest position is straightforward: do not let EICRs expire. The system described in this article costs nothing to build and prevents this situation entirely.

---

Free vs Paid Property Management Software: When to Upgrade

The spreadsheet-and-calendar approach described here works reliably for portfolios up to around 50–75 properties, depending on how complex your compliance picture is. Beyond that, or where your team is larger and coordination becomes harder, paid property management platforms start to earn their cost.

Tools like Arthur Online, Fixflo or Jupix offer built-in compliance tracking, automatic reminders and document storage. Costs vary considerably — check current pricing directly with each provider rather than relying on any figures quoted here, as these change regularly.

The honest advice is this: if your free system is working and you are not missing certificates, there is no urgent reason to pay for software. If you are finding the manual system is regularly breaking down, that is your signal to upgrade.

---

How Energy North Ltd Supports Letting Agents Across the North East

We work regularly with letting agents and landlords across Newcastle, Sunderland, Gateshead, Durham, Teesside and the surrounding areas. The majority of our rental work is EICRs and the remedial work that follows — consumer unit upgrades, circuit repairs, earthing improvements — all carried out by NICEIC-approved electricians working to BS 7671 18th Edition Wiring Regulations.

We understand how letting agents operate. We can work around tenant access schedules, return certificates promptly in a format that satisfies local authority requirements, and flag anything on an installation that is likely to cause problems at the next inspection rather than leaving it as a surprise.

If you are managing properties with upcoming EICR renewals, or if you have inherited a portfolio where the compliance history is unclear, we are straightforward to deal with and happy to discuss what you actually need rather than upsell you work you do not.

---

Frequently Asked Questions

How often does an EICR need to be renewed for a rental property in England?

At least every five years under the Electrical Safety Standards in the Private Rented Sector (England) Regulations 2020, or more frequently if the EICR itself specifies a shorter interval based on the condition of the installation.

What is the fine for a landlord or letting agent who fails to provide a valid EICR to a tenant?

Local authorities in England can issue civil penalties of up to £30,000 per breach under the Electrical Safety Standards in the Private Rented Sector (England) Regulations 2020. There is no fixed tariff — the amount is set by the local authority based on the circumstances.

Can a letting agent be held liable if an electrical certificate expires on a managed property?

Potentially, yes — both under the terms of the management agreement with the landlord and under general property management law. The extent of liability depends on what the management agreement specifically says about compliance obligations. Agents should review this with their professional indemnity insurer and seek legal advice if uncertain.

Is a new EICR required when a new tenancy starts or only every five years?

You must provide a copy of a valid EICR to a new tenant before they occupy the property. If the existing EICR is still within its valid period and was issued no more than five years ago (or less, if a shorter interval was recommended), a new inspection is not legally required solely because a new tenancy has started. However, if the existing report is close to expiry, it is generally sensible to renew it.

What free tools can a small letting agent use to track multiple property certificates without paying for software?

Google Sheets for a master compliance tracker with conditional formatting and days-remaining formulas; Google Calendar or Microsoft Outlook for tiered email reminders at 90, 60 and 30 days; and Trello or Notion to assign and track contractor jobs through to completion. All of these are free at the level a small letting agency typically needs.

---

If you manage rental properties across the North East and want to get your EICR schedule under control, we are happy to have a no-pressure conversation about what you have, what is coming up, and what is likely to need attention. You can reach Energy North Ltd at [energynorth.uk](https://energynorth.uk).