Practical Template Library · Operations · Free Excel (.xlsx)

Statutory mandatory training ledger template — with sample entries

Track statutory mandatory training for all employees on one sheet. Employees hired after the training date and those who have left are flagged separately, so anyone who still needs the training stands out automatically. The safety and health training log sheet includes fields for attaching training materials and photos.

  • FormatExcel (.xlsx) — just swap in your company logo and approval box
  • What's includedA blank template plus a filled-in example for a fictional company
  • How to get itEnter your company, name, and email for an instant download plus a copy by email
  • CostFree
Get the free templateSee fill-in tips
Statutory training completion ledger template preview — yellow rows are sample entriesEnlarge ⤢

Statutory Training Completion Ledger — yellow rows are filled-in examples

Fields in this template

  • Shows each employee’s completion dates and missing trainings automatically
  • Flags who needs make-up training based on hire and exit dates
  • Statutory training reference table (who, how often, hours, legal basis, records)
  • Safety and health training log (confirms materials and photos are attached)

How to fill it in

  1. Anyone who joins after the annual training date remains incomplete. Hold make-up training after they join and record the date.
  2. Enter an exit date and the status changes to 'Left', removing the person from the incomplete count.
  3. For training that applies only to some employees, such as personal data protection, enter 'N/A' for those it does not apply to.
  4. For safety and health training, mark in the log for each session whether training materials and photos are attached.

Sample entries — view as a table

This excerpt comes from an example filled in for a fictional company, Hanbit Precision Co., Ltd. (auto parts manufacturing, 280 employees). The file contains the blank template first, followed by the full example. All amounts and figures in the example are assumed, for illustration only.

Filled-in example of the completion ledger

NameHire dateDeparture dateSexual harassment preventionDisability awarenessStatusNotes
Haneul Kim2027-01-042027-02-172027-02-17Completed
Seojun Park2019-03-112027-02-172027-02-17CompletedPersonal data protection 'N/A'
Doyun Lee2027-03-024 not completedJoined after training date — needs make-up training
Yuna Jung2021-07-012027-02-10DepartedLeft before training date

Excel formulas fill in the Status column automatically. Sample names are fictional.

Statutory training reference table (excerpt)

TrainingAudienceFrequencyhours
Sexual harassment preventionAll employeesAt least once a yearNo legal minimum hours (usually 1 hour)
Disability awarenessAll employeesOnce a year1 hour or more
Personal Data ProtectionPersonal data handlersRegular (at least once a year recommended)No requirement
Retirement PensionEmployees enrolled in DB/DC retirement plansOnce a yearNo requirement

The file includes the occupational safety and health training requirements and a safety and health training log. Check for legal amendments before use.

Get the Statutory Training Completion Ledger Template

Get other templates too

Download the statutory mandatory training completion ledger template right away. We also email a copy of the same file as a single zip. Company name, name, and email are all required; we don’t collect phone numbers.

1 template selected

Stuck on the template? → Message us about instructors and programs · Check costs first with the quote calculator

FAQ

How do I manage employees who join after the training date?

If you record each employee’s hire date in the ledger, anyone hired after the training date shows up as not completed. Give them make-up training online or by distributing materials after they join, then record the completion date. Inspectors often check this for disability awareness training.

Do I need to attach materials and photos to the safety and health training log?

Along with the training content and attendee signatures, it is safest to keep the training materials and photos for each session. The log sheet in the template has a checkbox to confirm materials and photos are attached.

Are the templates free?

Yes, they are free. Just leave your company name, name, and email to download the template you choose right away. We also email you the same file.

Can I edit the templates to match our company format?

Yes. You may replace the company logo and approval block and use the templates as your internal forms. Please just refrain from selling them elsewhere or redistributing them as they are.

Other practical templates

Every template you need, from planning a single training program to reporting results, is free. Browse the full template library →

🗓️ Annual Training Plan📋 Training Needs Survey🧩 Training Program Design✍️ Training Approval Request🔎 Instructor Selection Checklist🪪 Instructor Card (for Fee Payment)✅ Training Operations Checklist (D-30 to D+7)🖊️ Attendance Sheet & Completion Confirmation⭐ Training Satisfaction Survey📊 Training Results Report🧭 New Hire OJT Plan & Log🌱 Individual Development Plan (IDP)
Document library: working documents for training managers and corporate instructorsYou can get other documents the same way, each with a filled-in example: an AI training adoption proposal, a statutory mandatory training calendar, a training budget table, and a sample instructor proposal.View documents ›

Stuck filling out a template?

Need an instructor or curriculum? Tell us. Within 24 hours, we’ll send you an instructor name, curriculum, and cost breakdown.

Message usQuote calculator

※ The statutory mandatory training cycles and tax rates are general guidelines to make drafting easier. They may vary by your company’s industry and size, so please check the underlying statutes and your company’s tax policy.

Get this template free