IMScollect
Template · ISO 9001, ISO 14001 and ISO 27001

Competence matrix: target by role, actual by person

Which competence does each role need, who has it, and where is something missing? The template compares target and actual by itself and colours every gap.

Download the Excel templateExcel file · as of 13 November 2026 · no email address
competence-matrix.xlsx

Example: competence matrix

Actual level per person, 1 to 4 · red: below the target of the role, green: met · the role must be spelled as on the target sheet

6 sheets17 columns60 rows prepared
Example: competence matrix: extract from the template with example rows
NameRoleInspection to drawing
Anna BeckerQuality inspector4
Jonas WagnerPainter2
Mehmet YilmazProduction3
Lea SchulzSales office
Tobias KleinProduction1
+ 11

more columns in the file: Hazardous substances · Information security · First aid · Internal audits · Handling complaints · Operating the paint line · Competence 9 · Competence 10 · Competence 11 · Competence 12 · Evaluated on

InstructionsTarget by roleCompetence matrixActionsExample targetExample matrix

Extract from the Excel file with example rows · the workbook has 6 sheets, highlighted columns are calculated by the template. The example values are invented.

What the template is for

Clause 7.2 asks you to determine the competence needed by people whose work affects the performance of your management system, to ensure these people are competent, to close gaps and to evaluate the effectiveness of these actions. Documented information serves as evidence.

A competence matrix answers all of this on one sheet: the target per role, the actual level per person and the gap between them. For ISO 27001 this includes information security awareness (Annex A, control 6.3), for ISO 14001 competence related to the significant environmental aspects.

What is in the file

  • An “Instructions” sheet with steps and the scale from 1 (basic knowledge) to 4 (can guide others).
  • A “Target by role” sheet: up to 20 roles and 12 competences, which you name yourself, with the required level.
  • A “Competence matrix” sheet: up to 60 people with role and actual level per competence. Every cell below the target of its role turns red, and one column counts the gaps per person.
  • An “Actions” sheet for training, induction or coaching, with due date, evaluation of effectiveness and evidence.
Step by step

How to fill it in

  1. 1

    On “Target by role”, write the competences that matter to you in the header row, such as inspection to drawing, hazardous substances, information security, auditing.

  2. 2

    Enter the required level for each role. Blank means: not required for this role.

  3. 3

    On “Competence matrix”, enter the people with their role; the role must be spelled exactly as on the first sheet.

  4. 4

    Assess each person's level together with their line manager. The matrix shows the gaps.

  5. 5

    For every gap, record on the “Actions” sheet how it will be closed, and after the action evaluate whether it worked.

  6. 6

    File the evidence (certificates, attendance records, briefings) and update the matrix with new hires, changes and at least once a year.

The same steps are in the file on the “Instructions” sheet, together with the rating scales and the completed examples.

Common mistakes when filling it in

What most often goes wrong when filling in this file, and how to avoid it.

Role spelled differently from the target
If “Competence matrix” says “Quality inspectors” and “Target by role” says “Quality inspector”, the formula finds no target and counts no gap. Pick the role from the drop-down list rather than typing it.
The target sheet stays empty
If you only enter what each person can do, you get neither colours nor gaps. First set the required level for each role; only then can the matrix compare.
Competences named too broadly
“Expertise” or “IT” in the header row cannot be assessed. Name what someone has to be able to do, such as “Inspection to drawing” or “Storing hazardous substances”. The names appear in the matrix by themselves.
An action without an effectiveness evaluation
The “Actions” sheet lists the training with a date, but “Effectiveness evaluated on” and “How evaluated” stay empty, and the level in the matrix is not raised. The gap is only closed after the evaluation.
“Evaluated on” column empty
Without a date, nobody can tell whether an assessment still holds. Enter the date with every assessment and go through the matrix with new hires, changes and at least once a year.

What an auditor checks for this clause and which nonconformities they often find is explained on the clause page: Clause 7.2: Competence.

ISO 9001 with IMScollect

In IMScollect you maintain competences in the system: target per position, actual per person, certificates with expiry date. One click turns a gap into a training.

Find out more

See it working in one system

In a free demo we show you how these lists work together in IMScollect, with your standards and your questions.

Start 14-day free trial

Try it yourself, no call needed.Prefer a walkthrough? Book a guided demo →