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
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
- CSV header:
risk, likelihood, impactrequired (1–5);owner, treatment, residual_likelihood, residual_impactoptional. - Press Run; download the heat map and sorted list as XLSX.
Fields
- Risk list (CSV)
- Likelihood and impact are integers 1–5.
Worked example
| Input | Value |
|---|---|
| Risk list (CSV) | |
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
| Input | Value |
|---|---|
| Risk list (CSV) | |
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
- Audit Evidence and Action TrackerCollects open actions, delays and missing evidence in one table before an audit.
- IT Change and Rollback PlanSchedules steps, reserves rollback time and produces the plan for the CAB as Markdown.
Related service: ISO 27001 Risk Analysis, Risk Treatment and SoA