Audit Risk Register Template
A live priority-score formula, a Significant Risk flag, a Status tracker, and a genuine colour-scale heat map.
No sign-up or email required. Real Excel formulas, not a screenshot.
What this template does
- ✓Scores each risk by Likelihood × Magnitude (Low=1/Medium=2/High=3), computed live.
- ✓Flags any risk scoring 6 or above as Significant automatically.
- ✓Tracks status per risk (Open / In Progress / Closed) via a dropdown.
- ✓Visualises priority with a real green-to-red colour-scale heat map, plus a Likelihood × Magnitude legend.
What’s inside
Risk Register
Dropdown-validated Likelihood/Magnitude (Low/Medium/High), a live PriorityScore formula, a Significant? flag for any risk scoring 6+, a Status dropdown tracker, and a colour-scale heat map on PriorityScore plus a reference Likelihood × Magnitude legend.
Read Me
The workbook's own documentation and a link back to the full guide.
How to use it
Replace the 7 example rows with your own risks — every row should trace back to something actually observed, not a guess.
Want the full walkthrough?
The guide explains every formula in this workbook step by step, with a worked example.
Go deeper
Advanced Audit & Assurance
This template is one piece of a bigger workflow. The course builds the whole thing with real datasets, step by step, with a graded assessment and a verifiable certificate.