IMScollect
Template · ISO 9001, ISO 14001 and ISO 27001

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.

Download the Excel templateExcel file · as of 13 November 2026 · no email address
risk-register-risks-and-opportunities.xlsx

Examples

Six completed entries for orientation, invented values

3 sheets22 columns60 rows prepared
Examples: extract from the template with example rows
TitleLikelihood (1-5)Impact (1-5)
Failure of the only supplier of control boards35
Encryption by ransomware35
Oil leak in the warehouse24
Departure of the only inspection planning specialist24
Funding programme for energy efficiency43
+ 16

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

InstructionsRegisterExamples

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.
Step by step

How to fill it in

  1. 1

    Collect risks and opportunities: from the context (4.1), the requirements of interested parties (4.2), from processes, audits, complaints and incidents.

  2. 2

    Describe every risk as cause and consequence: “Because …, … can happen.” A keyword such as “skills shortage” cannot be rated.

  3. 3

    Rate likelihood and impact using the scale on the “Instructions” sheet. The template calculates score and level.

  4. 4

    Choose the treatment: accept, reduce, transfer or avoid. For reduce, enter a concrete action with a responsible person and a due date.

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

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 →