Discussion Locked

Spreadsheet Risks and Sarbanes-Oxley compliance

0 helpful
8 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

The date for Sarbanes-Oxley compliance is looming. However, not that many companies are aware of the problems of spreadsheet risk and Excel Fraud. In fact, few managers know how the SOX or Sarbox Act relates to their spreadsheet legacy.

I would be interested to hear what your company is doing about the issue.

8 replies

by synthetic

As an admin for an international firm, we have compliance processes in place, and have had for sometime. Do to the sweeping changes, mixed with the broad language that provides little hint of help for getting to compliance, I have to agree with Donavon that few CIO's understand just how they fit into the larger picture of Sarbanes-Oxley. Unless one is a CIO, this is an issues that should be engaged in a very limited basis by technology staff. There is no answer in a pure technology solution, nor should that be a driving concern for most IT staff. I feel that the place for technology personnel in the Sarbox act is to do what they can to understand the affects of this legislation, and think critically how they maybe able to help with the technology related components. The issue is not Excel fraud, the issue (at least how I am reading from the original question, and section 404 of the Sarbox act) is accountable tracking techniques for any ledger, digital or not. This means, from a financial documents inception to it's final disclosure, controls must be in place to account for every step and change this documents goes thorough. Again, while technology will be instrumental in seeing this done, it is not the place, nor should it be, for the CIO or anyone else in technology, to come up with the process and controls for this level of accountability. This is the responsibility of the CFO, as well it should be. Technology staff should not jeopardize their career getting involved with the creation of internal controls that could end with that person in court, reputation ruined, potentially facing costly civil litigation, because of overstepping ones area of expertise. If one feels strongly about playing a part, and this could be a very positive career move, then get familiar with the issue, and take some time to speak casually with your CFO. Find out what steps are being taken, offer advise only on areas you know, area of implementation, and the technological hurdles that might be faced. This will show your commitment to your company, your knowledge and concern, and above all, keep it doing what it knows instead of involving staff and personalities in would most likely end in tragedy (honestly, do you want your CFO crating the asset tracking process for you? how about the guys in accounting creating the processes for administration of your back-up?). Have a great day!

by synthetic

Questions You Need to Be Able to Answer

Cap Gemini Ernst & Young auditors will ask CIOs the following questions in order to guage their companies' compliance with the Sarbanes-Oxley Act. Would you have the answers?

How are off-balance-sheet transactions and commitments tracked and reported?

Are payments to the external auditing firm monitored through the transactional flags on purchase orders, check requests, or other means within the system?

Are rolling forecast deployed throughout the business (business unit, product line, functional levels)?

How many tools are used in the forecasting process? The budgeting process?

Do the reporting systems trace back to the general ledgers?

Is cash flow from operations and generally accepted accounting principles (GAAP) cash flow automatically calculated?

Are key measures (drivers of financial results) delivered to operational managers? desktops daily, weekly, monthly?

Are tax reporting systems integrated with the company's consolidation system?

Are consolidation and reporting activities performed on spreadsheets?

Do transactional reporting systems have agent-based alerts?

How are manual entries identified and approved?

How much time is spent compiling data and the financial statements versus analyzing the data?

How many top-level adjustments are made in the consolidation process?

Are reporting activities performed on spreadsheets?

How often is control documentation updated for new changes to the internal controls (transactional and financial statement)?

Are controls in place to ensure that any off-balance-sheet items are properly approved?

Do reporting systems flag reserves and other estimated accounts?

Have the systems been updated to identify new responsibilities under the Sarbanes-Oxley Act?

Are earnings forecast tied to predictive models?

Do you forecast your business on cash flow drivers?

Are variance between the forecast and actual results reviewed and causes identified?

How long is the process to develop forecasts? Budgets?

Is there a significant difference between financial statements depending on timing, function or system?

Are standard chart of accounts used across the company?

How long does it take the company to get the results of operations?

What procedures are in place by the company to detect and prevent fraud?

Has the company identify high risk areas where fraud may occur and developed controls to prevent this from occurring?

Are the following categories of non-financial drivers measured? Leadership, communication, brand equity, reputation, networks/alliances, technology, human capital, culture, innovation, intellectual capital or adaptability.

Do sales systems flag quarter end sales volumes over selected limits?

How long does it take to develop ad hoc reports?

Do you model the sensitivity of your off-balance-sheet commitments (swap agreements, foreign exchange risk, purchase commitments, etc.)? How often?

Does the company have the ability to determine the profitability by using "what if" scenarios?

Have financial models been created for all high-risk operations, programs, etc.?

How long does it take to create the management package?

Does each operating unit have a financial model for the key drivers of their business?

Are documents backed up periodically to ensure significant reports and information are maintained?

Does the company have a retention policy for electronic information?

Are internal control reviews incorporated into all new system implementations (financial and non-financial)?

How often do you back up your data?

What controls are in place over record retention to avoid tampering with the data?

What best describes your IT capabilities related to financial transaction processing in your company?

How many control weakness/changes have there been to the financial statements controls (including in the authorization of transactions, safeguarding assets, maintaining records and over the reconciliation process) in the past year?

How many different systems are involved in the financial statement development process?

Are IRS and other data retention requirement being met?

Is your starting point for your tax return GAAP audited financial statements?

Are there flags in place to alert key resources of specific transactions taking place in the company?

Does the company review its transactions for unusual entries?

What controls are in place to detect wire/mail fraud?

by marco schumacher (at biznesslegion)

You may want to start from a few top-level ideas that apply to all compliance issues and that can help organize your analysis and remedial action.

What does it mean to control information? It can be summarized in principles like the following:
- Security: you protect the information when it enters and leaves your record keeping system.
- Redundancy: you store the information in various forms and locations.

This is what we recommed to the companies whom we help to manage their information assets.

by bob

PWC published a paper in July 2004 concerning Spreadsheets and Considerations for Section 404 of SOX. My interpretation is that you need a set of tools to gain compliance: 1) inventory, 2)analysis, and 3) control. So far, I have selected SCANXLS.xls for the inventory, Spreadsheet Detective for analysis, and strongly looking at eInfotree from CIMCON for control. I would be very interested in what others are doing.

Thank You
Bob Tuttle

by derek.wimmer

You also might want to look at Spreadsheet Professional software for design controls. We also have the leading Excel compliance solution (we were the first to come out with this type of product, before Cimcon and Scientific Software,) at www.wimmersystems.com. Also have a website at www.spreadsheetsox.com devoted to SOX issues for spreadsheets.

by eperry

Scientific Software provides a Sarbanes-Oxley solution for Microsoft Excel financial spreadsheet remediation that provides many of the key controls recommended by the PWC white paper - access control, version control, cell-by-cell audit trail, cell locking based on access control privileges, visual comparision of changes between versions, lock-out of Excel macros/menue items and hot keys for lower level users. It's all based on a secure content management repository that can also automate review and approvals via workflow and apply retention policies to the spreadsheets per SOX guidelines.

Check it out at http://www.scisw.com/solutions_new/sox/index3.htm

by pobeirne

There's a low-cost utility available at

[url]http://www.sysmod.com/scanxls.htm[/url]

that can collect data on what spreadsheets are where, and provide some metrics on their complexity and incidence of errors.

by techrepublic

Check out myCMDB.com

myCMDB allows you to inventory your equipment (online system and software scanner), report on it and does all that without having to install software or hire consultants.

myCMDB is a turn key business application which is targeted to address this problem.

This discussion is closed to new replies.