Spreadsheets: Auditing & Validating (Part 2)

00_Spreadsheet AuditIn the previous post I mentioned few of the risks associated with spreadsheets. In this post I’ll try to show some excel tools which can help  in detecting errors and frauds in Excel spreadsheets.

In the late 1990’s “Poor control over spreadsheets at Jamaican indigenous banks contributed to management information and external reporting problems (i.e., P&L distortions) that contributed to the banks’ management and external regulators losing sight of the banks’ true positions and exposures. Which led to collapse of entire Jamaican Banking System.

Continue reading

Spreadsheets: Risks (Part 1)

Spreadsheets have stood the test of time because they continue to meet the analytical needs of organizations, especially for analyzing and reporting financial results and providing support for decision-making.

“…spreadsheets will always fill the void between what a business needs today and the formal installed systems…” Mel Glass et al

Continue reading