Reporting portfolio compliance to landlords without a spreadsheet marathon

A landlord asking "are my properties compliant?" is a reasonable, ordinary question, and it shouldn't require an agent to pull together a bespoke answer from three different spreadsheets every time it's asked. But for a lot of managing and letting agents, that's exactly what it does mean — and the more properties and landlords involved, the more that becomes a genuine drain on time.

What a landlord actually wants to know

Underneath the general question, landlords are usually asking a small number of specific things: are the gas, electrical and EPC certificates current, as covered in tracking certificate expiry across a portfolio; is anything outstanding that needs their attention or approval; and is anything about to come due that they should know about in advance rather than being surprised by later.

Proactive reporting beats reactive reporting

A landlord who receives a short, regular update — even a simple one, sent quarterly — tends to ask far fewer ad hoc questions than one who only hears from the agent when something's overdue or when they've specifically chased for an update. The regular update doesn't need to be exhaustive; it needs to be reliable and to arrive without being asked for.

Repairs and compliance are really one picture, not two

A landlord's view of their property's condition and its compliance status are closely linked — an ongoing repair that's affecting an EICR finding, say — and reporting the two separately, in different formats, from different systems, makes it harder for a landlord to get a genuinely coherent picture. This connects directly to how repairs get managed across a multi-landlord portfolio, since the same underlying data usually feeds both.

• –A short, regular update sent proactively, not only produced on request
• –Certificate status, outstanding actions, and upcoming renewals covered in one place, not three
• –Repairs and compliance reported together where they're related, not as separate, disconnected updates
• –A format simple enough that a landlord can actually read it in a minute or two
• –A consistent reporting cadence across all landlords, not ad hoc depending on who happens to ask

Where the effort actually goes wrong

The time cost here rarely comes from having the underlying data — most agents do have gas, electrical and EPC dates recorded somewhere. It comes from that data being scattered across separate files, spreadsheets and inboxes, so producing one clean report means manually reassembling it every single time, for every landlord, from scratch.

Why this is really a data structure problem

Solving this properly is less about writing better reports and more about holding the underlying data in one place from the start, so a report becomes a filtered view of existing data rather than a fresh compilation exercise — which is really the core argument for what a compliance platform should include out of the box, rather than something bolted on as an afterthought.

The report a landlord actually reads

Landlords vary in how much detail they want, but almost none want a document that requires interpretation. What consistently lands is a short statement of position — what is current, what is expiring soon, what is outstanding and what is being done about it — with detail available if they ask for it.

The harder constraint is honesty about the data. A report stating everything is in order, drawn from a register that has not been reconciled against the portfolio, is worse than no report: it creates a documented assurance that may not be true, and the landlord has no way to know.

Common mistakes

• –Reporting completeness without saying what the data is drawn from
• –Detail that requires interpretation rather than a clear position
• –No distinction between expiring soon and already overdue
• –Reporting only on the properties where records are good
• –No trend, so a deteriorating position looks stable
• –Assurance given before the underlying register has been verified