Mandatory Compliance Training Tracker
Assign mandatory trainings to the right people on the right schedule, chase the overdue, and prove 100% coverage - build it yourself with AI, no developer required.
A working internal tool that generates training assignments by role/location/tenure, gets owner approval, sends reminders and escalations, tracks completion, and exports a clean completion report for leadership and auditors.
Before you start
- A training catalog with required cadence and audience rules (a Sheet or CSV is fine)
- An employee roster with role, location, and start date
- Completion records (or a way to mark them as people finish)
- Free accounts on Vercel, Supabase, and Resend
The problem this kills
Every year the same fire drill: harassment training, security awareness, safety, code of conduct - everyone has to finish by a date, and you are the one who has to prove they did. So you live in a spreadsheet. You cross-reference the roster against completion exports, hand-build reminder emails, chase managers, re-chase the same five people, and pray you did not miss the new hire who started in March or the person who was on leave in April.
Then an auditor asks for proof of 100% coverage and you spend a day reconstructing who was assigned what, when it was due, and who signed off on the exemptions. It is exhausting, error-prone, and it does not have to be you doing it by hand.
What you'll build
A small internal web app that runs your compliance training cycle for you:
- Loads your training catalog (each training, its cadence, and who it applies to) and your employee roster.
- Generates the assignment list automatically using your real rules - by role, location, and tenure - and auto-assigns new hires on their start date.
- Routes that list to the compliance owner for approval before anything goes live.
- Sends reminders as due dates approach, then escalates overdue items to managers and, if still ignored, to leadership.
- Tracks completion and handles the messy parts: leaves of absence, exemptions, and people who change roles mid-cycle.
- Produces a completion report the owner signs off on, plus a CSV export of status by person and training - exactly what leadership and auditors want.
What's inside the Implementation Plan
The plan is a single file you paste into an AI coding agent (Claude Code). It builds the whole tool with you, step by step, in plain language.
The first thing it does is interview you about your business - your trainings, your roster shape, your role/location/tenure rules, your approval chain, and your edge cases like leaves and exemptions. It reflects a short tailored spec back to you and waits for your thumbs-up before writing a line of code. That is the difference between a tool that fits how you actually run compliance and a generic template you have to fight.
From there it walks through every build step - database, login, assignment engine, the approval gate, reminders and escalations, completion tracking, and the report - and each step ends with a ready-to-copy prompt. No prior coding needed.
The governance it includes (this is the point)
This is a compliance tool, so it is built like one from the start:
- Login so only your team can use it.
- Row-level security so people only ever see their own organization's data.
- A complete audit trail - who assigned what, who approved, who completed, and exactly when.
- A human-in-the-loop approval gate - the tool drafts the assignment list and the final report, but a person reviews and approves before anything is committed or sent to leadership. Exemptions require explicit approval too.
- Duplicate guards keyed on employee + training + due-period, so nobody gets double-assigned and the same completion never lands twice.
Who it's for
Compliance, HR, and operations leads who own "everyone must complete X by date Y" - and who need to prove it. If you have ever rebuilt a coverage report from three exports the night before an audit, this is for you. You do not need to be technical.
You've got this - paste the first prompt and let the agent interview you.