Tracking licence expiry without a spreadsheet that nobody opens

A licence tracker is one of the first things any security contractor builds. It is also one of the first things that quietly stops being accurate, because a spreadsheet only tells the truth on the day someone updates it.

The three failure modes

Trackers do not fail dramatically. They drift, in three fairly predictable ways.

• –Staleness — an officer renews, the certificate goes in an inbox, and the sheet still shows the old date
• –Distance — the sheet lives with the compliance lead, and the person building the roster never sees it
• –Silence — the sheet has no way to raise its hand, so an approaching date only surfaces if someone goes looking

Of the three, silence causes the most damage. A tracker that is perfectly accurate and never consulted prevents nothing.

What good looks like

The useful test is not "do we have a record?" but "would this have stopped an unlicensed officer being rostered last Tuesday?" That reframes the problem away from record-keeping and towards the decision point.

• –The date is attached to the officer, so it travels with them between sites and contracts
• –The system raises the alert rather than waiting to be asked
• –The warning arrives with enough runway for a renewal to actually complete
• –Whoever builds the roster can see licence status without opening anything else

Evidence, not just alerts

Alerts prevent the incident. Evidence is what you produce afterwards. Being able to show when a licence was verified, by whom, and what it said at the time, is a different capability from knowing today's status — and it is the one that matters in an assessment.

Related: what actually happens when an SIA licence expires mid-contract.