The week before the audit

The email lands on a Tuesday. The audit is next Thursday, or the principal contractor wants your training matrix "with the PQQ response by Friday". You know what happens next, because it happens every year.

The scramble

Someone opens last year's matrix. Half the dates have passed. Nobody's sure which of those people renewed and which just... carried on. So the week begins:

Wednesday is for chasing. Texts to site: "can you send a photo of your CSCS card?" Half come back that day — a thumb over the expiry date, a card photographed at an angle in a van. The other half need chasing again. One card, it turns out, expired in March; the holder swears the new one is "in the post".

Thursday is for the yard. Someone walks the plant with a phone, photographing examination stickers and hunting for the LOLER report for the excavator lifting attachment — which is in a folder, in a cabinet, in an office belonging to someone on holiday. The MOT dates for the vans get looked up one registration at a time.

Friday is for the matrix itself: retyping dates from the photos, colouring cells, deleting the leaver, adding the two starters nobody ever entered. A supervisor's SSSTS turns out to lapse the week after the audit — refresher hastily booked, at whatever date the training provider still had.

Monday and Tuesday are for the gaps. A missing first-aid certificate that may or may not exist. A driver whose DQC expiry nobody recorded. Each gap gets a judgement call: chase harder, or hope the auditor doesn't pick that row.

By Wednesday night there's a matrix. It's accurate — briefly. It's the truth as of this week, assembled backwards from photographs, at a cost of most of someone's week. And next year it will be last year's matrix.

What the auditor actually sees

Here's the uncomfortable part: a scrambled-together matrix often passes. Auditors see a tidy grid and green cells. What they can't see is that the document is a photograph of one heroic week, not of how the company runs. The gap between those two is exactly where incidents live — the eleven months when nobody was checking. The scramble doesn't just cost a week; it teaches the organisation that compliance is an annual event.

And increasingly, the audience isn't only the annual auditor. Principal contractors ask for a training matrix at PQQ stage — before you've won anything, on their timetable, not yours. Gates run card checks in real time. DVSA doesn't announce roadside checks at all. When the request can arrive any Tuesday, "we tidy it up before the audit" stops being a strategy.

The boring alternative

Now the version of this story with no plot. The certificate comes in; it's photographed once, that day, and filed against the person. The expiry date goes in when the document does — one row per certificate, the date column as the single source of truth. Ninety days before anything expires, the right person gets an email; at 60 and 30, again, louder. Renewals happen inside the window, so the matrix never decays in the first place.

Then the audit email lands on a Tuesday, and the week before the audit looks like this: export the current overview, attach it, reply. Ten minutes. The matrix is accurate not because of a heroic week but because it was never allowed to go stale — the evidence collected itself, one document at a time, all year.

That's the whole trade: one week of scramble every year, plus the PQQs you answer thin and the gaps you hope go unnoticed — against a system that does the remembering continuously. It's what Certly does: every expiry date watched nightly, reminders at 90, 60 and 30 days, and the evidence file always one export away. If you're mid-scramble right now, moving the spreadsheet across takes an afternoon — and there's a 14-day free trial, so the next audit email can be the boring kind.