Risk template
Risk Register Excel Template
A practical risk register with likelihood, impact, inherent score, current controls, residual score, treatment plan, owner, deadline, and insurance relevance.
Who it is for
Risk managers, brokers, consultants, finance teams, founders, and project owners who need a clear operational risk log.
Best use cases
- Board risk reviews
- Insurance renewal preparation
- Project risk management
- Cyber risk planning
- Control improvement tracking
Related workflow
Used in: Business Risk Cost Workflow
Use this register to collect risk inputs before estimating exposure categories, cost pressure, and insurance data needs.
Template fields and structure
The starter structure is designed to work in Excel, Google Sheets, Power BI, insurer portals, internal trackers, or client-facing documents.
Copyable CSV / spreadsheet structure
risk_id,risk_title,category,owner,likelihood,impact,inherent_score,current_controls,residual_score,treatment_plan,target_date R-001,Supplier outage affects fulfilment,Operational,COO,4,5,20,Dual supplier for top SKUs,12,Test fallback supplier and update business interruption assumptions,2026-08-15
Example filled row
Use the example as a quality benchmark for how specific each row should be before the file is used in a workflow or tool.
| risk_id | risk_title | category | owner | likelihood | impact | inherent_score | current_controls | residual_score | treatment_plan | target_date |
|---|---|---|---|---|---|---|---|---|---|---|
| R-001 | Supplier outage affects fulfilment | Operational | COO | 4 | 5 | 20 | Dual supplier for top SKUs | 12 | Test fallback supplier and update business interruption assumptions | 2026-08-15 |
How to use it
- List each material risk as a separate row with a named owner.
- Score inherent risk before controls and residual risk after controls.
- Use the treatment plan to track what will reduce likelihood or impact.
- Review insurance relevance before renewal so risk controls and coverage match.
What a completed version should prove
Common mistakes to avoid
Frequently asked questions
What score scale should I use?
A simple 1 to 5 likelihood and 1 to 5 impact scale is usually enough. Multiply them for a practical priority score.
Is this only for insurance?
No. It works for operational, project, cyber, financial, and compliance risks, with an extra column to connect risks to insurance discussions.