ContactBook a call

Industries/ Real estate/ Portfolio and certificate dashboards

Arrears, repairs and expiring certificates on one screen, every morning

Occupancy, arrears, open repairs, contractor response and certificates coming due across the whole portfolio, pulled from the systems that hold them and refreshed overnight. Managers see trouble building on their own patch and directors see the whole book, without anyone exporting a spreadsheet first.

A portfolio manager, a South Asian man in his thirties in a white shirt, reviewing a list of properties with coloured status markers on a large monitor, an architectural model on a shelf.
Used by
Property managers, directors, compliance leads and landlords
Takes the place of
The Monday spreadsheet and one person's certificate tracker
Connects to
Your property management system, repair jobs and rent ledger
Built with
Our live dashboards service

Where it hurts today

A normal week, before it exists

Every Monday somebody exports reports from the property system, the repairs list and the accounts, pastes them into a spreadsheet and emails it round. By the time anyone reads it, it describes last week. The meeting spends its first twenty minutes arguing about whether the void count includes let agreed, and whether that roofing job is really still open or just never closed in the system.

Certificates are tracked in one person's spreadsheet, with a column for each type and a colour code only they understand. Gas, electrical, energy and fire records each run to a different cycle. When that person is on holiday, nobody looks. An expired certificate turns up when a let is about to start, when a lender asks, or when a tenant mentions nobody has checked the boiler this year.

Landlords ask how their properties are doing, and the answer is a summary someone writes by hand. Contractor performance is a feeling: everyone knows which firm is slow, but nobody can show it when terms are renewed. Directors cannot see which branch's arrears or repairs are building until it surfaces as complaints, and by then the useful moment to act has passed.

What it does

Portfolio and certificate dashboards, feature by feature

A small number of panels, each tied to a decision somebody makes every week, and each one clickable down to the records behind it.

  1. 01

    Certificate expiry tracking

    Every certificate type you track, against every property, sorted by expiry. Each manager sees their own patch: what lapses this month, what has already lapsed, whether a renewal visit is booked and whether remedial work from the last report is still open. The list shows what needs action, not everything you hold.

  2. 02

    Repairs past their target

    Open jobs by age, trade, contractor and urgency, measured against your own targets rather than a generic standard. Click a bar and the jobs behind it appear, with the tenant's report and the latest update, so a number is never a dead end.

  3. 03

    Contractor performance

    For each contractor, how long jobs take to accept, attend and close, and how often they are reopened, split by trade and area. It turns the feeling that one firm is slow into something you can put in front of them at the next review.

  4. 04

    Occupancy and void tracking

    Units let, let agreed, under offer and void, with how long each void has lasted and what is holding it up: works, marketing or referencing. Developers see plots reserved, exchanged and completed for each scheme on the same screen.

  5. 05

    Rent arrears and payment plans

    Arrears by age and by manager, with tenancies on an agreed payment plan shown apart from those where nobody has made contact. The figures come straight from your ledger, so the dashboard and the accounts team are looking at the same number.

  6. 06

    Each person sees their own slice

    A manager sees their patch, a director sees the whole book, and a landlord can be given a view of only their own properties. The rules sit on the data itself, so one dashboard serves everyone without separate copies drifting apart.

A day with it

How the day runs instead

A Monday at a management company with the dashboard in use.

  1. 7.30am
    Director

    Before the team meeting, the director opens the overview on her phone. Arrears are steady. One branch has more repairs past target than the others, and the certificate panel shows six gas safety certificates lapsing this month with no visit booked.

  2. 9am
    Branch managers

    The meeting works from the dashboard on the screen instead of an emailed spreadsheet. The branch with overdue repairs clicks through and finds most are waiting on one roofer. That becomes the conversation, rather than whether the numbers are right.

  3. 10.15am
    Compliance lead

    She filters certificates to those lapsing with no visit booked, assigns each to the property's manager and sends the list to the approved engineers. One already lapsed is escalated to the director by name, with the property and tenant details attached.

  4. 2pm
    Property manager

    Before a landlord's call, a manager opens his two properties: repairs closed this quarter, the certificate renewed last week and the void flat that was let on Friday. The call takes five minutes and needs no follow-up email.

  5. Tuesday 7am
    Operations manager

    The overnight refresh from the accounts system failed. The arrears panel is marked with the time it last updated, and she has an alert explaining why. Nobody reads Monday's arrears as Tuesday's while the connection is fixed.

What it connects to

Works with what you already run

The dashboard keeps no figures of its own. It reads the systems where the work is recorded, and each number has one agreed definition.

  • Property management system

    Properties, units, tenancies, voids and landlords, read nightly or more often where it offers an API or a reporting database. It decides what counts as a property and who manages it.

  • Repairs and works orders

    Jobs, contractors and the dates each was raised, attended and closed, from your works orders or a routing system. Targets come from your own urgency categories rather than an industry average.

  • Rent ledger and accounts

    Rent due, received and in arrears, payment plans and landlord balances, read from your ledger so the dashboard and the accounts team are working from the same figures.

  • Certificate and document records

    Each certificate's type, date, expiry and outstanding actions against its property, from your tracker or document store, with booked visits from contractor jobs so a renewal already arranged shows as in hand.

The first version

Start small, then grow it

A first version should be useful on day one and small enough to get right. This is where we would usually draw the line, and what tends to follow once people are using it.

In the first version

  • Certificates coming due across the portfolio, by manager and type
  • Open repairs against your own targets, with the jobs behind each figure
  • A written definition for each number, with a named owner
  • Access rules so each manager sees their own patch
  • A visible warning on any panel whose data has not refreshed

Once it is in use

  • Contractor response times by trade, area and urgency category
  • Arrears by age and manager, read from the ledger
  • Landlord views of their own properties inside a portal
  • Development dashboards for reservations, exchanges and completions by scheme

Buyer's guide

Before you commission one

Four decisions to make before you commission a portfolio or compliance dashboard.

  1. 01

    A compliance product, or your own dashboard

    Property compliance software exists that tracks certificates and inspections on its own, and if certificates are your only problem, one may be the better buy. Your own dashboard earns its place when you want certificates beside repairs, arrears and voids, drawn from systems you already run, or when you already pay for a reporting tool such as Power BI and need the data underneath.

  2. 02

    What to gather first

    From your compliance lead, the certificate and inspection types you track and the interval for each in every country you work in. The Monday spreadsheet as it is today. Access to the reporting side of your property software, repairs system and ledger. And the questions your directors actually ask each week, because each panel should answer one.

  3. 03

    Who should own it

    An operations or compliance lead owns the definitions: what counts as void, overdue or lapsed. Finance owns the arrears figures. Each panel has a named owner who is alerted if its data fails to refresh. Directors decide what landlords may see, if anything, and when that view goes out to them.

  4. 04

    How you will know it is working

    Watch whether the Monday spreadsheet stops being built, whether certificates are renewed before they lapse rather than after, how quickly overdue repairs are picked up once they show, and whether meetings argue less about numbers. Check that managers open it, not just directors. A dashboard nobody opens has failed, however accurate it is.

Terms worth knowing

The words you will meet

EICR
An Electrical Installation Condition Report, the usual record of an electrical safety inspection. In England, private landlords need one at least every five years, and the duty now covers social landlords too. Observations coded C1, C2 or FI need action, so a dashboard should track the remedial work as well as the date.
PRS Database
A register of private landlords and their properties in England, set up under the Renters' Rights Act 2025, with rollout due to begin from late 2026. Landlords will record property details and gas, electrical and energy performance information, so certificates kept current in one place make registration a lookup rather than a search.
Arrears ageing
Grouping unpaid rent by how long it has been owed, such as under a month, one to two months and over two months. It shows whether arrears are new and manageable or old and hardening, and it is the view a credit controller or property manager acts on first.

Handled with care

The details that matter here

A portfolio dashboard is only useful if people trust its numbers enough to act on them. These are the details we handle with care.

  • One definition for each number

    Does a void include let agreed? Is a repair overdue from the tenant's report or from the job being raised? We write each definition in plain words with your operations lead, give it a named owner, and show it beside the figure on the screen.

  • Records that are wrong at source

    Dashboards expose messy records: properties with no manager, certificates with no expiry, jobs nobody closed. We show these as a list to fix rather than hiding them inside an average, and agree with you who tidies them and how often.

  • Who sees tenants' and landlords' figures

    Arrears and payment plans are personal financial information. We apply access rules to the data itself, so a landlord's view holds only their own tenancies, and we agree with your data protection lead what each role may see and export.

  • Out-of-date data is marked

    When a source system fails to deliver, the affected panel shows when it last updated and the person who owns that connection is alerted. That way a Monday decision is not made on Friday's figures without anyone knowing.

Guides

Worth reading first

Questions

What buyers ask first

Which certificates should a landlord compliance dashboard track?

It depends on the country, the property and the tenancy. In England, for example, gas safety checks are due every 12 months, with a copy to existing tenants within 28 days, and electrical installations need inspecting at least every five years, with remedial work done within 28 days. Energy, fire, legionella and licensing records often sit alongside. We take the list and intervals for each market from your compliance lead and hold them per property.

Our property software has reports. Why would we need a dashboard?

If its reports already answer your Monday questions, keep using them. A dashboard earns its place when the answer needs more than one system: certificates in a tracker, repairs in another tool, arrears in the ledger, or branches running different software. It also helps when the report exists but takes someone half a morning to assemble each week.

Can a property dashboard work with Power BI?

Yes, and if you are already on Microsoft 365 it is often the sensible route, because licences and sign-in are in place. Most of the work sits underneath the screens anyway: the connections to your property system and ledger, the agreed definitions and the access rules. We would build in the tool you have rather than add another one.

Can landlords see their own dashboard?

They can have a limited view of their own properties: repairs, certificates and occupancy, usually inside the landlord portal. We suggest starting with the internal dashboard and adding landlord views once your own team trusts the figures, because a landlord who spots a wrong number on the first day is hard to win back.

What happens when we change one of our systems?

The connection to that system has to be rebuilt, and the definitions checked against the new one. Because each connection is separate and documented, that is a contained piece of work rather than starting again. Everything sits in accounts you own, and your team can be trained to add views and adjust panels without us.

Which number do you rebuild every Monday?

Send us the spreadsheet someone puts together each week. We reply within 48 hours with what it would take to build itself, and what needs tidying first.

More for real estate

What else we build for real estate