Tracking Recoveries on Written-off Loans

We are in the early design phases of a project to enhance how CU*BASE tracks written-off loans, recoveries, and charged-off loans, expanding on existing Write-off/Charge-off database and analysis tools.  This recipe will preview some of the concepts and ideas we’re considering in the design.

Why We’re Doing This Project

  • To allow for better recovery reporting via our 5300 Call Report tools.
  • To improve our capabilities related to calculating net losses.
  • To allow us to calculate a more accurate payoff amount on loans that are sitting in write-off status.
  • To put another brick in the wall in our capabilities to meet future CECL challenges.

Ideas Being Considered in the Design

  • Display more relevant information on account inquiry and update screens for written-off loans.  Replace data that pertains only to current loans with data specific to loans that are in a write-off status.
  • Create an easier way to handle partial write-offs, where a portion of the loan is charged off but the rest remains in a current status.
  • Write a special account adjustment tool, dedicated specifically to the special types of adjustments needed for written-off loans, such as posting recoveries, adding collections expenses, etc.
  • Design a technique for calculating interest due since write-off.  This wouldn’t involved daily accruals, but rather we would calculate, on the fly as needed, an accurate payoff amount that includes interest due since payoff, fines due, and other collections expenses (such as attorney fees, collections/repo fees, etc.).
  • Collect additional data at the time of the write-off, as needed to support the new calculations.

Methodologies Being Debated

  • Expand MEMBER5 and MEMBER6 tables? (Adding more special-use fields that would appear in the tables for all loans, but be used only for write-off and recovery purposes on written-off loans.)
  • Create a new set of MEMBWO5 (for Write Off) and MEMBWO6 tables just for written-off loans?  (In other words, removing loan accounts from MEMBER5/6 and moving them to these new tables instead.)
  • Expand the write-off/charge-off database and combine that data with existing MEMBER5/6 data for a more complete picture?  (Make use of this separate architecture to allow other loan processes to continue as now, but giving us new data to work with for new analysis and processing tools.)

Expanding the MEMBERx tables has fairly large ripple effect and might result in unintended consequences.  Creating new tables would eliminate that ripple effect but create a different one, as we have to figure out where existing processes would need to start looking not only at MEMBERx tables but also the new MEMBWOx tables.  The idea that has the most promise now is to greatly expand the existing database used for written-off and charged-off loans, adding new columns to existing tables and even creating new data tables that provide the information we’ll need for new analysis dashboards, calculation routines, reports, and the like.

We Want to Hear from You

At their meeting on April 11, 2019, we introduced our ideas to members of the Accounting Top Priorities focus group, and several of these credit unions are assisting us with their ideas and feedback as we move forward.

But we’d love to hear from you as well.  Give us your feedback, ideas, and suggestions so we can consider them as we continue to shape the final design.  And if you’d like to talk to someone, reach out to the chefs for this recipe: Randy Karnes and Dawn Moore.



June 1, 2020

Leave a Comment

* denotes required fields
  • (will not be published)

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

Check Out the New Recipes We’re Cooking in the Kitchen!

Check Out the New Recipes We’re Cooking in the Kitchen!

Have you visited the Kitchen lately? If not, take a look at our newest projects: Authentication Enhancements for Online/Mobile Banking Enhancements to the Credit Card Cash Back (CCCB) Feature Tracking Recoveries on Written-off Loans Each of these recipes includes a place to provide comments, suggestions, and additional feedback. Visit the Kitchen today – we’d love… Read more »

Aug 16, 2019

Visit the Kitchen Today for New Information on ACH Exception Processing Enhancements

Visit the Kitchen Today for New Information on ACH Exception Processing Enhancements

On May 9, 2019, a CU*Answers design team met to brainstorm ideas for changes to CU*BASE tools and processing routines.  Our main goal is to make it clearer to end-users how the tools work, including warnings about what to watch out for and tips for avoiding potential pitfalls. As a result of these preliminary conversations,… Read more »

May 14, 2019

Have you checked out the NCUA’s proposed 5300 Call Report changes?

Have you checked out the NCUA’s proposed 5300 Call Report changes?

Have you checked out the NCUA’s proposed 5300 Call Report changes yet?  The changes are targeted for March 2019, and the NCUA wants your feedback! The overall theme is modernization and simplification in order to reduce the reporting burden for credit unions.  Check out the 5300 Call Report Tools kitchen page for a highlight of… Read more »

Feb 15, 2018