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.

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
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.

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 group | Columns | Why |
|---|---|---|
| Staff details | Name, role, start date, contract type (permanent, bank, agency) | Lets you filter by role and spot new starters |
| Induction | Care Certificate started, Care Certificate completed | New care workers need this tracked separately |
| Courses | One column per required course, holding the completion date | The core of the matrix |
| Status | Count of overdue items, count due in 60 days | A quick total per person |
| Notes | Reason for gaps, booked dates | Shows 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.

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.
| Status | Rule | Action |
|---|---|---|
| Green | Expiry is more than 60 days away | No action |
| Amber | Expiry is within 60 days | Book the refresher |
| Red | Expiry date has passed, or no date recorded | Book now, record the reason, consider limiting duties |
| Grey | Course not required for this role | Ignore |
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.
- List roles and courses. Write down each role and the courses it needs, using your training policy.
- Fill the Settings tab. One row per course, with its refresher period in months.
- Add staff. Include bank and agency workers you deploy regularly.
- Enter dates from evidence. Only enter a date if you hold the certificate or signed record.
- Apply the formulas and colours. Test with a few known dates.
- 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 matrixSources
The official guidance this page is based on. Check the source for the latest rules.
- Statutory and mandatory training (Skills for Care) (opens in a new tab)
- How we're simplifying statutory and mandatory training guidance (Skills for Care) (opens in a new tab)
- The Health and Social Care Act 2008 (Regulated Activities) Regulations 2014, regulation 18 (opens in a new tab)
- The Oliver McGowan code of practice on statutory learning disability and autism training (GOV.UK) (opens in a new tab)
Related courses and pathways
Course · Health & SafetyFire SafetyFire prevention, risk assessment and emergency procedures at work and in care settings.See the course: Fire Safety
Course · HealthcareMoving and HandlingSafe moving and handling of people and objects in health and social care.See the course: Moving and Handling
Course · HealthcareInfection Prevention and ControlStandard precautions and good practice to stop infection spreading in care settings.See the course: Infection Prevention and Control - Bestseller

Funded placement and mentoring into care management
Care Manager
A funded route into care management for UK care workers and nurses: a management placement, one-to-one mentoring, work references and interview preparation.
Keep reading

Employers6 min read
How to check a training certificate is genuine
How employers can check a training certificate or qualification is real: the Ofqual register, awarding body checks, NEBOSH verification and warning signs.

Employers6 min read
How to prepare staff training records for a CQC inspection
What CQC expects to see in staff training records, which regulations apply, and a simple way to get your evidence ready before an inspection.

Clinical skills6 min read
Clinical skills for carers: catheter care, venepuncture and more
Care workers can do some clinical tasks, like catheter care or insulin support, when a nurse delegates them and they are trained and assessed as competent.

PDF2 CSV
Free download
The care home training matrix spreadsheet
See at a glance who is in date, who is due soon and who is overdue, for every worker and every course.