Risk control matrix template (Excel).
A ready-to-use risk control matrix with every column an internal audit function needs, and worked examples for procurement and payroll. Free, no sign-up.
The columns, and what goes in each.
One tab is one control register, for example one per process or department. Two columns are required: Risk description and Expected control. Keep the headings in row 1 as they are; the columns can be in any order.
| Column | Needed | What to write |
|---|---|---|
| Ref | Optional | Your own control number. Re-importing a row with the same Ref updates it instead of adding a copy. |
| Main auditable process | Recommended | The process in your audit universe, for example Procurement or Human Resources. |
| Sub-process | Recommended | The step inside the process, for example Vendor onboarding or Goods receipt. |
| Risk description | Required | What could go wrong and what it would cause, in one sentence. |
| Risk rating | Recommended | High, Medium or Low. |
| Expected control | Required | The control that should prevent or detect the risk. Number several controls 1, 2, 3 in one cell. |
| Responsible | Recommended | The control owner who confirms it works and receives follow-up. |
| Implementation date | Recommended | When the control must be in place. |
| Control review date | Optional | When the control is next reviewed. |
| Ticket no | Optional | A change or IT ticket that implements the control. |
| Testing date | Optional | When internal audit last tested the control. |
| Supporting document | Optional | The policy, SOP or evidence the control relies on. |
| Likelihood, Impact | Optional | Inherent risk scores from 1 to 5, before the control. |
| Residual likelihood, Residual impact | Optional | Risk scores from 1 to 5 after the control, for the heat map. |
One row, filled in.
Process: Procurement · Sub-process: Vendor onboarding · Risk rating: High
Risk: Fake or unapproved vendors are created, allowing payments to non-existent suppliers.
Expected controls: 1. New vendors are created only from an approved vendor form with tax number and bank letter. 2. Vendor master changes are approved by the Procurement Manager. 3. Finance reviews vendor master changes every month.
Owner: Procurement Manager · Evidence: Vendor Management SOP · Inherent risk: likelihood 4, impact 5 · Residual risk: likelihood 2, impact 4
How to build your matrix in five steps
- List the processes in your audit universe, one tab for each.
- Walk through each process with its owner and write down what could go wrong.
- Rate each risk High, Medium or Low, or score likelihood and impact from 1 to 5.
- For each risk, write the control that prevents or detects it, and name one owner.
- Add the evidence each control produces, so it can be tested and followed up.
About risk control matrices.
What is a risk control matrix (RCM)?
A risk control matrix is a table that links each risk in a process to the control that should prevent or detect it, with the control owner, the risk rating and the evidence. Internal audit uses it to plan testing, and management uses it to show which controls are in place.
What columns should a risk control matrix have?
At minimum: the process, the risk description, the risk rating, the expected control and the control owner. A complete matrix also has implementation and testing dates, the supporting document, and inherent and residual likelihood and impact scores. This template has all of them.
Is this risk control matrix template free?
Yes. Download it, use it in Excel as long as you like, and share it with your team. No sign-up is needed.
How is a risk control matrix different from a risk register?
A risk register lists risks and their ratings. A risk control matrix goes one step further: for each risk it names the control, who owns it and how it is evidenced, so the control can be tested and followed up.
Can I import this template into audit software?
Yes. It is the exact layout Scrutive imports. Each tab becomes one control register, and every row becomes a control with its owner and dates, ready for follow-up and testing.
Outgrowing the spreadsheet?
Upload this template to Scrutive and every control gets its owner, due date, follow-up email and independent verification.