Free template

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.

Download the template (.xlsx)

What is inside

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.

ColumnNeededWhat to write
RefOptionalYour own control number. Re-importing a row with the same Ref updates it instead of adding a copy.
Main auditable processRecommendedThe process in your audit universe, for example Procurement or Human Resources.
Sub-processRecommendedThe step inside the process, for example Vendor onboarding or Goods receipt.
Risk descriptionRequiredWhat could go wrong and what it would cause, in one sentence.
Risk ratingRecommendedHigh, Medium or Low.
Expected controlRequiredThe control that should prevent or detect the risk. Number several controls 1, 2, 3 in one cell.
ResponsibleRecommendedThe control owner who confirms it works and receives follow-up.
Implementation dateRecommendedWhen the control must be in place.
Control review dateOptionalWhen the control is next reviewed.
Ticket noOptionalA change or IT ticket that implements the control.
Testing dateOptionalWhen internal audit last tested the control.
Supporting documentOptionalThe policy, SOP or evidence the control relies on.
Likelihood, ImpactOptionalInherent risk scores from 1 to 5, before the control.
Residual likelihood, Residual impactOptionalRisk scores from 1 to 5 after the control, for the heat map.
Worked example

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

  1. List the processes in your audit universe, one tab for each.
  2. Walk through each process with its owner and write down what could go wrong.
  3. Rate each risk High, Medium or Low, or score likelihood and impact from 1 to 5.
  4. For each risk, write the control that prevents or detects it, and name one owner.
  5. Add the evidence each control produces, so it can be tested and followed up.
Questions and answers

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.

WhatsApp