Archive for June, 2009

Protiviti Says Unchecked Spreadsheets Can Lead to Major Accounting & Financial Reporting Problems

Yesterday Protiviti issued a press release and an update to their white paper entitled Spreadsheet Risk Management: Frequently Asked Questions. In the press release, Protiviti indicated that few organizations have properly addressed the risks associated with uncontrolled spreadsheets, but are now being forced to due to potential financial losses due to errors and fraud, regulatory pressures, and increasing scrutiny from auditors.

The white paper examines the risks associated with uncontrolled spreadsheets and EUCs, cites various cases of error and fraud, presents a framework for spreadsheet control, best practices for measuring risk, and a review of available technologies.

While the white paper is spot on for the type of information companies need now – how to get started, practical advice, frameworks, best practices – it is light on promoting technology. The main goal of any spreadsheet or EUC control initiative should be to embed the controls into everyday business processes and to make them sustainable. This cannot be achieved via manual processes and policies alone. It has to be driven by technology and automated controls.

You can view the press release here and the download the FAQ white paper here.

Enjoy, and please let me know your thoughts!

Spreadsheet Errors and M&A Transactions – A Risky Proposition

diceComplex spreadsheets have been used extensively in mergers and acquisitions. Although spreadsheets can provide rapid and immediate results to speed due diligence efforts, the potential for error is high and left undiscovered such errors can lead to disastrous results.

We saw an example of this last year during the Lehman fire sale when a complex spreadsheet containing hidden data for 179 contracts went undetected in a spreadsheet, causing Barclays to acquire more assets in the deal. Due to the tight timelines to complete the transaction before a bankruptcy court dealine, the spreadsheet was converted to PDF and the unwanted contracts (apparently in a hidden worksheet tab) were included in the deal.

To avoid this type of risk, organizations relying on spreadsheets for M&A activity should ensure they are inventoried, managed in a controlled environment with access control, versioning and audit trails, and finally analyzed for errors using diagnotic tools prior to the close of the deal. For more information on technology to satisfy these needs, check out www.prodiance.com.

The complete details of the Lehman-Barclays story are in this PC World article.

EuSpRIG to Host 2009 Conference on Spreadsheet Risk in Paris

European Spreadsheet Risks Interest Group

European Spreadsheet Risks Interest Group

This week the European Spreadsheet Risks Interest Group (EuSpRIG) announced it will hold its annual conference entitled The Role of Spreadsheets in Organisational Excellence”on July 2-3, 2009 at the Ecole Normale Supérieure de Cachan, Paris, France.

This event attracts spreadsheet researchers, practitioners, trainers, vendors, consultants and auditors and boasts on best practices for spreadsheet development and risk management.

Read the full story here.

New Deloitte Podcast Highlights Uncontrolled Spreadsheets as a Key IT Concern

This new podcast entitled Balancing Act – A Risk Management Solution for Spreadsheets by Sarah Adams and Tim Burdick of Deloitte urges companies to establish an effective risk management program for critical spreadsheets. It includes best practices on conducting an inventory, risk ranking, when conversion (into an IT application) is required, baselining, required preventive and detective controls, and business benefits of establishing an effective spreadsheet and EUC management framework.

View the podcast here


Add to Technorati Favorites

Prodiance on Twitter