Skip to main content

Are you sure your spreadsheets are error-free?

April 26, 2013
Read Time: 0 min

Eighty-eight percent of spreadsheet documents contain errors, as stated in a recent article in MarketWatch, which cited a 2008 analysis of multiple studies. Ray Panko, a professor of IT management at the University of Hawaii and an authority on bad spreadsheet practices, noted, “Spreadsheets, even after careful development, contain errors in 1% or more of all formula cells. In large spreadsheets with thousands of formulas, there will be dozens of undetected errors.”

Earlier this year, Sageworks polled over 130 financial institutions and found that eighty-four percent are using spreadsheets for one of their most complex and challenging calculations, the allowance for loan and lease losses. 

Working with over 700 financial institutions, Sageworks’ consultants have regularly heard from spreadsheet users about a number of challenges such as version control issues, errors in calculations and a complicated process that is inflexible, decentralized and non-transferrable should any changes occur with bank personnel or with accounting standards and regulations.

Besides errors, there are other risk management limitations that institutions should be aware of when using spreadsheets. These programs, such as Microsoft Excel, aren’t designed to process large volumes of data, and it can be difficult to export data from these programs to other applications the institution may use for spreading, global cash flow analysis, exception tracking or reserves.

Many institutions have decided to discontinue the use of their spreadsheets and implement a web-based solution to perform their credit analysis and ALLL calculations with increased accuracy, consistency and efficiency.

For more information on common concerns that regulators have with spreadhseets, download the whitepaper titled: Regulator Concerns with Spreadsheets in Risk Management.

 

To learn more about how Sageworks can help your financial institution transition away from spreadsheets, check out our risk management solutions.

About Abrigo

Abrigo enables U.S. financial institutions to support their communities through technology that fights financial crime, grows loans and deposits, and optimizes risk. Abrigo's platform centralizes the institution's data, creates a digital user experience, ensures compliance, and delivers efficiency for scale and profitable growth.

Make Big Things Happen.

 

Looking for Banker’s Toolbox? You are in the Right Place!

Banker’s Toolbox is now Abrigo, giving you a single source for all your enterprise risk management needs. Use the login button here, or the link in the top navigation, to log in to Banker’s Toolbox Community Online.

Make yourself at home!

Looking for MainStreet Technologies? You are in the Right Place!

MainStreet Technologies is now Abrigo, giving you a single source for all your enterprise risk management needs. Use the contact us button here, or the link in the top navigation, to reach product support for your MST products.

Make yourself at home!

Looking for Sageworks? You are in the Right Place!

Sageworks is now Abrigo, giving you a single source for all your enterprise risk management needs. Use the login button here, or the link in the top navigation, to log in to your Sageworks products.

Make yourself at home!

Looking for Farin? You are in the Right Place!

Farin is now Abrigo, giving you a single source for all your enterprise risk management needs. Use the login button here, or the link in the top navigation, to log in to your Farin client portal.

Make yourself at home!

Abrigo acquires construction loan management solutions

Coupled with our lending suite, Construct and +Pay from BankLabs enable end-to-end automated residential/commercial construction loans.

Read the press announcement

BankLabs Logo Abrigo Logo