Free download · Excel template
Free subcontractor insurance & WSIB clearance tracker
One row per subcontractor. Days left and a red, amber or green status fill in by themselves for their liability insurance and their WSIB clearance. No sign-up needed.
Works in Excel, Google Sheets and Numbers. No macros. General information, not legal or insurance advice.
What's inside
- Tracker tab: subcontractor, trade, contact, insurer, policy number, liability limit and expiry, additional insured, WSIB account and clearance number, clearance expiry, auto policy expiry and notes.
- Automatic countdown: days left for the liability policy and the WSIB clearance.
- Status at a glance: red when something has expired or you are not named as additional insured, amber within 30 days.
- How-to tab: a five-step weekly routine, including checking clearances yourself in the WSIB's online clearance lookup.
Why it matters: what happens if a sub's insurance or WSIB clearance lapses.
Get new checklists by email (optional)
Questions
Is the tracker really free?
Yes. Download it, no sign-up needed. The email box is optional and only for people who want occasional checklists and Ontario rule updates.
What do I need to open it?
Excel, Google Sheets, Numbers or LibreOffice. It has no macros.
How does the colour status work?
Enter expiry dates as YYYY-MM-DD. The "Days left" columns count down by themselves, and the Status turns amber within 30 days and red when a date has passed or you are not named as additional insured.
When is it time for software instead?
When you are chasing certificates by email every week, or more than a handful of subs work for you at once. SubCert Sentinel collects the certificates from your subs, checks them and sends the reminders for you.