No Result
View All Result
SUBSCRIBE | NO FEES, NO PAYWALLS
MANAGE MY SUBSCRIPTION
NEWSLETTER
Corporate Compliance Insights
  • Home
  • About
    • About CCI
    • CCI Magazine
    • Writing for CCI
    • Career Connection
    • NEW: CCI Press – Book Publishing
    • Advertise With Us
  • Explore Topics
    • See All Articles
    • Compliance
    • Ethics
    • Risk
    • FCPA
    • Governance
    • Fraud
    • Internal Audit
    • HR Compliance
    • Cybersecurity
    • Data Privacy
    • Financial Services
    • Well-Being at Work
    • Leadership and Career
    • Opinion
  • Vendor News
  • Library
    • Download Whitepapers & Reports
    • Download eBooks
    • New: Living Your Best Compliance Life by Mary Shirley
    • New: Ethics and Compliance for Humans by Adam Balfour
    • 2021: Raise Your Game, Not Your Voice by Lentini-Walker & Tschida
    • CCI Press & Compliance Bookshelf
  • Podcasts
    • Great Women in Compliance
    • Unless: The Podcast (Hemma Lomax)
  • Research
  • Webinars
  • Events
  • Subscribe
Jump to a Section
  • At the Office
    • Ethics
    • HR Compliance
    • Leadership & Career
    • Well-Being at Work
  • Compliance & Risk
    • Compliance
    • FCPA
    • Fraud
    • Risk
  • Finserv & Audit
    • Financial Services
    • Internal Audit
  • Governance
    • ESG
    • Getting Governance Right
  • Infosec
    • Cybersecurity
    • Data Privacy
  • Opinion
    • Adam Balfour
    • Jim DeLoach
    • Mary Shirley
    • Yan Tougas
No Result
View All Result
Corporate Compliance Insights

Stopping Spreadsheet Fraud

by Diane Robinette
June 15, 2016
in Uncategorized
The risk of accounting fraud is real – do you know how to prevent it?

Last fall, Microsoft Excel celebrated its 30th anniversary – a miraculous feat considering the industry has endured rumor after rumor of its pending demise for the past 10 plus years. While many financial applications have been launched touting their ability to “rid companies of error-prone spreadsheets,” it seems we are no closer to finding a better alternative.

Excel spreadsheets have stood the test of time because they continue to meet the analytical needs of companies today, especially for analyzing and reporting financial results and providing evidentiary support for decision-making. There is no waiting for IT to make changes to systems.  There are no workarounds necessary and no compromises. For complex calculations that require the use of cell functions and where data is continually changing, Excel is often the go-to tool to get the job done. Spreadsheets are used for budgeting, forecasting, financial reporting, determining tax computations, operational analysis and much more. Unfortunately, spreadsheets are also one of the easiest places to commit fraud.

Hidden Data Dangers

Countless news stories have appeared over the years revealing how easy it is to manipulate spreadsheets. With just a few tweaks, spreadsheet data can be deliberately hidden or cleverly disguised, making it is easy for unscrupulous employees to manipulate spreadsheets for personal gain. On a larger scale, spreadsheet fraud also can make a company appear to be worth more much more than it is.

Without internal spreadsheet controls in place, changes easily can be made and data hidden without anyone being the wiser. For example, when formatting and organizing spreadsheets, it is common practice to insert a blank column for the purpose of creating a gap between results. A row or column can be shrunk to five pixels, making it easy to overlook. The problem is, no matter how small the “blank” cell may appear, it is a real cell. Therefore, if a value is inadvertently or intentionally hidden within this cell, it will still be included in the calculations.

Another common way to hide data is by merging cells. Cells are typically merged to make a spreadsheet easier to read and to eliminate clutter. A user may also merge cells to hide irrelevant or sensitive data. While the ability to merge cells was intended to help users, it quickly can become a way to hide data from unsuspecting eyes. One of the most high-profile examples of the dangers associated with merged cells is the Lehman Brothers Holdings/Barclays Capital case, the largest bankruptcy case in U.S. history. Contracts that had been marked as “hidden” in the spreadsheet when received by the law firm were added to the purchase offer during the reformatting process, according to the motion. Those contracts weren’t supposed to be part of the deal. While this instance was a case of human error, it clearly demonstrates the risks associated with hidden cells (and how easy it is to hide data).

Another very basic, yet effective way to hide data is by manipulating font color. Data can be hidden in plain sight simply by changing the font color to the same color as the background of the cells. A more complex way to hide data is misrepresenting something that appears to be a number when it is actually formatted as text. When something is formatted as text, a formula will not look at it; therefore, it will be omitted from the calculation.

Fortunately, advances in technology are making it harder to hide data, thus significantly reducing risk and exposure for organizations.

The Benefits of Technology

Spreadsheets alone are not perfect. As discussed, by themselves they provide little to no protection against data corruption and no way to validate numbers or check errors, nor do they offer the transparency businesses require today. Simply double-checking numbers will not cut it, especially when there are so many ways to hide or misrepresent data. However, when combined with spreadsheet management technology, errors and fraudulent activities can be significantly reduced, and, in many instances, completely eliminated. Unfortunately, most organizations do not utilize spreadsheet management solutions merely because they are unaware this technology exists.

Taking a methodical approach to understanding where risks may hide is the first step in managing spreadsheets across an organization. Spreadsheet management solutions offer detailed insight into spreadsheets, regardless of where they reside on a network or how many exist. These solutions provide visibility into who is working on a file, how many people are working on it, when something changes, what changed and who made those changes. The ability to monitor and track this information over a period of time provides valuable insight into whether policies are being followed while making it significantly easier for accountants to identify potential risks.

For even greater transparency and risk management, many spreadsheet management solutions will allow threshold alerts to be set if certain changes occur to key numbers such as commission percentages or diluted shares. These red flag-type alerts can be customized to meet particular criteria and can be as basic or detailed as necessary. Thresholds also can be set to alert accountants to disparate currency and tax changes; this information is especially useful when dealing with global mergers and acquisitions. Threshold alerts serve as automated checks and balances to ensure inaccuracies are not missed.

Spreadsheet management technology that offers automated detection capabilities makes it easy to locate hidden and misrepresented data within spreadsheets so that fraudulent activity is not overlooked. The ability to identify rows and columns that are significantly reduced in size and merged cell activity will ensure nothing is missed.

It’s time organizations stop putting themselves at risk by using Excel in a silo. Automated risk and analysis solutions provide the necessary control and insight into potential risk and errors that may be hiding in spreadsheets. With the right technology in place, fraudulent behavior can be stopped before it damages your company and your reputation.


Previous Post

How Boards of Directors Really Feel About Cybersecurity Reports

Next Post

Rethinking FCPA Due Diligence in a Hyper-Transparent Environment

Diane Robinette

Diane Robinette

June 15 - Diane Robinette headshotDiane Robinette is president and CEO of Incisive Software, a provider of innovative risk intelligence spreadsheet management solutions. She has more than 20 years of experience in strategic planning, marketing, product management, business operations and management. Diane has worked in companies from startups to large enterprises in various industries including high-tech, aerospace and defense, telecommunications, financial services and transportation.

Related Posts

robot nurturing a good idea

Innovation vs. Compliance: In the Age of AI, Why Not Both?

by Asha Palmer
June 17, 2025

As governments scramble to regulate AI, forward-thinking companies are writing their own compliance playbooks

human robot working as team pie chart

Smart Machines, Smarter Humans: Why Compliance Still Needs a Human Touch

by Roman Eloshvili
June 17, 2025

From the 2008 financial crisis to everyday judgment calls, the case for keeping humans in the compliance loop

data privacy leader concept

Who’s Minding Your Data? The Case for Dedicated Privacy Leadership

by Daniel Barber
June 16, 2025

As state privacy laws multiply and AI introduces new vulnerabilities, the question isn't whether you need dedicated privacy expertise —...

abstract obscured data colorful

NIST’s Differential Privacy Guidelines: 6 Critical Areas for Secure Implementation

by Michelle Drolet
June 16, 2025

Standard de-identification methods remain vulnerable to sophisticated attacks, but differential privacy offers mathematical guarantees that scale with emerging threats

Next Post
Measuring ethics and integrity to mitigate third-party risk and ensure FCPA compliance

Rethinking FCPA Due Diligence in a Hyper-Transparent Environment

No Result
View All Result

Privacy Policy | AI Policy

Founded in 2010, CCI is the web’s premier global independent news source for compliance, ethics, risk and information security. 

Got a news tip? Get in touch. Want a weekly round-up in your inbox? Sign up for free. No subscription fees, no paywalls. 

Follow Us

Browse Topics:

  • CCI Press
  • Compliance
  • Compliance Podcasts
  • Cybersecurity
  • Data Privacy
  • eBooks Published by CCI
  • Ethics
  • FCPA
  • Featured
  • Financial Services
  • Fraud
  • Governance
  • GRC Vendor News
  • HR Compliance
  • Internal Audit
  • Leadership and Career
  • On Demand Webinars
  • Opinion
  • Research
  • Resource Library
  • Risk
  • Uncategorized
  • Videos
  • Webinars
  • Well-Being
  • Whitepapers

© 2025 Corporate Compliance Insights

Welcome to CCI. This site uses cookies. Please click OK to accept. Privacy Policy
Cookie settingsACCEPT
Manage consent

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. These cookies ensure basic functionalities and security features of the website, anonymously.
CookieDurationDescription
cookielawinfo-checbox-analytics11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics".
cookielawinfo-checbox-functional11 monthsThe cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional".
cookielawinfo-checbox-others11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other.
cookielawinfo-checkbox-necessary11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary".
cookielawinfo-checkbox-performance11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance".
viewed_cookie_policy11 monthsThe cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data.
Functional
Functional cookies help to perform certain functionalities like sharing the content of the website on social media platforms, collect feedbacks, and other third-party features.
Performance
Performance cookies are used to understand and analyze the key performance indexes of the website which helps in delivering a better user experience for the visitors.
Analytics
Analytical cookies are used to understand how visitors interact with the website. These cookies help provide information on metrics the number of visitors, bounce rate, traffic source, etc.
Advertisement
Advertisement cookies are used to provide visitors with relevant ads and marketing campaigns. These cookies track visitors across websites and collect information to provide customized ads.
Others
Other uncategorized cookies are those that are being analyzed and have not been classified into a category as yet.
SAVE & ACCEPT
No Result
View All Result
  • Home
  • About
    • About CCI
    • CCI Magazine
    • Writing for CCI
    • Career Connection
    • NEW: CCI Press – Book Publishing
    • Advertise With Us
  • Explore Topics
    • See All Articles
    • Compliance
    • Ethics
    • Risk
    • FCPA
    • Governance
    • Fraud
    • Internal Audit
    • HR Compliance
    • Cybersecurity
    • Data Privacy
    • Financial Services
    • Well-Being at Work
    • Leadership and Career
    • Opinion
  • Vendor News
  • Library
    • Download Whitepapers & Reports
    • Download eBooks
    • New: Living Your Best Compliance Life by Mary Shirley
    • New: Ethics and Compliance for Humans by Adam Balfour
    • 2021: Raise Your Game, Not Your Voice by Lentini-Walker & Tschida
    • CCI Press & Compliance Bookshelf
  • Podcasts
    • Great Women in Compliance
    • Unless: The Podcast (Hemma Lomax)
  • Research
  • Webinars
  • Events
  • Subscribe

© 2025 Corporate Compliance Insights