Compliance
Credential tracking: why the spreadsheet fails at 30 workers
Spreadsheets record credential expiry dates but do not act on them: no reminders, no dispatch gating, no proof for clients. At 30 workers, tracking credentials in a spreadsheet means manually re-checking 30 rows every week and hoping you catch an expiry before a worker reaches an assignment.
A 1998 University of Hawaii study by Ray Panko found that 94% of audited spreadsheets contained at least one error. The structural problem: a spreadsheet is passive. A forklift certification expires on July 15. If no one manually reviews the sheet on July 14 to send a reminder, the expiry lands mid-assignment. By the time you realize it, the worker is already on-site or the shift was canceled at the last minute.
What does credential tracking do?
Credential tracking logs the licenses and certifications your workers hold: a forklift license (Class 5 or 7 in most provinces), a WSIB clearance certificate, a Serving It Right or ProServe certificate (if you place workers in food service), a driver's license for delivery roles, WHMIS training, fall protection, etc. Each credential has an expiry date. Some are renew-able annually, some every 3 years. Your responsibility as the employer is twofold: (1) confirm that a worker has the credential before you assign them to a role that requires it, and (2) ensure the credential stays current.
How do spreadsheets fail?
- Spreadsheets are passive. They record dates but do not send reminders or alerts. A forklift card expires July 15. If no one manually reviews the sheet on July 13 or 14, the expiry lands mid-assignment, often discovered only when the worker shows up on-site and the client rejects them.
- Spreadsheets do not gate dispatch. A worker with a lapsed credential can still be scheduled for a role that requires it. The gating happens (if it happens at all) after the shift is assigned, when the owner notices the certification is stale and has to cancel the shift.
- Spreadsheets fork into copies. The owner has one on the desktop, the on-site supervisor has an email copy, and the bookkeeper has a third version. When a credential is updated in one copy, the others are out of sync, and nobody knows which version is the truth.
- Spreadsheets do not provide proof. A client asks: 'Do all my assigned workers have valid certifications?' You have to manually check 20 rows and send a text file. A compliance system produces a one-click report with every worker's current status and expiry date.
- At 30 workers, manual re-checking is a ritual that gets skipped. An owner with 10 workers might review the spreadsheet every week. At 30, it becomes a 30-minute task that gets deferred, and deferral becomes delay.
What does research say about spreadsheet errors?
A 1998 University of Hawaii study by researcher Ray Panko reviewed over 88 spreadsheets and found that 94% contained at least one error. The errors ranged from formula mistakes to missing or stale data. Panko's research is 28 years old now, and modern tools like Excel data validation and cloud-based shared sheets have improved error detection. However, the structural weakness remains: a spreadsheet is a passive record, not a system that acts on its data.
What is the failure timeline?
A real example: a worker named Marcus has a valid Class 5 forklift license expiring July 15, 2026. His license is recorded in the compliance spreadsheet. On July 12, the owner does not manually review the sheet (it is Friday, the pay cycle is done, and the next shift assignments are not due until Monday). On July 15, Marcus's license expires. On July 18, the owner gets a call: 'We have an urgent order for Marcus starting Monday at 8 a.m., 40 hours a week.' The owner books Marcus without checking the spreadsheet (or checks it but does not notice the July 15 expiry). On Monday, Marcus shows up on-site and the client's safety officer scans his license: expired. The client sends him home. The owner gets an angry call and has to scramble to find a replacement. The shift is either filled by someone else (at higher cost) or canceled (costing the client's revenue and your fee).
What does a spreadsheet do vs. what the job needs?
| Feature | Spreadsheet | Active system |
|---|---|---|
| Record a credential and expiry date | Yes | Yes |
| Automatically remind the worker at 90 days | No | Yes |
| Automatically remind the worker at 2 weeks | No | Yes |
| Automatically remind the worker at 3 days | No | Yes |
| Block dispatch if a credential is lapsed | No | Yes |
| Generate a proof-of-compliance report for a client | Manual | One click |
| Sync across the owner and all staff | No (copies drift) | Yes |
| Alert on an expiry date (so you don't miss it) | No | Yes |
What happens as the agency grows?
At 10 workers, the owner can manually review credentials weekly and send reminder texts to workers before expiry. At 30 workers, the weekly review becomes a 30-minute task that is easy to skip. At 100 workers, it is impossible. Meanwhile, the liability stays: every worker assigned to a role must have the required credential, current and valid. A lapsed credential is not just a mistake; it is a compliance violation. If a worker is injured on-site and they lacked the required credential (because you dispatched them without checking), your liability is higher and your insurance may not cover it.
Common questions
What credentials do we need to track?
That depends on the roles you fill. Forklift licenses are required for warehouse and logistics. WSIB clearance certificates are required in Ontario. Serving It Right is required for food service. Driver's licenses are required for delivery. WHMIS training and fall protection may be required depending on the client. Check your client contracts and the provincial regulations for your industry.
How often should credentials be renewed?
It varies. A forklift license is typically valid for 3 years. A WSIB clearance certificate is valid for 90 days and must be re-verified before each assignment in Ontario. Serving It Right is valid for 3 years. A driver's license renewal depends on the province (usually 5 to 8 years). Check each credential's specific renewal schedule.
What happens if we assign a worker without a valid credential?
The client can reject the worker and send them home. You lose the fee and may face a breach of contract. If the worker is injured, your liability is higher because you knowingly assigned them to a role without the required certification. Your liability insurance may deny a claim.
Can the worker renew their own credential?
Most credentials the worker must renew (forklift, Serving It Right, driver's license). You should encourage them and remind them before expiry, but the responsibility to renew is theirs. Once they show you the updated credential, you update the tracking system.
How do we handle a credential that expires mid-week?
If a credential expires on Wednesday and the worker is assigned through Friday, you need to pull them off the assignment if the credential is required for the role. Call the client as soon as you know, offer a replacement, and work with them to minimize disruption.
Is credential tracking required by law?
It is not a separate legal requirement, but you are responsible under employment law for assigning workers to roles they are qualified for. If a client requires a forklift license and you assign a worker without one, you are liable for the breach. Tracking is your due diligence.
Sources
Keep reading
Kordis handles this work for Canadian staffing agencies.
Shifts filled, credentials tracked, worker texts answered, payroll evenings shortened. Set up on your own data.
Start your two weeks freeOn your own data. No credit card.