Free Excel template

Free construction risk register template with a 5×5 matrix

A project risk and opportunity register on the same 5×5 matrix Palydin uses: rate each item, and the sheet works out its score, band, expected value and next review date, with a heat map of everything still open.

Sheets Register · Heat map · Matrix · How to use

Get the risk register template

Enter your email and the download starts straight away.

Excel (.xlsx); also opens in Google Sheets and Numbers. We’ll email you the link, and we may get in touch about Palydin. See our privacy policy.

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. 1

    Set your matrix

    Check the likelihood, consequence and band settings, or adjust them to your organisation's matrix.

  2. 2

    Capture risks and opportunities

    One row per item: type, title, cause and effect, category and owner.

  3. 3

    Rate and value

    Pick likelihood and consequence, enter the most likely cost or benefit, and choose a response and treatment.

  4. 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.