How to track property safety certificates without spreadsheets

Almost every letting agency and landlord starts the same way: a spreadsheet with a row per property and a column per certificate. It works — right up until the portfolio, the team or the certificate list grows. Then the spreadsheet fails, and it fails silently, which is the worst way for compliance tracking to fail.

The four ways certificate spreadsheets break

• They depend on someone looking. A spreadsheet never interrupts anyone. If the person who normally checks it is on leave the week a gas certificate lapses, nothing happens — which is precisely how most missed renewals occur.
• The data goes stale invisibly. A renewed certificate that never gets typed back in looks identical to a lapsed one that was never renewed. The spreadsheet can't tell you which rows are wrong.
• The document and the date live apart. The expiry date is in the spreadsheet; the certificate itself is in a shared drive, an inbox, or a filing cabinet. When a council or tenant asks for the actual document, the scramble starts.
• There's no audit trail. If a lapse is ever challenged, “the spreadsheet said it was fine” is not an evidence trail. Who uploaded what, when it was checked, and when tenants received copies — none of that exists in a grid of dates.

What a reliable system actually needs

Replacing the spreadsheet isn't about prettier software; it's about removing the failure modes above. Four properties matter:

• One source of truth per property — the certificate document and its dates stored together, against the property record, not in parallel systems that drift apart.
• Dates read from the document itself — expiry dates extracted from the uploaded certificate rather than retyped, so the recorded date can't silently disagree with the paper.
• Reminders that escalate — a system that interrupts you as a deadline approaches, rather than waiting to be checked, and gets louder the closer the date gets.
• A portfolio-wide view — one screen that answers “what's expired, what's expiring, what's missing” across every property, so triage takes minutes rather than an afternoon of scrolling rows.

What this looks like in Verixad

This is the specific problem Verixad was built around. You upload a certificate — a CP12, an EICR, an EPC — and it reads the document, identifies the type and extracts the expiry date, showing you what it found before anything is trusted. Reminders are created automatically and escalate as expiry approaches, and the compliance overview scores the whole portfolio so the most urgent property is always at the top. The features page shows the full workflow, and pricing starts with a 15-property plan sized for exactly the portfolios that have outgrown the spreadsheet.

Migrating without retyping everything

The reason most teams keep the spreadsheet is the switching cost of re-entering years of data. Verixad imports properties, contacts, tenancies and more from CSV or Excel — with column mapping, validation and a downloadable error report — so the existing spreadsheet becomes the migration file rather than the thing you're chained to.