
Co-Founder & ERM Practitioner
An enterprise risk management practitioner with experience across healthcare, public sector, and regulated environments. Phumi focuses on translating ERM frameworks into practical, decision-relevant processes.
A comprehensive Excel template for identifying, tracking, and managing organizational risks. Includes risk scoring, categorization, ownership assignment, and control linkages — all in one structured spreadsheet.
Structured fields for risk ID, title, description, category, and root cause
Likelihood and impact assessment with automatic risk score calculation
Assign risk owners, track status, and set review dates
Link existing controls and track residual risk after treatment
Every column in the risk register sheet, explained.
Unique identifier (e.g. R-001) for traceability across reports and audits.
Short, descriptive name that makes the risk immediately recognisable.
Detailed explanation of the risk event, including potential causes and consequences.
Classification (Strategic, Operational, Financial, Compliance) for filtering and reporting.
The underlying driver of the risk — helps target controls at the source.
Probability of occurrence based on the scoring guide: 1 = Rare, 5 = Almost Certain.
Severity if the risk materialises: 1 = Insignificant, 5 = Catastrophic.
Auto-calculated (Likelihood x Impact) before controls. Colour-coded by severity.
Existing preventive, detective, or corrective controls that mitigate this risk.
Risk remaining after controls. The gap from inherent shows control effectiveness.
The person accountable for monitoring and managing this risk.
Planned actions to further reduce, transfer, avoid, or accept the risk.
Current state: Open, In Treatment, Monitoring, Closed, or Accepted.
Next scheduled review date to ensure the risk assessment stays current.
What you get with a purpose-built template versus starting from scratch.
| Capability | Dimeri Template | Blank Excel |
|---|---|---|
| Pre-built risk scoring formulas | Yes | No |
| Conditional formatting by severity | Yes | No |
| Visual risk heat map | Yes | No |
| Predefined risk categories | Yes | No |
| Dashboard with summary charts | Yes | No |
| Action tracker tab | Yes | No |
| Scoring guide with examples | Yes | No |
| Inherent + residual risk tracking | Yes | No |
| Ready to use immediately | Yes | No |
| Customisable to your organisation | Yes | Yes |
| Free to download | Yes | Yes |
Get started in five steps.
Download the .xlsx file and open it in Excel, Google Sheets, or any compatible application. Review the Scoring Guide tab first to understand the rating scales.
Edit the Risk Categories tab to match your organisation's taxonomy. Add or rename categories like Technology, Reputational, Environmental, or HSE depending on your industry.
Work through each business unit or process. For each risk, fill in the ID, title, description, category, and root cause. Be specific — vague descriptions lead to vague responses.
Use the Scoring Guide to rate likelihood and impact for each risk. The inherent risk score calculates automatically. Then document your controls and enter the residual risk score.
Assign a risk owner to every risk. Set review dates (quarterly recommended for most risks). Use the Dashboard tab to monitor your risk profile at a glance.
Want to go deeper? Read our complete guide to creating a risk register or learn how to score risk likelihood and impact.
Ideal scenarios for this template
Centralize all organizational risks in one structured format
Capture identified risks during facilitated sessions
Track project-specific risks and their treatment plans
Document risk management for internal and external audits
Generate risk summaries and reports for senior leadership
Regular risk review and status updates
While spreadsheets work, Dimeri transforms your risk register into a live system with AI-powered risk identification, automated scoring, and real-time reporting.