Create your free CareStream account to:

  • Give every member of staff CPD certified training, free
  • Track who has finished in your training matrix
  • Run any of our 100+ free audit templates with your team
  • Check your first 5 policies against CQC regulations
  • Add as many staff logins as you need
  • Certificates for every course, with access that never expires

CPD training, audits and policy checks in one place

Free for ever · No card needed · Upgrade any time and keep everything

CPD Certified
Scenario

Your training matrix is a spreadsheet of guesses. Is it true today?

A coloured spreadsheet is only as true as the last person who edited it. CareStream builds your training matrix from completions recorded in the system, so it shows who is in date, due soon or expired today. You can open it before an inspection, not after.

Book a demo

14 day free trial · Set up in a day · UK data residency

The scenario

The inspector's question is simple. The answer is not.

A scenario we see in many care settings.

Asha manages a care home. Training certificates sit in each staff folder, and she keeps a spreadsheet with a coloured square for every person and every course. It looked fine in March. Then three carers joined, a fire safety certificate ran out and nobody changed a colour. A visit could come any week. Asha does not need a prettier grid. She needs a staff training matrix that is true today, and a way to hand it over without a scramble.

A care home manager points to a printed grid of coloured squares pinned beside a laptop while a senior carer looks on in a clear, tidy, bright office
Last spring

Everyone completes the mandatory courses and certificates go into staff folders.

The same week

Asha builds a spreadsheet with a coloured square for each person and course.

Spring

The squares are green and the team feels well prepared.

Summer

Three new carers join. Nobody adds their rows to the sheet.

Autumn

A fire safety certificate expires. The square stays green.

Each month

Colours change by hand, when someone remembers to open the file.

This week

Nobody can say who is due for renewal in the next two months.

?
Inspection day

"Can I see who is in date for safeguarding and moving and handling?"

The training happened. The record of it drifted. A grid that is edited by hand cannot tell you what is true today. Here is how CareStream builds it from the records themselves, and where it stops.

An example scenario, not a named service.

Why it matters

A matrix you maintain by hand is a matrix you cannot trust

The question is not whether training took place. It is whether you can show it, today, without a scramble.

Colours go stale the day after you edit

A spreadsheet does not know a certificate has expired or that a new carer has started. Someone has to notice, and busy managers do not notice everything.

The questions come fast and in pieces

Who has not done safeguarding? Who is due next month? Which seniors are missing moving and handling? Answering from folders and a spreadsheet takes far longer than the question did.

Good records help staffing, not only inspections

A clear matrix shows who is safe to put on a shift and who needs a refresher booked. The staffing use of a matrix matters every week, not once a year.

How it works

From role requirements to a grid you can hand over.

This is the matrix in CareStream, in the order a manager meets it. For what a good grid should hold, read what a care home should put in one. For plans, see the pricing page.

Say which training each job role needs

  • Open Training, then the Matrix tab, and choose Required training by role
  • Pick a job role, or All staff for training everyone needs, and tick the courses it must hold
  • Staff are matched by the job role on their profile, so set roles on the Staff page first
Audits
Required training by role (example)Example
Job roles3
Courses ticked11
All staff
Safeguarding adultsTicked
Fire safetyTicked
Senior carer
MedicationTicked
Moving and handlingTicked

Example only. You choose your own roles and courses.

See who is in date, due soon or expired

  • One row per staff member, one column per course that some role requires, so the grid is your requirement and not the whole library
  • Each square says In date, Renewal due soon (within 60 days), Expired, Overdue, In progress or Assigned, not started
  • A red ! means the training is required but has not been assigned yet, so you know what to allocate first
Audits
Who is in date (example)Example
Fully compliant staff9 of 14
Required, not assigned3
Expired or overdue2
Renewals due in 60 days4
Needs attention first
Moving and handling, carerExpired
Fire safety, senior carerRenewal due soon
Safeguarding, new carerRequired, not assigned
Each person
Compliance percentageShare of required training in date
Gaps only filterShows people with a gap

Example only. Your matrix shows your own staff.

Export it or print it, and check the staff record

  • Download a CSV to open in your own spreadsheet, or use Print / PDF for a clean landscape page of the grid
  • Search by name, filter by job role or show gaps only before you export
  • The same information shows under Required training on each person's staff record, so the grid and the record agree
Audits
Print or export (example)Example
Staff shown14
FormatCSV or PDF
What the page carries
Staff member and job roleListed
Compliance percentagePer person
Valid until datesWhere a course renews
Key printed underneath
In dateGreen
Expired or overdueRed

Example only. The print page lists your own staff and courses.

In date is not the same as understood

  • The matrix tells you who completed a course and when it renews, not how well they understood it
  • After a refresher, allocate a short adhoc module on the same topic and see the most missed questions in Analytics, Knowledge gaps
  • Adhoc training is on the paid plans; see the pricing page for which plan suits your service
Analytics: Knowledge gaps
Open gaps6
Staff affected5
Closed (30 days)14
Engaged with learning68%
Most-missed questions
Who to tell about a safeguarding concern4 staff
Safe moving of a person after a fall3 staff
Fire evacuation routes2 staff
Weakest topics
Safeguarding Adults4 gaps
Fire Safety2 gaps
How gaps are being closed
Learn & retryJust retry

Illustration based on the Knowledge gaps view. Example figures.

Talk it through

The questions managers ask, and how CareStream answers them

Read this as a conversation. The questions are the ones we hear most.

Manager

I already have a spreadsheet. Why change?

CareStream

Your spreadsheet only changes when someone edits it. The CareStream matrix reads completions recorded in the system, so a certificate that passes its date shows as Expired without anyone touching a colour.

Manager

Is this a training matrix template I can download?

CareStream

Not as a blank file. A template is empty and you fill it in. Here you set the training each job role needs and the grid fills itself from what staff complete. You can still export the result to CSV and use your own spreadsheet.

Manager

What does each colour or symbol mean?

CareStream

In date, Renewal due soon (within 60 days), Expired, Overdue, Practical to sign off, In progress, Assigned, not started, Required, not assigned, and Not required. A legend sits under the grid, and the same labels are printed on the PDF.

Manager

Does it include training my staff did somewhere else?

CareStream

Only what is recorded in CareStream. That means courses staff complete in the Staff Hub and face to face sessions you log with who attended. A certificate sitting in a folder, or a course done elsewhere, does not appear unless it is recorded.

Manager

Will it enrol my staff on the training they are missing?

CareStream

No. A red ! tells you a course is required but not assigned. You then allocate it. Setting requirements by role changes what the grid expects, it does not enrol anyone for you.

Manager

Can I hand it to an inspector?

CareStream

You can download a CSV or print the grid to PDF, so you have something to show. It is a view of your own records. It is not a rating and it is not a regulator record.

Manager

What if a person has no job role set?

CareStream

They only match the training you ticked for All staff. The role screen warns you how many staff have no job role, so you can set them on the Staff page.

Manager

Can I try it, and which plan has it?

CareStream

Yes. There is a 14 day free trial, and you can create a free account to look around. Plans differ, so see the pricing page for which plan includes the matrix and required training by role.

What it does not do

A clear view of your records, not a substitute for the training

It only knows what is recorded

The matrix reflects courses completed in CareStream and face to face sessions you log. Training done elsewhere shows up only if it is recorded, so a gap on the grid may be a gap in the recording.

It does not enrol anyone for you

Required, not assigned tells you what to allocate. You still allocate it. A role requirement tells the grid what to expect, nothing more.

It is not a rating or a regulator record

A full green grid does not mean a pass, and the matrix is not a CQC document. It also cannot tell you whether the training changed what someone does on the floor.

Questions

Questions about the matrix, answered

About the matrix

What is a matrix of staff training in a care home?

A grid of staff against the training their job needs, showing what is complete, what is due and what has lapsed. CareStream builds it from your own training records in the system and your required training by role.

What should a staff training matrix show?

Each person, their job role, each required course and its status, with renewal dates where a course expires. See what a care home training matrix should contain for a fuller list.

Can I use a training matrix template instead?

You can, but a template is only as accurate as the last edit. If you want to compare approaches first, read whether an Excel matrix is still safe.

Where are the training records for one person?

On their staff record, under Required training for their role. It uses the same rules as the grid, so the two agree.

Using it in CareStream

How do I set which courses each role needs?

In Training, open the Matrix tab and choose Required training by role. Pick a job role or All staff, tick the courses and save. The grid then shows only courses that some role requires.

Can I export the matrix?

Yes. Download a CSV, or use Print / PDF for a clean landscape page. Both follow your filters for name, job role and gaps only.

How does it treat face to face training?

Topics marked mandatory for a role on the Face-to-face tab appear in the grid, using attendance and renewal dates. Read more about recording in person sessions.

Which plan includes the matrix?

Please check the pricing page for which plan includes the matrix and required training by role, as plans change.

Guide

A practical way to get your matrix ready before an inspection

Start with what you are asked for, then work backwards to the records. These steps take an afternoon, and they make the grid worth trusting.

Start from the rules that apply to you

Regulation 18 of the Health and Social Care Act 2008 (Regulated Activities) Regulations 2014 says staff must receive such appropriate support, training, professional development, supervision and appraisal as is necessary to carry out their duties. Regulation 17 on good governance includes keeping securely the records that are necessary in relation to persons employed.

Those two lines are why a manager keeps training records at all. They do not give you a list of courses. Decide the list yourself, by job role, using your service and your policies. Then see the monthly compliance audit for a regular check.

Before the visit, work through this list

  • Check every staff member has a job role set, so the right requirements apply to them
  • Tick the courses each role needs, and All staff for training everyone holds
  • Assign anything marked Required, not assigned, then chase Expired and Overdue first
  • Export a CSV or print to PDF, and check a few rows against the certificates in staff folders

Keep it true after the visit

Open the grid on the same day each month and filter to gaps only. Book renewals for anyone in the 60 day window, and record in person sessions on the day they happen. Our guide to the Care Certificate course shows where new starters begin.

CareStream gives you a view of your own records. It does not decide what training your service needs, and it does not promise any inspection outcome.

Accreditations and compliance

  • Good Business Charter accredited
  • CPD Certified training, The CPD Certification Service
  • Registered with the Information Commissioner's Office
  • Disability Confident Committed
  • GDPR compliant

CPD Provider No. 50224 · ICO registration ZC221613