Skip to main content
MySkillsPlace

Employers6 min read

How to build a training matrix for a care home

Step-by-step: set up a care home training matrix with the right columns, expiry dates and red-amber-green status, using Skills for Care guidance.

A smiling care worker sitting at a table in a care home
Photo: Brooke Cagle on Unsplash

The short answer

A training matrix is a grid with staff names down the side and required courses across the top. Each cell holds the date a person completed a course, and a formula works out when it expires and colours the cell red, amber or green. You set the refresher period for each course in your training policy, using the Skills for Care statutory and mandatory training guide as your reference.

The method works for any care setting worldwide. The regulatory points refer to England, where care homes are registered with the Care Quality Commission (CQC).

On this page
  1. What is a training matrix for?
  2. Which columns should a care home training matrix have?
  3. How do you decide refresher periods?
  4. How does the expiry and RAG logic work?
  5. How do you set it up, step by step?
  6. A short example
  7. FAQs
  8. Sources

What is a training matrix for?

It shows, on one page, who is trained, who is due and who is overdue.

Regulation 18 of the Regulated Activities Regulations 2014 says staff must receive the training, supervision and appraisal they need for their role. A matrix is the simplest way to prove you track this. It also helps you plan and budget, because you can see next quarter's refreshers in advance. For what inspectors look for, read preparing training records for a CQC inspection.

Two women reviewing papers together at a table
Photo: MySkillsPlace

Which columns should a care home training matrix have?

Start with staff details, then one column per course.

Swipe the table sideways to see every column.

Column groupColumnsWhy
Staff detailsName, role, start date, contract type (permanent, bank, agency)Lets you filter by role and spot new starters
InductionCare Certificate started, Care Certificate completedNew care workers need this tracked separately
CoursesOne column per required course, holding the completion dateThe core of the matrix
StatusCount of overdue items, count due in 60 daysA quick total per person
NotesReason for gaps, booked datesShows you are acting on gaps

Keep a second tab called "Settings". List each course with its refresher period in months and which roles need it. Formulas read from this tab, so you change a period in one place.

How do you decide refresher periods?

Your organisation decides, guided by Skills for Care and any topic-specific law.

Skills for Care's Statutory and mandatory training guide for adult social care employers (updated December 2025) lists the topics and guidance on refreshing them. For most core topics, such as health and safety awareness and assisting and moving people, it gives a minimum refresher period of three years, sooner if there is a new risk or activity. Formal basic life support is refreshed when identified or at least annually, and formal first aid every three years. Part 1 covers training all workers need and training that depends on the role. Part 2 covers extra training you set for your own service. The guide also recognises qualifications: if a worker completed a recognised adult social care qualification that covered a topic, they do not need to refresh it for three years from completion.

Some topics have a firmer rule. The Oliver McGowan code of practice says learning disability and autism training should be repeated at least every three years, or sooner if a role changes or a need is identified.

Put your chosen periods in the Settings tab and in your written training policy. Inspectors look for a policy that explains your choices. They also look for evidence that you follow it. For more on typical periods, see how often care training needs renewing.

A clinician talking with a smiling older man outdoors
Photo: LOGAN WEAVER | @LGNWVR on Unsplash

How does the expiry and RAG logic work?

Each cell compares today's date with the expiry date and shows a colour.

The expiry date is the completion date plus the refresher period. The status follows a simple rule:

Swipe the table sideways to see every column.

StatusRuleAction
GreenExpiry is more than 60 days awayNo action
AmberExpiry is within 60 daysBook the refresher
RedExpiry date has passed, or no date recordedBook now, record the reason, consider limiting duties
GreyCourse not required for this roleIgnore

In Excel or Google Sheets, the expiry is `=EDATE(completion_date, months)`. Conditional formatting then colours the cell by comparing that expiry with `TODAY()`. You can change 60 days to suit how long it takes you to book training.

How do you set it up, step by step?

Follow these six steps.

  1. List roles and courses. Write down each role and the courses it needs, using your training policy.
  2. Fill the Settings tab. One row per course, with its refresher period in months.
  3. Add staff. Include bank and agency workers you deploy regularly.
  4. Enter dates from evidence. Only enter a date if you hold the certificate or signed record.
  5. Apply the formulas and colours. Test with a few known dates.
  6. Review monthly. Filter for red and amber, book training and update notes.

Give one person ownership of the matrix, with a named deputy. A matrix that nobody updates becomes a risk, because it shows dates you cannot rely on.

A short example

A care home sets moving and handling to a 12-month refresher in its policy. A senior carer completed it on 14 December 2025. The expiry is 14 December 2026. On 7 November 2026 the cell turns amber because expiry is within 60 days. The manager books her onto a session on 2 December and notes the date. When she passes, the new date goes in and the cell turns green.

Estimate. You’re charged in pounds (GBP); your bank sets the final rate.

FAQs

Is there an official CQC training matrix template?

CQC does not prescribe a template. The regulations require that staff are suitably trained and that records are kept securely, but the format is your choice. A spreadsheet, a paper file or training software can all work if the information is accurate and backed by evidence.

Should agency staff be on the matrix?

Yes, if you deploy them regularly. Regulation 18 applies to people you deploy, so you need confidence they are trained. Ask the agency for each worker's training record, enter the dates and keep the proof on file. Check it again when items fall due.

What refresher period should I use for each course?

Use the Skills for Care statutory and mandatory training guide as your starting point, then set periods in your training policy. Some topics need shorter cycles because of risk or a specific legal standard. Record your reasoning, because inspectors may ask why you chose a period.

Do I need a separate column for competency checks?

It helps. A certificate shows someone completed a course, while an observed check shows they can do the task safely. For practical skills such as moving and handling or medicines, add a competency column with its own review date.

Next step

Download the free care home training matrix, with the columns and expiry formulas already set up. Then close red cells with free online courses such as Fire Safety and Infection Prevention & Control. Certificates cost £9.99 (est. US$13, an estimate. You are charged in pounds and your bank sets the final rate) when you pass and carry a unique certificate number you can check at /verify.

care home training matrix

Sources

The official guidance this page is based on. Check the source for the latest rules.

  1. Statutory and mandatory training (Skills for Care) (opens in a new tab)
  2. How we're simplifying statutory and mandatory training guidance (Skills for Care) (opens in a new tab)
  3. The Health and Social Care Act 2008 (Regulated Activities) Regulations 2014, regulation 18 (opens in a new tab)
  4. The Oliver McGowan code of practice on statutory learning disability and autism training (GOV.UK) (opens in a new tab)

Keep reading