IT Operations, Risk and Audit · #97

Online IT Risk Matrix

Scores information security risks, places them on a heat map and flags missing ownership or treatment.

  • Data is processed in your browser and not sent to a server
  • Export: XLSX, CSV

Tool

Likelihood and impact are integers 1–5.

What does this tool do?

ISO 27001, TISAX and GDPR audits expect risk assessment to follow a consistent method and every high risk to have an owner and a treatment plan. The tool converts likelihood × impact into a level, places risks on a heat map, shows the residual risk score and lists gaps that will cause audit findings.

How to use it

  1. CSV header: risk, likelihood, impact required (1–5); owner, treatment, residual_likelihood, residual_impact optional.
  2. Press Run; download the heat map and sorted list as XLSX.

Fields

Risk list (CSV)
Likelihood and impact are integers 1–5.

Worked example

InputValue
Risk list (CSV)
risk,likelihood,impact,owner,treatment,residual_likelihood,residual_impact
Ransomware,4,5,IT,EDR + immutable backup,2,5
Backups not restore-tested,3,4,IT,,,
Vendor remote access,3,3,Purchasing,PAM,2,2
Unsupported firewall,2,4,,Replacement,1,4
Personal data breach,2,5,Legal,DLP,2,3

Expected result: 1 critical (ransomware, 20), 2 high (backups not restore-tested 12, personal data breach 10), 2 medium risks. The backup test risk has no treatment plan; the unsupported firewall has no owner.

After controls ransomware still has a residual risk of 10 (high): since impact is unchanged, controls lowering likelihood further or a risk acceptance decision are needed. Ownerless and untreated risks can be recorded directly as nonconformities.

Second scenario

InputValue
Risk list (CSV)
risk;likelihood;impact;owner;treatment
Laptop theft;3;2;IT;Disk encryption

Expected result: Laptop theft 3 × 2 = 6, medium risk; treated with disk encryption.

Method and assumptions

Score = likelihood × impact (1–25). Level: 1–4 low, 5–9 medium, 10–16 high, 20–25 critical. Residual risk uses residual likelihood × residual impact on the same scale.

Using the result and troubleshooting

Take critical and high risks to management review; transfer treatment plans to the Audit Evidence and Action Tracker. Keep scale definitions (1 = less than once a year etc.) in your risk methodology document.

Limits and common mistakes

  • Organisation-specific risk appetite, asset value and control effectiveness are not modelled; level thresholds are fixed.

Frequently asked questions

Why are 15 and 16 high, not critical?

In a 5×5 matrix 15 and 16 arise only from 3×5, 5×3 and 4×4; common practice sets the critical threshold at 20. If your methodology differs, interpret accordingly.

Related tools and service

Related service: ISO 27001 Risk Analysis, Risk Treatment and SoA

Compliance online tools · See all online tools