5300 Call Report Tools for CU*BASE

Have Comments about the 5300 Call Report?

We’d love to hear your feedback, use the Comments Section below

Since the NCUA 5300 Call Report data is subject to change every quarter, the Call Report is an ongoing project here at CU*Answers!  We are always looking for ways to make gathering Call Report information easier for credit unions.   In fact, we have a dedicated resource on staff who keeps our CU*BASE software up-to-date and continually analyzes how we can help credit unions gather 5300 Call Report data.  For detailed information on CU*BASE 5300 Call Report tools, refer to the booklet.

Refer to the NCUA’s dedicated webpage for details of the current Call Report, Profile and Instructions.

New for CU*BASE Tool March 2023 – Account Codes Reformatted for Specific Fillable Account Codes

In order to prevent error/warning messages in the NCUA CU Online site after Call Report data is uploaded, selected Account Codes in Tool #362 Enter 5300 Call Report Data have been reformatted as fillable Account Codes.  This matches the exact format of the NCUA.

The Account Codes listed below are now “fillable” which means they must be manually entered or auto-populated if applicable to your credit union.  Since these Account Codes are no longer calculated, they can now be included in the NCUA upload file.  If populated appropriately, this should eliminate NCUA errors related to these data points.

  • AS0055 Equity Securities (pg. 1)
  • AS0061 Trading Debt Securities (pg. 1)
  • AS0067 Available-for-Sale Securities (pg. 1)
  • AS0073 Held-to-Maturity Debt Securities (pg. 1)
  • 025A Number of Loans and Leases (pg. 2)
  • 025B Amount of Loans and Leases (pg. 2)
  • 860C Borrowings (pg. 3)
  • 013 Member Shares of All Types (pg. 3)
  • 880 Nonmember Deposits (pg. 3)

Why this change?  With the NCUA revamp of the Call Report in March 2022, the detail needed to determine the Account Codes listed above occurs in subsequent sections of the Call Report (the NCUA has separate “calculated” Account Codes for these items).  For example, “Total Shares” SH0013 (Schedule D page 19) is calculated based upon share account detail on page 19.  This total should match Account Code 013 “Member Shares of All Types” on page 3.

Note:  Since the above Account Codes are used in the calculation of Total Investment Securities (pg. 1),  Total Assets (page 2) and Total Liabilities (page 3), be sure to use the “Recalc Totals” button after all of your Call Report data has been entered.  Remember that “calculated” Account Codes display in the CU*BASE Tool for informational purposes only and are not included in the NCUA upload file.        

The format change described above allows you to review and make any appropriate adjustments to your Call Report data within the CU*BASE Tool prior to the upload to the NCUA.  The goal is to have fewer errors/warnings to address in the NCUA site.

Collections Summary Dashboard to be Updated to Match NCUA Delinquency Terms

For the March 2022 Call Report, the NCUA revised loan delinquency reporting to separate out the 60-179 day range to 60-89 days and 90-179 days.   Our first priority was to update the Loan Delinquency Analysis Report to match the NCUA ranges and this change was implemented on 12/4/2022.  Next up is updating Tool #229 “Collections Dashboard/Summary” with the NCUA’s revised day ranges.

Project #59016 status as of 6/22/23: Targeted for 23.10 release  

Add NCUA Edits/Warning Messages to CU*BASE Tool

Project #59088 is in development to add back specific NCUA error/warning messages that display from Tool #362 Enter 5300 Call Report Data when creating the xml file for upload to the NCUA.  These warning messages do not prevent you from creating the xml file but are there to help eliminate errors in the NCUA online system.

Project #59088 was implemented in the 23.05 release!  

Tracking Recoveries on Written Off Loans

A new program that calculates daily memo accruals on written-off loans was introduced with the 22.05 release.  The project also expanded the written-off loans database table to capture memo accrual data and other data points requested by CUs.  Refer to the kitchen page for more information.

Project #56556 implemented in the 23.05 release enhanced Tool #476 Written Off Loan History Dashboard to add date toggles so that the net change/recovery amount can be calculated using end of month (EOM) balances.  For example, you can compare loan balances from EOM December to EOM March, June or September to determine the year-to-date net change.

Be sure to check out the “Write-off/Charge-off Tools for Loans” booklet for suggestions on assembling the data needed to determine loan recovery amounts.  Refer to the section “Tracking Charge Offs and Recoveries for the 5300 Call Report” in this booklet available on the CU*Answers CU*BASE Reference page.

Keep in mind that the Loan Charge Offs and Recoveries section of the Call Report encompasses both written off (debt is deemed still collectible) and charged off (debt is not deemed collectible) per the classifications in CU*BASE.

Highlight of the NCUA’s March 2022 Changes

The NCUA implemented major changes to the 5300 Call Report with the March 2022 Call Report.  The overall theme of the re-vamp was modernization and simplifying in order to reduce the reporting burden for credit unions.  Although credit unions (and CU*Answers) are still adjusting, the reorganization and restructuring of the data does seem to make sense.   Please provide feedback below if you do not agree!

Here is a highlight of the changes:

  • Time deposits now included with cash assets (pg. 1)
  • Investments sections revamped and moved to Schedule B (pgs. 13-16)
  • Revised categories of Foreclosed and Repossessed Assets (pg. 2)
  • Shares/Deposits information moved to Schedule D (pg. 19) and dividend rates no longer required
  • NCUA Insured Savings Computation section simplified and moved to pg. 19
  • Delinquent loan range of 60-179 days separated out to 60-89 days and 90-179 days (pg. 7)
  • No longer required to report # of delinquent loans by day range, only report total # of delinquent loans 60+ days
  • Additional Delinquency Information page removed
  • Loan Charge Offs and Recoveries page streamlined with new commercial loan categories added (pg. 8)
  • Miscellaneous Information page removed with some account codes moved to Schedule E
  • Troubled Debt Restructured Loans section removed – only need to report total # and amount of TDRs on pg. 8
  • New categories of Indirect Loans and Participation Loans (pg. 10)
  • Lending related data collected in Schedule A simplified but many account codes replaced (pg. 11)
  • Contingent Liabilities and Off Balance Sheet Exposures sections revamped and moved to Schedule C (pgs. 17-18)
  • Complex Credit Union Leverage Ratio Schedule H added (pg. 23)
  • Risk Based Capital Schedule I added (pgs. 24-28)

Impact to CU*BASE Tools

With the NCUA March 2022 changes, the number of the account codes on the Call Report was reduced by approximately 20%.  The main task for CU*Answers was to update our template of account codes to match the NCUA. Our dedicated Call Report resource completed these updates and continues to monitor each quarter for future updates.

In addition, a comprehensive review of CU*BASE reports/dashboards used to gather Call Report information was performed.  The Loan Delinquency Analysis Report was updated to break out the 60-89 and 90-179 day ranges (accessed via Tool #461 or Tool #788).  As always, we welcome any suggestions for CU*BASE report/dashboard enhancements that will make it easier for you to obtain Call Report data!

Many of the account codes used for the calculations on the Tool #1021 “5300 Call Report Ratios Dashboard” were changed therefore we implemented PS#58341 to update the calculations for 8 ratios to match the NCUA calculations.

Keep in mind that the NCUA Schedule H (CCULR) and Schedule I (RBC) are not included in the CU*BASE tool at this time.

        

March 2023 Webinar

View the below March 2023 webinar to learn about using the CU*BASE Call Report Tools. webinar

We are always looking for ideas on how to improve the 5300 software. Contact callreport@cuanswers.com with any suggestions!

The chef for this recipe is Karen Sorensen.

Feedback

Have thoughts or ideas about the 5300 Call Report? We’d love to hear your feedback. Use the Comment Section below.

Updated
November 29, 2023

Tags:

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: Card Activity Optics Credit Card Statement Enhancements Introducing Biz Watch for ACH: ACH Controls for Business Memberships Max Earnings Sweeps for Business Members Positive Pay Cashier Services (for Inhouse Checks) RDC Enrollment via CU*BASE Summary Statements for Business Credit Cards… Read more »

Sep 29, 2020

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: Accounts Payable Enhancements Creating an Engine for Predictive Retailing (aka “Nostradamus”) Deposit Hold Enhancements Escrow Analysis Enhancements Expanding Screen Sizes for CU*BASE GOLD Mobile First Transaction Limits for Express Tellers Each of these recipes includes a place to provide comments,… Read more »

Jul 14, 2020