Risk register template with a 5×5 matrix

A register where each risk’s score and zone work themselves out, and a separate sheet shows how many risks sit in each cell of the matrix.

Excel, 12 KB. No macros, no sign-up.

What is inside

  • The “Risk register” sheet: the risk as “cause → event → consequence”, category, probability, impact, score, zone, owner, response, review date, status and linked work.
  • Score is probability × impact; the zone is red from 15, amber from 8, green otherwise.
  • The “Matrix” sheet: the number of risks in each of the 25 cells.
  • An “Instructions” sheet.

How to use it

  1. Describe a risk in one sentence: what may happen, why, and what it leads to.
  2. Rate probability and impact with whole numbers from 1 to 5 — the score and zone appear by themselves.
  3. Give every red and amber risk an owner and a response.
  4. Review the register at regular project meetings and close risks that no longer apply.

How it looks in Etapero

In Etapero the register of risks, problems and assumptions lives in a project’s Risks section, the matrix is built automatically, and red-zone risks show in the project overview and the portfolio. Loading a register from Excel into Etapero is not available yet.

Related articles

  • The project risk register

    Which fields a risk register needs, how to rate probability and impact, what a risk matrix is, and how to keep the register from becoming a formality.

  • How to meet project deadlines

    Ten practices for keeping projects on schedule: realistic estimates, buffers, milestones, the critical path, catching slippage early and change control.

Other templates

  • Project plan with a Gantt chart

    A work breakdown with codes, dates and dependencies and weekly Gantt bars.

  • Issues and decisions log

    Issues with owners and due dates, decisions with who made them and when. Overdue ones turn red.

  • RACI matrix

    Deliverables and roles with R, A, C and I. The check column shows rows with no accountable person or two.

  • Project management plan

    A “how we run the project” checklist: plan sections, questions, answers and approval status.

Try it yourself

The demo runs in your browser with no sign-up: you enter as a demo user and can edit the sample projects.

Open the demo