5300 Call Report Checklist for Reports

The following is a list of reports you can use to complete your 5300 Call Report:

 

Call Report Page

CU*BASE Report

1, 2, 3, 4

Financial Statement Report Tool #376 Financial Report Configuration 

  • Select Report #53 (or the designated 5300 Financial Report #)

  • Current period end  = Quarter end MMYYYY

  • Type = CY (Current Year)

1

Investment Maturity Report  Tool #407 Investment Maturity Report

 

  • Change Month/Year to Process to EOM date unless changes made in current month in investment subsidiary

  • Starting date to use for maturity/review months calculation = EOM date

  • Sort by Investment Type or FASB Code depending on how investments are categorized'

  • Column 1 = 000 to 012 Months

Column 2 = 013 to 036 Months

Column 3 = 037 to 060 Months

Column 4 = 061 to 120 Months

Column 5 = 121 to 999 Months

 3, 6

Member Trial Balance Summary by G/L Account Tool #489 Mbr Trial Balance Summary by G/L Account

  • Change Month/Year to Process to EOM date

6

Loan Purpose Analysis Tool #471 Loan Purpose Code Analysis Report

  • Change Process Date to EOM date

6

Loan Security Analysis Tool #474 Loan Security Code Analysis Report

  • Change Process Date to EOM date

11

Contingent Liability Analysis Tool #280 Contingent Liability Analysis Report  

  • Include share draft accounts with negative balance

3

Certificate Maturity Analysis  Tool 190 CD Maturity Analysis Report    

  • Column 1 = 000-012 months

  • Column 2 = 013-036 months

  • Column 3 = 037-999 months

7

Membership Analysis Report Tool #520 Membership Analysis Report

  • Corp ID 01

  • Date to Process = EOM date

  • Accounts to Include = All

  • Report Option = 1

4

NCUA Share Insurance Report Tool #545 NCUA Share Insurance Report

  • Reporting Period = EOM date

  • Report Type = Summary

  • Include Members = O

Note:  You only need to print the 1st page of this report; delete others

Various

Loan Information Report Tool #788 Selective Loan Information Report

  • Output Format = Trial Balance

8,9

Loan Information Report Tool #788 Selective Loan Information Report

  • Output Format = Loan Delinquency Analysis

10

Loan Information Report Tool #788 Selective Loan Information Report  

  • Output Format = Loan Interest  Analysis

7

ARU/Online Banking Summary Stats Tool #141 ARU/Online Banking Stats Dashboard

  • Output = Print Dashboard

15

Participation Loan Trial Balance (if participation loans apply) Tool #590 PLI Trial Balance

  • Report as of Date = EOM date

  • Report Only Loans That Were Sold to the Investor on or after = MMDDYYYY

16

Loan Classification Update (if TDR loans apply and loan classification code is used to identify) Tool #656 Loan Classification Report

  • Month/Year = EOM date

3

CU*Spy Regulation D Statistics Report (PREGD from Member Services section)

14

Loan Maturity Analysis  Tool #467 Loan Maturity Analysis Report

  • Calculate length of time to maturity date from original term

  • Process date= EOM date

  • Maturity ranges depend on the type of real estate loan, for example Fixed rate > 15 years or 15 years or less is

  • Column 1 = 000-180

  • Column 2 = 181-999

  • Loan open date period used for Call Report YTD totals = MMDDCCYY to EOM date

 

 

Link to ID: https://help.cubase.org/cubase/cubase.htm#5300_Call_Report_Checklist_for_Reports.htm