Staff Training Records — Training Matrix & Certificate Expiry Spreadsheet

£24.99

Build your hospitality bundle

Tick the sheets you want. The discount is worked out here and added in your basket automatically.

Any 3 – 15% offAny 5 – 25% off10 or more – 40% off
  • £24.99
  • £29.99
  • £29.99
  • £29.99
  • £29.99
  • £24.99
  • £24.99
  • £19.99
  • £19.99
  • £19.99
  • £19.99

Know who's trained, what's expired and what's due next. Keep a record of every course your staff complete. Works in Excel & Google Sheets. No macros, no subscription. Instant download: blank sheet, filled-in DEMO and a full PDF guide.

Digital download, available immediately. By buying, including with Google Pay or Amazon Pay, you agree to immediate access and that your 14-day right to cancel ends once your download is available. See our Terms and Refund Policy.

RestaurantsPubsCafésBarsHotelsTea roomsGastropubsBistrosTakeawaysFood trucks
Instant downloadLink straight after checkout and by email
Excel or Google SheetsMac, PC, Chromebook. No macros
Start Here guide built inPlain-English steps for every tab
Secure checkoutCard, Apple Pay and Google Pay

Sound familiar?

The inspector asks. The certificates are in a drawer.

  • Certificates in a drawer or someone’s email
  • Training lapses without anyone noticing
  • New starters missing key courses
  • No quick way to show who’s done what

That’s not a you problem. It’s a missing-system problem.

Why managers love it

Log a course once. Expiry dates work themselves out.

  • Expiry dates from your course list
  • Training matrix: green, amber, red
  • Due-soon warnings, 60 days by default
  • Missing training counted
  • Your own courses and job titles
  • Renewals kept in the log

How it fits together

Log it once. The matrix updates itself.

  1. StaffNames and job titles
  2. Training logOne line per course
  3. ExpiryWorked out for you
  4. MatrixGreen, amber, red
  5. DashboardExpired and due soon
Staff training dashboard with expired and due-soon courses

The dashboard

See what’s expired and what’s due.

Expired and due-soon training listed soonest first.

Staff100On the matrix
Log rows3,000Courses completed
Warning60Days before expiry
Monthly fees£0One payment, yours to keep

What’s inside

6 tabs, one file. Click through them.

Dashboard

Active staff, expired, due soon and missing training, listed soonest first.

Training matrix with every member of staff

Matrix

Everyone on one screen.

  • Green is in date
  • Amber is due soon
  • Red is expired or missing

Before and after

From guessing to knowing.

Without it

  • Certificates in a drawer
  • Expiry dates missed
  • No overview of the team
  • Panic before an inspection

With the sheet

  • Every course logged
  • Expiry worked out
  • The whole team on one matrix
  • Ready to show an inspector

What you get

Everything in one download.

The training records workbookReady for your team
A filled-in DEMO copySee it working before you add your own
Full PDF user guideSet-up, every tab and the rules explained
Colour themesPick one to match your venue
Works everywhereExcel or Google Sheets, Mac or PC
Help if you’re stuckMessage me any time and I’ll help you set up

Up and running before service

Four steps.

  1. Buy and downloadThe link arrives straight away
  2. Open itIn Excel, or upload it to Google Sheets
  3. Check the DEMO and guideThen fill in your blank copy
  4. Start using itEverything else works itself out

Made for

  • Independent restaurants, pubs, cafés and hotels in the UK
  • Owners, managers and head chefs who do the admin themselves
  • Anyone who’d rather not pay monthly for software

Not for

  • Delivering the training itself
  • HR or payroll
  • Large chains with their own systems

A record-keeping spreadsheet, not legal, tax or accounting advice. Check renewal periods with your training provider or local authority.

Before you buy

Questions

How does it know when training expires?

In Settings you list your courses and how many months each one lasts (or leave it blank if it never expires), and which courses everyone needs. Check renewal periods with your training provider or local authority.

How much warning do I get?

You choose. The default warning period is 60 days before expiry.

Do I need Microsoft Excel?

No. It works in Microsoft Excel, or free in Google Sheets.

Is it a subscription?

No. It is a one-off payment and the file is yours to keep. There are no monthly fees.

I'm not good with spreadsheets. Is this for me?

Yes. You type into the yellow boxes and everything else works itself out. There are no formulas to write, and the How to use tab walks you through it.

Can I see it before I buy?

Yes. Look through the screenshots above. Your download includes a filled-in DEMO copy and a full PDF guide as well as the blank spreadsheet, so you can see exactly how it works before adding your own.

Does it work on a Mac, iPad or phone?

Yes on a Mac: use Excel for Mac, or open it free in Google Sheets in your web browser. On an iPad or phone you can open it in the free Excel or Google Sheets app, but a computer is easier for setting it up.

Can I get a refund?

Because it is an instant digital download, I can’t offer a refund once the file has been downloaded. If the file is faulty and I can’t fix it, you were charged twice, or you received the wrong product, I will put it right or refund you. See the Refund Policy. This doesn’t affect your statutory rights.

How do I get my file?

It is an instant digital download. You will get a download link straight after checkout, and by email.

What if I get stuck?

Message me any time and I will help you get set up.

Ready when you are

Know your team is covered.

£24.99 once. Download it now and log your team today.

Buy now, instant download

More spreadsheets for restaurants, pubs & cafés →

Full product details, tabs list and notes

Description

Sound familiar?

  • Certificates are in a drawer and you can't prove who has done what.
  • Food hygiene or fire safety training lapses without anyone noticing.
  • An inspection is coming and you're digging through emails.

What the Staff Training Records does

Keep a record of every course your staff complete. It works out when each certificate expires, shows everyone at a glance on the Matrix, and lists what has expired or is due soon on the Dashboard.

What’s inside

  • How to use – step-by-step instructions and what the colours mean
  • Settings – your business name, lists for the drop-downs and a colour theme picker
  • Dashboard – active staff, expired, due soon and missing training, listed soonest first
  • Staff – names, job titles and start dates
  • Training Log – one line per course completed, with expiry and status
  • Matrix – everyone against every course: green, amber or red

Format

  • Your blank spreadsheet (.xlsx, UK edition), ready for your business
  • A filled-in DEMO copy, so you can see every tab working before you start
  • A full PDF user guide: set-up, every tab explained, a daily routine, the rules that apply and answers to common questions
  • Works in Microsoft Excel (Windows and Mac) and Google Sheets
  • No macros, nothing to install, no subscription
  • Yellow boxes are for you to fill in; pale green boxes work themselves out

How it works

  1. Buy and download the file straight away.
  2. Open it in Excel, or upload it to Google Sheets.
  3. Open the DEMO and the PDF guide to see how it works, then fill in Settings on your blank copy and start typing your own.

Please note

This is a digital product — nothing will be posted. It is a record-keeping template, not legal, tax or food safety advice. For use in your own business only — please don’t resell or share the file.

Questions before you buy? Message me any time — happy to help!

Staff Training Records FAQ

How does it know when training expires?

In Settings you list your courses and how many months each one lasts (or leave it blank if it never expires), and which courses everyone needs. Check renewal periods with your training provider or local authority.

How much warning do I get?

You choose. The default warning period is 60 days before expiry.

Do I need Microsoft Excel?

No. It works in Microsoft Excel, or free in Google Sheets.

Is it a subscription?

No. It is a one-off payment and the file is yours to keep. There are no monthly fees.

I'm not good with spreadsheets. Is this for me?

Yes. You type into the yellow boxes and everything else works itself out. There are no formulas to write, and the How to use tab walks you through it.

Can I see it before I buy?

Yes. Look through the screenshots above. Your download includes a filled-in DEMO copy and a full PDF guide as well as the blank spreadsheet, so you can see exactly how it works before adding your own.

Does it work on a Mac, iPad or phone?

Yes on a Mac: use Excel for Mac, or open it free in Google Sheets in your web browser. On an iPad or phone you can open it in the free Excel or Google Sheets app, but a computer is easier for setting it up.

Can I get a refund?

Because it is an instant digital download, I can’t offer a refund once the file has been downloaded. If the file is faulty and I can’t fix it, you were charged twice, or you received the wrong product, I will put it right or refund you. See the Refund Policy. This doesn’t affect your statutory rights.

How do I get my file?

It is an instant digital download. You will get a download link straight after checkout, and by email.

What if I get stuck?

Message me any time and I will help you get set up.

Reviews

There are no reviews yet.

Only logged in customers who have purchased this product may leave a review.