A skills register, a qualification for each person with an expiry date, the evidence behind it, and a competence matrix an auditor can read in one glance.
A skills register — what each skill is, whether it needs evidence to count, and which work centers it applies to
One qualification per person per skill, with the date it expires and a note or link to the evidence: the certificate, the test, the sign-off
Training events with attendees, so “who was in the room” is a record and not a memory
Attach the certificate to the qualification and the attendance sheet to the training event — a paperclip on the matrix shows where a certificate is on file
A competence matrix — people down the side, skills across the top, qualified / expiring / expired at a glance
Expiring-within-30-days and expired tiles at the top of the page, so renewals get chased before the auditor asks
Built for ISO 9001 7.2, IATF 16949 7.2.x and AS9100 7.2–7.3 competence requirements