• Home
  • Education
  • News and Resources
  • Advocacy
  • Associate Members
  • Contact
  • Search
  • Menu Menu
News
Compliance

Excel for CECL Compliance: "Can" vs. "Should"

Preparation is fully underway among Wisconsin's banks for the new CECL standards, which were issued by FASB on June 16, 2016 and fundamentally change how banks estimate losses in their allowance for loan and lease losses (ALLL). Among other considerations, banks must develop or purchase new systems and/or processes to conduct those calculations. One hotly debated question: whether or not banks can utilize a simpler solution than software, namely an Excel spreadsheet.

The answer: banks can use Excel, but that doesn't necessarily mean they should. 

There are several key considerations for banks when selecting a tool for CECL compliance, including the capabilities of that tool, the bank's complexity, staff expertise, and cost. Prior to any of that, however, bank management must determine which model is the right fit for their institution. "We've seen a number of different allowance calculations," said Mark A. Zeihen, assistant deputy controller with the OCC's Milwaukee/Iron Mt. Field Office. "Banks can use a variety of calculations today and going forward under CECL." While the more complex models aren't inherently bad, it is important to select the right tool for the job. "The selection of the methodology is important," said Ryan Abdoo, CPA, partner at Plante Moran. "That decision will have a long-term impact. With increased complexity comes increased data requirements and, thus, risk of error, so if you're an institution that has historically not complicated things, I would advise not complicating them." 

Tom Danielson, principal – financial institutions at CliftonLarsonAllen, LLP, recommends the "remaining life method"—which was outlined in a regulatory webinar on Feb. 27, 2018—as a good starting point for most community banks. If necessary, they can move to a more complex model in the future. "A key consideration is whether the model is right for your organization," he said. "Does it give you an ALLL computation that is correct, understandable, and easy for you to explain to shareholders, board members, auditors, and examiners?"

Along with selecting the most appropriate model, bank management must evaluate the data capabilities of their chosen solution. "CECL will require banks to maintain, manage, and store larger amounts of data," said Zeihen. "Each tool will vary greatly, so it's important for banks to consider how quickly they can retrieve and tailor reports." A key component of that evaluation is determining whether or not the bank's CECL solution integrates with its core. "Whether they integrate with your core processer is a big piece for making sure you have historic data points," explained Tom Mews, president, First National Community Bank, New Richmond, adding that a vendor who can supply industry data is also important. 

When evaluating different solutions for CECL compliance, bank management must first consider the level of complexity of the model that best fits their bank's needs. "When purchasing or building a model, we believe simple banks do not need complex models," said Danielson. "There are certain pros and cons with each option. Some of the software tools available are more complex than what many community banks need, which could lead to higher costs and some complexities within the model that are not needed by the user," added David Braden, CPA, manager – financial institutions at CliftonLarsonAllen, LLP. "However, the one concern with using an Excel-based model is you might not have enough staff who are comfortable modifying the spreadsheet accurately over time, and maintaining a proper control structure around that process." Bank management should also keep in mind that their institution's complexity may change. Software can be more flexible than a spreadsheet by supplying different methodology options, which could be an important feature for growth-oriented banks, according to Abdoo. "CECL allows for half a dozen different methodologies that range in complexity," he explained. "Due to the fact that the more complex the methodology gets, the more data the software needs, that flexibility allows you to start with a less complex methodology and then transfer to a more complex one as you grow without changing products."

Another important factor to consider is the expertise and time required by bank staff in order to effectively use the chosen tool. "Value the time your people put into managing the components and training backups," Mews advised. "Under the current CECL requirements, to train multiple people under that model is very difficult, with time constraints being the biggest component." That evaluation is likely one of the most difficult bank leadership will face when it comes to CECL implementation. "The difficult decision is the analysis of the skillset of your current employees and an honest assessment about the challenges and skills needed to build, maintain, and validate a CECL model using Excel," said Danielson. "Many banks may conclude that while it's possible, it's not cost-beneficial to do." Staff aren't the only ones responsible for understanding the model; management are required to fully comprehend how the model works. "Management has to be in charge of the internal control structure, and that escalates as the community bank grows in size," Braden explained. "The individuals at the bank need to understand how the inputs go into the structure and interpret what the outputs mean." 

Finally, bank management must weigh the costs of a potential CECL solution against its benefits. The key is to include all of the costs involved. "Don't consider just the initial cost but also the ongoing costs," said Zeihen, using employee training and implementation costs as an example. "Cost definitely plays into every decision a community bank makes," said Mews. "We could train one person internally, but because of the in-depth knowledge it takes, it would be difficult to have any backup." It's critical for bank leadership to consider the long-term costs and benefits of each potential solution rather than selecting the least expensive option in the short-term. "It doesn't make sense to pay for more than you need, but one of the poorest business decisions you can make is to buy the cheapest solution out there and find out later that it is ineffective," said Danielson. Bank management should also factor in the staff time required to utilize a software solution. "Each institution has someone responsible for loan loss allowance calculation," Abdoo pointed out. "Whether you use Excel or not, that person will still be putting in time documenting and entering data. You still will have to put in time and effort to calculations, no matter what the tool."

Ultimately, regulators are more concerned about compliance with the principles of CECL than the specific tools being used. "The bottom line is banks will continue to have flexibility in choosing a solution that meets their needs as long as the CECL principles are followed and objectives are met," said Zeihen. "The OCC isn't expecting or requiring banks to purchase from a third party vendor or purchase a new system. It's possible for banks to use the tools they already have, but some modifications will be required. We expect them to have proper controls over the input, the appropriate calculations, and controls over changes in outputs."

If a bank does decide to pursue using Excel for CECL compliance, be sure to leave plenty of time for testing and adjustments during implementation. "Community banks who want to consider using Excel will need to start very early in building their models so they can develop or hire the skills they need and change course if necessary," said Danielson. "It can be done, but don't make that decision lightly."


Helpful Resources

  • CECL Teleconference for Bankers: Practical Examples of How Smaller, Less Complex Community Banks can Implement CECL – Hosted by FDIC and FRB on Feb. 27, 2018
  • OCC Bulletin 2013-29 – Guidance for assessing and managing risks associated with third-party relationships
  • OCC Bulletin 2011-12 – Articulates the elements of a sound program for effective management of risks that arise when using quantitative models in bank decision making
  • 2006 Interagency Policy Statement on the Allowance for Loan and Lease Losses
  • BankNet's CECL Section (for OCC-supervised banks only)

Plante Moran is a WBA Silver Associate Member. 
CliftonLarsonAllen, LLP is a WBA Bronze Associate Member.

By, Amber Seitz

Print 🖨
August 30, 2018/by Jose De La Rosa
Tags: CECL, Wisconsin Banker
Share this entry
  • Share on Facebook
  • Share on Twitter
  • Share on WhatsApp
  • Share on Pinterest
  • Share on LinkedIn
  • Share on Tumblr
  • Share on Vk
  • Share on Reddit
  • Share by Mail
https://www.wisbank.com/wp-content/uploads/2021/09/Wisconsin-Bankers-Association-logo.svg 0 0 Jose De La Rosa https://www.wisbank.com/wp-content/uploads/2021/09/Wisconsin-Bankers-Association-logo.svg Jose De La Rosa2018-08-30 17:08:502021-10-13 13:46:50Excel for CECL Compliance: "Can" vs. "Should"
You might also like
What’s in a Name? The Intersection of Brand and Community
November 2022 Wisconsin Banker
Legal Q&A: NPCs Covered by CDD Requirements for Certification of Beneficial Ownership
Where Have All the De Novos Gone?
Legal Q&A: Negotiating Checks Using Transfer by Affidavit
Legal Q&A: POA and IRA or Trust Accounts
Nimble CFOs: Bank CFOs Take a Broader Role as Their Industry Evolves
Community Banks Leveraging Technology

Categories

  • Advocacy
  • Community
  • Compliance
  • Credit Unions
  • Education
  • Member News
  • News
  • Products
  • Resources
  • Uncategorized

Recent Posts

  • Nelson Celebrates 30 Years at National Exchange Bank & Trust
  • Bakalars to Retire
  • PWSB Mortgage Lenders Receive the Five Star Mortgage Professional Award
  • Executive Letter: Wisconsin Supreme Court Upholds Priority of Secured Creditor Under Receivership Rules
  • Peshtigo National Bank Announces Promotions

Archives

  • March 2023
  • February 2023
  • January 2023
  • December 2022
  • November 2022
  • October 2022
  • September 2022
  • August 2022
  • July 2022
  • June 2022
  • May 2022
  • April 2022
  • March 2022
  • February 2022
  • January 2022
  • December 2021
  • November 2021
  • October 2021
  • September 2021
  • August 2021
  • July 2021
  • June 2021
  • May 2021
  • April 2021
  • March 2021
  • February 2021
  • December 2020
  • November 2020
  • October 2020
  • August 2020
  • July 2020
  • June 2020
  • May 2020
  • April 2020
  • March 2020
  • February 2020
  • November 2019
  • October 2019
  • September 2019
  • August 2019
  • July 2019
  • May 2019
  • April 2019
  • March 2019
  • November 2018
  • September 2018
  • August 2018
  • June 2018
  • April 2018
  • March 2018
  • January 2018
  • November 2017
  • October 2017
  • September 2017
  • May 2017
  • April 2017
  • December 2016
  • November 2016
  • August 2016
WBA logo
  • About
  • Community
  • Subsidiaries
  • Staff

questions@wisbank.com

608-441-1200

4721 S Biltmore Ln.
Madison, WI 53718

Get our Newsletter!
Subscribe

© 2023 Wisconsin Bankers Association. All rights reserved. | Website Design by Bizzy Bizzy
Legal Q&A: NPCs Covered by CDD Requirements for Certification of Beneficial...Will Wisconsin Tackle Regulating Cryptocurrency and Blockchain?
Scroll to top

This site uses cookies. By continuing to browse the site, you are agreeing to our use of cookies.

OKLearn more×

Cookie and Privacy Settings



How we use cookies

We may request cookies to be set on your device. We use cookies to let us know when you visit our websites, how you interact with us, to enrich your user experience, and to customize your relationship with our website.

Click on the different category headings to find out more. You can also change some of your preferences. Note that blocking some types of cookies may impact your experience on our websites and the services we are able to offer.

Essential Website Cookies

These cookies are strictly necessary to provide you with services available through our website and to use some of its features.

Because these cookies are strictly necessary to deliver the website, refusing them will have impact how our site functions. You always can block or delete cookies by changing your browser settings and force blocking all cookies on this website. But this will always prompt you to accept/refuse cookies when revisiting our site.

We fully respect if you want to refuse cookies but to avoid asking you again and again kindly allow us to store a cookie for that. You are free to opt out any time or opt in for other cookies to get a better experience. If you refuse cookies we will remove all set cookies in our domain.

We provide you with a list of stored cookies on your computer in our domain so you can check what we stored. Due to security reasons we are not able to show or modify cookies from other domains. You can check these in your browser security settings.

Other external services

We also use different external services like Google Webfonts, Google Maps, and external Video providers. Since these providers may collect personal data like your IP address we allow you to block them here. Please be aware that this might heavily reduce the functionality and appearance of our site. Changes will take effect once you reload the page.

Google Webfont Settings:

Google Map Settings:

Google reCaptcha Settings:

Vimeo and Youtube video embeds:

Privacy Policy

You can read about our cookies and privacy settings in detail on our Privacy Policy Page.

Terms of Use
Accept settingsHide notification only

Subscribe

* indicates required








Membership