How to organise property compliance documents without spreadsheets

Most letting agencies start with a spreadsheet that has one row per property, a column per certificate and a date in each cell. It can work well for a small portfolio. It gets harder to keep accurate when the documents themselves live in several inboxes and a shared drive, when several people keep their own copies, and when nobody opens it on the week a date passes. This guide covers the model that replaces it, and the practical order for moving a portfolio across without a gap.

Where a spreadsheet needs extra work

A well-built spreadsheet can do more than it is given credit for. The question is how much setting up and upkeep each part takes, and who does it.

• Keeping the document with the date. A cell can link to the certificate file, but someone has to add each link and fix it when a folder is renamed. A date on its own is only a claim, and the certificate is the evidence a tenant or council will ask for.
• Telling you in time. A highlight rule can colour a date that is 23 days away, but only someone who opens the file sees it.
• Showing who changed what. Excel's Show Changes and version history record who edited which cell, when everyone works in the shared workbook with a current version of Excel. Edits made in an older version, or in a copy that was emailed or saved locally, are not tracked there.
• Connecting to the work. The engineer booking, the tenant copy and the remedial job usually live somewhere else.

How to organise documents instead

1. One place per property. Every certificate is filed against the property it belongs to, not in a folder named after the month it arrived.
2. The expiry date recorded once, with the file. Status (valid, expiring, expired, missing) is worked out from that date, not typed by hand.
3. Rules per property type. Decide which document types every property must hold (gas safety, EICR, EPC), and which apply only to HMOs (for example a fire risk assessment), so a gap is visible before anyone asks. The list of what each property needs is in what certificates a UK rental property needs.
4. Reminders that reach a person. An email on the days something is due, not a report someone has to remember to run.
5. A record of changes. Who uploaded, who corrected a date, who marked a job done.

Clean the data before you move it

The move itself is usually an afternoon. The part that takes longer is deciding what is true, when there are three spreadsheets with slightly different addresses for the same flat, a tenancy end date that was never updated, and a certificate “on file” that nobody can find. Do the cleaning in the spreadsheet, where it is fast, then move once.

• One row per property, with a full address including postcode, written the same way everywhere.
• Property type (residential, HMO, commercial) and the number of units for buildings with several.
• Contacts with a name, an email and a type (landlord, tenant, applicant, contractor), one per row.
• Tenancies with the property address, start date, status and the tenant's name as it appears in contacts.
• Dates as dates (2026-03-14), not “March” or “ASAP”.

Move it in this order

1. Properties. Everything else hangs off them.
2. Contacts. Landlords, tenants, applicants and contractors.
3. Owner links and tenancies. These need the property and the contact to already exist.
4. Maintenance and tasks. Open items only; history can stay in the old file.
5. Certificates. Upload these against each property with their expiry dates. Start with anything due in the next 90 days, because those are the ones a missed week would hurt.

Before you switch the spreadsheet off

• Spot-check ten properties end to end: address, tenancy, rent, documents.
• Confirm every property with gas has a gas safety record on file with the right expiry date, using the preserved date if the last check used the early-renewal window (how that rule works).
• Run one week with both in parallel, then freeze the spreadsheet and keep it read-only as an archive.
• Put the weekly review in the diary, so the new system is looked at on a fixed day rather than when something goes wrong.

Verixad is built around this model. Properties come first, documents with expiry dates are attached to them, and there are required-document rules per type, a compliance timeline, a weekly summary and morning reminders you can switch on. It imports properties, contacts, tenants, applicants, owner links, tenancies, certificate dates, maintenance and tasks from a spreadsheet, with a sample file for each type, and shows a preview with any problems before anything is saved. See documents, compliance and imports, or, if you are still choosing a product, what to look for in compliance software.