Skip to main content
Article

Risk register example: a fully worked register you can copy

All posts

See a complete risk register example with inherent and residual scores, linked controls, owners and triggers. Copy the structure or import it into Cilver.

What is a risk register?

A risk register is the single list of everything that could knock your project or organisation off course, with a score, an owner and a plan for each item. It is the working record of your risk management process, not a one-off workshop output.

Most risk register examples online stop at a description and a red, amber or green cell. That is enough to fill a slide, but not enough to manage anything. Below is a complete, worked example from a mid-sized construction and IT programme, showing the columns we would expect a risk manager to defend in front of a board.

You can copy the structure into Excel, or bring it straight into Cilver's risk register software and keep it live.

The columns a useful risk register needs

A register that only scores risk once will always look better than reality. These twelve fields are the minimum for a register that shows both exposure and whether your controls are working.

FieldWhat it capturesWhy it matters
IDUnique reference, e.g. R-014Lets actions, minutes and reports point to one risk
Risk statementCause, event and effect in one sentenceStops vague entries like "budget risk"
CategoryCommercial, schedule, technical, cyber, peopleDrives roll-up reporting
OwnerOne named personShared ownership means no ownership
Inherent likelihood x impactScore before any controls, on a 5x5Shows how bad it could be
ControlsExisting measures and their effectivenessExplains the gap between inherent and residual
Residual likelihood x impactScore after current controlsThe exposure you actually carry today
Target scoreWhere you want residual to landTells you whether more action is needed
ResponseAvoid, reduce, transfer or acceptForces a decision
ActionsOwner and due date for each extra mitigationTurns the register into work
TriggerEarly warning sign that the risk is materialisingLets you act before it becomes an issue
Last reviewedDate of last reviewExposes stale entries

Risk register example: six real entries

The example below covers a 14-month office fit-out and IT migration. Scores use a 5x5 matrix (likelihood x impact, so 25 is the maximum). Treat the content as illustrative; the structure is what to copy.

IDRisk statementCategoryOwnerInherent (L x I)Key controlsResidual (L x I)TargetResponseNext actionTrigger
R-001Because the main contractor is resource-constrained, fit-out could slip past the lease exit date, causing double rent of about $85k a monthScheduleProject Director4 x 5 = 20Weekly progress reviews; LDs in contract (partly effective)3 x 5 = 158ReduceAgree recovery programme with contractor by 15 NovTwo consecutive weeks below 90% planned progress
R-002Because long-lead switchgear is single-sourced, a supplier delay could stop power-on, delaying handover by 6 to 8 weeksSupply chainProcurement Lead3 x 4 = 12Early order placed; monthly supplier updates (effective)2 x 4 = 86ReduceIdentify second supplier and get a quoteSupplier misses factory test date
R-003Because legacy file shares hold unclassified data, migration could expose confidential files to all staff, causing a reportable data breachCyberIT Security Manager3 x 5 = 15DLP scanning; permission audit before cutover (partly effective)2 x 5 = 105ReduceComplete permission audit on remaining 40% of sharesAny audit finding of "Everyone" access on HR or finance folders
R-004Because steel prices are volatile, material costs could rise above the 5% contingency, causing budget overrunCommercialCommercial Manager3 x 3 = 9Fixed-price package for 70% of steel (effective)2 x 3 = 66AcceptNone. Monitor monthlyIndex rises more than 8% in a quarter
R-005Because only one engineer knows the network design, their absence could stall cutover, delaying go-live by 2 weeksPeopleIT Manager2 x 4 = 8None in place2 x 4 = 84ReduceDocument design and pair a second engineer by 30 NovLeave request or resignation from key engineer
R-006Because the building is in a flood-risk zone, a storm event could damage ground-floor plant, causing outage and repair costOperationalFacilities Manager1 x 5 = 5Plant raised 600mm; building insurance (effective)1 x 3 = 33TransferNoneSevere weather warning for the area

How to read this example

The useful information sits in the gaps between columns, not in any single score.

  • Inherent vs residual tells you if controls are earning their keep. R-001 only drops from 20 to 15 because its controls are partly effective. That is the risk the board should hear about first. R-005 has no controls at all, so inherent and residual are the same, which is a warning sign on its own.
  • Residual vs target tells you whether to act. R-004 already sits on its target of 6, so the right response is accept and monitor. Spending more effort there would be waste. R-003 is still double its target, so the open action matters.
  • Triggers turn a register into an early warning system. Every trigger in the example is observable: a progress percentage, a missed test date, an audit finding. If you cannot see a trigger happen, rewrite it.
  • One owner per row. Each risk names a role, not a team. When the trigger fires, there is no debate about who moves.

Five mistakes that make a risk register useless

  1. Listing issues as risks. "Contractor is behind schedule" has already happened. It belongs in the issue log; the risk is what that delay could cause next.
  2. Scoring once. A single score hides whether controls work. Always record inherent and residual.
  3. Controls with no effectiveness rating. A control that exists on paper but is never tested should not cut a score from 20 to 6.
  4. No review rhythm. Registers go stale the week after the workshop. Review high risks monthly and the rest quarterly, and record the date each time. More on that in why risk registers go stale.
  5. Overwriting history. If last month's score is typed over, you can never show the board how exposure moved. Keep a snapshot each reporting period.

Risk register template or risk register software?

An Excel risk register template is fine for one project and one owner. It breaks down when several people edit it, when you need history, or when the board wants to see how exposure moved since last quarter.

That is the point where teams move to dedicated risk register software. Cilver imports the spreadsheet you already have, keeps inherent and residual scores tied to rated controls, reminds owners before reviews slip, and snapshots every reporting period for board-ready reporting or Power BI dashboards.

Bring your current register and see it live in an afternoon. Start a 14-day free trial, no credit card needed.

FAQ

What should a risk register include?

At minimum: ID, risk statement, category, owner, inherent score, controls, residual score, response, actions, trigger and last review date.

What is the difference between a risk register and an issue log?

A risk register tracks things that might happen. An issue log tracks things that already have. When a risk materialises, close it in the register and open an issue.

How often should a risk register be reviewed?

High and critical risks monthly, the rest at least quarterly, and immediately when a trigger fires.

What is the difference between inherent and residual risk?

Inherent risk is the exposure before any controls. Residual risk is what remains after the controls you have in place today.

Can I use a risk register in Excel?

Yes, for a single project. Most teams outgrow it once they need multiple editors, audit history or period-on-period reporting.

Related in Cilver: Run this register live in Cilver · Period snapshots and board reports · Connect Power BI to your register

Take control of your risk register. Today.

See on your own risks

A short live walkthrough. Bring your current spreadsheet and we'll show you how it looks in Cilver.

Just have a question? Ask us anything.