Guide
How to track mandatory training
Mandatory training is training people must finish because a rule says so.
Tracking it means knowing, for every person, what they must finish, by when, and whether they did.
This guide shows a simple way to do that, first in a spreadsheet and then in a learning management system (LMS).
Published October 24, 2026 by the Openbox team. Updated October 31, 2026.
What counts as mandatory training
Training usually becomes mandatory for one of these reasons:
- A law or regulation requires it.
- A client contract or an insurer requires it.
- A professional license or certification requires it.
- Your own policy requires it, such as a code of conduct course.
The rules differ by country, state, industry and role.
Check the rules that apply to you with the agency that sets them.
For one example, see how three states set harassment prevention training rules, using each state's own website.
Step 1: List every requirement
Write down every training your organization requires.
For each one, note five things:
- Where the rule comes from.
- Who it applies to.
- When a new person must first finish it.
- How often it repeats.
- What proof you must keep.
Ask HR, safety, legal and each department head. Each of them often knows rules the others don't.
Step 2: Map requirements to roles
A training matrix is a table with roles down the side and training across the top.
Each cell says whether that role needs that training, and how often.
Map training to roles, not to people. When someone joins or changes jobs, their role tells you what they need.
Start from our free training matrix template. It opens in Excel, Google Sheets or Numbers.
Step 3: Set due dates and renewal cycles
Each requirement needs two timings: when a new person must first finish it, and how often it repeats.
For example: within 30 days of starting, then every 12 months.
Copy the cycle the rule actually sets. If a rule says every two years, write every two years.
Put every due date on one calendar, so a busy month doesn't surprise you. Our compliance training calendar for 2027 is a place to start.
Step 4: Remind people before the due date
Tell each person what is due, when, and where to find it.
Send a first reminder well before the due date, and another close to it.
Tell managers who on their team is behind, so they can help before the date passes.
Step 5: Keep proof
For every completion, record who finished, what they finished, which version, the date, and the score if there was a test.
Keep certificates and sign-off forms with the record.
How long to keep training records depends on the rule. Check the rule's own record-keeping section.
Keep records where you can search and download them quickly. An auditor usually asks for them by a date.
Tracking it in a spreadsheet
A spreadsheet works for a small team with a few requirements.
Use one row per person for each requirement, with the due date, the date finished and a status.
A spreadsheet starts to break down when:
- people change roles often;
- requirements repeat on different cycles;
- several people edit the same file;
- you need to prove who finished which version of a course.
Tracking it in Openbox
Openbox Learn is a simple LMS that works out of the box, for required training and everything else you teach. Here is how it covers each step.
- An LMS administrator sets the rule once with Create requirement: who it is for, what they must finish and when it is due.
- The same steps set due dates and reminders.
- Before the rule goes live, Openbox shows how many people it affects.
- People can ask for more time in Openbox, and the person you choose decides.
- Changing a requirement keeps every earlier version, so finished training and past exceptions stay on record.
Managers check Needs you on Teams as a due date gets close, and follow up with anyone due soon or overdue.
Reports such as Compliance status and Overdue learning download as CSV, XLSX or accessible HTML. A saved report can also run on a schedule.
At audit time, Create audit package makes a ZIP file of the records the audit asks for.
Guided setup brings in your past training records, with a preview before anything is saved. There is no setup fee.
Plans start at $249 a month for up to 50 active accounts, billed annually. See plans and pricing.
Keep reading
See how Openbox tracks required training
Try the sample with no sign-up, or see what each plan costs.