To any company executive or business owner, the mere possibility of fraud can be enough to send alarm bells ringing – for good reason. In a prolonged recession, the last thing investors would want to discover is a huge, gaping hole where supposedly a neat profit should have been. Also to find out that such loss was brought about by deliberately falsified accounting and poor spreadsheet controls only makes the situation even more regrettable.
Why?
Because these losses would not have occurred had there been a stronger risk management program in place and more stringent quality control on critical data to begin with.
But given the nature of a spreadsheet system i.e. its sheer flexibility and easy accessibility, plus the fact that they were never intended to be enterprise-level tools, there are no hard and fast rules for auditing spreadsheets. Also because of the lack of internal controls for end user computing (EUC) applications, in this case spreadsheets, you can’t expect these systems to yield consistently accurate results.
In fact, most managers assume that major spreadsheet errors should result in figures that are blatantly out of touch with how things stand in the real world, making these errors easily detectable.
Well they assumed wrong. You’ll find cases where the losses ran to millions of dollars without anyone being the wiser.
In instances of fraud, the problem becomes more complicated as these errors are deliberately hidden and cleverly disguised, perhaps one erroneous cell at a time. Even if these cover-ups started out with smaller figures that may have had negligible impact on a company’s operation, the cumulative costs of these “insignificant” errors multiply exponentially as the spreadsheets are reused and utilised as bases for other related reports.
While there is no generally accepted definition of the term “spreadsheet fraud”, its quite easy to identify one when a case crops up. Fraud arising from spreadsheets are typically characterised by:
Fallacious inputs – correct figures are deliberately replaced with false values.
Erroneous outputs owing to data alteration – hyperlinks are linking to the wrong spreadsheets or cells; use of macros or special lines of code which are understandable only to the person who developed the code.
Concealment of critical information – can be done with easy “tweaks” such as hidden rows and columns, using the same colour for both the font and the background, or hard coding additional values into a cell.
There is nothing really highly-sophisticated or technical in any of these methodologies. But without internal spreadsheet controls in place, it would take a discerning eye and a thorough review to catch the inconsistencies contained in a spreadsheet fraught with errors. Also, if these errors are knowingly placed there, the chances of finding them are close to nil.
Learn more about our server application solutions and discover a better way to protect your company from spreadsheet fraud.
More Spreadsheet Blogs
amazon.co.uk
amazon.com
Contact Us
- (+353)(0)1-443-3807 - IRL
- (+44)(0)20-7193-9751 - UK
- How SOA can help Transformation - 17th October 2016
- The Connection between Big Data and MDM - 9th June 2016
- Technology and process improvement - 7th June 2016
[…] Spreadsheet Fraud […]
[…] Copy-paste errors, omission of a negative sign, erroneous inputs, accidental deletions, and even fraudulent manipulations can take place. And because each member can end up with multiple versions of a single spreadsheet, […]
You should take part in a contest for one of the best blogs on the web. I will recommend this web site!
I don’t suppose I’ve never read something like this before. So good to see someone with some authentic thoughts on this subject. I really thank you for starting it. This web site is something that is wanted on the web, someone with just a little originality.
very nice post, i certainly love this website, keep on it
It is highly useful for me. Large thumbs up for this weblog post!
Hello! I just would like to give a huge thumbs up for the great info you have here on this post. I will be coming back to your blog for more soon.
Good article , thanks and we want more! Added to FeedBurner as well
There are some attention-grabbing points in this article but I don’t know if I see all of them center to heart. There may be some validity but I will take maintain an opinion till I look into it further. Good article , thanks and we want more! Added to FeedBurner as well.
I desire to use some of the content material on my blog. Naturally I’ll give you a link on my net blog. Thanks for sharing.
I am often blogging and i really appreciate your content. The article has really peaked my interest. I am going to bookmark your site and keep checking for new information.
I was very pleased to find this website. I wanted to thank you for your time for this wonderful post!! I definitely enjoy reading it and I have you bookmarked to check out new stuff you blog post.
Phen375 reviews…
This is really attention-grabbing, You are a very professional blogger. I have joined your feed and stay up for seeking more of your fantastic post. Also, I’ve shared your site in my social networks! phen375 reviews…
[…] all the spreadsheet disadvantages listed here, this is perhaps the most damaging. Fraudulent manipulations in company Excel files have already resulted in Billion-Dollar losses. The main underlying reason behind this […]
[…] in using them are increasing the risk of loss on those portfolios. Or, they can be opening up opportunities for fraud as Allied Irish Bank (in the case of John Rusnak – $690 million) learned the hard […]
[…] Spreadsheet Fraud […]
[…] Spreadsheet Fraud […]
[…] Less prone to fraud; […]