CECL Group Maintenance
CECL Group Maintenance Published: April 25, 2022 | Revised: June 1, 2022 The FLEX CECL program will help calculate the amount or percentage that will need to be manually moved in the General Ledger. Please keep in mind that this program does not include third party loans such as credit cards and participation lending. It is also only available for closed ended loans, open ended loans will be programmed soon. FLEX can pull data as far back as 2018. FLEX uses the Vintage model for calculations. Click here for an example of how these are calculated. This spreadsheet may also be used for your own calculations by entering in credit union applicable numbers. CECL Group Maintenance can be found under System Administration>General Configuration>Managerial.
Click Add to create a new record, or highlight an existing record to edit, view subgroups, detail or delete.
Group ID – Enter a Group ID. This will link in Loan Type Configuration to indicate that the loan type is tied to the CECL group.
Description – Enter a description for the group ID.
Model
C - Current Balance Modified Vintage – Calculates EOM date and number of years set to report (default is 5). Each month/year includes total count and original balance of loans that were charged off in the current month. The total charged off amount is then divided by the total original balance to get the calculated loss.
V – Original Balance Modified Vintage – Calculates EOM date and number of years set to report (default is 5). Each month/year includes total count and current balance of loans that were opened that month/year, total count and charged off amount in the current month. The total charged off amount is then divided by the total current balance to get the calculated loss.
Credit Option – Select whether to use member’s Credit Score or Credit Grade.
# Years Life Expectancy – Enter the number of years expected to be included in CECL for the loan. This will display the number of years in the Subgroup Detail information.
Available Types – Loan types not already included in another CECL Group are listed as available to add to the group. Highlight and click arrow to move to Selected Types.
Selected Types – Lists loan types that have been selected to be included in the CECL Group. Highlight and click arrow to move out of Selected Types.
All Assigned Types – Lists loan types that have been assigned to other CECL Groups.
Add All will move all loan types into Selected Types. Remove All will move all loan types into the Available Types.
Adding Subgroups to the CECL Group
To add a Subgroup to a CECL Group, highlight the group and click Subgroup.
Click Add to create a new Subgroup or highlight an existing Subgroup to Edit, retrieve Detail or Delete.
Enter Description, Purpose Code (if applicable), Security Code (if applicable) and Credit Score or Grade range. Click Save to save Subgroup.
If a duplicate entry is made, an error message will display state that score or grade was already included in another Subgroup.
Recreate History
Recreate History will recreate the history data for the group. Recreate History should be used after groups are created or changed. End of Month will automatically create history, finalize and generate reports.
Subgroups MUST be added before history is displayed.
Viewing Subgroup Detail
Detail will display the detail for each year including Loss Percentage and Loss Amount.
Group Detail will display the date for the Last Acquired Date and the # Years Life Expectancy that was entered in the CECL Group setup.
Detail is also available in the Subgroup.
Loss Percentages
Displays the total loan balance of loans opened in the designated year. Column header will vary depending on the calculation method that was chosen, original or current balance. Year Loss % columns will display the [loss amount for that year] / [original balance or current balance].
Loss Amounts
Displays the total loss amounts for loans opened for displayed year, with a total of all losses for that year over the course of time.
Total Unadjusted
Open loans and charged off months.
Unadjusted Loss $ - Calculated dollar amount. Total of ALL loss amounts.
Unadjusted Loss % - Calculated percentage. Average of all the Total Loss % values.
Adjustment
Entered by the credit union as predicted loss. This can only be entered through the Detail option within the Subgroup. This value raises the actual Unadjusted values to generate the Total Allowance values.
Adjustment % - Credit union defined percentage amount.
Adjustment $ - Credit union defined dollar amount.
Note: If a percentage is entered, the Adjusted $ will automatically calculate and if the amount is entered the Adjustment % will automatically calculate.
Total Allowance
Calculated total of the Total Unadjusted and Adjustment amounts and percentages.
Allowance $ - Calculated dollar amount of the unadjusted and adjusted.
Allowance % - Calculated percentage of the unadjusted and adjusted.
Adjustment Reason – Will display when the Subgroup is finalized.
Finalize – Click to lock the entries made into the CECL Subgroup. Once the Subgroup is finalized, it cannot be ‘unfinalized’ until the last month is closed at the end of month or end of month has run and finalized the subgroup automatically.
Enter in Adjustment % or $ and reason for adjustment. Click Finalize.
The subgroup will then show as finalized in the overview.
When all the subgroups are finalized, the Group will show as finalized.
To drill down even further, highlight the Subgroup and select Month Detail. Different years may be selected to view.
Adding the CECL Group to Loan Type
In the Loan Type tab in Type Configuration, select the Loan Type to be included in the CECL Group under the Miscellaneous tab.
If this step is missed, the group will automatically be added to Type Configuration at end of month.
CECL Reports
There are two reports that can be run for CECL.
CECL Report can be found under the Managerial Reports section (LL5300R). This report shows information on the Subgroups and can be run as a Summary or Detailed.
Detailed Report (LL5300)
Summary Report (LL5300R)
CECL End of Month Report (LL3005R) shows the details for each of the Subgroups. This report is run with end of month, but can be ran at any time. In order to run this report, all Subgroups MUST be finalized otherwise, an error will display.
Confidentiality Notice: This document is published by Computer Marketing Corporation/FLEX and is intended solely for its contracted clients. It may contain information that is privileged, confidential or otherwise protected from disclosure. Dissemination, distribution or copying of this document and any accompanying attached information by someone other than the intended recipient(s), or an employee or agent acting on behalf of the intended recipient, is strictly prohibited.