Skip to main content

Spreadsheet concerns in risk management: Consistency

Sageworks
July 29, 2013
Read Time: 0 min

Financial institutions use spreadsheets for a variety of tasks including the loan loss reserve, credit analysis and stress testing. Unfortunately, spreadsheets are prone to error and complications, and are often sources of problems when examiners are present. While their complexity is one of the major concerns voiced by regulators, consistency is also a significant concern.

A perceived benefit of spreadsheets in the work environment is that it offers individuals complete control over consistency (or lack thereof). Spreadsheets may be copied and replicated easily, and can be saved in one place or transferred to/shared with another person. They can also be altered to reflect new preferences and/or methodologies. As a result of this flexibility, the responsibility of consistency lies with individual users.

The complete control individuals have over consistency, however, also presents an area of concern for regulators. Different users have the ability to incorporate their specific preferences and methodologies into these spreadsheets, and all too often, the end result may vary widely from one user to the next, from one location to the next and from one institution to the next. This not only presents risks associated with potential inconsistencies, but also exposes institutions to potential regulatory scrutiny. Regulators must ascertain inconsistencies from prior reviews, and then validate the reasoning behind the changes. 

To promote consistency with spreadsheets, financial institutions should:

1) Establish formal policies and procedures that can serve as the guideline/blueprint to a desired output.
2) Assign a specific individual or group to take ownership of any and all spreadsheets, promoting accountability for accuracy and consistency.
3) Minimize how often each particular spreadsheet changes hands, including users changing data or taking ownership.
4) Consider alternative options such as an automated web-based solution to improve consistency between users and locations.

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

About the Author

Sageworks

Raleigh, N.C.-based Sageworks, a leading provider of lending, credit risk, and portfolio risk software that enables banks and credit unions to efficiently grow and improve the borrower experience, was founded in 1998. Using its platform, Sageworks analyzed over 11.5 million loans, aggregated the corresponding loan data, and created the largest

Full Bio

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