Blog Compliance
How to prove, on the day somebody asks, that mandatory training is up to date
You need three things and none of them is a course: a compliance figure that calculates itself, the named list of who is overdue today, and a certificate per person that whoever receives it can check without phoning you. With those, the question is answered on one screen.
The question is never “do you run training?”
When an audit, a tender, a supplier prequalification or an inspector turns up, nobody asks whether the company runs training. What they ask is more specific and considerably more awkward: show me who has it, since when, and how long it stays valid.
That question is answered with three facts per person and per course: whether they completed it, when, and whether that date is still valid today. Everything else — the syllabus, the provider, the invoice — is context. Without those three there is nothing to show.
Why the training matrix in a spreadsheet always ends up lying
It is not the spreadsheet's fault; it is what is being asked of it. A training matrix fails in the same three places every time:
- One person maintains it. And the week that person is away, nobody does. Nothing warns you that it has gone stale: it simply stops being true, quietly.
- It does not hear about joiners and leavers. Whoever started in March is not on the list and whoever left in January still counts in the percentage. Both distort the figure, in opposite directions.
- It cannot expire anything. A cell that said “done” in 2023 still says “done” today. Expiry is precisely what separates mandatory training from any other kind, and it is the one thing a spreadsheet will not do on its own.
What you have to be able to show, specifically
If you are going to set this up — with whatever tool — these are the four deliverables that actually get asked for. It is worth checking the tool produces them before you start loading data:
- The mandatory compliance percentage. Courses marked as mandatory, completed and still valid, over everything assigned. One figure, always calculated the same way, that does not depend on who pulls it.
- The named list of who is falling behind. Overdue, expired or failed, with name, course and date. That is your call list, and it has to be filterable by team, by site and by course.
- What expires soon. What is fine today and will not be next month. Acting there costs an email; acting after it has expired costs an explanation.
- A certificate per person and per course. With the completion date and the expiry date. And, if possible, with a way of checking it that does not depend on taking your word for it.
The certificate that can be checked without trusting you
A PDF is worth exactly as much as the reader's trust in you, and in a supplier prequalification or a tender that trust is not assumed. The difference between sending a folder of PDFs and sending a list of codes is that in the second case they do the checking.
A verifiable certificate carries a short code — usually with a QR — that leads to a public page where you type it in and the system answers whether it is genuine, whose it is, which course and which date. No account, no sign-up, no phone call. Underneath there is normally a cryptographic fingerprint of the certificate's own data: retouch the PDF and the code stops matching.
That changes a whole conversation. Instead of “here are the certificates, trust me”, it becomes “here is the list with their codes, check them”.
Expiry is not remembered: it reassigns itself
The laborious part is not running the course, it is remembering to run it again. A course with its validity declared in months solves that by itself: when the date arrives the enrolment expires and, if that person still belongs to the group that has to take it, they are enrolled again on a fresh cycle with its own deadline.
The important bit is that last clause. If the assignment is a list of names, somebody has to revisit it every time a person joins or changes role. If the assignment is a rule — everybody at the Getafe site, everybody with this job title, everybody on this project — whoever joins tomorrow gets it without anybody remembering, and whoever changes role stops receiving what no longer applies.
And the previous cycle is not erased. A person's record is their whole history, not the last row: that is exactly what an audit looking backwards wants.
Training delivered elsewhere: recognise it, do not fake it
A good share of a company's mandatory training is delivered by somebody else: the health and safety consultancy, the insurer, a supplier, a college. That has to be able to enter the record, and it has to enter saying what it is.
The honest way is to mark it as recognised: it counts towards compliance, it expires like everything else, and the certificate is issued with no grade, because the grade would belong to an exam that was not taken there. A document that says less and is true is worth more than one that invents a score.
And the history from previous years
The commonest mistake when starting is to begin at zero and wait two years for the figure to mean anything. You do not have to: if the tool accepts loading already-completed enrolments with their completion date, the compliance figure is right from day one, with expiry dates worked out from those dates.
It is half an afternoon with the spreadsheet you already have, and it is the difference between a tool you show people and one you have to explain.
Frequently asked questions
Which training is mandatory for my company?
It depends on your activity, your sector rules and your risk assessment, and the people who say are your own health and safety advisers, not a software tool. What a tool does solve is that, once it is known, nobody falls off the list and it can all be evidenced. This is not legal advice.
Does a software record work as evidence in an audit?
It works as a record of the training your company delivered and who completed it, with dates and certificates. It does not replace your advisers' documentation and it does not decide what applies to you. Check with them.
How often does health and safety training expire?
There is no single interval: it depends on the role, the risk and what your own prevention plan says. What matters for the record is that the interval is declared per course and that the system applies it by itself, whatever it is.
What happens when somebody changes role?
If training is assigned by rules over the job title, the site or the project, the change propagates on its own: they start receiving the new role's training and stop receiving the old one's. What they already completed stays in their record, which is correct.
Can we export the whole matrix for a tender?
You should be able to, as a spreadsheet or CSV with the filters applied. If each line also carries a verification code, whoever receives the annex can check it without asking you for anything.
All of this is built into Fichaloto. See how it works.
Keep reading
How to choose
Twelve questions worth asking before you sign
None of these twelve questions is technical. Every one of them is answered in a sentence, and you can ask for the answers in writing before signing anything.
Compliance
A clocking record that cannot be quietly rewritten
Most time-tracking tools store hours in a table anyone with database access can edit. That is fine until the day somebody asks you to prove a number.
Capacity
Planned, clocked, charged: three numbers that should match and usually do not
Most companies can tell you what they planned and what they invoiced. Very few can tell you, for a given week, whether those two things are related.