Every audit, tender and inspection eventually asks the same question: who is trained in what, and when does it run out? A training matrix answers it in one screen. Most companies keep one in a spreadsheet that is out of date the week after it is made. This guide gives you the exact structure auditors want, the refresher frequencies that catch people out, and the honest case for automating the whole thing.
The columns that actually matter
An auditable matrix is people down the side, courses across the top, and in every cell not a tick but a date story. For each person and course you should be able to show:
- Assigned: when the training was set, so you can evidence intent.
- Completed: the date passed, linked to the certificate.
- Score or outcome where there is an exam.
- Refresher due: the expiry or renewal date. This column runs your year.
- Status now: current, due soon, overdue, or not required for the role.
- Reminded: when the person was chased, because "we told them twice" only counts if it is recorded.
A worked example
| Team member | Fire safety | Conflict management | BS 7858 awareness | First aid |
|---|---|---|---|---|
| A. Khan Site supervisor | ✓ 12 Mar 2026 due Mar 2027 | ✓ 02 Jun 2026 due Jun 2028 | ✓ 15 Jan 2026 due Jan 2027 | Due 30 Sep 2026 reminded 01 Aug |
| J. Mills Security officer | ✓ 04 Feb 2026 due Feb 2027 | Overdue since Jul 2026 reminded 08 Aug | ✓ 20 Jul 2026 due Jul 2027 | ✓ 11 May 2025 due May 2028 |
| S. Obi Control room | ✓ 22 Apr 2026 due Apr 2027 | Not required | Assigned 05 Aug 2026 in progress | Not required |
Notice what this one screen proves: nothing is a bare tick, every cell can be traced to a certificate, the overdue item has a recorded chase, and "not required" is a decision, not a blank. That is the difference between a matrix and a spreadsheet of hope.
Refresher frequencies that catch people out
- Annual as the default for high-risk awareness topics (fire safety refreshers are commonly annual by policy, and our certificates run 12 months for the same reason).
- First aid: requalification is typically every 3 years, with annual refresher skills updates recommended.
- Licence-linked dates: SIA licences run on their own 3 year clock; put the expiry in the matrix even though it is not a course.
- Contract-specific promises: if a tender said "conflict management every 2 years", the tender is now your standard. Auditors read your promises back to you.
The five habits of matrices that pass audits
- One owner. A named person reviews the matrix monthly, and the review itself is logged.
- Role profiles, not guesswork. Define what each role requires once; every new starter inherits the requirements automatically.
- Chase from the matrix. Reminders go out because the "due" column says so, and the reminder date is recorded.
- Certificates one click away. An auditor who asks for evidence should never wait while someone searches inboxes.
- Leavers archived, not deleted. You may need to prove a former employee was trained on the day of an incident years later.