Certification & License Renewal Reminders: Never Run on an Expired Credential
Map required credentials to roles, register every employee's certs and licenses, and send tiered renewal reminders before they lapse — with HR verifying each renewal proof before anyone is marked current.
A web tool where you map required credentials to roles, register each employee's certifications and licenses with expiry dates and proof uploads, send tiered reminders before expiry, and run a current-vs-lapsed report — with HR verifying each renewal proof before marking anyone current.
Before you start
- A Supabase account (free)
- A Vercel account (free)
- A Resend account (free)
- A list of your roles and the credentials each one requires
- Your current employee credential register (or a spreadsheet of it)
- Claude Code or any AI coding agent
The problem this kills
In a licensed or regulated shop, an expired credential is not a paperwork problem — it's a "we cannot legally let this person work" problem. The CNA whose certification lapsed last Tuesday. The electrician whose journeyman license expired and nobody noticed. The advisor whose continuing-education deadline slipped past. Someone in HR is supposed to be tracking all of this, usually in a spreadsheet with a column of expiry dates and a personal reminder to "check it every month."
That system fails quietly. A row gets missed, a renewal email goes to a stale address, an employee swears they renewed but never sent proof, and you find out during an audit — or worse, after an incident — that someone has been working on a credential that expired weeks ago. You don't need to live with that risk, and you don't need to be a developer to fix it.
What you'll build
A simple internal web tool. First you map your roles to the credentials each one requires (a Registered Nurse needs an active RN license + BLS; a forklift operator needs a current operator certification). Then you register each employee's actual credentials — type, number, issuing body, expiry date, and a proof upload. The tool computes who's expiring, sends tiered reminders (say 90 / 30 / 7 days out, then overdue) to the employee and their manager, and collects the renewed proof. HR opens each renewal, verifies the proof, updates the expiry, and only then marks the employee current. A live report shows exactly who is current, who's expiring, who's lapsed, and — critically — who is missing a required credential entirely.
What's inside the Implementation Plan
The downloadable plan is a step-by-step file you paste into an AI coding agent. It opens by interviewing you about your business — which roles you staff, exactly which credentials each role requires, how your existing register is laid out and named, your reminder lead times, your grace-period rules, and your messy edge cases — and then it tailors the data model, the reminder schedule, and every later step to your answers. This is not a generic template; the agent reflects a short spec back to you and waits for your thumbs-up before it builds anything. From there it walks the agent through the role-to-credential mapping, the per-employee register with proof uploads, the expiry math, the tiered reminder emails, the HR verification-and-approve screen, and the current-vs-lapsed report — each step with a ready-to-copy prompt. There's also a fallback so you can build the whole thing today even with no integration to your HRIS.
The governance it includes (this is the point)
This is real compliance tooling, so it ships with the controls an HR team needs: login so only your team can use it, row-level security so you only ever see your own organization's employees and credentials, a complete audit trail of who verified and updated which credential and when, a hard human-verification gate so no employee is marked current until HR confirms the renewal proof, and duplicate guards keyed on employee ID + credential type so the same credential can't end up with two competing active records. Lapsed credentials are flagged for action and require a manager acknowledgment, and proof documents are stored in access-controlled Storage — not an open shared drive.
Who it's for
HR and operations leaders in regulated or licensed fields — healthcare, the trades, finance, transportation, childcare — who are accountable for keeping every required credential current. If you can describe which roles need which credentials, you can build this.
You've got this — start with the plan, paste the first prompt, answer the interview, and you'll see your current-vs-lapsed board light up the same afternoon.