Report Links Spreadsheets to Risk of Compliance Failure

A recent survey of financial executives reveals the 92 percent of all public companies use spreadsheets for critical accounting activities in their revenue reporting processes, increasing the likelihood of compliance failures and financial restatements. These findings should be concerning because the risks introduced by spreadsheets go against basic compliance principles.

The report, “Enterprise Systems and Revenue Recognition: The Missing Link”, was sponsored by Softrax Corp. and conducted by and IDC. Results were based on information collected from 685 companies. More than 75 percent of respondents were high-ranking finance executives including: chief financial officers (CFOs), controllers, and senior finance and compliance officers.

When asked to identify the single most important change they would make to improve their revenue accounting processes, the top three answers were:

  • Enhance revenue recognition functionality in financial systems (22 percent)
  • Establish single source of “clean” revenue data (19 percent)
  • Implement business intelligence solution for analyzing revenue (18 percent)

According to the survey, more than half of all companies use spreadsheets to create their revenue accounting entries. Other spreadsheet-based tasks include revenue scheduling, allocation, and redistribution based on accounting guidelines.

Spreadsheets are widely used because key revenue recognition and reporting tasks are still not automated in Financial/ERP systems. Only 8 percent of responding companies report completing their revenue reporting processes without having to take data offline and into spreadsheets. The remaining companies participating in the survey use spreadsheets, which are prone to errors, lack audit capabilities and resist internal controls. Surprisingly, public companies with more than $200 million in revenue are substantially more reliant on spreadsheets for revenue accounting entries than the overall sample.

Even with corporate compliance at stake, there are significant obstacles to overcome in automating revenue reporting processes.

“Revenue recognition processes are dependent upon information from multiple sources and typically cannot be executed in existing systems,” Kathleen Wilhide, Director of Compliance and Business Performance Management (BPM) at IDC, a global provider of market intelligence, advisory services and events for the information technology and telecommunications industries, said in a prepared statement. “What is required is automation across this function which will yield a host of benefits, including: more accurate results, better internal controls, less reliance on uncontrolled spreadsheets, and freeing up time for performance analysis.”

Complete results are available at

You may like these other stories...

A proposal issued by the Governmental Accounting Standards Board (GASB) last week explains how fair value measurement should be defined for state and local government financial reporting.The exposure draft, Fair Value...
By Jason Bramwell The board of trustees of the Financial Accounting Foundation (FAF) finalized a new policy on November 19 that provides the Governmental Accounting Standards Board (GASB) with direction on what...
By Jason Bramwell The Governmental Accounting Standards Board (GASB) is now offering a free online toolkit designed to assist preparers and auditors of state and local government pension plans with implementing new...

Already a member? log in here.

Upcoming CPE Webinars

Oct 30Many Excel users have a love-hate relationship with workbook links.
Nov 5Join CPA thought leader and peer reviewer Rob Cameron and learn ways to improve the outcome of your peer reviews while maximizing the value of your engagement workflow.
Nov 12This webcast presents basic principles of revenue recognition, including new ASU 2014-09 for the contract method. Also, CPAs in industries who want a refresher on revenue accounting standards will benefit.
Nov 18In this session Excel expert David Ringstrom, CPA tackles what to do when bad things happen to good spreadsheets.