📑Risk Register

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
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

You'll need to host the Excel risk register in one of these cloud locations:

1. Microsoft Teams

2. Microsoft SharePoint

3. 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.