Training Tracker: What It Is and How UK Businesses Use One

A training tracker is the live record that tells you, at any given moment, who in your organisation is trained, what they are trained in, when those qualifications expire, and what is outstanding. It is the document an HSE inspector, CQC auditor, or employment tribunal would ask to see if a training-related dispute arose.

Most UK businesses have something that functions as a training tracker. The question is whether it would hold up under scrutiny — and whether it would tell you what you need to know before a problem forces the issue.

What a training tracker actually is

The terms training tracker, training matrix, and training log are used interchangeably in practice. They refer to the same thing: a record that captures, at minimum, four pieces of information for each employee:

1. What training they have completed
2. When they completed it
3. When it expires (if it expires)
4. Whether they have been assessed as competent

The Health and Safety Executive's guidance on competence defines competence as "the combination of training, skills, experience and knowledge that a person has and their ability to apply them to perform a task safely." A training tracker is how you demonstrate that combination exists for each employee.

Without a tracker, you have training but no record of it. Without a record, you cannot demonstrate compliance when it matters — and compliance only gets tested when things go wrong.

What a training tracker must contain

A tracker that satisfies UK regulatory expectations covers the following for each training item per employee:

Field	Why it matters
Employee name and role	Identifies who the record belongs to and whether the training is relevant to their function
Training title and type	Distinguishes between statutory, mandatory, and development training
Completion date	Establishes when the training took place
Expiry or renewal date	Identifies when the qualification lapses and refresher training is required
Trainer or provider name	Enables verification of trainer competence (HSE requirement)
Assessment method	Records how competence was confirmed — test, observation, practical assessment
Assessment outcome	Confirms competence, not just attendance
Certificate reference	Links the tracker entry to the physical or digital evidence
Status	Current / expired / pending renewal — should update automatically or be reviewed regularly

The 5 training record mistakes that trigger HSE investigations all trace back to missing fields in this list. The most common is having no expiry date column, which means the tracker shows training as valid long after the certificate has lapsed.

The difference between a training tracker and a training plan

A training plan tells you what training is needed and schedules it for the future. A training tracker records what has been completed and its current status.

Both documents are necessary. The plan without the tracker produces no record. The tracker without the plan produces reactive catch-up rather than systematic compliance.

If you have a training plan that schedules upcoming training, see our guide on training plan templates for the structure that feeds into your tracker once training is delivered.

Three formats for training trackers — and where each breaks down

Spreadsheet tracker (Excel or Google Sheets)

Suitable for: teams of up to 15 to 20 employees with a relatively stable training requirement.

What it does well: flexible, no software cost, easy to share with a manager, straightforward to audit.

Where it breaks down:

• Expiry alerts must be set up manually (conditional formatting or a separate formula column). When someone adds a row without following the formula structure, the alerts stop working silently.
• No audit trail. If a record is changed — intentionally or accidentally — there is no log of who changed it or what the previous entry was. In a tribunal or HSE investigation, an unsourced change to a training record damages credibility significantly.
• No version control. When the tracker is saved locally rather than in a shared drive, different managers hold different versions. Reconciling them when an inspector arrives is not a good use of time.
• Access control is binary: either someone can edit the entire document or they cannot. You cannot give a line manager update rights for their team only.

For a detailed view of why spreadsheets specifically fail under inspection scrutiny, see Why Your Excel Training Matrix Will Fail an HSE Inspection.

Shared cloud spreadsheet (Google Sheets, SharePoint Excel)

Suitable for: teams up to around 50 employees where a central HR or compliance function manages the tracker.

What it does well: shared access without version conflicts, easier to enforce a standard format, accessible from multiple devices.

Where it breaks down:

• Expiry alerts still require manual formula maintenance — and cloud spreadsheets do not send push notifications by default.
• Audit trail remains absent unless change history is turned on and someone monitors it.
• As staff count grows beyond 50, filtering and maintaining the spreadsheet becomes a part-time job.

Purpose-built training management software

Suitable for: organisations with 20+ employees, high staff turnover, multi-site operations, or sector-specific compliance requirements (care homes, construction, food production).

What it does well: automatic expiry alerts, built-in audit trail, role-based access, bulk completion logging, integration with HR systems, one-click compliance reports for audits.

Where it breaks down:

• Cost. Most platforms price per user per month, which adds up for larger teams.
• Data migration from a spreadsheet takes time to do correctly. Partial migrations leave gaps that are worse than starting clean.
• Over-configuration. Some platforms offer more customisation than the organisation needs, leading to an underused system with incomplete data.

For a structured comparison of when it is worth switching from a spreadsheet to software, see Online Training Matrix vs Spreadsheets: When to Switch.

How to set up a training tracker from scratch

If you are building a tracker for the first time or replacing a broken one, this sequence prevents the most common gaps:

Step 1: Define your training categories. Separate statutory requirements (set by law), mandatory organisational requirements (set by your policies or sector standards), and role-specific training (identified through appraisal or needs analysis). Each category has different update frequencies and different consequences for gaps.

Step 2: List every role, not every individual. Start by mapping training requirements to roles rather than employees. A customer service agent has different requirements than a warehouse operative or a care home nurse. Once role requirements are defined, applying them to individuals is a quick lookup rather than a rebuild.

Step 3: Populate historical records before going live. An empty tracker is worse than no tracker — it suggests training has never happened. Pull existing certificates, attendance records, and induction logs and populate the tracker before anyone is expected to use it. Flag gaps as genuine gaps, not missing data.

Step 4: Set expiry alerts on day one. Whatever format you use, expiry alerts must work before the first live entry is added. In Excel or Google Sheets, use a formula column that calculates days to expiry and conditional formatting to flag anything within 60 days. If you cannot make the alerts work reliably, use automated training expiry alerts instead — see How to Set Up Training Expiry Alerts That Actually Work for the method.

Step 5: Assign one person to own the tracker. A training tracker with shared but unnamed ownership drifts. One person is responsible for ensuring it is accurate, that new employees are added, and that completions are logged within five working days of the event. Name that person in your training plan.

The inbound link: connecting tracker to records

A training tracker entry is only as good as the evidence behind it. Every entry needs a reference to where the physical or digital certificate is stored — a document management folder, a personnel file, an HR system.

When the tracker says an employee completed fire safety training on 12 March 2025, the inspector should be able to follow that reference directly to the certificate. If the certificate does not exist, the tracker entry is a claim, not a record.

Building this link from day one — rather than retrofitting it when an audit is imminent — is the single change that most improves a tracker's value as a compliance document.

What a working training tracker tells you at a glance

A properly maintained training tracker answers five questions without searching:

1. How many employees are fully compliant right now?
2. Which employees have training expiring in the next 30 days?
3. Which employees have overdue training they have not completed?
4. When did each qualification last get renewed?
5. Who delivered each training session, and are they qualified to deliver it?

If your current tracker cannot answer all five in under 30 seconds, it has structural gaps worth fixing before they surface in an audit. Use our training compliance gap checker to identify where your records are weakest.

---

TrainProof is built around the training tracker. Every record includes the fields inspectors look for, expiry tracking is automatic, and the audit trail is built in from day one.

Join the waitlist to be notified when it is ready.