Ask a compliance manager how they know what’s overdue and you’ll usually get one of two answers. The good one is “I check the tracker every Monday.” The honest one is “I’d know if something was wrong.” Both describe the same underlying arrangement: a list of dates, and a person remembering to look at it.
That works, right up until it doesn’t. Holiday, illness, a busy fortnight, a site added in a hurry, a row accidentally filtered out — and a check quietly passes its date with nobody informed. Nothing announces it. The spreadsheet looks exactly the same the day after as the day before.
The fix isn’t a better spreadsheet. It’s a change in what the record holds. A date is inert data: it sits there and means nothing until a person interprets it. A status is a calculation the system performs continuously — comparing the last completion, the frequency and today’s date to answer one question: where does this item stand right now?
Once that calculation exists, useful things follow. Items can be grouped as overdue, imminent or due soon without anyone building a view. Counts become trustworthy, because they’re derived rather than maintained. And critically, the answer is the same for everyone who asks — the site manager, the compliance lead and the director all see one number, because there is only one.
If any of those takes more than a minute, it isn’t really being tracked; it’s being reconstructed on demand — and reconstruction is when things get missed.
There’s a second problem that only shows up once you start measuring. Not everything on a maintenance list is statutory. Servicing a door closer and testing a fire alarm are both maintenance; only one of them is a legal obligation with an enforcement consequence. If both sit in the same count, your compliance percentage becomes meaningless — flattered by routine tasks, or dragged down by them.
Separating the two is unglamorous work, and it’s usually the first thing worth doing. It costs nothing but an afternoon of decisions, and it turns a number nobody trusts into one a board can act on.
You know the register is working when the awkward question is boring. Someone asks whether site seven is compliant; you open one screen and answer, with the certificate attached, in less time than it takes to explain why you can’t. That’s the whole objective. Not a dashboard that looks impressive — an answer that arrives before the anxiety does.