ERM Risk Register Template (Excel) - ISO 31000 Aligned with Live Dashboard & KRI Tracker
Stop building risk registers from scratch. This Excel template gives you a complete, board-ready ERM risk register aligned to ISO 31000:2018 and COSO ERM (2017), the same structure used by enterprise risk teams.
What's inside (5 worksheets, 1,300+ live formulas, no macros):
Risk Register: describe each risk as cause, event, and consequence, score it inherent to residual on a 5x5 scale, and get automatic ratings, color coding, and a risk appetite test on every row. Dropdowns and validation are pre-built for 200 risks.
Dashboard: live 5x5 heatmaps (inherent and residual), risks by category with chart, top 5 residual risks, overdue treatment actions, and a KPI row for board packs. Updates automatically as you type.
KRI Tracker: key risk indicators linked to your risks with amber/red thresholds and automatic red/amber/green status.
Setup sheet: fully customizable likelihood and impact scale descriptors, rating bands with response protocols, risk appetite threshold, and category lists.
Includes 12 fully worked sample risks (cyber, liquidity, third-party, compliance, people, health and safety, and more) so you see exactly how to use it, plus a quick-start guide and definitions.
Works in Excel 2016+ and Google Sheets. Instant download. Single-organization license.