The email lands on a Tuesday morning: your biggest client wants proof, by Friday, that every forklift operator who will handle their goods holds valid training. Or worse: an inspector shows up at reception and asks to see your CNESST training records. You open the infamous “Training_Tracking_FINAL_v7.xlsx” file, and doubt creeps in. Is this the right version? Who updated it last? Where are the certificates?
Most owners and HR managers of industrial SMEs in Quebec have lived through this scene, or dread it. Employee training tracking almost always starts the same way: a spreadsheet built in good faith, a few columns, some dates, some names. Then the company grows, shifts multiply, the one person who “understood the file” moves to another role, and the spreadsheet becomes a ticking time bomb.
The good news: it has never been easier to replace that file with a real training register, one that stays alive, up to date and exportable in two clicks. Here is how to get there without turning everything upside down.
Why the training tracking spreadsheet always ends up breaking
Excel is an excellent calculation tool, but a very poor guardian of compliance. On the shop floor, the training tracking spreadsheet almost always breaks for the same reasons:
- No automatic alerts. A forklift operator card is typically renewed every three years (the practice recommended by the CSA B335 standard). Excel will never warn you that your most experienced operator’s card expired eight months ago.
- Only one person understands the file. Colour codes, hidden tabs, homemade formulas: the day that person goes on vacation, falls ill or retires, the register becomes unreadable.
- Versions multiply. One copy on the server, another in an email inbox, a third on the supervisor’s desktop. When the audit comes, nobody knows which one is the official record.
- The proof lives somewhere else. The spreadsheet says “WHMIS: completed”, but the certificate itself is sitting in a binder in the supervisor’s office, or in the drawer of an employee who left the company.
The result is predictable: the spreadsheet is accurate the day you create it, then it quietly drifts out of sync with what is actually happening on the floor.
CNESST training records: what an inspector actually wants to see
Quebec’s Act respecting occupational health and safety requires employers to properly inform and train their workers. For certain activities, the requirement is explicit: operating a forklift requires both theoretical and practical training, and WHMIS requires training on the hazardous products present in your facility. During an inspection, the burden is on you to demonstrate that these obligations are met.
In practical terms, a training register that holds up in front of an inspector or a client auditor must let you answer these questions in a matter of minutes:
- Who was trained (employee name, position, department)?
- On what (training content: forklift, WHMIS, internal procedures)?
- When (completion date, not a vague “done” note)?
- Until when (expiry date or planned renewal, such as the forklift card renewal)?
- With what proof (certificate, attestation, assessment result, signed attendance sheet)?
If your company has a payroll above two million dollars, this same register also documents your eligible expenses under Quebec’s 1% training law. One well-kept register, two obligations covered.
What a good employee training tracking system looks like
Whatever tool you choose, the system that replaces your Excel file should meet five simple criteria:
- A single source of truth: one central register, accessible online, with no parallel copies.
- Automatic expiry alerts: the system warns you before the deadline, not after the accident.
- Proof attached to the record: every certificate is archived with the corresponding training record, in the same place.
- One-click export: a clean PDF or Excel report to hand to the inspector, the auditor or the client whose contract you want to keep.
- No expert required: if only one person can use it, you have just recreated the Excel problem.
How an online training platform for business automates all of this
This is where an online training platform for business (also known as an LMS) changes the game: it does not just hold the register, it fills it in by itself. When an employee completes their forklift or WHMIS training online, the platform records the completion date, generates the certificate, archives it in the employee’s file and calculates the renewal date. Nobody has a column to fill in.
On the Witeach platform, built for industrial SMEs in Quebec, that translates into:
- Renewal alerts that flag cards and attestations approaching their deadline, before they expire.
- Certificates generated and archived automatically when each course is completed.
- An exportable register by employee, by course or by department, ready for the CNESST inspection or the client audit.
- A dashboard that shows at a glance who is compliant, who is overdue and who is coming up for renewal.
And because a register is only as good as the training behind it, Witeach offers a catalogue of online training courses designed for the shop floor: a complete forklift operator course, WHMIS training, plus a free 10-minute lockout refresher capsule to keep the right reflexes sharp between full courses.
Where to start without turning everything upside down
Replacing your Excel file requires neither an IT project nor a consultant. A four-step approach is enough:
- Week 1: gather your current file and the existing paper certificates, even if they are incomplete.
- Week 2: import your employees and their training records into the platform, starting with the most critical courses (forklift and WHMIS).
- Week 3: turn on the expiry alerts and schedule the renewals that are already overdue.
- After that: let the register keep itself up to date as employees complete their training online.
The Excel file served you well, but your compliance deserves better than a fragile formula and a “FINAL_v7” version. If you want to see exactly what your training records would look like in the platform, get in touch: the team at Witeach Formation, a CPMT-accredited training provider, will be happy to walk you through it in a few minutes. The next time an inspector or a client asks for your proof, all you will have to do is click “Export”.
