When does a compliance spreadsheet stop working for a letting agent?

Between 5 and 10 properties. Beyond that you are tracking 40+ individual deadlines across different renewal cycles, with no reminders, no audit trail, and no accountability if a colleague edits the wrong cell. The first missed certificate — gas safety at £6,000 per breach, EICR at £30,000 — costs more than years of dedicated software.

What is the best alternative to a compliance spreadsheet for letting agents?

A dedicated compliance tracking platform like Proplio is the closest like-for-like replacement: it imports directly from your spreadsheet, adds automatic reminders at 90/60/30/14/7 days, provides a portfolio-wide RAG dashboard, and generates audit-ready PDF reports for council inspections. Property management suites such as Arthur Online or Reapit also include compliance modules but typically as a secondary feature.

Can I import my existing compliance spreadsheet into Proplio?

Yes. Proplio supports CSV import, so you can export your current spreadsheet and upload it in one go. Property addresses, certificate types, expiry dates, and contractor details all transfer in minutes. You do not need to re-enter your data manually.

How long does it take to switch from a spreadsheet to compliance software?

For a portfolio of 20–100 properties, the migration itself takes around 30 minutes: export your spreadsheet to CSV, clean up any obvious errors, import into the platform, and validate the dashboard against your records. Document upload (attaching the actual PDF certificates) is the longer task and can be done property by property as renewals come up.

Will my colleagues need training to switch from a spreadsheet to compliance software?

Modern compliance platforms are designed to mirror what letting agents already do — log a certificate, set the expiry date, get reminded before it lapses. Most teams are productive within a day. The bigger shift is mental: trusting the system to remind you instead of checking the spreadsheet manually.

Is dedicated compliance software worth it for a small letting agency?

If you manage more than 5 properties and rely on a spreadsheet today, yes. At £29 per month flat, Proplio costs less than two hours of your time per month — and one missed gas safety certificate (£6,000 fine) pays for over 17 years of subscription. The real risk is not the software cost; it is the absence of reminders and audit trail when a council inspector or insurer asks for proof.

Letting Agent Compliance Software vs Spreadsheet: When (and How) to Switch

The compliance spreadsheet every letting agent has built

If you run a letting agency, you have either built a compliance spreadsheet or inherited one. It probably has columns for property address, gas safety expiry, EICR expiry, EPC expiry, smoke and CO alarm check date, and maybe a conditional-formatting rule that turns cells red when a date is overdue.

For a handful of properties, this works. For 20, 50, or 100+ properties, it quietly stops working — usually months before anyone notices. The spreadsheet does not fail loudly. It just gradually becomes the thing that is going to cause a missed deadline, and you do not find out until a council inspector, a tenant solicitor, or an insurer asks a question you cannot answer.

This guide is for letting agents who suspect they have outgrown their spreadsheet but have not yet made the switch. We will cover the signs the spreadsheet is failing, what to switch to, and how to migrate in under an hour without losing data.

The hidden costs of a compliance spreadsheet

Spreadsheets are free. The hidden costs show up everywhere else.

No reminders

A spreadsheet does not email you. You have to remember to open it, scroll through it, and check what is about to expire. If you forget for two weeks because you are dealing with a tenancy renewal, a leak, and a viewing, certificates slip past expiry without anyone noticing.

Most letting agents try to solve this with calendar reminders. That just creates a second system to maintain — every certificate now has to be tracked in two places, and updates have to happen in both. The first time someone updates the spreadsheet but forgets the calendar (or vice versa), the system breaks silently.

No audit trail

When a council inspector or insurer asks for proof of compliance, a spreadsheet is not enough. They want the actual certificate, dated, signed, with a verifiable record of when the work was carried out and by whom. That means digging through email attachments, cloud drives, or filing cabinets and reconstructing a timeline manually. For one property it is annoying. For a portfolio of 100, it is a full day's work — and that is assuming you can find every document.

No accountability

A shared spreadsheet has no record of who changed what and when. If a colleague accidentally overwrites a date, deletes a row, or types the wrong year, you have no way of knowing it happened until something goes wrong. With staff turnover, this becomes a real problem: the person who set up the spreadsheet leaves, the new starter does not understand the conventions, and small errors compound over months.

Human error at scale

A letting agency managing 100 properties is tracking 800+ individual compliance deadlines (gas, EICR, EPC, legionella, smoke and CO, right to rent, HMO conditions, deposit protection deadlines, and more). One typo in a date, one sort that scrambles rows, one tab not updated after a renewal, and a certificate quietly lapses.

The fines for non-compliance are not theoretical:

Gas safety: up to £6,000 per breach
EICR: up to £30,000 per breach
HMO licence: up to £30,000 per property
Right to rent: up to £20,000 per tenant
Deposit protection: up to 3× the deposit per tenancy

One missed certificate costs more than two decades of dedicated software.

Five signs you have outgrown the compliance spreadsheet

If two or more of these apply, it is time to switch:

1You manage more than 10 properties. Beyond this, you are tracking 80+ individual deadlines across different renewal cycles. The spreadsheet stops fitting in your head.
2More than one person updates it. As soon as compliance is a team responsibility, you need accountability and an audit log — neither of which a spreadsheet provides.
3You have ever missed a renewal — even by a day. Near misses are the system telling you it is going to fail. The next one might not be a near miss.
4A council inspection or audit would take you more than an hour to prepare for. If you cannot pull a complete compliance pack for any property in a few clicks, your audit trail is not ready.
5You spend more than 30 minutes a week maintaining the spreadsheet itself. That is your signal that the tool is now creating work, not removing it.

What letting agents switch to

There are three realistic destinations when leaving a compliance spreadsheet:

1. Dedicated compliance tracking software

Purpose-built for the job. The closest like-for-like replacement for a spreadsheet — same workflow (log a certificate, log an expiry date), but with automatic reminders, dashboards, audit trails, and reports built in.

Example: Proplio — £29/month flat, unlimited properties, all UK compliance types, audit-ready PDF reports, landlord read-only sharing, CSV import direct from your spreadsheet.

Best for: Letting agents who want compliance handled properly without paying for a full property management suite.

2. Property management software with compliance features

Platforms like Arthur Online, Reapit, or Fixflo include compliance tracking as part of a broader feature set covering tenancies, repairs, and rent collection.

Best for: Agents who want everything in one platform and are willing to pay £100–£500+/month for the full suite. The compliance modules are typically less detailed than purpose-built tools.

3. A better spreadsheet (not recommended)

Some agents try to solve the problem by building a more elaborate spreadsheet — pivot tables, scripts that send reminder emails, conditional logic. This rarely ends well. You are reinventing software in Excel, badly. When the person who built it leaves, no one understands how it works, and the whole thing collapses.

If you are tempted to do this, the time you would spend building and maintaining a complex spreadsheet costs more than a year of dedicated software.

For a deeper comparison of the dedicated compliance platforms available in 2026, see our guide to the best compliance tracking software for letting agents.

How to migrate from a spreadsheet to compliance software

The migration itself is faster than most people expect. For a 50-property portfolio, you should be live on the new system within 30 minutes. Here is the process.

Before you start: clean the spreadsheet

Open your existing compliance spreadsheet and do a quick audit:

Standardise date formats. Make sure every date is in the same format (DD/MM/YYYY is safest). Mixed formats are the most common cause of import errors.
Remove blank rows. Empty rows between properties confuse most CSV importers.
Fix obvious typos. Look for property addresses with extra spaces, postcodes with missing letters, dates that are clearly wrong (a "2030" expiry in 2026 usually means 2026).
Decide on certificate type names. Pick consistent labels — "Gas Safety" not a mix of "Gas", "CP12", and "Gas Cert". Most platforms expect standardised compliance type names.

This cleanup takes 10–15 minutes and saves an hour of debugging later.

Step 1: Export to CSV

In Excel: File → Save As → CSV (Comma delimited).

In Google Sheets: File → Download → Comma-separated values (.csv).

If your spreadsheet has multiple tabs (one per property type, for example), export each tab separately or consolidate them into a single sheet first.

Step 2: Import into the platform

Most dedicated compliance tools have a CSV import function in the settings or onboarding flow. With Proplio, it is on the Properties page — upload the CSV, map your spreadsheet columns to the platform's fields, and confirm.

The mapping step is where most issues surface. Common fixes:

Spreadsheet column "Address" maps to platform field "Property Address"
Spreadsheet "Gas Expiry" maps to "Gas Safety Certificate Expiry Date"
Spreadsheet "Engineer" maps to "Contractor"

If a column does not map cleanly, you can usually skip it and add the data manually later.

Step 3: Validate the dashboard

Once imported, your portfolio should appear on the compliance dashboard. Spend 5 minutes spot-checking:

Does the property count match your spreadsheet?
Are the expiry dates correct on a few sample properties?
Are properties showing the right RAG status (Red for overdue, Amber for due soon, Green for compliant)?

If something looks off, fix it in the platform — do not go back to the spreadsheet.

Step 4: Set up reminders and team access

Add your colleagues as users so reminders go to the right people. Configure who receives notifications for which property (most platforms let you assign a property to a specific team member or branch).

Step 5: Upload existing certificates

This is the slowest part — uploading the actual PDF certificates so your audit trail is complete. You do not have to do all of them at once. Most agents:

Upload certificates for all overdue and due-soon properties first
Upload the rest as renewals come up over the next 12 months

After 12 months, every certificate in the system will be one you have uploaded directly, and your audit trail is complete.

What changes after the switch

The first thing most letting agents notice is that they stop opening the spreadsheet. The reminders arrive on their own, the dashboard tells them at a glance whether anything needs attention, and the weekly "let me check the spreadsheet" ritual disappears.

The second thing is that audits become trivial. When a council inspector asks for compliance proof on a property, you generate a PDF report in one click instead of spending an hour assembling documents.

The third thing is harder to measure but more valuable: peace of mind. You stop worrying about whether you missed something. The system catches deadlines for you.

Key takeaways

Spreadsheets work for the first 5–10 properties and then start to fail silently
The hidden costs are missed reminders, missing audit trails, no accountability, and human error at scale
The fines for non-compliance (£6,000 to £30,000 per breach) dwarf the cost of any dedicated tool
The best replacement is a purpose-built compliance platform, not a more elaborate spreadsheet
Migration is fast — 30 minutes for a 50-property portfolio if you clean the spreadsheet first
The biggest gain is not features, it is no longer having to remember to check the spreadsheet

Related guides on Proplio:

This article reflects our honest assessment of the move from spreadsheet-based compliance tracking to dedicated software. Proplio is our product — we have tried to be transparent about the migration process, the trade-offs, and what to look for in any tool.