Training Manager
ISO 9001:2015  ·  Clause 7.2  ·  v — April 2026
ISO 9001:2015 The QMS Collective, LLC
⚠️ You have unsaved changes. Export to Excel before closing this tab.
Dashboard
Training compliance at a glance
⏰ Expiring Soon (Next 90 Days)
✅

No training expiring in the next 90 days

❌ Overdue Training
✅

No overdue training

🎯 Competency Gaps
✅

All assigned competencies are satisfied

Expiring Training
Recurring training sorted by urgency
Employee Department Training Completed Expires Status
Employees
Employee
🎯 Competency Status
📋 Training History
Log Training
Record a completed training event
➕ New Training Record
Training Type
The category of training being recorded — e.g. AS9100 Internal Auditor, LOTO, First Aid. Training Types are defined under the Training Types tab and each carries a default recertification frequency. Selecting the correct type ensures this record feeds the right competency tracking and expiration alerts.
Frequency (Recertification)
How often this employee must repeat this training. The tool uses this value to calculate the next due date and will flag the record on the Expiring Soon view when that date approaches. Selecting N/A means no recertification is required — the record is treated as permanently valid. This field auto-populates from the Training Type default but can be overridden per record.
Certificate / Reference #
The certificate number, document control number, or external reference that proves this training occurred. During an AS9100 audit, this number is the link between the training record and objective evidence — the physical certificate, test result, or training log the auditor will ask to see. Leave blank only if no documentary evidence exists.
Training Records
Employee Department Training Type Date Completed Expires Status Trainer
Competencies
Define requirements and assign them to employees
Competency Links To Training Type Recurrence Global Assigned To
Employee Department Competency Status Last Completed Expires
Training Types
The catalog of training courses available to log
Training Type Default Frequency Description Records
Departments
Manage the list of departments in your organization
Department Name Employees Training Records
All changes saved in browser
v

Training Manager — User Overview

The QMS Collective, LLC  ·  ISO 9001:2015 · Clause 7.2  ·  v

Why This Tool Exists

Most small aerospace shops track employee training in spreadsheets — or not at all. When an auditor asks for objective evidence of competence under ISO 9001:2015 Clause 7.2, a disorganized spreadsheet is a finding waiting to happen. The Training Manager replaces that spreadsheet with a structured register that logs training records, tracks recertification due dates, links training to competency requirements, and exports audit-ready evidence in seconds.

How It Works

Set Up Departments → Add Training Types → Add Employees → Define Competencies → Log Training → Monitor Dashboard

What This Tool Does for You

  • Eliminates manual expiration tracking. The tool calculates every recertification due date automatically and surfaces expiring records before they lapse.
  • Closes the competency gap. Linking Training Types to Competencies means completing a training record automatically satisfies the associated competency — no double entry.
  • Produces audit evidence in seconds. Export a complete, formatted training register to Excel for any internal audit, external audit, or registrar review.
  • Preserves historical records. Inactive employees and superseded records are retained — critical for demonstrating sustained compliance over time.
  • Survives browser closes. Every data change auto-saves to localStorage and every Excel export includes a hidden backup sheet for full restore.

Before You Start

📋Your current employee roster — names, departments, job titles, and hire dates.
📚A list of training types your organization requires — safety, quality, regulatory, and job-specific.
🔁The recertification intervals for each training type (check your procedures, customer requirements, or regulatory source).
📁Any existing training records you want to enter — certificates, attendance logs, or test results with reference numbers.
🎯Your competency matrix or job descriptions, if you want to link training types to specific competency requirements.

What This Tool Produces

Training Register (Excel)Complete record of all training events with employee, type, date, score, and certificate reference — formatted for auditor review.
Expiring Soon ReportLive view of training records approaching or past their recertification due date — filterable by urgency window.
Employee Competency ProfilePer-employee view of all training history and linked competency status — accessible from the Employees tab.
Competency Status RegisterOrganization-wide view of which employees hold which competencies and whether they are current.
Dashboard SummaryAt-a-glance KPIs: total records, expiring within 30/60/90 days, overdue count, and department coverage.
Excel BackupEvery export includes a hidden _Backup sheet with full JSON state — load the file to restore all data exactly as exported.

Support

Questions? Contact The QMS Collective, LLC — clayton.kuehl [at] theqmscollective.com

The QMS Collective  │  Training Manager  │  User Overview  │  v © 2026 The QMS Collective, LLC. Proprietary and Confidential.