Skip to content

Free template

Updated

Training matrix template with expiry dates

A training matrix lists your people down the side and the trainings, evaluations and authorisations their jobs need across the top, with the date each one was done and when it runs out. This template works out each expiry date from how many months the training stays valid, marks every record OK, Due (inside a warning window you set, 30 days by default), Expired, or Missing when the person's role needs it and there is no date, and counts compliance by person, training and area. It also counts how many people are qualified on each training, flags single points of failure, and lists every renewal in the next 90 days with the expired ones first. Use it for forklift evaluations, lockout/tagout, respirator fit tests, first aid cards, weld tests, food safety training and site sign-offs. To record how well someone does a task, use the skills matrix template instead.

Free to use: print it, copy it and edit it for your team. Enter your name and work email once to download.

Page 1 of the training matrix templateFields for the site, review date and warning days, a key for OK, due, expired and missing cells, and a grid of 15 people by 10 trainings with valid-for, roles, qualified-now and minimum rows.
Expiry from months validOK, Due, Expired, MissingRequirements by roleCompliance by person, training and areaCover and single points of failure90-day renewal scheduleRules that set an intervalWorked example

When to use it

When to use a training matrix

  • Every Monday, to see whose forklift evaluation, fit test or first aid card runs out this month and book the sessions before it does.
  • Before a customer, ISO or OSHA audit, to show that everyone doing a job holds the training it needs and that it is in date.
  • When someone joins or changes role: the role sets what is required, so every gap shows as Missing on day one.
  • When a training has only one or two holders and an absence would stop the work. The cover row shows it.

How to fill it in

  1. 1

    List the trainings that must be held

    One row on the Setup sheet for each training, evaluation, fit test, licence or site sign-off a job needs, named the way the certificate names it. The Excel holds 15, the paper sheet 10.

  2. 2

    Enter how long each stays valid, and where that comes from

    Months valid, or blank if it never expires. Use a rule's interval only where the rule names one, such as the forklift operator evaluation at least once every three years in 29 CFR 1910.178(l)(4)(iii). Everything else is set by your site, your customer or the card, and the source column says which.

  3. 3

    Mark which roles need each one

    Type up to six role names and put Y where a role needs the training. Each person's role then decides what is required, so nobody has to remember it.

  4. 4

    Enter completion dates, not expiry dates

    For each person, the date they last completed or were evaluated on each training. The workbook adds the months. Keep the certificate or sign-off sheet as the record: OSHA's forklift rule, for example, asks for the operator's name, the training and evaluation dates and who did them, in 1910.178(l)(6).

  5. 5

    Set the warning days and the minimums

    The default warning is 30 days. Give a training more where you have to book an outside evaluator. Set the minimum number of people who must hold each training, for example two first aiders per shift, so the cover row can flag gaps.

  6. 6

    Review it weekly, monthly and on every change

    Weekly: book everything on the renewal list. Monthly: compliance by area and the cover flags go to the plant manager. On every change (a new hire, a role change, a new machine, chemical or procedure, an incident, a failed inspection), update the matrix, because many rules make these the retraining trigger. Once a year, check each validity period against the current rule text. This cadence is common practice, not a standard.

Intervals set by a rule

Which trainings have an interval in the rules

Many intervals people quote are site practice. These are the US federal rules for common plant trainings, read at osha.gov and ecfr.gov on 9 October 2026. Check the current text, and any state plan, customer or local rule that applies to you.

  • Forklift (powered industrial truck) operator

    Rule
    29 CFR 1910.178(l)(4)(iii) and (l)(4)(ii)
    What it says about timing
    An evaluation of each operator at least once every three years. Refresher training after unsafe operation, an accident or near miss, a poor evaluation, a different type of truck or a workplace change.
    In the template
    36 months; a trigger is a reason to retrain early and enter the new date
  • Lockout/tagout, authorized and affected employees

    Rule
    29 CFR 1910.147(c)(7)(iii)
    What it says about timing
    No fixed interval. Retraining when job assignments, machines, processes or the procedure change, or when the periodic inspection (at least annually, (c)(6)(i)) finds deviations.
    In the template
    The site sets the months (12 in the example)
  • Respirator use, tight-fitting facepiece

    Rule
    29 CFR 1910.134(f)(2) and (k)(5)
    What it says about timing
    Fit test before first use, with a different facepiece, and at least annually. Retraining annually.
    In the template
    12 months
  • Portable fire extinguisher use

    Rule
    29 CFR 1910.157(g)(2)
    What it says about timing
    Education on initial employment and at least annually, where the employer provides extinguishers for employee use.
    In the template
    12 months
  • Hazard communication

    Rule
    29 CFR 1910.1200(h)(1)
    What it says about timing
    At initial assignment and whenever a new chemical hazard is introduced. No periodic interval.
    In the template
    No expiry
  • First aid

    Rule
    29 CFR 1910.151(b)
    What it says about timing
    A person adequately trained to give first aid where no infirmary, clinic or hospital is in near proximity. No interval in the section.
    In the template
    The expiry on the provider's card
  • Food hygiene and food safety, US food plants

    Rule
    21 CFR 117.4(b)(2) and (d)
    What it says about timing
    Training suited to the food, the facility and the person's duties, with records of it. No interval.
    In the template
    The site sets the months

A filled-in example

Illustrative, not a benchmark

An example: a made-up metal fabrication shop with 12 people in 4 roles and 8 trainings, reviewed on 12 October 2026 with a 30-day warning (60 days for the forklift evaluation). Names, dates and most months valid are illustrative.

The example's 45 required trainings on review day

  • Valid, not due soon: 31 items
  • Valid, due inside the warning window: 7 items
  • Expired (4) or never done (3): 7 items
  1. Fabrication12 of 12 valid
  2. Shipping7 of 9 valid
  3. PaintLowest4 of 6 valid
  4. Maintenance15 of 18 valid

Of the 45 person and training items the roles require, 31 are valid and not due soon, 7 are valid but fall inside the warning window, and 7 are expired or never done (4 expired, 3 never done). By area: Fabrication 12 of 12 valid, Shipping 7 of 9, Paint 4 of 6, Maintenance 15 of 18.

Compliance is 38 / 45 = 84.4% today, but 31 / 45 = 68.9% if none of the 7 due items is renewed. The renewal list starts with the 4 expired ones.
  • The roles require 45 person and training items. 38 are valid (OK, Due or no expiry), 4 have expired and 3 were never done.
  • 7 of the valid items fall inside the warning window, among them Eli E.'s forklift evaluation, due on 20 November and so inside its 60 days, and Jun J.'s lockout/tagout and first aid.
  • Only Hana H. holds a valid respirator fit test, so the cover row flags a single point of failure. Lockout/tagout has 2 authorized people against a minimum of 3.
  • By area: Fabrication 12 of 12 valid, Shipping 7 of 9, Paint 4 of 6, Maintenance 15 of 18.

Compliance is 38 / 45 = 84.4%, and 31 / 45 = 68.9% if none of the 7 due items is renewed. The 90-day renewal list has 12 records with the 4 expired ones first, so this week the coordinator books Gus G.'s forklift re-evaluation and Ivo I.'s fit test.

Common mistakes

  • Typing expiry dates instead of completion dates

    Then nobody can tell how long the training was valid for, and changing a validity period means retyping every date. Enter the completion date and let the months do the work.

  • Calling site practice a legal interval

    Many quoted intervals are in no rule: OSHA sets no refresher interval for hazard communication or lockout/tagout training. Write where each number comes from in the source column.

  • Only tracking who lapsed

    A list of expired certificates misses the people who were never trained. Role requirements make them show as Missing.

  • Counting expired holders as cover

    A lapsed forklift evaluation is no cover for a shift. Only OK, Due and no-expiry records count as qualified.

  • A warning shorter than the booking time

    If an outside evaluator needs six weeks' notice, a 30-day warning guarantees lapses. Set the warning days for each training.

Download the template

Free to use: print it, copy it and edit it for your team. Enter your name and work email once to download.

Run this template in LeanSuite

LeanSuite keeps a live skills matrix: people qualify through training and digital sign-offs, and gaps show up before they cost you a shift.

See it in a 45-minute demo

FAQ

Training matrix template with expiry dates: common questions

More free templates

All templates
Browse all 189 templates

Can't find the template you need?

Tell us what you're looking for. We'll make it and send it to your inbox, free.

A shift handover sheet, a red tag log, a changeover checklist for one machine: if your team uses it on the floor, ask.

By sending this form you agree to our Terms of Service and Privacy Policy.

Pass it on

We want LeanSuite to be the best place on the internet for lean help. If this was useful, send it to someone on your team or in your network who needs it.