What a training matrix is
A training matrix is a grid: people down one side, the training they need across the top, and a status in every cell. At a glance you can see who is complete, who is missing something, who is part way through, and whose training is about to expire.
It is a planning and audit view, not the training itself. The matrix does not teach anyone how to lift safely or report an incident - it tells you whether they have been taught, when, and where the proof is. That makes it the first thing a manager, client or auditor asks to see.
Who needs one
Any team with mandatory or recurring training gets value from a matrix. It is common practice in:
- NDIS providers - worker orientation, manual handling, infection control, medication and behaviour support training.
- Aged care - infection prevention, manual handling, dementia care and incident reporting.
- Construction - site inductions, toolbox talks and plant or equipment tickets.
- Cleaning and trades - WHS induction, chemical handling, working at heights and site-specific rules.
Which training is actually required depends on your industry, your clients and your regulator. The matrix is how you show you are on top of whatever that list is.
The columns to include
Whether you build it in a spreadsheet or a system, a useful training matrix has these fields:
| Column | Why it matters |
|---|---|
| Person | Who the row is about. Use the same name as your staff list so the two never drift apart. |
| Role and site | Drives what training they need. A support worker at one site may need different modules to a team leader at another. |
| Required module | One column (or one row block) per piece of training: induction, manual handling, infection control, chemical handling and so on. |
| Completion date | The date they finished, not the date it was assigned. |
| Expiry or refresher date | When it has to be done again. Leave it blank only for training that genuinely never lapses. |
| Status | Complete, in progress, missing or expiring soon - the column people actually scan. |
| Evidence | A link to the certificate, signed acknowledgement or quiz result that proves it. |
Here is what a few rows might look like. The people and dates below are made up, purely to show the layout:
| Person | Role and site | Module | Completed | Expires | Status |
|---|---|---|---|---|---|
| Example: Sam Lee | Support worker, North site | Manual handling | 3 Feb 2026 | 3 Feb 2027 | Complete |
| Example: Sam Lee | Support worker, North site | Infection control | 10 Sep 2025 | 10 Sep 2026 | Expiring soon |
| Example: Priya Shah | Team leader, South site | Manual handling | - | - | Missing |
| Example: Priya Shah | Team leader, South site | Incident reporting | Started | - | In progress |
Map training to roles, not people
The most common mistake is building the matrix person by person. It works for the first ten staff, then every new starter means working out from scratch what they need, and somebody always gets missed.
Start from roles instead. Write down each role (support worker, team leader, cleaner, site supervisor) and the training that role requires. Then a person's requirements are simply the sum of their roles. When someone new starts, or moves into a new role, they inherit the right training automatically. It also pairs naturally with your employee onboarding checklist, where the induction modules belong.
Refresher cycles and expiry
Much of the training on a matrix does not last forever. There are two common ways to set the refresher:
Rolling cycle
Due a set period after the person completed it, for example 12 months from their completion date. Fair to each person, but due dates are spread across the year.
Calendar cycle
Everyone is due by the same point, such as the end of the calendar year. Easier to run as one campaign, but someone who started in November gets a short cycle.
Whichever you choose, do not wait for training to lapse before acting. Flag anything expiring in the next month or so, and send the refresher early enough that people have time to complete it.
Keeping records an auditor will accept
A tick in a spreadsheet cell is a claim, not evidence. When a client, auditor or regulator asks, you want to be able to show:
- Dated proof of completion - a certificate, a quiz result or a signed sign-off, with the date it happened.
- Signed acknowledgements - for policies and procedures, a record that the person read and accepted them.
- What the training covered - the version of the module they completed, not just its name.
- One source of truth - a single place where the matrix and the evidence live together, rather than a spreadsheet in one folder and certificates scattered through email.
How long you must keep training records, and exactly what they must contain, depends on your industry and the rules you work under. Check with Safe Work Australia and your state WHS regulator, the Fair Work Ombudsman for employee records, and your industry regulator (for example the NDIS Quality and Safeguards Commission or the Aged Care Quality and Safety Commission).
Spreadsheet or software?
A spreadsheet is a perfectly good training matrix when the team is small, there are only a handful of modules and little of it expires. If that is you, the columns above will serve you well.
It starts to break when:
- Refreshers pile up. Someone has to work out every due date by hand and remember to chase it.
- You have several sites or roles. Copies of the sheet multiply and stop agreeing with each other.
- You need proof, not ticks. The sheet says "complete" but the certificate is somewhere else, or nowhere.
How AirSign Training does it
AirSign Training is one of the AirSign sub-apps, available on the Enterprise plan. It keeps the training, the evidence and the matrix in one place:
Modules with quizzes. Build modules from text, video and files, add a quiz, and set the pass mark and the number of attempts allowed.
Assigned by role. Make a module a requirement for a role, or for a class of learners who join with a code, and everyone in scope gets it.
Certificates on a pass. Turn on certificates for a module and a numbered certificate is issued when someone passes. Download it as a PDF, or revoke it if you need to.
Refreshers. Give a module a validity period, or set a rolling or calendar cycle on the requirement, and the training comes due again on schedule.
The matrix. Every training requirement against everyone it applies to, showing who is compliant, expiring soon or missing. Filter it by class and export it as CSV for an audit.
For a step-by-step walkthrough of the screens, see the training matrix and certificates guide. If you are an NDIS provider, see how NDIS providers use AirSign for worker documents and agreements too.
This article is general information only and is not legal or WHS advice. Training and record-keeping obligations depend on your industry, state and the rules you operate under. Check the current requirements with Safe Work Australia, your state WHS regulator, the Fair Work Ombudsman and your industry regulator, or get professional advice for your situation.