Your Risk Assessment spreadsheets are costing you!

Are your employees still manually managing Risk Assessments using spreadsheets?
If you answered yes, they are likely struggling to work with others efficiently, they are frustrated by version control issues, and they are wasting time trying to figure out who has given input and who still needs to provide information.

The data in spreadsheets is difficult to aggregate. Performing analyses within a spreadsheet is limited, and across multiple spreadsheets it is nearly impossible. There are nearly always issues with data entry and, therefore, data integrity. So, your employees are likely also spending time having to validate and track down information and they’re likely performing rework to shore up assessments and findings. For all of these reasons, spreadsheets prolong the time and expense of audits.

RGP’s policyIQ team has developed features that help you to automate questionnaires, inventories, risk ratings, capability measures, track gaps and roll-up findings. Your management and audit teams can begin collaborating on their finance, operational, fraud and enterprise risk assessments right away.  Contributors from your locations can work together in one flexible and easy to use tool with confidence in the security and accuracy of their information and analyses. Templates for various risk assessments are easy to customize. Notes and assumptions from previous assessments can be easily referenced and considered in current risk calculations.

Your auditors can remotely review the content that you choose to make available to them and only after it has completed the review process that you enforce using policyIQ.

Reach out to us to request your free trial site and to learn more about how your team can end their reliance on spreadsheets. Work smarter.

We’re handing it to you: Risk Assessment Template for policyIQ

The policyIQ Team has discussed the benefits of bringing automation to the full cycle of work and documentation associated with your Sarbanes Oxley Compliance program in previous posts. You might recall training sessions or posts that introduced the application of policyIQ for your Risk Assessment process. If you haven’t had time to play around with your content and tying everything together in your policyIQ site, we want to help you with an example of a Risk Assessment Page Template that could provide you with a good starting place.

RiskAssessment Template

Of course, your template could include different fields, different risk factors that are weighted differently and you might have different thresholds for your risk ratings. I hope that you already know that virtually everything in your policyIQ Page Templates is customizable.

With that disclaimer, I would also like to highlight some things in our example. We have captured a template that would be used to rate the risk for a single Financial Statement Line Item. The six risk factors included here are simply Whole Number fields for entering a rating. Most of the text in this template is content that we captured in a policyIQ “Static Text” field—really, just to provide guidance and clarification to those performing and reviewing the assessment. The critical field in the Risk Assessment Financial Statement Line Item Page Template is the Calculated numeric field used to take all of the Risk Factor ratings and weights of each factor into account. When adding this type of field to your Page Templates, you are prompted to enter the formula for the calculation. Math formulas are not your thing? Feel free to reach out to one of us on the policyIQ team and we’ll help you to pull it together.

Okay, you’re really close now! Build the template (or ask us to build it with you) and then we’ll help you to see how you can import your latest Risk Assessment results into policyIQ and link them to the relevant Assertions and related Controls. Most of this initial setup can be performed in bulk via the policyIQ Import utility. Really, it could be in policyIQ within the next week. Really. What are you waiting for?

Get in touch with us: 1-866-753-1231,