How to track compliance training without spreadsheets
How to track compliance training without spreadsheets
Who has done this year’s safety course? Whose certificate expires next month? Here is how to set up compliance training so the answers are always one click away — and the reminders go out by themselves.
Key takeaways
- List required courses per role, and how often each must be renewed.
- Assign by group, so new people get the right courses automatically.
- Let reminders and renewals run on their own; check one overdue list weekly.
- Keep certificates and an export ready for audits — not a folder of screenshots.
Why spreadsheets break
A spreadsheet works when there are 15 people and two courses. Then someone joins, someone changes role, a certificate expires, and the sheet is only as accurate as the last time someone updated it. When an inspector or client asks for proof, you spend a day collecting emails and screenshots. The fix is not a better spreadsheet; it is letting the system that delivers the training also keep the record.
Step 1: write your training matrix
A training matrix is a simple table: roles down the side, required courses across the top, and how often each must be done. For example:
- Everyone: data privacy (yearly), code of conduct (on joining), fire safety (yearly).
- Warehouse: forklift safety (yearly), manual handling (every two years).
- Managers: anti-harassment for managers (yearly).
Ask your industry body, insurer or regulator what is required for your sector and country — it differs by place and industry.
Step 2: assign by role, not by name
Create one group per role and give each group its required courses. When someone joins a group, they get the courses automatically with a due date; when they move role, they get the new group's courses. This is what keeps the record correct without anyone updating a sheet.
Step 3: due dates, reminders and renewals
- 1Give each required course a due date counted from when the person was assigned (for example 14 days).
- 2Turn on reminders: a few days before the due date, on the day, and again when overdue.
- 3Copy managers on overdue reminders for their team.
- 4For yearly courses, set the course to renew — the person is assigned again automatically before the year runs out, and their certificate shows the new expiry date.
Step 4: be ready for an audit
When someone asks for proof, you want three things ready in minutes:
- A completion report for the course and date range, with names, dates and scores, exported to CSV or PDF.
- Certificates that show the person, course, date and expiry — ideally with a code anyone can check online.
- An audit log of who assigned, changed or removed training.
Check one overdue list every Monday. Fixing three late people each week is far easier than finding thirty before an audit.
How Learnwick does it
Learnwick's compliance training set-up follows these steps: group rules give each role its required courses, due dates and reminders run on their own, yearly renewals re-assign courses automatically, and certificates can be verified online. The training matrix report shows everyone against every required course, and missing training can be assigned in one click. It is all included on the free plan for up to 30 learners.
Frequently asked questions
What is a training matrix?+
A table that lists roles or people against the courses they must complete, with how often each must be renewed. It shows at a glance who is up to date and who is missing training.
How often should compliance training be done?+
It depends on the topic, your industry and your country. Many policies (data privacy, code of conduct, safety refreshers) are renewed yearly; check what your regulator, insurer or industry body requires.
What records do I need for a compliance audit?+
Usually who completed which course and when, their score if there was a test, the certificate and its expiry date, and a history of changes. An LMS keeps all of these automatically and exports them to CSV or PDF.
The author

Venchito Tampon
Venchito Tampon is the founder of Learnwick, the LMS for small business — a simple, affordable way to upload or build courses, assign training, give certificates and see who has finished.
He is also the CEO and founder of eLearning Solutions Lab, a Philippines-based eLearning production company making custom and rapid eLearning for clients around the world, and Chief Learning Officer of Rainmakers Training & Consultancy, a corporate training and leadership development company.
He is a Certified Learning & Development Professional (CLDP) and a certified executive coach, and also founded ExpirePilot and Sidelight 360.
Keep reading
All postsEmployee onboarding training: a 30-day plan for small teams
A simple onboarding training plan you can copy: what to cover in week one, week two and the first month, how to keep it the same for every new hire, and how to see who is falling behind.
November 16, 2026· 3 min read
How to choose an LMS for a small business: a 10-point checklist
Most LMS buying guides are written for companies with an L&D department. Here is the short list that matters when you are a team of 10 to 1,000 and the person running training also has a day job.
November 16, 2026· 5 min read
How much does an LMS cost? A plain guide to LMS pricing
Per user, per active user, plans by team size, set-up fees and add-ons: how LMS pricing works, where the hidden costs are, and how to work out what you will really pay each year.
November 16, 2026· 4 min read
Give your team training they’ll actually finish
Free for up to 30 learners. No credit card, no sales call. Every feature on every plan.