Skip to content
The PM Toolbox
← All tools

While you deliver

Risk Register Scorer

Place a risk register on its own matrix, see inherent beside residual, and find where the matrix and the score column put your risks in different orders.

Read a risk register as .xlsx or .csv, with likelihood and impact as numbers, words or percentages, inside your browser. Nothing is uploaded.

Risk register

Drop a spreadsheet here

One row per risk, with likelihood and impact as numbers, words or percentages. Residual columns if you keep them.

Your scale, your matrix

Registers score likelihood and impact in numbers, in words, or as a percentage chance, and sometimes all three in one column. The tool reads “4”, “4 - Likely”, “Likely” and “70%” onto the same scale, works out whether that scale runs to 3, 4, 5 or 10, and lets you correct it. The matrix starts leaning a little toward impact, as many organizational matrices do, and every cell can be changed to match the one your organization uses.

Counts, not colors

The matrix shows how many risks sit in each cell, with the cell’s rating written in it. A heat map painted red and green suggests a precision that a one-to-five judgment does not have; a count shows where the register is crowded and where it is thin. Inherent and residual sit side by side, so it is plain which risks the responses are meant to move and whether the register says they moved.

Two orders that disagree

Most registers are sorted by likelihood times impact. Most meetings talk about the matrix rating. They are not the same order: a rare event that would be severe (1 x 5) and a near-certain nuisance (5 x 1) both score 5, and a sensible matrix rates the first higher. The tool lists every pair of risks the two orders rank differently, so the people in the room know which order they are looking at.

Checks on the register itself

A score column that is not likelihood times impact. Values outside the scale. Residual scores higher than inherent, which means the response made things worse, and residual scores lowered with no response written down. High-rated open risks with no response at all.

What this does not do

It does not say whether a risk is scored correctly; that is a judgment for the people who know the work. A matrix rating is an ordinal label, not a measurement, so the tool does not add ratings up or average them. For a reserve built from risk ranges, use a simulation instead of a matrix.