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-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 (F8) button 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 CU*BASE reports and some of the reports below may not apply for your credit union depending on how Call Report data is organized in CU*BASE.