EXCEL NOT CUTTING IT FOR AUDITS

Are you still creating financial statements in Excel? You’re not alone. Excel is one of the most utilized spreadsheet applications in the business world–but it is often being used for tasks it wasn’t designed for.

Excel’s greatest strength is its simplicity in creating and editing spreadsheets. This is also its biggest drawback. In the current age of stringent audits, a CFO, Accountant or even a Bookkeeper can be required to certify that final financials are accurate. Using Excel can be risky, requiring one to assume that the Excel numbers or formulas have not been altered and that linked spreadsheets are providing accurate information.

In a recent survey by Data Management Inc., over half of respondents say they spend a great deal of time correcting spreadsheet errors. The survey shows a strong belief among the participants that fixing inaccurate spreadsheets is part of their job duties.

“So many companies, right up to the Fortune 500, do their final analysis and consolidation in Excel spreadsheets,” says Tony Munns, a member of Brown Smith Wallace, who runs the risk management practice for the St. Louis-based firm. “Anyone can deliberately or accidentally change a field and it won’t necessarily be found.” In a recent telephone survey to companies undergoing an audit, nearly one half of the participants reported that auditors are expressing displeasure when told that the company’s financials were done using a spreadsheet.

Human error in both design and implementation is another factor contributing to the unsuitability of spreadsheets for financial reporting. Typos happen, and numbers that appear accurate may be taken at face value and not checked for discrepancies, leading to potentially disastrous results.

Incorrect information is also part of the equation. An Excel spreadsheet can only process the data that it is given and provide output based on that information. The mantra “garbage in, garbage out” continues to ring true.

Consider the following scenario: An organization is using a series of linked spreadsheets to create financial output. The worksheet designer has left the organization, so when problems arise they are not fixed at the source; rather, temporary patches are put into place to address the issue in the short term. Eventually the system will need to be redesigned from the ground up, with additional safeguards in place, costing the organization time and money.

ACC Accounting Solutions offers a variety of cost-effective solutions to improve the efficiency of your accounting staff, including steps to mitigate the risk associated with publishing financial reports. Our programs are designed to review your existing spreadsheet, meet the specific training needs of your staff, and help you transition your business to a dedicated financial reporting software that meets your particular business needs. Most projects involve a combination of a few days on site and a few days online to get you up and running.

Using Microsoft FRx software we have assisted many small to mid-size companies in becoming less dependent on Excel and more efficient in creating and distributing accurate financial reports. Why not give us a call to find out how we can do the same for you?


Solutions by Industry

What's New

Private versus Public Cloud

The term “cloud” has become common in the ERP world. Migration or moving to the cloud is becoming more popular as technology evolves. While your data can be moved to the cloud, there are different ways that data can be stored: public or private. Below are the differences between public and private cloud hosting environments. Read More

Submitted by Ally Donahue on Fri, 04/02/21 - 1:46

Your Brain on ERP

Just as your body needs your brain and central nervous system, your business needs an integrated ERP system. Read More

Submitted by Ally Donahue on Fri, 03/26/21 - 1:40

Benefits of Ongoing Staff Software Training

After ERP implementation, employees who will use the technology are trained on how to use the new software. However, software systems are constantly improving and updating which can cause employees confusion while working in the system. By hosting ongoing staff software training, your staff will feel confident and prepared to do their job effectively and be well versed in the updated technology.  Read More

Submitted by Ally Donahue on Fri, 03/19/21 - 1:44

Whatever Your ERP Needs, We Have the Solution!

Or call us for a free consultation 866-379-3799