{"product_id":"license-certification-tracker-trades","title":"License and Certification Tracker, Trades Edition","description":"\u003cp\u003eOne expired card can idle a crew, fail an inspection, or stall a permit pull, and the office usually finds out the hard way. Trade licenses, EPA 608 certifications, and OSHA cards get tracked from memory, a wall calendar, and a spreadsheet nobody has audited against the cards people can produce.\u003c\/p\u003e\u003cp\u003eThe License and Certification Tracker, Trades Edition, gives you 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.\u003c\/p\u003e\u003ch3\u003eWhat is inside\u003c\/h3\u003e\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003e1. Start Here (PDF).\u003c\/strong\u003e What each file does, the four setup steps, and the rules of the road. One page, read it first.\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003e2. Trades License and Certification Tracker (Excel).\u003c\/strong\u003e Eight working tabs: a Requirement Catalog you map to your roles, a Crew Roster, a License and Card Register where days to expiration and status calculate on every row, a Renewal Pipeline for items in motion, a Per Person View, a Crew Coverage matrix that shows where exactly one person carries a card, a stops-work-first Dashboard, and plain-language Definitions. Works in Excel or Google Sheets.\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003e3. License Verification Log and Renewal Checklist (Word and PDF).\u003c\/strong\u003e The quarterly sight-check walk in five steps, a printable verification log, the 90, 60, 30 day renewal countdown with a checklist at each checkpoint, the new-hire verification step, and a completed example with the gaps it caught.\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003e4. Using This Workbook in Google Sheets (PDF).\u003c\/strong\u003e A one-page note on importing the workbook and what to confirm after the import.\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003ePlus the Product License, one license covering everything in this kit.\u003c\/p\u003e\u003ch3\u003eWhat makes it different\u003c\/h3\u003e\u003cp\u003eA working tracker, not a blank grid. It opens pre-filled with a fictional mechanical contractor so you can see how every tab behaves, then you type over the samples with your own crews and cards. Expired blocks-work items turn the whole row red, and the Dashboard puts them ahead of everything else.\u003c\/p\u003e\u003cp\u003eIt tracks your rules; it does not invent them. Jurisdiction and renewal interval are your entries, every pre-filled interval is flagged as a sample in the same row, and credentials are named correctly: EPA Section 608 as the federal credential it is, and OSHA 10 and 30 hour cards as the course-completion cards OSHA describes, not as certifications.\u003c\/p\u003e\u003ch3\u003eQuestions contractors ask\u003c\/h3\u003e\u003cp\u003e\u003cstrong\u003eDoes it tell me which licenses my jurisdiction requires?\u003c\/strong\u003e\u003c\/p\u003e\u003cp\u003eNo, and that is deliberate. Requirements and renewal intervals vary by jurisdiction, trade, and issuing body, and they change. The workbook structures your entries and does the date math; you confirm the rules with the issuing body or your licensing authority.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eIs blocks-work automatic?\u003c\/strong\u003e\u003c\/p\u003e\u003cp\u003eYou decide per row whether a lapse pulls someone off the job. The Dashboard then surfaces those items first, ahead of everything else.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eHow many people can it track?\u003c\/strong\u003e\u003c\/p\u003e\u003cp\u003eIt holds 120 register rows, 40 roster rows, and 30 catalog requirements, enough for most shops up to about fifty people with two to three tracked items each. If you outgrow it, email support@truestephr.com and we will size it up for you.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eDo I need special software?\u003c\/strong\u003e\u003c\/p\u003e\u003cp\u003eNo. The workbook opens in Excel or Google Sheets, the checklist opens in Word with a PDF copy, and a short guide for the Sheets path is included.\u003c\/p\u003e\u003ch3\u003eScope\u003c\/h3\u003e\u003cp\u003eThis kit is general information to help you track licenses and certifications in a clear, consistent, and defensible way. It is not legal or tax advice, and it is not a substitute for qualified counsel on your specific situation. 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.\u003c\/p\u003e\u003cp\u003eBuilt by expert HR practitioners and leaders. Backed by a 14-day money-back guarantee. Questions: support@truestephr.com. Last reviewed June 2026.\u003c\/p\u003e","brand":"TrueStep HR","offers":[{"title":"Default Title","offer_id":52661049327892,"sku":"TSHR-124","price":49.0,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1013\/9048\/3732\/files\/TSHR-124__license-certification-tracker-trades-hero.jpg?v=1781364361","url":"https:\/\/shop.truestephr.com\/products\/license-certification-tracker-trades","provider":"TrueStep HR","version":"1.0","type":"link"}