Completing the 5300 Call Report
C. Configuring Credit Union Data
C1. Same Settings as Account Code
D. Modifying/Re-calculating Auto-populated data
A. Creating a Call Report
CU*Answers maintains a template of NCUA defined Account Codes. Every quarter, the template is updated to match the current NCUA Call Report.
Access Tool #362 Enter 5300 Call Report Data, and use Create New (F6).
Enter the Year and Period (3=1st quarter, 6=2nd quarter, 9=3rd quarter, 12=4th quarter) for the Call Report.
A 'template not available' error message displays if you are attempting to enter a Call Report before the end of the current period (before EOM files are available). CU*Answers maintains a template of NCUA defined Account Codes. Every quarter, the template is updated to match the current NCUA Call Report.
Keep in mind that when entering a prior Call Report, the arrangement of Account Codes will be pulled from the current configuration template.
The Account Codes appear in the same order of the NCUA Call Report. The Section arrows will move you forward and back between Call Report Sections.
Refer to the Call Report Data screen for more information on creating a Call Report in CU*BASE.
B. Automation Routines
Automation routines will automatically populate data to Account Codes based on a default automation routine or credit union configured automation routine.
The following CU*BASE automation routines are in place:
-
Copy Prior Quarter Data (will apply to 2nd CU*BASE Call Report entered)
-
G/L Quarterly Account Balance (from the GLBALA file)
-
Loan Counts/Amounts by Purpose Code
-
Loan Counts/Amounts by Security Code
-
Loan Counts/Amounts by Category Code
-
Count Member Accounts by G/L (from EOM MEMBER files)
-
Account Balances by Primary G/L (from EOM MEMBER files)
-
Account Count/Amount by Dividend Application Code
-
Loan Count/Amount by Loan Classification Code
The software has default automation routines where specific G/L accounts will default for you, i.e. Cash on Hand 739.00-739.99, Undivided Earnings 940.00, and Loan Servicing Expense 280.00-289.99 to name a few. The Credit Union is not required to use the default configuration.
C. Configuring Credit Union Data
Many Account Codes have automation routines available. On the Call Report Data screen, if the “Auto-populate options” button 
appears next to an Account Code, one or more automation routines are available. Click this button to select from the available automation routines on the screen. More than one automation routine can be used for an Account Code if appropriate.
After you select a routine, you will be brought to the Call Report Automation Configuration screen where the data specific to your credit union (security codes/purpose codes, G/L numbers) is entered. The configuration allows for individual values, multiple values, or a range of values. Be sure to use F10-Add/Update to save your configuration.
The automation routine configurations that your credit union creates are saved for future CU*BASE Call Reports.
Keep in mind that G/L numbers need to classified correctly (asset, liability, income, equity, expense) in your credit union’s Chart of Accounts in order to populate correctly to the Call Report. Refer to the Call Report Data screen for more information.
C1. Same Settings as Account Code
On the Call Report Automation configuration screen, you can copy the settings from another Account Code. This prevents you from having to set up the same configuration twice (i.e for number and amount of loans). The dropdown box next to “Use same settings as account code” provides Account Codes to select from. Enter the Account Code that you want to copy the settings from. Use F5-Add/Update.
NOTE: When entering an Account Code to copy from, there must be an A in front of the Account Code; i.e. A993.
You can change the configuration of a ‘copied to’ Account Code, but you cannot delete the configuration for an Account Code that has been copied from. You must first delete the configuration on the ‘copied to’ Account Code(s).
C2.Comparison Data
The comparison window on the 5300 Call Report Data screen allows you to view data for the Account Code including a comparison to prior quarters. Click on the Refresh button 
Next to the Account Code to view the Comparison Data. You can change the prior quarters for comparison by clicking F13-Chng Comparison.
C3. Removing a CU Configuration
If you determine that you no longer want to use an automation routine for an Account Code, from the Call Report data screen 3575, click on the auto-pop button to get to the Call Report Automation Selection screen. Highlight the automation routine to be deleted and use the Deactivate option. You will receive a message confirming the delete. Click F16-Delete to remove this automation routine from the Account Code.
After deleting an automation routine, the calculated value on the Call Report Data screen will change to zero even if the auto-populated amount had been Modified (i.e. outside vendor totals added in). If desired, the Modified amount can be added back to the Account Code manually.
C4. Multiple Auto-pops to Same Account Code
You have the ability to assign multiple auto-pops to the same Account Code. For example, if loan data for a specific NCUA category like “All Other RE Loans” is organized both by loan category and loan purpose code, simply select and configure both (one at a time) from the Call Report Automation Routine Selection screen. The system will recognize if the same loan data resides in both loan codes and only count that loan data once.
D. Modifying/Re-calculating Auto-populated Data
There may be instances where you need to modify auto-populated data. For example, to add in outside vendor totals or update a G/L balance that has been adjusted after you created your CU*BASE Call Report.
On Account Codes where you have to add in outside vendor data to CU*BASE data, you can modify the value on the Call Report Data screen without changing your configuration. In the Comparison data window, you will see the ‘Modified’ to remind you that the auto-populated value was changed.
To refresh an auto-pop calculation, access the Call Report Automation Routine Selection screen and use F9-Refresh Acct Code. The updated value will display. Note: This might be necessary if the Call Report is created before all the G/L entries are complete and the total needs to be refreshed to the current G/L balance
Be sure to use Recalc Totals (F8) to re-calculate the Totals after you have modified or recalculated an Account Code.
G. Account Code Level Help
Click on the 
button next to the Account Code in order to view field level help which may also include a tip on how to obtain the data from CU*BASE. You can also visit the 5300 Account Code Online Help at any time.
I. Upload Your Call Report
Once you have entered the data for your 5300 Call Report in CU*BASE, use F14-Create XML File to start the process of creating xml file to upload to the NCUA. Refer to 5300 Call Report Upload Steps for detailed steps necessary to upload your Call Report to the NCUA.
Learn more about 5300 Call Report software General Ledger default auto-pops.