How to prepare a training compliance report
Build a training compliance report that shows which required courses are outstanding, which records need checking, and who should follow up.
Free app. Runs on your Mac with the Claude or Codex plan you already have.
What a training compliance report is
A training compliance report compares required assignments with valid completions at a dated cutoff. To find required training still outstanding, start with the people and courses covered by your employer's rules on that date. An open course may be due next week, already overdue, or waiting for HR to clear up a record. Those cases call for different actions, even when the learning system gives them the same status.
For each assignment, record the evidence behind the status and the person responsible for the next step. A learning management system (LMS) completion report supplies some of the evidence. Your roster, assignment history, and rules about renewals or exceptions supply the rest. Treat the queue and reminder text as drafts for a qualified HR reviewer.
What it does for the business
- Focus follow-up on people who need itAn owner can set aside completed and exempt assignments. That leaves time to follow up on overdue training and help employees find the course or make time for it.
- Fix gaps in the training rosterWhen the report ties each question to a specific record, HR can route it to whoever can fix the source. A missing assignment for a whole role, for example, gives the training administrator a rule to check before the next group starts.
- Plan around upcoming deadlinesManagers can use upcoming assignments to schedule learning time and plan coverage. Seeing renewals before they become overdue gives managers and employees more flexibility than handling each one as it comes up.
- Answer questions from a dated recordAn internal reviewer can see why an assignment was open at month-end, even if the employee finished it later. The dated view helps the reviewer reconstruct decisions and reconcile reports.
Training compliance report, step by step
Define the roster, rules, and cutoff
Each assignment in the report starts with a dated record or a documented employer rule.
What to do
- Write down the cutoff date, time, and timezone, along with the teams and courses included. For a past cutoff, find roster and assignment records that show who and what was covered at that point.
- Gather dated assignment, completion, and expiration records. Record which teams, courses, and dates each export covers and keep a source reference that another reviewer can follow.
- Read the employer's requirement rules for each course. Check whether employees who changed roles, contractors, and departing staff were covered at the cutoff using the relevant effective dates.
- Compare expected assignments with the export where the rules support that comparison. If a row is missing and the export's coverage is uncertain, open a reconciliation item and record what evidence would resolve it.
- Keep stable employee, course, version, and assignment identifiers. Give reviewers access to the minimum personal information they need to trace an assignment.
Why
A completion-only export can omit people who were never assigned a required course or whose assignments fall outside the export filter. A dated roster and clear scope help you distinguish missing rows in an export from missing assignments.
Determine each assignment's status at the cutoff
Credit a completion to the employee, version, and requirement cycle it actually satisfies.
What to do
- Match on employee ID, course ID, required version, and assignment ID or requirement cycle. Remove exact duplicates and set aside conflicting records or aliases you cannot resolve with reliable source evidence.
- Keep the exported status and the event date in separate fields. Check whether the course completion meets the accepted version or equivalence rule, was achieved by the cutoff, and was valid on that date.
- Check whether the source records a finished lesson or a finished course. Record expired credit and progress separately so the reviewer can see whether a renewal is open and how far the employee has progressed.
- Use the supplied due date and timezone. Treat a date-only deadline as ending at the end of the local day. Mark incomplete required assignments Overdue only after the deadline has passed. Use Upcoming for those with later due dates.
- Check any training exemption for its scope, approving authority, and expiration. Record an exemption valid at the cutoff as Exempt. Use Verify whenever a missing date, timezone, or rule would change the status.
Why
An export generated after the cutoff can include a recent pass that would distort an earlier report. An employee may also have credit for an earlier cycle and an open renewal. The assignment and event dates let you reconstruct the status on the reporting date.
Build the exception queue and draft reminders
An exception row should give its owner enough evidence to act.
What to do
- Use one row per scoped assignment with its requirement, due date, completion or expiration date where available, status, and an exact source locator. Keep any exclusions with their reasons.
- Group rows into Overdue, Upcoming, Complete, Exempt, and Verify. Give each row an action or disposition, and assign an owner who can carry it out. For a disputed match, ask the training administrator to resolve the identifier against the original record.
- Count unique assignments in each status and state the population counted. Report roster and identity gaps separately so the assignment totals are easy to interpret.
- Group reminder drafts only by resolved employee ID. Include the course and version, deadline, and the supplied learning link if there is one. Use the channels or owners already provided, and keep the wording focused on the training and next step.
- Handle Verify cases through internal requests for the missing evidence. Hold employee reminders when there is an unresolved identity, disputed source status, or uncertainty about whether the assignment applies.
Why
An employee can complete a course, the training administrator can check a missing assignment, and HR can confirm whether an exemption applies. Giving each owner a precise source reference makes it easier to check what happened before taking action.
Check the flagged rows against the sources
Review each consequential finding against the exact evidence that supports it.
What to do
- Ask a second reviewer to check material findings against the original training records where possible. If you review your own work, set a checklist first, make a separate source-to-report pass, and write down who checked it.
- Recheck late and expired cases against the cutoff and timezone, the correct requirement cycle, and the accepted version. Trace approved exemptions to their evidence and confirm their status reflects the date in question.
- Recount unique assignments from stable keys and compare the detailed queue with the summary. Keep enough information to reproduce the counts. Leave coverage gaps visible and omit rates when the population is uncertain.
- Open the source locators and read the proposed owner actions. Hold disputed rows for the owner to resolve and confirm that each remaining reminder identifies the intended recipient and the right assignment.
Why
A wrong match can put the same employee on two lists or send a reminder for a course they already passed. Rechecking the evidence independently of the first classification helps catch those cases. It also gives the report owner a clear basis for holding a row when the training records still conflict.
Hand off the draft for owner action
Put unresolved cases that could change the next action where the owner can see them first.
What to do
- Lead with the cutoff and the finding that needs attention. Put consequential unresolved cases first so the reviewer can decide which ones to resolve before contacting employees.
- Give the owner a short queue with the employee or assignment, status, due date or validity, action, and a source they can open. Keep proposed actions separate from findings so the next reviewer can tell what has happened.
- If there are no actionable rows, summarize the coverage and what the supplied sources establish. Record any missing scope separately so a reader can tell how far the finding applies.
- Have a qualified HR reviewer clear the draft, confirm owners, and approve any reminders before they are sent. Give the reviewer a handoff that lists the files, what was held, and the first action to take.
Why
The owner can reproduce the finding, check whether the assignment still needs action, and follow up using current records. The recorded cutoff preserves the history when a later review changes the status.
Common mistakes
- Reviewing completions without checking assignmentsUse the dated roster and employer's rules to see who was expected to take the course and where the assignment export has gaps.
- Joining on employee nameUse stable IDs so that two people with the same name do not share a completion history.
- Counting any pass for a renewalCheck that the accepted version, requirement cycle, achieved date, and validity interval satisfy the current assignment at the cutoff.
- Treating exemptions as completionsRecord a valid training exemption as its own status and keep the scope and expiration with the evidence.
- Sending reminders for unverified rowsSend unresolved records to an internal owner who can check the source before anyone contacts the employee.
What a good result looks like
- A defined cutoff and timezone, with the covered people, courses, and source gaps recorded.
- A stable key and a traceable row, message, or policy reference for every assignment.
- A status that accounts for version, dates, expiry, and any valid exemption.
- Unique assignment totals with the denominator and unresolved coverage recorded separately.
- Specific owner actions and drafts suitable for qualified HR review, with uncertain cases held.
And then what? Using the result
- Ask the training administrator to resolve missing assignments, duplicate accounts, and mismatched identifiers in the source records.
- Check current completions before approving reminders for rows confirmed overdue so people who have since finished receive the right follow-up.
- Give managers the upcoming assignments they own so they can schedule learning time before the deadline.
- Ask the policy owner to clarify any rules that repeatedly put the same course or role into Verify.
- Review again after the owners act and trace status changes to updated assignment, completion, or exemption records.
When to run it
- Before a regular HR reviewA dated snapshot gives the training owner a common basis for discussing open work and deciding which records to reconcile first.
- After an onboarding wave or team transferCompare the effective roster dates with the assignment rules. That can surface missing assignments for new starters or requirements left over from old roles.
- When courses renew or change versionCheck which earlier completions still qualify and which people have an open renewal. Give owners the upcoming dates so they can plan training time.
Questions people ask
How do you find required training still outstanding?
Compare the required assignments with valid completions as of a dated cutoff, then give each open or uncertain assignment a status and an owner. Check the roster and employer rules first so you know whom the comparison covers.
What should a training compliance report include?
Include the scope and cutoff, each assignment's status and key dates, its evidence reference, and its owner's next action. Record coverage and identity gaps separately from assignment counts.
Can an LMS completion report show who is overdue?
Yes, if it covers the required assignments and provides the information needed to judge completion and due dates at the cutoff. If it lists completed courses alone, reconcile it with the roster, assignment records, and employer rules first.
How do you handle expired training?
Apply the employer's validity and renewal rules to the required assignment at the cutoff. Keep the expired credit visible and classify the open assignment according to its own due date and the evidence available.
When should you send a required training reminder?
Send a reminder after a qualified HR reviewer confirms that the assignment applies, the employee identity is resolved, and the latest records still justify contact. Include the training and due date, along with the supplied learning link if there is one.
How should you handle training completed after the reporting date?
Keep the earlier report tied to the original cutoff and use the later completion in an updated review. An owner deciding whether to send a reminder should use the latest verified records.
More jobs in Hiring
Find required training still outstanding, on your own Mac.Free app. Runs on your Mac with the Claude or Codex plan you already have. Your files stay on your computer.
Download for Mac