📑Risk Register
Last updated
Last updated
The SecureMetrics Risk Register works with the included Excel Risk Register Template.
Upon opening, the Excel template will include sample data. This is the same sample data included in the initial install of the PowerBI app. You'll want to replace this data with data from your own organization.
Upon opening, you'll find the following columns:
Column | Description | Data Type |
---|---|---|
You'll need to host the Excel risk register in one of these cloud locations:
Microsoft Teams
Microsoft SharePoint
Microsoft OneDrive
While other cloud-hosting options may work, the above three are the only ones tested and officially supported.
Because the risk register is centrally located, you can use this version to collaborate across your team. Just make sure any updates are made to this "source of truth" and not offline copies.
Risk ID
Unique ID to identify risk
Whole Number
Risk Description
Short description of the risk
Text
Risk Category
Custom category field to bucket risks
Text
Date Opened
The date the risk was opened
Date
Risk Decision Date
The date the risk decision was made
Date
Date Last Updated
The date of the most recent update to the risk
Date
Risk Owner
The name of the risk owner
Text
Inherent Risk Probability
The probability of the risk before a risk reponse
1-5
Inherent Risk Impact
The impact of the risk before a risk response
1-5
Target Risk Probability
The target probability set by the organization for that risk
1-5
Target Risk Impact
The target impact set by the organization for that risk
1-5
Risk Response Type
The type or strategy of the risk response
Mitigate, Accept, Avoid, Transfer
Risk Response Controls
A short description of the risk response
Text
Risk Response Due Date
The date set for the risk response to be in place
Date
Cost of Mitigations
The determined financial cost of the risk response
Currency
Compensating Controls
An indication if compensating controls are in place for the risk
None, Partial, Full
Residual Risk Probability
The probability of the risk after the risk response
1-5
Residual Risk Impact
The impact of the risk after the risk response
1-5
Risk Status
The current status of the risk
Open, Closed
Notes
Any notes on the risk
Text