Risk register for risks and opportunities
One register for all standards: risks and opportunities with cause, rating, treatment and effectiveness check. The template calculates the risk score and level by itself.
Examples
Six completed entries for orientation, invented values
| Title | Likelihood (1-5) | Impact (1-5) |
|---|---|---|
| Failure of the only supplier of control boards | 3 | 5 |
| Encryption by ransomware | 3 | 5 |
| Oil leak in the warehouse | 2 | 4 |
| Departure of the only inspection planning specialist | 2 | 4 |
| Funding programme for energy efficiency | 4 | 3 |
more columns in the file: Type · Cause and consequence · Standard · Category · Process or area · Treatment · Action · Responsible (risk owner) · Due date · Status · Residual likelihood · Residual impact · Residual score · Residual risk accepted on (ISO 27001) · Effectiveness checked on · Result of the effectiveness check
Extract from the Excel file with example rows · the workbook has 3 sheets, highlighted columns are calculated by the template. The example values are invented.
What the template is for
In clause 6.1 all three standards ask you to determine the risks and opportunities that affect your management system and to plan actions to address them. If you run several standards, you do not need a register per standard: one column for the standard concerned is enough.
ISO 27001 goes further. There the assessment follows defined criteria, every risk has a risk owner, and the risk owner accepts the residual risk. The template has the columns for residual rating and acceptance for this.
What is in the file
- An “Instructions” sheet with the steps and the rating scale from 1 to 5 for likelihood and impact, with a description of each level.
- A “Register” sheet with 60 blank rows and drop-down lists for type, standard, category, treatment option and status.
- Formulas for the risk score (likelihood times impact), the level (Low, Medium, High, Critical; for opportunities Low to High potential) and the residual score after the action, highlighted in colour.
- An “Examples” sheet with six completed rows from all three standards for orientation.
How to fill it in
- 1
Collect risks and opportunities: from the context (4.1), the requirements of interested parties (4.2), from processes, audits, complaints and incidents.
- 2
Describe every risk as cause and consequence: “Because …, … can happen.” A keyword such as “skills shortage” cannot be rated.
- 3
Rate likelihood and impact using the scale on the “Instructions” sheet. The template calculates score and level.
- 4
Choose the treatment: accept, reduce, transfer or avoid. For reduce, enter a concrete action with a responsible person and a due date.
- 5
For ISO 27001, enter the residual rating after the action and record the date on which the risk owner accepted the residual risk.
- 6
After the due date, check effectiveness and enter the result. Go through the register at least once a year and after major changes.
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.
- Only a keyword in the title
- If the “Title” column just says “supply shortage” and “Cause and consequence” stays empty, the row can be neither rated nor treated. Write out the sentence “Because …, … can happen.”
- Rated by gut feeling instead of the scale
- Likelihood and impact follow the levels on the “Instructions” sheet. Adapt the descriptions to your business once, for example with amounts in euros, and then rate every row on the same scale.
- “Type” column left empty
- Without a choice, the level is calculated as for a risk. For an opportunity, choose “Opportunity”; the level then runs from “Low” to “High potential”, and the treatment “Pursue” fits it.
- Formulas overwritten with numbers
- Score, level and residual score are calculated by the file. Typing a number there by hand deletes the formula, and the row no longer follows the rating. Create new rows by copying an existing one.
- “Effective” without a date and result
- The status says “Effective”, but “Effectiveness checked on” and the result are empty. Enter the check with date and result first, then set the status. For ISO 27001, the residual rating and the date of acceptance belong there too.
What an auditor checks for this clause and which nonconformities they often find is explained on the clause page: Clause 6.1: Risks and opportunities.
Risks and actions in IMScollect
In IMScollect the risk register with heat map lives in the system, shared by all standards. Actions are linked to the risk, with owners, due dates and effectiveness check.
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.
More templates
- ISO 27001Statement of Applicability (SoA)ISO 27001 clause 6.1.3 Information security risk treatment, Annex AExcel templateView
- ISO 14001Environmental aspectsISO 14001 clause 6.1.2 Environmental aspectsExcel templateView
- ISO 9001ISO 14001ISO 27001Management reviewClause 9.3 Management reviewWord templateView
- ISO 9001ISO 14001ISO 27001Audit programmeClause 9.2 Internal auditExcel templateView
