Home › Free workplace documents › Training and certificate expiry tracker

Free workplace documents

Free training and certificate expiry tracker

A training matrix that works out every expiry date for you, counts the days left and turns each certificate green, amber or red. Excel and Google Sheets, free.

Free training and certificate expiry tracker (cover)

Most expired first aid certificates are not neglect. Nobody was watching the dates. A certificate quietly runs out, the trained person leaves or changes shift, and the first anyone knows is when an inspector, an insurer or an accident asks who the first aider is.

This tracker fixes that. Add your staff and the courses they have done, with the date. It works out the expiry date, counts the days left, and colours each one: green while valid, amber when due within 90 days, red when expired. A dashboard shows totals by course so a manager can see the whole team at a glance.

It comes with the common courses already set up and lets you add your own, with your own renewal rule for courses that have no fixed legal expiry.

The key facts

Emergency First Aid at Work and First Aid at WorkValid 3 years. HSE strongly recommends a short annual refresher in between. Requalify before expiry; once it has lapsed you usually need the full course again.
Paediatric First AidRenewed every 3 years under the Early Years Foundation Stage.
Mental Health First AidNo legal expiry. Three-yearly refreshers are the common policy.
Fire marshal, manual handling, safeguarding, food hygieneNo fixed legal expiry for most. Set your own policy; yearly to three-yearly is typical. The tracker lets you choose per course.

Based on HSE guidance and the EYFS framework, checked October 2026. Your own regulator, insurer or contract may ask for more.

What is inside the document

  • Automatic expiry dates, days left and green, amber, red status
  • Drop-down lists for staff and courses
  • Ready-made course list: EFAW, FAW, paediatric, refreshers, mental health first aid, fire marshal, manual handling, moving and positioning, safeguarding, food hygiene
  • Dashboard by course
  • Start-here instructions
  • Works in Excel and Google Sheets

It comes with the other two free documents: all three arrive in one email.

How to track first aid certificate expiry dates

  1. List your people and courses. Add each person once, and pick the course from a drop-down list.
  2. Type the date completed. The tracker works out the expiry date and the days left using the lifespan you set for that course.
  3. Watch the colours. Green is valid, amber is due soon (90 days or less), red is expired and grey means you have not set a lifespan yet.
  4. Book renewals early. Check the dashboard at the start of each month and book before the date, not after.

Why expiry dates matter

An expired certificate no longer counts. A workplace that relied on one first aider can find itself with no cover overnight, and an inspector or insurer will ask for dates. EFAW, FAW and paediatric certificates last three years, and HSE strongly recommends a short refresher each year.

Excel or Google Sheets?

It works in both. Open the Excel file in Excel or Numbers, or upload it to Google Drive and open it as a Google Sheet. The colours and formulas carry over.

Not sure how many first aiders you need? Read our guide, or ask us for a quick answer.

Training your team? Get your price now

Emergency First Aid at Work at your premises anywhere in London.

From £50 £100 per person, first booking

50% off the first 12 people of your first on-site booking until 31 March 2027. Minimum 2 places per visit. Certificates included, no VAT. Terms apply.

Where should we send it?

Free. One email with the download links, nothing else unless you tick the box.

Questions people ask

Is a training matrix a legal requirement?

Not by that name. But you must be able to show that your first aiders, fire marshals and others are trained and in date. A matrix is the simplest way to show it, and inspectors expect to see something like it.

Can it remind me by email?

The spreadsheet shows amber at 90 days so you can see renewals coming. If you book your training with us, we also email you a month before each certificate expires.

Can I use it for other training?

Yes. Add any course and set its renewal period. Many care homes use it for their whole mandatory training list.

Does the tracker work in Google Sheets?

Yes. Upload the Excel file to Google Drive and open it with Google Sheets. The formulas and colours work in both.

How do I add my own courses?

Add them on the Courses tab, with how many years the certificate lasts. They then appear in the drop-down lists.

What does SET POLICY mean?

Some courses have no legal expiry. Choose your own refresh period on the Courses tab and the tracker will use it.

What to do next

Written and checked by Esin O. FRSA, founder and lead trainer at Core Aid Training. Based on HSE guidance (L74, 2024 reissue; INDG214). Last reviewed November 2026.