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	CBX Report
1-5	Print CU Financials (Tool #640) Select Report #53 (or the designated 5300 Financial Report #) Current period end = Quarter end MMYYYY Type = CY (Current YTD)
15	Investment Maturity Report (Tool #407) Change Month/year to process to EOM date unless changes made in current month in investment subsidiary Starting date to use for calculation = EOM date (i.e. 9/30/20) Sort by Investment Type or FASB Code depending on how investments are categorized Column 1 = <=1 YEAR (000 to 012 months) Column 2 = >1-3 YEARS (013 to 036 months) Column 3 = >3-5 YEARS (037 to 060 months) Column 4 = >5-10 YEARS (061 to 120 months) Column 5 = >10 YEARS (121 to 999 months)
19	Member Trial Balance accessed via Mbr Trial Balance Summary by GL Account (Tool #487) Enter Employee Type if applicable Enter Membership Designation if applicable Month/year to process = EOM date
6, 19	Mbr Trial Balance Summary by GL Account (Tool #489) Set Month/year to process to EOM date (MMYYYY)
19	CD Maturity Analysis Report (Tool #190) Column 1 = 000-012 months Column 2 = 013-036 months Column 3 = 037-999 months
19	Portfolio Analysis – Savings (Tool #596) Select appropriate EOM date (MMYYYY)
19	Certificate Rate Analysis Report (Tool #195) Month/year to process = EOM date (MMYYYY)
19	CU*Spy Regulation D Statistics Report (PREGD from Member Services section)
19	CU*Spy Member’s Accounts with Negative Balances report (LNGBL from the Share Accounts section)
19	NCUA Share Insurance Report (Tool #545) Reporting Period = EOM date Report Type = Summary Include Members = O (only members with uninsured funds) Note: Use Summary report LSHINS9 for uninsured totals
6	Portfolio Analysis – Loans (Tool #595) Select appropriate EOM date (MMYYYY)
6, 9	Loan Interest Analysis (Tool #466) Set Process date to EOM date (MMYYYY) Note: The Loan Interest Analysis Report can also be run via Tool #788 Selective Loan Information Report.
6, 12	Loan Purpose Code Analysis Repor (Tool #471) Set Process date to EOM date (MMYYYY)
6, 12	Loan Security Code Analysis Report (Tool #474) Set Process date to EOM date (MMYYYY)
6, 11	New/Refinanced Loan History Report (Tool #554) Disbursement date range from 01/01/YYYY to EOM date* Filter loan balances/loan codes as appropriate Print Summary only *For obtaining YTD totals
6,10, 11, 12	Selective Loan Information Report (Tool #788) Output Format = Trial Balance Filter loans as appropriate
6, 10, 11, 12	New/Closed/All Accounts Dashboard (Tool #552) Enter date range from 01/01/YYYY to EOM date* Filter loans as appropriate * For obtaining YTD totals
19	Membership Analysis Report (Tool #520) Corp ID 01 Date to process = EOM date (MMYYYY) Accounts to Include = All Report option = 1 (Include written off loans in totals)
20	Wire Transfer Activity Report (Tool #980) Enter appropriate Start and End dates
7	Selective Loan Information Report (Tool #788) Output Format = Loan Delinquency Analysis Note: Loan Delinquency Analysis Report can be directly accessed via Tool #461 but does not offer the same selection criteria as Tool #788.
8	Calc/Post Adjustment for Delq Loans (Tool #179) Month/year to process = EOM date (MMYYYY)
8	Loan Write-off/Charge-off History Dashbd (Tool #476) Written off between 01/01/YYYY and EOM date (MMYYYY) Filter loans as appropriate (loan category, purpose, security code) Use Analysis for WO/CO totals
8, 9	Print Loan Classification Report (Tool #656) Process date = EOM date (MMYYYY) Note: This report can be used for loans in bankruptcy, TDR or PCIL loans if classification codes are used to group these loans.
17, 18	Contingent Liability Analysis Report (Tool #280) Include share draft accounts with negative balance
11	Loan Maturity Analysis Report (Tool #467) Calculate length of time to maturity from = open date Process date = EOM date (MMYYYY) Maturity ranges vary depending on the type of real estate loan Loan open date period to use for Call Report YTD totals = MMDDYYYY to EOM date
10	Participation Loan Analysis Report (Tool #579)) Month/year to process = EOM date (MMYYYY)
10	PLI Trial Balance (Tool #590) (if participation loans apply) Report as of date = EOM date (MMYYYY) Report only loans sold to the investor on or after = MMDDYYYY

Note: Your credit union may use additional CBX reports and some of the reports below may not apply for your credit union depending on how Call Report data is organized in CBX.