Anonymised, illustrative composite. An Ontario contractor tracked three different credentials on three different paper systems — and only found the forty that had quietly expired once all three were put on one spreadsheet, sorted by date.
At a glance
The contractor was not careless about credentials — it tracked all three categories it needed to. It just tracked them in three separate places: Certificates of Qualification in a binder at head office, JHSC certification dates in a spreadsheet the safety manager kept, and subcontractor WSIB clearances as a folder of PDFs saved when each subcontractor was onboarded and rarely revisited after.
Each of those three credentials runs on a genuinely different clock. Skilled Trades Ontario states plainly that in Ontario's 23 compulsory trades, “journeypersons in compulsory trades must renew their Certificate of Qualification each year.” A JHSC certified member's training, by contrast, is good for three years before a refresher is required. And a WSIB clearance certificate, per the same regulator's own clearance page, is “valid for up to 90 days” — a subcontractor cleared at the start of a project can be lapsed well before the project ends.
Three separate systems, on three separate clocks, kept by different people, is a reliable way to lose track of all three at once — not because anyone was negligent, but because nobody had one place where an annual date, a three-year date and a 90-day date could be compared side by side.
Building one matrix and sorting every credential by its own expiry date, against its own clock, found: 24 of the firm's Certificate of Qualification holders overdue for annual renewal; 9 of 22 firm-wide JHSC certified members overdue for their three-year refresher; and 7 of the firm's 15 active subcontractors carrying a WSIB clearance certificate past its 90-day validity window. 24 plus 9 plus 7 is 40 — three separate lists, none individually alarming on its own, adding up to a number worth noticing.
The fix was not more diligence within any one of the three existing systems — each was already being maintained by someone. The fix was combining three different clocks into one view, with a reminder lead time set to each clock's own length: 60 days ahead of an annual Certificate renewal, 90 days ahead of a three-year JHSC mark, and 30 days ahead of a 90-day WSIB clearance. Three separate binders cannot cross-reference each other; one spreadsheet, sorted by date regardless of category, can.
An expired Certificate of Qualification is not a paperwork technicality: Skilled Trades Ontario is explicit that to work in a compulsory trade “you must hold a valid” certificate. A lapsed credential means the individual is not currently authorized to perform that trade's work, regardless of how qualified they still are on paper. And on the WSIB side, only a business “in good standing” can obtain a clearance certificate at all — a lapsed one is not a formality to renew whenever convenient, it is the difference between being able to demonstrate coverage and not.
Over six weeks, all 24 Certificates were renewed (three workers had let theirs lapse long enough that they stopped performing compulsory-trade work until renewal came through), all 9 JHSC members completed their refresher, and all 7 subcontractor clearances were brought current. Credential expiry now lives in the same matrix as the rest of the firm's compliance calendar, checked on a fixed schedule rather than discovered.
The same single-view fix — one matrix instead of several disconnected systems — is what let a different contractor pass its second audit on documentation alone, and it is the same kind of gap a routine site walk surfaced in an orientation-gap case.
The 7 lapsed subcontractor clearances were not evenly spread across the firm's 15 active subcontractors — all 7 traced to a single project that had been fast-tracked onto the schedule 90 to 120 days earlier, with subcontractors added quickly to meet a compressed start date. The same rushed-onboarding pattern that produced an orientation gap on a different site here produced a clearance gap — a schedule crunch is a reliable predictor of which compliance shortcut gets skipped, whichever credential is at stake.
A 30-minute call is enough to tell you whether AI pays for itself here.
