Fear Not The Software

The spreadsheet: The easiest place for committing financial statement fraud

Please sign in to save this to your favorites.
Date: July 1, 2005
read time: 5 mins

[Some links and figures referenced in this article are no longer be available. —Ed.]

The spreadsheet is one of the most brilliant software tools for almost any industry including accounting and finance. However, because everyone is so comfortable with them, spreadsheets can be excellent tools for committing fraud. Also, they have little to no security in controlling changes within the worksheets. For example, a general ledger in its original form may be secure from misstatements but once exported to Excel for posting an adjusting journal entry all changes can be made without control.

Spreadsheets therefore become the least expected weak link in the financial statement chain. Aside from fraud, they're also ripe ground for errors because of their open nature for change. One improperly copied formula can spell disaster in a spreadsheet that serves as the basis of a month-end journal entry. Examples of such errors and fraud are rampant and have been summarized by the European Spreadsheet Risks Interest Group at the following link: www.eusprig.org/stories.htm. Following are some case highlights:

Begin Your Free 30-Day Trial

Unlock full access to Fraud Magazine and explore in-depth articles on the latest trends in fraud prevention and detection.