2 IT Control Objectives For Sarbanes-Oxley, 2 - FreeBSD

Transcription

2IT Control Objectives for Sarbanes-Oxley, 2nd EditionIT Governance Institute The IT Governance Institute (ITGITM) (www.itgi.org) was established in 1998to advance international thinking and standards in directing and controllingan enterprise’s information technology. Effective IT governance helps ensurethat IT supports business goals, optimizes business investment in IT, andappropriately manages IT-related risks and opportunities. ITGI offerselectronic resources, original research and case studies to assist enterpriseleaders and boards of directors in their IT governance responsibilities.DisclosureCopyright 2006 IT Governance Institute. All rights reserved. No part ofthis publication may be used, copied, reproduced, modified, distributed,displayed, stored in a retrieval system, or transmitted in any form by anymeans (electronic, mechanical, photocopying, recording or otherwise)without the prior written authorization of the IT Governance Institute.Reproduction of selections of this publication for internal andnoncommercial or academic use only is permitted and must include fullattribution of the material’s source. No other right or permission is grantedwith respect to this work.IT Governance Institute3701 Algonquin Road, Suite 1010Rolling Meadows, IL 60008 USAPhone: 1.847.590.7491Fax: 1.847.253.1443E-mail: research@itgi.orgWeb site: www.itgi. orgISBN 1-933284-76-5IT Control Objectives for Sarbanes-Oxley: The Role of IT in the Design andImplementation of Internal Control Over Financial Reporting, 2nd EditionPrinted in the United States of America

DisclaimerDisclaimerThe IT Governance Institute, ISACA and other contributors make no claimthat use of this document will assure a successful outcome. This publicationshould not be considered inclusive of IT controls, procedures and tests, orexclusive of other IT controls, procedures and tests that may be reasonablypresent in an effective internal control system over financial reporting. Indetermining the propriety of any specific control, procedure or test, USSecurities and Exchange Commission (SEC) registrants should applyappropriate judgment to the specific control circumstances presented by theparticular systems or information technology environment.Readers should note that this document has not received endorsement fromthe SEC, which is responsible for regulating public companies, or the USPublic Company Accounting Oversight Board (PCAOB), which isresponsible for regulating the public accounting profession. The issues thatare dealt with in this publication will continue to evolve. Accordingly,companies should seek counsel and appropriate advice from their riskadvisors and/or auditors. The contributors make no representation orwarranties and provide no assurances that an organization’s use of thisdocument will result in disclosure controls, procedures, internal controlsand procedures for financial reporting that: Are compliant with the internal control reporting requirements of theSarbanes-Oxley Act (the Act) Make the organization’s plans sufficient to address and correct anyshortcomings that would prohibit the organization from making the requiredcertification or reporting under the ActInternal controls, no matter how well designed and operated, can provideonly reasonable assurance of achieving an entity’s control objectives. Thelikelihood of achievement is affected by limitations inherent to internalcontrol. These include the realities that human judgment in decision makingcan be faulty and that breakdowns in internal control can occur because ofhuman failures such as simple errors or mistakes. Additionally, controls,whether manual or automated, can be circumvented by the collusion of twoor more people or inappropriate management override of internal controls.3

4IT Control Objectives for Sarbanes-Oxley, 2nd EditionAcknowledgmentsFrom the publisherThe IT Governance Institute wishes to recognize:The principal contributorsChristopher Fox, ACAPaul Zonneveld, CISA, CAThe following contributorsGordon Bloom, CISA, RSM McGladrey Inc., USAMichael Cangemi, CISA, CPA, Cangemi Company LLC, USANancy Cohen, CPA, AICPA, USARoger Debreceny, Ph.D., FCPA, University of Hawaii, USARobert Frelinger, CISA, Sun Microsystems Inc., USAKenneth S. Gabriel, CPA, KPMG LLP, USAMichael Garber, CIA, CPA, Motorola Inc., USAJohn Gimpert, CPA, Deloitte & Touche LLP, USAJohn Hainaut, Jefferson Wells, USAHussain Hasan, CISM, CISSP, RSM McGladrey Inc., USAEdward Hill, CIA, CPA, Protiviti, USATara Janos, BP Amoco, USAPeter Koltun, Jefferson Wells, USAPhillip Lageschulte, CPA, KPMG LLP, USAElsa K. Lee, CISA, CISM, CSQA, AdvanSoft International Inc., USAAnthony Noble, CISA, CCP, Viacom Inc., USAHeriot Prentice, MIIA, FIIA, QiCA, The Institute of Internal Auditors, USADebbie Sanneman, Motorola, USASheryl Skolnik, CISA, CISM, CPA, BDO Seidman LLP, USATracy Stewart, CISA, CISSP, CCP, CIA, Allstate Insurance Company, USADoug Underwood, CPA, McGladrey & Pullen, USAMickey Vaja, CISA, CCNA, CISSP, Grant Thornton LLP, USAKenneth Vander Wal, CISA, CPA, CSP, Ernst & Young LLP, USATimothy Van Ryzin, CISA, CISM, Harley-Davidson, USAJeffrey Ward, CISA, CPA, CITP, Stone Carlie & Company LLC, USAMargaret Yocher, United Technologies-Carrier, USAPaul Zonneveld, CISA, CA, Deloitte & Touche LLP, Canada

AcknowledgmentsThe ITGI Board of TrusteesEverett C. Johnson, CPA, Deloitte & Touche LLP (retired), USA,International PresidentGeorges Ataya, CISA, CISM, CISSP, Solvay Business School, Belgium,Vice PresidentWilliam C. Boni, CISM, Motorola, USA, Vice PresidentLucio Augusto Molina Focazzio, CISA, Colombia, Vice PresidentAvinash Kadam, CISA, CISM, CBCP, CISSP, Miel e-Security Pvt. Ltd.,India, Vice PresidentJean-Louis Leignel, MAGE Conseil, France, Vice PresidentHoward Nicholson, CISA, City of Salisbury, Australia, Vice PresidentFrank Yam, CISA, CIA, CCP, CFE, CFSA, FFA, FHKCS, FHKIoD, FocusStrategic Group, Hong Kong, Vice PresidentMarios Damianides, CISA, CISM, CA, CPA, Ernst & Young LLP, USA, PastInternational President,Robert S. Roussey, CPA, University of Southern California, USA, PastInternational PresidentRonald Saull, CSP, The Great-West Life and IGM Financial, Canada, TrusteeThe IT Governance CommitteeWilliam C. Boni, CISM, Motorola, USA, ChairMax Blecher, Virtual Alliance, South AfricaSushil Chatterji, SingaporeTony Hayes, FCPA, Queensland Government, AustraliaAnil Jogani, CISA, FCA, Tally Solutions Limited, UKJohn W. Lainhart IV, CISA, CISM, IBM, USARomulo Lomparte, CISA, Banco de Credito BCP, PeruMichael Schirmbrand, Ph.D., CISA, CISM, CPA, KPMG LLP, AustriaRonald Saull, CSP, Great-West Life Assurance and IGM Financial, CanadaThe COBIT Steering CommitteeRoger Stephen Debreceny, Ph.D., FCPA, University of Hawaii, USA, ChairGary S. Baker, CA, Deloitte & Touche, CanadaRafael Eduardo Fabius, CISA, Republica AFAP, S.A., UruguayUrs Fischer, CISA, CIA, CPA (Swiss), Swiss Life, SwitzerlandErik Guldentops, CISA, CISM, University of Antwerp Management School,BelgiumJimmy Heschl, CISA, CISM, KPMG, AustriaDebbie A. Lew, CISA, Ernst & Young LLP, USAMaxwell J. Shanahan, CISA, FCPA, Max Shanahan & Associates, AustraliaDirk E. Steuperaert, CISA, PricewaterhouseCoopers LLC, BelgiumRobert Ernest Stroud, CA Inc., USA5

6IT Control Objectives for Sarbanes-Oxley, 2nd EditionThe ITGI Advisory PanelRonald Saull, CSP, Great-West Life Assurance and IGM Financial, Canada,ChairRoland Bader, F. Hoffmann-La Roche AG, SwitzerlandLinda Betz, IBM Corporation, USAJean-Pierre Corniou, Renault, FranceRob Clyde, CISM, Symantec, USARichard Granger, NHS Connecting for Health, UKHoward Schmidt, CISM, R&H Security Consulting LLC, USAAlex Siow Yuen Khong, StarHub Ltd., SingaporeAmit Yoran, Yoran Associates, USAThe ITGI Affiliates and SponsorsISACA chaptersAmerican Institute for Certified Public AccountantsASIS InternationalThe Center for Internet SecurityCommonwealth Association of Corporate GovernanceInformation Security ForumThe Information Systems Security AssociationInstitut de la Gouvernance des Systèmes d’InformationInstitute of Management AccountantsISACAITGI JapanSolvay Business SchoolUniversity of Antwerp Management SchoolAldion Consulting Pte. Ltd.CAHewlett-PackardIBMLogLogic Inc.Phoenix Business and Systems Process Inc.Symantec CorporationWolcott Systems GroupWorld Pass IT Solutions

Table of ContentsTable of ContentsEXECUTIVE SUMMARY .9Compliance and IT Governance .9Enhancements to the Publication With the Second Edition .9Considerations for Smaller Companies.10Alignment With PCAOB and COBIT.11Using This Publication.11THE FOUNDATION FOR RELIABLEFINANCIAL REPORTING.12A Need for IT Control Guidance.12Where to Find IT Controls.12Information Technology Controls—A Unique Challenge .13PCAOB Guidance for IT Controls .15Controls Over IT Systems .15MANAGING THE HUMAN ELEMENT OF CHANGE.19Committing to Change .19Assessing the Current State .19Overcoming the Obstacles.20SETTING THE GROUND RULES.22COSO Defined .22Applying COSO to IT.22IT COMPLIANCE ROAD MAP .27Sarbanes-Oxley Compliance.27APPENDIX A—SARBANES-OXLEY PRIMER .46Background .46Sarbanes-Oxley—Enhancing Corporate Accountability .46Auditing Internal Control Over Financial Reporting.47Specific Management Requirements of the Sarbanes-Oxley Act .48Section 302 Management Requirements.50Section 404 Management Requirements.51Auditor Focus Under Sarbanes-Oxley.527

8IT Control Objectives for Sarbanes-Oxley, 2nd EditionAPPENDIX B—COSO AND COBIT.54APPENDIX C—IT GENERAL CONTROLS .57Entity-level IT Controls .57Activity-level IT Controls.60APPENDIX D—APPLICATION CONTROLS.82The Importance of Application Controls.82Defining Application Controls .82The Business Case for Application Controls .83Establishing the Application Benchmark .85Examples of Automated Application Controls .86APPENDIX E—SAMPLE APPLICATION ANDTECHNOLOGY LAYERS INVENTORY .97APPENDIX F—PROJECT ESTIMATING TOOL .98APPENDIX G—INHERENT RISK ASSESSMENT ANDCONTROL PRIORITIZATION GRID .99Risk Assessment Considerations .99Information Technology Risk Assessment .100Recommendations on Where Controls Should Be Considered.101APPENDIX H—SAMPLE CONTROL DOCUMENTATIONAND TESTING TEMPLATE .102APPENDIX I—SAMPLE DEFICIENCY EVALUATIONDECISION TREE .103APPENDIX J—SAMPLE APPROACH FOR SPREADSHEETS .104APPENDIX K—LESSONS LEARNED .107APPENDIX L—ISSUES IN USING SAS 70EXAMINATION REPORTS .114Scope .114Description of Controls.115Timing .116Nature and Extent of Testing .117Qualifications and Exceptions.119Service Auditor .120APPENDIX M—SEGREGATION OF DUTIES INSIGNIFICANT ACCOUNTINGAPPLICATIONS .121APPENDIX N—LIST OF FIGURES .125REFERENCES.127

Executive SummaryExecutive SummaryIn April 2004, the IT Governance Institute issued IT Control Objectives forSarbanes-Oxley to help companies assess and enhance their internal controlsystems. Since that time, the publication has been used by companies aroundthe world as a tool for evaluating information technology controls in supportof Sarbanes-Oxley compliance.Compliance and IT GovernanceThere is no such thing as a risk-free environment, and compliance with theSarbanes-Oxley Act does not create such an environment. However, theprocess that most organizations will follow to enhance their system ofinternal control to conform to the Sarbanes-Oxley Act is likely to providelasting benefits. Good IT governance over planning and life cycle controlobjectives should result in more accurate and timely financial reporting.The work required to meet the requirements of the Sarbanes-Oxley Actshould not be regarded as a compliance process, but rather as an opportunityto establish strong governance models designed to result in accountabilityand responsiveness to business requirements. Building a strong internalcontrol program within IT can help to: Gain competitive advantage through more efficient and effective operations Enhance risk management competencies and prioritization of initiatives Enhance overall IT governance Enhance the understanding of IT among executives Optimize operations with an integrated approach to security, availabilityand processing integrity Enable better business decisions by providing higher-quality, moretimely information Contribute to the compliance of other regulatory requirements, such as privacy Align project initiatives with business requirements Prevent loss of intellectual assets and the possibility of system breachEnhancements to the Publication With the Second EditionMany lessons have been learned with respect to financial reporting and ITcontrols since the publication was issued—most significantly, the need totake a top-down, risk-based approach in Sarbanes-Oxley complianceprograms to help ensure that sufficient and appropriate attention is given toareas of highest risk.As a result, ITGI has revised the publication to provide additional IT guidanceon areas of greater importance to internal control over financial reporting, aswell as to share lessons learned regarding IT compliance with SarbanesOxley. The second edition was exposed publicly for a 60-day period, andcomments received were addressed through revisions in this final publication.9

10IT Control Objectives for Sarbanes-Oxley, 2nd EditionWhile much has been learned since the initial release of the publication, thefundamental guidance provided in April 2004 is sound. The purpose ofenhancing the publication is to share lessons learned from companies andprovide additional guidance on how to improve the efficiency andeffectiveness of compliance using a risk-based approach. A summary ofenhancements to the publication follows: Enhanced focus on scoping and risk assessment—Guidance has beenadded to assist companies in applying a top-down, risk-based approach. Inparticular, guidance has been added to assist in performing an IT riskassessment for Sarbanes-Oxley. Prioritization of controls—Guidance has been added to assist companiesin defining “relevant controls.” Using this guidance, certain controlsin appendix C, IT General Controls, have been identified as mostrelevant controls. Managing the human element of change—Insights into cultural and peoplemanagement issues have been added to highlight the human factors thatneed to be considered when complying with Sarbanes-Oxley. Enhanced guidance on application controls—Guidance has been added toassist companies in identifying and addressing various types of applicationcontrols and providing a business case for using application controls. Approach for spreadsheets—Guidance has been added to assist companiesin addressing spreadsheets, including best practices for controls. Simplification of the readiness road map—Changes have been made to thereadiness road map to simplify the process. Cross-reference to COBIT 4.0 processes Lessons learned—A summary of lessons learned has been added to sharethe compliance experiences of companies worldwide, including steps toconsider in realizing benefits or avoiding common pitfalls. Issues in and approach for using SAS 70 examination reports Enhanced guidance on segregation of duties for significant applicationsConsiderations for Smaller CompaniesIn July 2006, the Committee of Sponsoring Organizations of the TreadwayCommission (COSO) issued Guidance for Smaller Public CompaniesReporting on Internal Control Over Financial Reporting. The COSOpublication highlighted the challenges faced by smaller companies incomplying with regulations such as Sarbanes-Oxley and provided suggestionsto address these challenges.Smaller companies may also find it difficult to address the IT controlconsiderations that are expected under Sarbanes-Oxley. Therefore, it isimportant not to take a one-size-fits-all strategy, but instead to take a riskbased approach and implement only those IT controls that are necessary andrelevant in the circumstances. For instance, smaller companies often userelatively simple off-the-shelf (OTS) financial applications rather than large,customizable enterprise resource planning (ERP) systems. In such cases, therisk of financial statement errors resulting from the application is typically

Executive Summaryless than that of a larger, more complex system. Accordingly, the nature andextent of controls required for the smaller company should be less than thoseof the larger company. While there are always exceptions to the rule, smallercompanies should carefully assess their risks and implement only thecontrols that are necessary. To assist in this regard, enhancements have beenmade to the risk assessment guidance provided in this publication.Alignment With PCAOB and COBITIn all, 12 IT control objectives, which align to the PCAOB Auditing StandardNo. 2 and Control Objectives for Information and related Technology(COBIT ), were defined for Sarbanes-Oxley. Figure 1 provides a high-levelmapping of the IT control objectives for Sarbanes-Oxley described inthis document, IT general controls identified by the PCAOB and theCOBIT 4.0 processes.Figure 1—Mapping to PCAOB and COBITProgramChangesComputerOperationsAccess toProgramsand DataIT Control Objectives for Sarbanes-Oxley1. Acquire and maintain application software. AI22. Acquire and maintain technologyAI3infrastructure.3. Enable operations.AI44. Install and accredit solutions and changes. AI75. Manage changes.AI66. Define and manage service levels.DS17. Manage third-party services.DS28. Ensure systems security.DS59. Manage the configuration.DS910. Manage problems and incidents.DS8,DS1011. Manage data.DS1112. Manage the physical environmentDS12,and operations.DS13PCAOB IT General ControlsProgramDevelopmentMapping toCOBIT 4.0ProcessesCOBIT Using This PublicationThe information contained in this document provides useful guidance andtools for companies trying to prepare and sustain their IT organizationsrelative to Sarbanes-Oxley compliance. However, each organization shouldcarefully consider the appropriate IT control objectives necessary for itsown circumstances. Organizations may choose not to include all thecontrol objectives discussed in this document, and, similarly, they maychoose to include others not discussed in this document. In either case, itis expected that changes to the description of control objectives, illustrativecontrols and illustrative tests of controls provided in this document will benecessary to reflect the specific circumstances of each organization.11

12IT Control Objectives for Sarbanes-Oxley, 2nd EditionThe Foundation for Reliable Financial ReportingA Need for IT Control GuidanceIn today’s environment, financial reporting processes are driven by ITsystems. Such systems, whether ERP or otherwise, are deeply integrated ininitiating, authorizing, recording, processing and reporting financialtransactions. As such, they are inextricably linked to the overall financialreporting process and need to be assessed, along with other importantprocesses, for compliance with the Sarbanes-Oxley Act.Much has been written on the importance of the Sarbanes-Oxley Act andinternal controls in general; however, little exists on the significant role thatinformation technology plays in this area. For instance, the Sarbanes-OxleyAct requires organizations to select and implement a suitable internal controlframework. COSO’s Internal Control—Integrated Framework has becomethe most commonly used framework by companies complying withSarbanes-Oxley; however, COSO does not provide a great deal of guidanceto assist companies in the design and implementation of IT controls.As a result, organizations need guidance to address IT components asthey relate to the overall financial reporting compliance program. Thisdocument is intended to assist in this regard, using relevant SEC, PCAOBCOSO, and COBIT content. See appendix B for further discussion aboutCOSO and COBIT.Where to Find IT ControlsIn understanding where IT controls exist within the typical company,consideration of at least three elements should be given: executivemanagement, business process and IT services.Figure 2 illustrates the common elements of organizations.Executive ManagementBusiness ProcessIT ServicesExecutive managementestablishes and incorporatesstrategy into businessactivities. At the enterprise orentity level, businessobjectives are set, policies areestablished, and decisions aremade on how to deploy andmanage the resources of theorganization. From an ITperspective, policies andother enterprisewideguidelines are set andcommunicated throughoutthe organization.Business processes are theorganization’s mechanism ofcreating and delivering valueto its stakeholders. Inputs,processing and outputs arefunctions of businessprocesses. Increasingly,business processes arebeing automated andintegrated with complex andhighly efficient IT systems.IT services form thefoundation for operations andare provided across theorganization, rather thansegregated by businessprocess or business unit. ITservices commonly includenetwork management,database management,operating systemmanagement, storagemanagement, facilitiesmanagement and securityadministration, and are oftenmanaged by a central ITfunction.

The Foundation for Reliable Financial ReportingMore and more, IT systems are automating business processes. In doing so,these systems often replace manual control activities with automated or ITdependent control activities. As a result, compliance programs need toconsider system-based controls to keep pace with changes in businessprocesses and new system functionality.Figure 2—Common Elements of OrganizationsEntity-levelControlsApplication ControlsControls embedded within business processapplications directly support financial controlobjectives. Such controls can be found in mostfinancial applications including large systemssuch as SAP and Oracle as well as smallerOTS systems such as ACCPAC.Etc.Business ProcessLogisticsBusiness ProcessManufacturingFinanceBusiness ProcessExecutiveManagementBusiness ProcessEntity-level controls setthe tone and culture ofthe organization.IT entity-levelcontrols are partof a company’soverall controlenvironment.Controls include: Strategies and plans Policies and procedures Risk assessmentactivitiesIT Services Training and education OS/Data/Telecom/Continuity/Networks Quality assurance Internal auditIT General ControlsControl objectives/assertions include: Completeness Accuracy Existence/authorization Presentation/disclosureControls embedded within IT processesthat provide a reliable operatingenvironment and support the effectiveoperation of application controlsControls include: Program development Program changes Access to programs and data Computer operationsInformation Technology Controls—A Unique ChallengeThe Sarbanes-Oxley Act makes corporate executives explicitly responsiblefor establishing, evaluating and monitoring the effectiveness of internalcontrol over financial reporting. For most organizations, the role of IT iscrucial to achieving this objective. Whether through a unified ERP system ora disparate collection of operational and financial management softwareapplications, IT is the foundation of an effective system of internal controlover financial reporting.Yet, this situation creates a unique challenge: many of the IT professionalsbeing held accountable for the quality and integrity of information generatedby their IT systems are not well versed in the intricacies of internal control.This is not to suggest that risk is not being managed by IT, but rather that itmay not be formalized or structured in a way required by an organization’smanagement or its auditors.13

14IT Control Objectives for Sarbanes-Oxley, 2nd EditionOrganizations need representation from IT on their Sarbanes-Oxley teams todetermine whether IT monitoring controls, general controls and applicationcontrols exist and support the objectives of the compliance effort. Some ofthe important areas of responsibility for IT include: Understanding the organization’s internal control program and its financialreporting process Mapping the IT environment (IT services and processes) thatsupports internal control and the financial reporting process to thefinancial statements Identifying risks related to these IT systems Designing and implementing controls designed to mitigate the identifiedrisks and monitoring them for continued effectiveness Documenting and testing IT and systems-based controls Ensuring that IT controls are updated and changed as necessary tocorrespond with changes in internal control or financial reporting processes Monitoring IT controls for effective operation over time Participating in the Sarbanes-Oxley project management officeThe SEC regulations that affect the Sarbanes-Oxley Act are undeniablyintricate, and implementation has been both time-consuming and costly. Inproceeding with an IT control program, there are two importantconsiderations that should be taken into account: There is no need to reinvent the wheel; virtually all public companies havesome semblance of IT control. While they may be informal and lackingsufficient documentation of the control and evidence of the controlfunctioning, IT controls generally exist in areas such as security and changemanagement. Many organizations are able to tailor existing IT control processes tocomply with the provisions of the Sarbanes-Oxley Act. Frequently, theconsistency and quality of control documentation and evidential matter arelacking, but the general process is often in place, requiring only somemodification.Performing a thorough review of IT control processes and documenting themas the enterprise moves forward can be a time-consuming task. The reviewof application and IT processes will be driven by the risk of the businessprocesses and environments. Without appropriate knowledge and guidance,organizations run the risk of doing too much or too little. This risk isamplified when those responsible are not experienced in the design andassessment of IT controls or lack the necessary skill or managementstructure to identify and focus on the areas of most significant risk.While some industries, such as financial services, are familiar with stringentregulatory and compliance requirements of public market environments,most are not. To meet the demands of the Sarbanes-Oxley Act, most

The Foundation for Reliable Financial Reportingorganizations are in the process of a change in culture. Enhancements to ITsystems and processes have been required, most notably in the design,documentation, retention of control evidence and evaluation of IT controls.PCAOB Guidance for IT ControlsPCAOB Auditing Standard No. 2 discusses the relationship of IT andinternal control over financial reporting and emphasizes the importance ofidentifying IT controls and testing their design and operational effectiveness.In particular, it states: Controls should be tested, includ

Executive Summary 9 Executive Summary In April 2004, the IT Governance Institute issued IT Control Objectives for Sarbanes-Oxley to help companies assess and enhance their internal control systems. Since that time, the publication has been used by companies around