01What's inside
Built the way the work is done.
Register
Active exposure at the top (risk and opportunity expected value, extreme and high risks, reviews overdue) and a 200-row register.
Heat map
Two 5×5 grids, risks and opportunities, counting open items by likelihood and consequence.
Matrix
Likelihood levels with probability ranges, consequence levels with cost thresholds, band thresholds and review intervals, all editable.
How to use
How to rate, treat and review items, and what expected value is (and isn't) for.
- Score = likelihood × consequence, banded Low, Medium, High or Extreme from thresholds you can change.
- Opportunities have their own bands (Low, Moderate, High, Exceptional) and net off the risks.
- Probability fills in from the likelihood level; an override outside the level's range is flagged.
- Expected value = probability × most likely cost, rounded to the cent, for every open item.
- Next review date by band (Extreme every 7 days, Low every 90 by default), with overdue reviews counted.
- Responses checked against the type: Avoid, Mitigate or Transfer for risks; Exploit, Enhance or Share for opportunities.
02How to use it
From blank to done in four steps.
- 1
Set your matrix
Check the likelihood, consequence and band settings, or adjust them to your organisation's matrix.
- 2
Capture risks and opportunities
One row per item: type, title, cause and effect, category and owner.
- 3
Rate and value
Pick likelihood and consequence, enter the most likely cost or benefit, and choose a response and treatment.
- 4
Review on schedule
Work through items by their next review date and update the rating as treatments take effect.
03Questions
Good to know.
When the spreadsheet stops scaling.
Palydin's risk register uses this same matrix, links each item to the cost codes it affects, and turns the register into P50 and P90 cost outcomes with a Monte Carlo run.
More free templates
- Progress claim templateA month-end progress claim: schedule of values, cumulative % complete, variations, retention, GST and the total payable, with the Security of Payment endorsement for your state.Get the template
- Payment schedule templateThe assessor's reply to a payment claim: claimed against scheduled amount line by line, a reason wherever they differ, retention, GST and the scheduled amount.Get the template
- Variation register templateEvery variation on the contract in one log: status, claimed and approved values, time impact and the adjusted contract sum.Get the template
- EOT and delay notice registerDelay notices and extension of time claims per separable portion: notice dates, days claimed, days granted and each portion's adjusted completion date.Get the template
- Retention tracker templateRetention held claim by claim against the cap, releases at practical completion and the end of the defects liability period, and the balance still held.Get the template
- Cost report templateMonthly cost control by cost code: budget, approved changes, committed and actual cost, forecast to complete, forecast final cost and variance.Get the template