in

smartercommunity

Bringing policyIQ users together

policyIQ Blog

February 2010 - Posts

  • Using policyIQ for ERM? Want to? Let’s talk!

    In a recent survey, a number of you responded that you’re interested in policyIQ for Enterprise Risk Management (ERM). Okay, you asked for it, so we’re going to deliver it!

    Enterprise Risk Management will be the subject of our next CPE training session offered in late March. We have a standard configuration for ERM that we plan to walk through with you…but we want to make this session more interesting and valuable to YOU!

     

    Can you help us out?

    Are you using policyIQ for ERM?
    Can we have a quick chat about how things are working for you, lessons that you’ve learned and highlights that you’d like to pass on to other policyIQ users? If you wouldn’t mind sharing your insights with us, please get in touch with me and I’ll give you a call.

    Are you interested in using policyIQ for ERM?
    I would love to talk to you and learn more about your particular needs, the problems that policyIQ might help you to solve and see if we can add more relevant examples to our upcoming training session that will suit you and others with similar needs. Please get in touch with me so that I can pick your brain and create more value for you in our March session.

    Thank you!

     

  • Overview of policyIQ for SOX: Training Q&A - Reports and Training (Part 2 of 2)

    In this second half of our Q&A follow-up from our February 23rd training class, we'll address those questions related to:

    • Reports
    • Training
    • Other policyIQ uses

    Haven't read Part 1, yet?  Check it out here!

    Reports 

    When we dug into the topic of Reports, there were a great number of really terrific, detailed questions.  This topic always strikes up some great conversations - and we'd love to hear from some of you in the comments to let us know if you have other answers that you have given to your fellow policyIQ users! 

    Question: Is there a Template or linking ability to a Summary of Aggregated Deficiencies (SAD) Report?

    Answer: This is definitely a possibility within policyIQ Reports.

    Based on my understanding of what is required as a part of a typical Summary of Aggregated Deficiencies report, you essentially need to pull together a report of all Deficiencies that are not closed out by the end of your testing year. By documenting your Deficiencies in policyIQ and linking them to failed Tests, you can keep track of the status of the Deficiency (some clients go so far as to link a Remediation Plan), and include fields for the Severity and even the Cost or Estimated Financial Exposure related to the Deficiency. When pulling this information back out for your end of the year reporting, you will likely use a Detail Link report type, starting with your Open Deficiencies in data set 1 and including critical details from the Test, Control and ultimately the Risks that are linked back to this Deficiency.

     

    Question: Are the reports in the Unfiled-Administer and Unfiled-View Only viewable to all users?

    Answer: Not necessarily. You can make reports available to all Advanced users or specific Groups of users by adding them as "Viewers" to the Report properties. Those reports that appear in the Unfiled-Administer area are those reports that you can administer, but that you have not filed into a specific Category. Those in Unfiled-View Only are reports that you can view, but not administer that have not yet been categorized.

     

    Question: How can I create that report that you are describing now?

    Answer: Please check out our Help guide for some additional details about how to create the various reports that we created in our training class, along with several others that may be important for your Sarbanes-Oxley process.

     

    Question: Are the Page hyperlinks available in the Excel export of the Report?

    Answer: Starting in version 6.6, you will be able choose to include the Item URL as one of the columns in your exported report, which will then appear as a hyperlink in your Excel export. (Check out version 6.6 release notes for more information.) 

     

    Question: Can Report Categories be assigned differently per user or only by the report designer?

    Answer: Report Categories are always defined by the specific user. When you create Categories in your Reports module, those Categories are specific for you – so that you can organize reports in any way that makes the most sense for your daily work.

     

    Question: Can a summary report be generated that indicates the number of control deficiencies/exceptions by department or division for risk management reporting (i.e., KRI, KPI trends, etc?)

    Answer: Yes! Another one of those questions we love to receive, because it allows us to talk about the depth of possibilities in policyIQ.

    Most clients will document Deficiencies on their own unique Pages, with a specific Template for all of those fields that must be captured related to a Deficiency. Those Deficiencies are indexed into those Folders that outline your Business Processes and also in to the Folders for Locations or Divisions, alongside the Controls and Tests. This allows you to create a Summary Report (along with so many other possibilities) of all Deficiencies identified in this testing cycle by Business Process and Division (or Location). You can quickly pinpoint which Processes or Divisions pose the greatest risk to your organization. You might also have a field on your Deficiency Template that defines the Severity of the Deficiency. Is it a material weakness? You could then create a different Summary Report of all Deficiencies identified this testing cycle by Severity and Process (or Division) to see where the greatest risk lies.  

     

    The above illustration is just a quick example of what this might look like.  Remember that Summary Reports allow you to drill down, as well - either into a specific Process to see sub-Processes, a Region to see specific office locations, or by clicking on any of the numbers in the report to see the detail of the Deficiencies represented.

     

    Question: What is the difference between Standard and Read-Only user types?

    Answer: Standard Users have access to a few additional things that Read-Only users do not: Standard users can respond to Forms, they have a Dashboard to keep track of Forms assigned or Pages to read, and they access to Advanced Search! Advanced Search allows a user to create a simple "Detail Report" of content.

    In version 6.6, Standard and Advanced users will be able to create and save Advanced Searches to create their own custom views or queries to be accessed within their left-hand navigation. (Check out version 6.6 release notes for more information.)  Read-Only accounts do not have any personalized content or access to Advanced Search.  

    Question: What examples do you have available in the Internal Audit and Enterprise Risk Management areas?

    Answer: We don’t plant attendees to ask leading questions, but sometimes it feels like we do! Join us next month when we host our next CPE training event that will focus on Enterprise Risk Management in policyIQ. We’ll show you a little bit more about how you can incorporate elements of your ERM program into policyIQ. Keep an eye on our blog or on your policyIQ log-in screen for more details!

    For more information on how to use policyIQ for Internal Audit, check out our whitepaper that is available now in our online Help guide. This guide will walk through how policyIQ can be set up to manage workpapers and operational audit documentation.

     

    Question: What further training would you recommend to develop a deep knowledge of policyIQ?

    Answer: Our policyIQ Training Center offers a great deal of options for getting more knowledge and in depth training on policyIQ. Training courses are broken down by both the policyIQ Module (such as Create And Edit or Setup), as well as by user type (such as "Content Manager" or "Site Administrator").

    If you are brand new to policyIQ, we recommend starting with the Introduction to policyIQ followed by the Workflow – Overview session. The combination of those two sessions is just about 30 minutes of recorded training, but will provide a solid overview for new users.

     

    Question: Can we get a copy of the questions & answers in chat?

    Answer: Yes.

     

    *whew*  Those were some GREAT questions.  Of course, every organization is just a little bit different and has different reporting and documentation needs.  Contact our support team or speak with your account manager if you'd like to talk more about how you can utilize policyIQ most effectively for your SOX compliance.

    And don't forget those great resources available to you in the policyIQ online Help guide!

  • Overview of policyIQ for SOX: Training Q&A - 302 and 404 (Part 1 of 2)

    Our training team recently hosted the first in our series of "solution-based" policyIQ training sessions. Every month we will be choosing a new area of your business for which policyIQ can offer you solutions to your business needs. In addition to the opportunity to learn about a new way to extend your policyIQ application, attendees earn CPE credit for their participation.

    This month, our topic was Sarbanes-Oxley in policyIQ – boy, did we have participation! Many thanks to all of you who did attend for the great questions that kept coming throughout the hour long training session. We had so many great questions, that I've been forced to split this blog post into two parts. (That's definitely not a complaint!) Even if you were on the training session and had your question answered, check out the responses below, as we've tried to put a little more detail around those answers than we were able to provide in our limited time on Tuesday.

    In Part 1, we'll address those questions that were asked in the first half of the training class, as we discussed

    • Using Forms for 302 Certifications and Control Self-Assessments
    • Ideal configuration for 404 Documentation, including recommended Templates

    If you did not have a chance to attend this month’s training, you can listen to the recorded training session available now within our training center – and watch for an announcement of next month’s CPE training event with an overview of Enterprise Risk Management in policyIQ.

    In conjunction with the release of the training session, we have also put together a new chapter in our online Help guide under Training & Support that is all about using policyIQ for Sarbanes-Oxley.  (As we present other solutions in future months, this area will grow.)

     

    Now onto those questions…

     

    Using Forms for 302 Certifications and Control Self-Assessments

    Forms can be used in a variety of ways within your Sarbanes-Oxley process. We showed you examples of 302 Certification Questions and Control Self-Assessments. You all had some questions.

    Question: Can documents be attached to a Form in response to a question?

    Answer: Yes! When issuing Forms, you first create a Form Template with all of the fields (or questions) that you need to have filled out by the respondent. One of these fields can be a "File Upload" field type, which allows the respondent to upload supporting documentation to their Form.

     

    Question: Are respondents required to be users in policyIQ?

    Answer: Yes, in order to respond to Forms in policyIQ a user must be at least a Standard User in the application.

    It is understandable that all organizations are looking to maximize the value they get from policyIQ while minimizing their cost. Consider the time and effort that you currently put into managing the 302 Certification process or the review and self-assessment of your Controls. policyIQ can save you time and reduce the risk of error or misplaced responses, which will add a great deal of value to your organization! And if you can extend policyIQ Forms into other areas of your business or use Forms for more business processes, that value continues to grow.

     

    Question: Can I send my Form to different people at the same time? Or can I only send the Form out to users one by one?

    Answer: Yes, you can absolutely send your Form to a Group of users at the same time.

    For example, those Forms that are related to your 302 Certification process probably need to be distributed to a number of individuals. We recommend creating a Group in your policyIQ structure to help you to organize your users into a "302 Respondents" Group for ease of maintenance. If you have some questions that only get answered by a few people, while other questions get answered by a larger Group, separate those questions into different Form Templates and then gather them up into a Form List to make it easier to distribute.

    If you’d like some more detail about how to set up Forms in policyIQ for 302 Certifications or Control Self-Assessments, check out your policyIQ Help guide for more information.

     

    Ideal configuration for 404 Documentation, including recommended Templates and Folder Structure

    After reviewing how Forms can help with your 302 Certifications or Control Self-Assessments, we tackled the big question: How do I manage my Risks, Controls, Testing, Deficiencies and other SOX 404 documentation?

    Question: How do you identify Key Controls?

    Answer: Your organization will create Templates in policyIQ for Risks, Controls, Tests, Deficiencies and various other types of SOX content. On your Control Template, you will be creating fields to capture all of the relevant information about your Controls – including whether or not that Control is "Key". Often this is a simple dropdown labeled Key Control? with Yes or No options, while some clients choose to refer to this field as the Control Significance with Key or Non-Key choices.

     

    Question: If you choose to index Controls to multiple Processes, what is the best way to determine the number of Controls in each process and the total number of Controls without double-counting your Controls?

    Answer: Our recommendation is that when documenting a Control, index that Control into the Process folder(s) to which it applies. If the same Control exists in more than one Business Process, document it just once. That way you can minimize the total number of Controls that you have to manage and test, while still clearly communicating the existence of the Control in the appropriate Processes. However, one of our attendees asked a great question about how to properly count the total number of Controls. policyIQ Reports will allow you to both report on an individual Process (How many Controls do I have in the Procure to Pay process?, for example) or report on all Controls in the entire organization, with a column in those report results to show you the Process(es) in which the Control exists.

     

    Question: There is a "Reference Number" field on your Risk Template. Is that necessary? It seems like it would be cumbersome to maintain a reference number.

    Answer: To be fair, this wasn’t originally in the form of a question. One of our participants had commented on the existence of this field on our examples – and it was a great opportunity to address the issue of customizable Templates and Fields.

    Our policyIQ team has a great deal of experience in helping clients implement policyIQ for Sarbanes-Oxley compliance, so we do have some suggestions for your Risk, Control, Test, Deficiency and other types of Templates. However, every organization has unique needs when it comes to gathering that information. Some companies are moving into policyIQ from an existing system or spreadsheets, where they already have a numbering convention for Risks or Controls. The Reference Number field can be very helpful as a way to cross-reference the policyIQ page with the older documentation, if necessary. The beauty is that you decide what is important and what data you just do not need to capture.

     

    Question: Can you comment on how Pages are rolled-forward for one year/period to another? Can we customize the extent to which the information is carried forward?

    Answer: This is SUCH a great question that we’d like to spend an entire half an hour talking about it. We’ve scheduled a 30 minute training session for March 9th at 4 PM ET / 1 PM PT to talk about how you might roll-forward for a new testing period. You can register today! We will also be creating Help documentation to talk about the roll-forward process and will make it available in our online Help guide in conjunction with the March 9 training session.

     

    Question: Is there a feature allowing for cross-reference with complementary, compensating and/or Entity Level controls?

    Answer: I love this question, because there isn’t a simple, single answer. We would love to see some of our existing SOX clients comment on this blog post to share how they might manage this very situation. The best answer is likely to be a combination of Template fields and link relationships between your Controls.

    For example, you might have a multi-select list field on your Control Template that is labeled Type of Control, with choices for Primary, Complementary, and Compensating. If a Control is flagged as Complementary or Compensating, it would then be linked to the other Control that is the Primary Control for a specific Risk. You would then be able to create a Risk / Control Matrix (a "Detail Link" report type) that is filtered for Risks in your first data set, Primary Controls in the second data set, and Complementary or Compensating Controls in the third data set.

    In my experience, Entity Level Controls are often handled a little differently – either by having a Business Process Folder that contains all Controls that are identified as Entity Level, or by having a unique Entity Level Control Template that captures different fields than your standard Control Template. The best solution for you depends on your reporting needs and the structure of your process.

    Does anyone reading this have a different way of handling this that they'd like to share? Post a comment and let us know!

     

    Question: Is there a way to restrict the view of users to certain pages only? For example, can I restrict my external auditors from being able to view anything but completed and reviewed pages?

    Answer: Yes, absolutely! policyIQ allows you to restrict access to your content in a number of ways.

    For your External Auditors, we suggest creating a Group in your Group structure called External Auditors. This group can then be added as a Viewer on all of the relevant SOX content – Risks, Controls, Tests, Deficiencies, Narratives, etc. (If you are just getting started, you can add this Group to your Default Viewers on your content Templates, so that you don’t have to add them later!)

    When creating the individual user accounts for your External Auditors, we would suggest giving those users an Advanced user account with a Role of "Reporting User." The "Reporting User" Role has access to create and run Reports, but will not be able to see any content that is not yet published. If you aren’t quite ready to give your External Auditor an Advanced user account, you can also set him/her up as a Standard user. The Auditor will have the ability to create Advanced Searches (similar to "Detail Reports"), and as a Standard user, he/she will not have access to any unpublished content.

     

    Question: Is there audit trail capability? For example, can I keep track of what changes are made in key controls and test plans for SOX documentation?

    Answer: Yes, absolutely! That is a key feature in policyIQ. All changes to a page are tracked in the "Change History" with a user and date/time stamp. There is also a "Version History" that will save an exact copy of the page as a "Version" every time you publish the page.

     

    Question: In the examples, it looks like the same icon, "C", is used for business controls and IT controls - how does that work?

    Answer: This question was specifically directed to our training site, where we have different Templates for Financial Controls and IT Controls. As you probably know, each Template is assigned an icon to help users identify it quickly. policyIQ allows you to reuse those icons for as many Templates as you'd like. We thought it made it easier to identify "Controls" (be it Financial or IT) if we used the same "C" icon.

     

    Question: Is there an auto-save feature to save input on your pages if you get logged out or lose your connection?

    Answer: There is not an auto-save feature on pages in policyIQ. There is a Save option available from your toolbar while you are working on a Page that will save your work so far. If your connection might be problematic, you may wish to save your work periodically. (If you find yourself frequently losing your connection to policyIQ, please contact your IT department or our policyIQ support team for some assistance.)

     

    Question: What is the maximum size of external files that can be attached within a page?

    Answer: When uploading a file as an attachment to a Page or Form, the maximum size permitted is about 10 MB per file. (Your upload connection will time out for larger files.) There is no limit to how MANY 10 MB files you can upload, however.

     

    Question: What is the difference between Any Approver and All Approver?

    Answer: This question was asked in reference to the Content Approver options that are available when setting up a content Template. "Any Approver" means that only one of the users identified as an Approver needs to approve the page. "All Approvers" means that approval must be granted by all of those users before it is approved and published.

     

    Even more questions related to Reports, further training and other uses of policyIQ are available in Part 2!

  • 64 (yes, 64!) secrets to Effective Content Management

    It would be an understatement to say that companies struggle to execute Enterprise Content Management.  Even with a system like policyIQ, effectively managing all of the information you collect requires a clear strategy, understood responsibilities, and diligence.  And even if everyone executes their steps perfectly, you still need to deal with user acceptance and company culture. 

    The free e-book “8 Secrets of an Effective Content or Records Management Implementation”, by John Mancini (posted on the AIIM website), is a great collection of practical advice.  The book is actually a collection of 8 different articles on the subject, with each article covering a different aspect of ECM through a list of 8 points.  Articles include 8 Ways to Increase User Adoption, 8 Things You Always Wondered About Your Legacy Content, and 8 Steps to Avoid Process and Organizational Problems.  With 8 articles each conveying 8 points, that’s 64 pieces of advice to help you effectively manage your content.  

    Some of my favorites from the list of 64 include:

    ·         Think Through a Governance Structure and Approach.  A common mistake is believing that the technology enforces governance; the technology will have some features to help automate the governance of your content, but ultimately governance is your responsibility, not the technology’s. 

    ·         Don’t Forget the Change Management.  Who could forget something this important?  Well, almost everybody does to some degree.  You are changing how your employees operate, and many of those employees are set in their ways.   All of your change management activities – and there will be a lot of them – should be near the top of the priorities list. 

    ·         Get Top Level Support.  Sounds obvious, and you may think you have it because the CIO or CEO sent out an email once, but do you really have it?  How committed is management to supporting this initiative?  Do they anticipate the headaches and complaints that they will need to weather to ultimately get to the promised benefits?  It’s going to get harder before it gets easier. 

    ·         Start Small.  This is a BIG project.  You need to turn it into a bunch of smaller projects that you can execute, measure, celebrate success, and learn lessons from. 

    ·         Focus on the Business Process.   Implementing an ECM strategy and system will require change, but there are some things that you just won’t be able to change.  Know as much as you can about today’s process (Who creates information?  How?  Where? When?  Why?) and be comfortable that you will be supporting “something like that” with your implementation.  It doesn’t have to be that process exactly, but assume that the more you change the harder it will be to reach success. 

    Maybe the most valuable part of this book is what it doesn’t have – a discussion of what software features you need.  Too many organizations jump right to software demonstrations as step 1 of their process – looking for the silver bullet that will magically solve their content management problems. 

    Software demonstrations should be step 65 (or later) on your list – skipping all of the other steps will almost assuredly set you up for failure. 

    Posted Feb 22 2010, 06:40 AM by roccotarasi with 1 comment(s)
    Filed under:
  • policyIQ version 6.6 release announcement!

    Hello, policyIQ Users!

    We're happy to announce the release of policyIQ version 6.6. We will be introducing version 6.6 over the weekend of February 27 - 28. Your site may be unavailable very briefly during this maintenance window.

    If you read our recent sneak peek right here on the Blog, you know about some of the great features we're introducing. For more details about the release content, read the release notes here. We also recently held a live release notes review session, and you can view the recording from that session by clicking here.

    If you have any questions about version 6.6 functionality, send us an email at support@policyIQ.com.

  • Micron: Using Approvals and Workflow for a high SOX “IQ”

    "...our primary goal is to keep the SOX environment as efficient as possible," explains Wayne Radue, SOX Manager for Micron Technology, Inc
    Wayne and the team at Micron have used policyIQ to manage their Sarbanes-Oxley compliance since 2004.  At Micron, access to policyIQ is distributed to Internal Audit testers, control owners and process owners, but they use Approvals to maintain strong oversight over all changes.  We asked Wayne to share a little bit about how their organization uses workflow features to keep the process running smoothly and efficiently.
    Groups, Groups, Groups
     
    The key to Micron's efficiency might just lie in their extensive use of Groups to organize their users.  While they have 50 users in policyIQ, Micron has close to 100 Groups defining all of the different parts that a user might play in the SOX process.  There are Groups for each Business Process, broken down into two subgroups: one for the Process Owner and another for other users involved in that business process. 
     
    The Internal Audit department is broken down in several ways, including a structure into which all IA Testers can be appropriately assigned to the business cycle that they will be testing within any given period.  By utilizing such a detailed Group structure, Wayne and the SOX team at Micron do not need to concern themselves with updating pages to include the right individual tester, control owner, process owner, reviewer, etc.  It is simply a matter of making sure that the user profiles are properly assigned and updated as individuals move within the organization. 
     
    Assigning and Performing Testing 
    When it comes to Sarbanes-Oxley testing, this is the domain of the Internal Audit team at Micron.  The Business and IT Audit Managers assign the Testers to the appropriate business cycles at the start of any given testing period - and remember, they do so by simply moving the user profiles in the appropriate groups!  Those same Audit Managers are the designated Approvers on the Test Template, which allows them to review the Tests as they are submitted.
     
    Keeping the Controls Updated
    When it comes to keeping Control documentation updated, Micron Technology asks the Process Owners to update the documentation in policyIQ when the control changes.  By making the appropriate Process Owners Group the "Administrator" of the Control pages, the Process Owners are empowered to make changes as necessary. In some cases, they will also give individual Control Owners administrative access to the pages to further distribute the responsibility.
    All changes to the Control documentation must be routed through an approval group including Wayne as the SOX Manager and the designated IT control coordinator.  This ensures that the changes are reviewed for completeness and that the SOX Management team has a clear picture of how much the control environment is changing at any time. 
    Wayne admits, however, that the Business Process Owners are often too busy to make the changes directly.  Wayne and his counterpart in IT will often make the Control changes on behalf of the Process Owners in policyIQ.  The process is designed to be flexible, giving the right individuals the access to make changes - but allowing for a distribution of work that makes sense for their organization.

     
    Every organization strives to work smarter - not harder.  By utilizing a detailed and well thought out Group structure, as well as distributing the ability to make changes to all of the right users within the company, the SOX team at Micron Technology has maximized their SOX "IQ" and created an efficient and effective process for their organization.
  • Know thy data, Know thyself: Improve your Business IQ with Reporting

    Business Intelligence is defined by the good people at Wikipedia as referring to skills, processes, technologies, applications and practices used to support decision making. 

    So how can you improve your "Business IQ" and make better, more informed decisions?  If you are using policyIQ, the first step is to fully utilize your Reports module to understand your data and get smarter about your business.

    In an effort to help you to boost that IQ, we've given you some ideas for the reports that you might need, or reports that will make you a more efficient part of the process.  In just this sample of report possibilities, we've covered reports for

    -  Policy and Procedure Management
    -  Compliance Efforts (SOX, MAR, PCI, etc)
    -  Contract Management
    -  Account Reconciliation process

     

    Regardless of how you are using policyIQ, reports can add value and can improve the quality of the decisions that you make!


    Reporting on Policies, Procedures and Process Documentation

    If you are using policyIQ for policies, procedures and basic process documentation, you might be thinking “I don’t need reports.  This doesn’t apply to me.”  Go ahead and admit it – you won’t hurt our feelings.  But there are so many ways that well structured Reports can help you to better manage your content.

    • What policies and procedures haven’t been reviewed in awhile?

      Don’t underestimate the need to keep your information current!  Your users want to know that they can trust the data – and seeing that the page was last reviewed within the past year will give them greater peace of mind that they are, in fact, looking at the most current version of you the policy or procedure.  policyIQ already has a standard field for the “Expiration Date” on the content – and standard reports available to track of things as they expire.  Or use Change filters to find pages that haven't been updated in a certain period of time.

    • What policies or procedures aren’t yet published and available?  What is being worked on?

      Run a quick report to see those policies that are still unfinished and not published for your audience – and then follow up with the individual to whom the page is checked out to check on the status.

    • We've just implemented a new enterprise wide application.  What policies and procedures need to be updated because they reference the legacy system?

      When you implement a new application or move responsibility from one job position to another, you should go through your existing documentation and be sure that the information is up to date.  But how do you identify everything that might be affected?  The easiest way to find all of the pages that might need to be adjusted is to run a report – or do a Search – for all content that contains that application name or that job title.  The list of the content that comes back should be reviewed – and you can easily review all of the pages or assign the pages out to their respective owners to be reviewed right from your results!

     

    Reporting on your Compliance Efforts – SOX, Model Audit Rule (MAR), Payment Card Industry (PCI), SEC Rule 38a-1, Canadian Bill 198 (“C-SOX”)

    There are a lot of different compliance efforts that our clients manage in policyIQ, but our experience has been that your needs boil down to the same thing:  You have to have procedures or controls in place that mitigate risks (or meet regulations) – and you need to confirm that your organization is performing those procedures properly. 

    For compliance efforts, reporting is CRITICAL.  Having controls in place and testing them is only half the battle.  You need to PROVE that the testing has been completed to your auditors.  The compliance management teams need to provide reports to management and executive level, as well as to external auditors.

    • Risk / Control / Testing Matrix

      A “Detail Link” report will allow you to pull together Risks, Controls and Tests into a single report (even adding on Gaps or Deficiencies, if desired).  You can create one report for the entire company, or break it down by division, business process, location, etc using filters.

    • Executive Summary of Gaps by Process or by Location

      Your executive team wants to know where the problems are – and what areas of the business have the greatest potential liability.  A “Summary” report of all Gaps distributed by Business Process and Location (or Division) is a great way of illustrating the trouble spots.

    • Testing Status Report

      There are a variety of ways to provide status reports of the Testing process, depending on the level of detail that is desired by the audience.  A simple “Summary” report can show the number of Tests that are in various stages of completion – and can be broken down by Business Process or Location, as desired.  A “Detail” report can list all Test pages, sorted by the Status of those Tests.

    • Period End Testing Results

      Again, there are a variety of ways to provide this report, depending on the level of detail desired.  A “Summary” report can show the number Tests that have Passed, Failed, Remediated, etc, and can be broken down by Business Process or Location.  A “Detail” report can simply list all Test pages, with columns for the Results and Conclusions.

      Perhaps even more useful, though, is a “Detail Link” report, with Controls and Tests – where both the Control information and the current period Test information is provided side by side in the “Detail Link List” export format.

    But reporting for compliance efforts isn’t all about deliverables; there are a lot of reports that can help you to manage the process along the way.

    • Are all of my Controls linked properly?  Tests?  Gaps / Deficiencies?

      Run a “Detail Link” report with Risks in the first data set and Controls in the second data set to confirm that all of your Risks are linked properly to your Controls.  Or switch the order of the data sets to confirm that all of your Controls are linked to at least one Risk.   Similar “Detail Link” reports can be used to confirm that Tests (in dataset 1) are linked to their respective Controls (in dataset 2), or that Deficiencies are linked to a Test or Control page.

    • Have any of the Controls changed from Key Controls to non-Key or vice versa this year?

      You need to concentrate your testing on the Key Controls – and you need to know if that has changed this year.  Create a “Detail” report and use the Change filters to narrow down any Control pages where the “Key/Non-Key”  field has changed.  (Change filters all you to narrow down results to changes on a specific field.)

    • Who still has Testing that is incomplete? 

      A “Detail” report filtered by all Test pages with an Incomplete status will tell you what isn’t yet finished.  Be sure to include the column of “Checked Out To”, so that you can follow-up with the appropriate tester.

    Reports for Contract Management

    In the world of contract management, reporting is critical to keep track of what is coming up for renewal, what needs to be reviewed, etc.   Here are just some of the questions you could answer using policyIQ reports.

    • What contracts with vendors are set to renew in the next 60 days?
    • What client contracts are expiring in the next 60 days?
    • Who are our largest clients?  (or “What client contracts are worth more than $X?”)
    • What contracts are under legal review?
    • Which of our vendor agreements are on an auto-renewal schedule?

     Account Reconciliation Reports

    For those using policyIQ for account reconciliation, one of the key benefits that policyIQ offers is the ability to easily report on the reconciliation progress and results.

    • Which accounts are not yet reconciled for this month (or quarter)?
    • Which accounts have an unreconciled balance?
    • What reconciliations this month have an unreconciled balance greater than $X?
    • For this specific account, what is its balance and reconciliation history?


    policyIQ can be used to manage so many different types of business content – and we’ve touched on just a few of those here.  Check out our description of a variety of policyIQ Solutions for even more ideas on how your organization might be using the application.  With each type of business content or new area that you move into, consider the reporting needs of your audience, your management team and yourself – and ask us how you can best utilize policyIQ reporting to increase your business IQ!

  • Sneak Peek at our next release, version 6.6

    Version 6.6 of policyIQ is on its way and we just know you're chomping at the bit to see what's in it! With that in mind, we wanted to give you a sneak peek of the coming release.

     

    Custom Views using Advanced Searches

    This new feature is going to let you define the different views you have in various modules. An Advanced Search menu item will appear in the left hand navigation of the Home, Create And Edit, Approve and Setup modules. You'll be able to create Advanced Searches that give you a custom view of data, and then save these Advanced Searches for quick access.

    Do you perform SOX testing in a specific business area?  Use this feature to create an Advanced Search in Create And Edit that lists all Test Pages in a specific Process Folder, with columns that display the Testing Status, Sample Size and other relevant details. 

    Would you like to have a quick view of all newly published Content? Create an Advanced Search in Home that lists all Content published in the last 30 days, and includes the published date and the publish reason.

     

    New Approval Options

    We're introducing functionality that will let you specify what happens when a Page is published by an Approver, or when a Form is Submitted by an Approver. In both scenarios, you may want to skip the automatic approval process and allow different Approvers to review the item. Our new approval options are going to give you this flexibility.

    It's also going to be possible now to run Form Templates with no Approvers. This is going to let you have submitted Forms go directly to the Approved stage without requiring a review process.

     

    Lots of Reporting Enhancements!

    There are a number of reporting improvements in this release, including greater accessibility for Form Reports, new filter and column options, and some very nice stylistic enhancements to the column selection process. Oh, and we'll be introducing four new Standard reports!

     

    Dashboard Enhancements too

    You'll notice a few nice improvements for your dashboard too, including the ability to add this policyIQ Blog to your Dashboard, and a breakdown of Active vs. Deleted Pages in the Administrative Overview section.

    There are more changes included in the release, but we'll save those for the release notes! Be sure to keep an eye on this blog for the release announcement and a link to the full release notes document.

  • Networking our way to an impressive IQ!

    Would it surprise you to know that more than 2500 policyIQ Templates are in use by you--our clients? Sure, many of you are using policyIQ for similar purposes, but more than 1400 of those are unique Templates! We know of clients in 36 different industries using policyIQ from banking to healthcare and manufacturing to utilities. While we know that many of you are applying policyIQ for uses that are not on our radar screen, we are aware of more than 31 different applications of policyIQ!

    I set out today to write a post about the many uses of policyIQ and how we hope to help you capitalize by teaching you how you can put your site to even better use than what you have accomplished so far. As I dug into the data, I became humbled and grateful all at once. You are amazing!

    Take back the best of what others have discovered

    We don’t want to just share what we know about how you can make good use of policyIQ; we want to share what YOU know about making good use of policyIQ! Off the top of my head, I can picture a site for Model Audit Rule that I wish I could share with all Insurance clients. I know of a great PCI compliance site. One of your peers hammered through the use of policyIQ for account reconciliations and refined a process that works great for them. And I recall helping a client to work through the documentation, review and approval process that they were managing for their Capital Expenditures projects. How are you managing contracts or staffing agreements? Whether you’re going public, going private, ripe for a merger or acquisition, spinning off or going through the difficulty of bankruptcy, another policyIQ client has gone through it before you and they used policyIQ to smooth out the process.

    So, I’m asking you…

    • Do you want to learn what others have done with policyIQ that might be applicable to your organization?
    • Will you share what you have learned about using policyIQ with others?

    If so, please stay tuned, engage in our discussions, comment on blogs and chat with us in training sessions. We are listening and looking forward to networking more with you.

    Solution focused policyIQ Training for CPE Credit!

    We are also anxious to learn what is working best for each of you and are eager to pass on the lessons. We will be hosting a new training session each month that focuses on a different solution each time. The February training session will focus on Sarbanes Oxley content and examples. We will be looking to you to guide our pick of solutions to feature in following months, so let us know what interests you. We’ll be sure to keep the sessions informative and work to share valuable information so that you’ll want to join us and to collect CPE credits while doing so! 

    Are you ready? Get in the conversation, share your thoughts with us and let’s start knowledge networking!

  • policyIQ Overview Training: Follow-up Q&A

    The policyIQ team recently held a new policyIQ Overview training session. If you missed this session, you can view it here: policyIQ Overview - Highlighting the Latest Features .

    Our participants took full advantage of our Chat feature, and we received a lot of great questions. We'd like to share these questions with you, and also offer some answers, in case you missed them in Chat.

     

    Q: How do I go about converting from policyIQ version 5.7 to the latest version?

    A: To schedule your free upgrade to the latest version of policyIQ, contact our Support team at 1-866-753-1231, or by email at support@policyIQ.com.

     

    Q: Does the Search option in Home only include published items?

    A: Search results vary in the different modules. In Home, the Search results will be limited to published content.  In the Setup module, on the other hand, the Search results are Users.

     

    Q: What internet browsers does policyIQ support?

    A: Currently, policyIQ requires Microsoft Internet Explorer version 6 or higher.

     

    Q: Where can I get more information on using the Import tool?

    A: You can view the "Importing Content" session offered on-demand on the policyIQ Training page: http://www.policyiq.com/training.asp.

    Additionally, the policyIQ Help Guide contains a lot of information on importing. Launch help and navigate to Help Guides -> 3. "How to" by Subject -> Imports.

     

    Q: Is it possible to use policyIQ for Control Self Assessments, even for a large number of respondents?

    A: Absolutely! We have clients using policyIQ Forms for assigning Control Self Assessments to large numbers of users. Additionally, our Reporting tool simplifies the process of reporting on the large number of responses. This is a topic your policyIQ Account Manager would be happy to speak with you about!

     

    Q: Can Read-only users respond to policyIQ Forms?

    A:  No. Form respondents must be named users (i.e., Standard or Advanced users).

     

    Q: When a policy is checked out to others, can it be checked out to more than one person?

    A: No. Only one person can be editing a page at one time.

     

    Q: Are there attachment file size limits?

    A: There is a 10 MB limit per upload. However, there is no limit to the number of files that may be attached to a Page in policyIQ.

     

    Q: Do you have to save a Page first prior to sending it on for approval?

    A: No. When you are finished working on a Page, you can then send it for approval without a separate "Save" step.  Any time you hand a page off (to a new stage or if you check it out to a different user) the page will be automatically saved before the hand-off takes place.

     

    Q: Who can review pages--just administrators? Or can you set different people as reviewers?

    A: There are many ways to set up a review process on Pages in policyIQ.  (The specific permissions that are unique to Page Administrators are that they are the only ones who can decide when the Page should be sent for approval or published, if no approval process is required.)  "Reviewers"  might be Administrators, Approvers, or even Editors on a Page to whom the Page is checked out while the Page is in draft.  For assistance setting up Page Security to meet your preferred review process, contact your account manager or email support@policyIQ.com.

     

    Q: I would like to have the ability to use charts and graphs to show testing results in addition to reports.

    A: With version 6.5, we introduced standard charts and graphs for all users.  Stay tuned for more information soon on how to request custom charts and graphs for your organization!

     

    Q: When viewing Pages in the table view, is it possible to view the full folder path of a Page?

    A: In version 6.6, you will be able to add the Full Folder Path as a column in Reports and Advanced Searches. 

     

    Q: Do you expect in a future release the ability to have two levels of approvals on Forms?

    A: We are always adding new features to policyIQ based on the feedback we receive from our users.  In our upcoming 6.6 release, you will be able to designate the approval process on Forms as requiring "All Approvers" to approve an item before it is finalized, along with the existing capability of requiring "Any Approver" to approve it.  We are also adding the ability to have no approval process at all on your forms.

    While we can't commit to any specific features in releases beyond 6.6, we are definitely listening!  Continue to submit all of your requests, questions, suggestions and ideas to us. (For some suggestions on submitting high impact feature requests, check out this blog post.)

     

    Q: Can a vacation request be routed to an individual supervisor, based on the name of the person submitting the request?

    A: No.  At this time, policyIQ Forms are not routed to a specific approver based on information entered on the Form.  However, there are a variety of ways to set up a Form and its approvers such that the person submitting the request can choose to whom it should be directed.  For assistance setting up Form security to best accommodate your process, contact your account manager or email support@policyIQ.com.

     

    Thanks again to all who attended our session! Please keep an eye on this blog for information on upcoming trainings. Also, check back here often as we are frequently posting lots of useful information, including tips and tricks!

© 2008 Resources Global Professionals