VanillaPM
Sign in Get started free Dashboard
Free template

Risk register template

A free risk register template in Excel and CSV — probability × impact score, EMV, response strategy, trigger, residual risk and status, with drop-downs and the calculations built in.

Download Excel (.xlsx) Download CSV Free · no sign-up · opens in Word, Excel, Google Docs/Sheets and LibreOffice

What's inside

ColumnWhat goes in it
IDRISK-001, RISK-002 …
RiskCause → event → effect, in one sentence
Threat / opportunitydrop-down Threat, Opportunity
Categorydrop-down Technical, External, Schedule, Cost, Quality, Resource, Scope
OwnerOne person who watches it and acts
Probability (1–5)drop-down 1, 2, 3, 4, 5
Impact (1–5)drop-down 1, 2, 3, 4, 5
ScoreProbability × impact · calculated
Probability %For EMV
Cost if it happens
EMVProbability % × cost · calculated
Response strategydrop-down Avoid, Mitigate, Transfer, Accept, Escalate, Exploit, Enhance, Share
Response plan
TriggerThe early warning that it is starting
Residual Pdrop-down 1, 2, 3, 4, 5
Residual Idrop-down 1, 2, 3, 4, 5
Statusdrop-down Open, Monitoring, Occurred, Closed
Last reviewed

The Excel file has three sheets: the blank register, a filled example from the Coral Ridge Resort sample project, and how to use each column. The CSV is the blank header row only.

What a risk register is

The risk register lists the uncertainties that could affect the project, how big each one is, and what you're doing about it. A risk can be a threat (something that would hurt) or an opportunity (something that would help).

When to use it

From the start of planning to the last day, and review it on a cadence (every two weeks is common). Risks appear, change size, happen or go away as the project moves.

How to fill it in

  1. Describe the risk in one sentence: cause → event → effect. "Monsoon rain" is a cause; "monsoon rain stops external works beyond the planned window, delaying the frame" is a risk.
  2. Score it: probability and impact from 1 to 5. The Score column multiplies them for you.
  3. Put a number on the big ones: a probability in percent and the cost if it happens. The EMV column works out the expected loss. The sum of EMV across the threats is what your contingency reserve should cover (check it with the contingency calculator).
  4. Choose a response: avoid, mitigate, transfer, accept or escalate for threats; exploit, enhance, share, accept or escalate for opportunities. Write the actual plan, not just the word.
  5. Set a trigger: the early warning that the risk is starting.
  6. Score the residual risk: what's left after the response.

The Example sheet has two risks from the Coral Ridge sample: a cyclone (mitigated and insured) and the lifts held at customs (it happened, so its status is Occurred, and it became an issue).

Common mistakes

  • Risks written as worries ("weather"). Without cause and effect you can't plan a response.
  • A response with no plan. "Mitigate" on its own changes nothing.
  • No owner and no trigger. Nobody notices until it's too late.
  • Never reviewed. A register last updated at kick-off is a historical document.

See it used on a real project: B5 · Plan and manage risk