Real tabs from the workbook. Example people, dates, and certifications are illustrative, and the sample dates track the current day so the statuses always demonstrate.
License and Certification Tracker, Trades Edition
One register where days to expiration and status calculate on every row, a blocks-work flag that pushes the cards that stop a job to the top, a crew coverage matrix that finds single points of failure, and the field checklist that keeps the register honest.
One-time purchase, no subscription. Instant download.
Built by expert HR practitioners and leaders
- Days to expiration on every row: a License and Card Register where days to expiration and status calculate as you enter each card, and an expired blocks-work item turns the whole row red
- The cards that stop a job, first: a blocks-work flag you set per row, and a stops-work-first Dashboard that puts those items ahead of everything else
- The single-point-of-failure read: a Crew Coverage matrix that shows where exactly one person carries a required card
- Renewals you can see coming: a Renewal Pipeline for items in motion and a 90, 60, 30 day countdown with a checklist at each checkpoint
- Named correctly, on purpose: EPA Section 608 as the federal certification it is, and OSHA 10 and 30 hour as the course-completion cards OSHA describes, not as certifications
The workbook structures your entries and does the date math. It does not tell you which licenses your jurisdiction requires, and requirements and renewal intervals vary by jurisdiction, trade, and issuing body, so confirm the rules with the issuing body or your licensing authority.
One editable Excel workbook with a Word and PDF verification log, general business information, not legal or tax advice. It tracks the licenses and cards you enter against the intervals you set; it does not decide which credentials your work requires, and licensing requirements vary by jurisdiction and change, so confirm what applies to your work with the issuing body or qualified counsel before you rely on this.
Last reviewed June 2026
One workbook, eight tabs, plus the verification walk
Everything runs in a single Excel file that also works in Google Sheets, with a fictional mechanical contractor pre-filled on every tab. Amber cells are yours to edit; white cells calculate. The Product License and a one-page Google Sheets guide are included.
Start Here Guide
What each file does, the four setup steps, and the rules of the road. One page, read it first.
Requirement Catalog + Crew Roster
Map the credentials your roles require, then list your crew. Every other tab reads from these two.
License and Card Register
Each license and card with jurisdiction and renewal interval you set. Days to expiration and status calculate on every row, and an expired blocks-work item turns the row red.
Crew Coverage + Renewal Pipeline
A coverage matrix that shows where exactly one person carries a card, and a pipeline for the items in renewal with a 90, 60, and 30 day countdown.
Stops-Work-First Dashboard + Definitions
The cards that idle a crew put ahead of everything else, with a plain-language Definitions tab for every status and flag.
License Verification Log and Renewal Checklist
The quarterly sight-check walk in five steps, a printable verification log, the renewal countdown with a checklist at each checkpoint, the new-hire verification step, and a completed example with the gaps it caught.
Using This Workbook in Google Sheets
A one-page note on importing the workbook and what to confirm after the import.
Map the credentials, then keep the register honest
Map your role requirements, list your crew, and enter the cards. The workbook opens pre-filled with a mechanical contractor so the logic is clear before you change anything.
Map requirements and the crew
Set the credentials your roles require on the Requirement Catalog, then list your people on the Crew Roster. Type over the samples.
Enter the cards and set blocks-work
Record each license and card with its jurisdiction and renewal interval, and mark per row whether a lapse pulls someone off the job. Days to expiration and status calculate.
Work the Dashboard and the quarterly walk
Read the stops-work-first Dashboard, work the renewals in the pipeline, and run the quarterly sight-check so the register matches the cards people can produce.
A working tracker, named correctly, honest about its limits
It opens pre-filled so you can see how every tab behaves, it puts the cards that stop a job first, and it names credentials the way the issuing bodies do.
Who it is built for
Who the workbook fits, and where to go if your need is something else.
Built for
- A contractor or office manager tracking trade licenses, EPA 608, and OSHA cards across a crew.
- A shop up to about fifty people with two to three tracked items each that needs the office to see a lapse before a crew is idled.
- A field operation that needs the blocks-work read and a quarterly verification walk, not a spreadsheet nobody has audited.
If your need is different
- The attendance and no-show side of the field. The Crew Attendance and No-Show System runs that.
- The whole field HR program in one purchase. The Construction and Trades HR System bundles this with the rest.
Before you buy
Does it tell me which licenses my jurisdiction requires?
Is blocks-work automatic?
How many people can it track?
Do I need special software?
What is the refund policy?
What happens after I buy?
Can I expense this purchase to my business?
The 6 red flags to check before you discipline or fire someone
A five-minute screen that catches the most common and most expensive people-decision mistakes before they happen. Free PDF, sent to your inbox. Unsubscribe anytime.
One register, the cards that stop a job first
Your roles, your crew, and the intervals you set: the workbook turns them into days to expiration on every row, the blocks-work flag, the coverage read, and the quarterly walk that keeps it honest.
Recordkeeping and planning support, not legal or tax advice. Last reviewed June 2026.