5300 Call Report Data

Screen ID: 

Screen Title: 

Panel Number:

images\kb_closed_shg.gif

UN53QTRFM-02

5300 Call Report Data

3575

images\3575g_shg.gif

Click here to magnify

 

Access this screen from the 5300 Call Report Data screen or the Create New Call Report screen.

This screen is used to enter the data for your 5300 Call Report. The Account Codes are presented in the same order as the NCUA Call Report and are presented in sections. The Section arrows will move you from Section to Section (i.e. Investments to Loans and Leases, etc.) Position to account code allows you to input an Account Code and enter to position to that Account Code.  

NCUA 5300 Call Report & CU*BASE Tools booklet

5300 Call Report Upload Steps

images\5300help_shg.gif

This is the Account Code level help button. You will get a detailed description of the Account Code along with automation routine information if applicable to the Acct Code. Tips on obtaining the data from CU*BASE will also display.

images\5300refresh_shg.gif

This is the Refresh button. For each Account Code, you will see Comparison Data at the bottom of the screen. The Comparison Data allows you to view Account Code information and also compare prior period data for the Account Code. You can select the prior quarters for comparison by using F13 CHNG COMPARISON.

images\5300autopop_shg.gif

This is the Auto-pop lookup button. If this button displays next to the Acct Code, that means that one or more automation routines are available. Automation routines will automatically populate CU*BASE data based on credit union configured data.

 

Automation Routines currently available in CU*BASE:

The software has default automation routines, where specific G/L accounts will default for you, i.e. Cash on Hand 739.00-739.99. You can change the default G/L routines, if desired.  Click here for a list.

General Ledger automation routines consider both the classification of the G/L account and the G/L balance when determining how to calculate and display your results. The software follows the NCUA standards for classification (asset, income, expense, liability). Therefore, it is recommended to set up your credit union’s financial statements with G/L ranges and classifications as follows:

G/L Number  Description Classification

100.00 – 199.99  Income   I

200.00 – 399.00  Expense  E

400.00 – 499.99  Gain/Loss I

700.00 – 799.00  Assets  A

800.00 – 899.00  Liability  L

Special Note on Gain (Loss)/Income(Expense) Account Codes: An automation routine may not calculate correctly if G/L’s within the configuration are classified as Expense instead of Income. There are just a few of these, such as A420 Gain (Loss) on Investments or A440 Other Non-Operating Income (Expense).

This is because of how the NCUA wants to see these numbers: If they see a positive number in one of these gain/loss Account Codes, they want that to mean a gain, and if they see a negative number, they want that to mean a loss. If these are set up in your G/L as expenses, they will work fine for your CU*BASE financial reports, but the 5300 Call Report auto-population routine will not be able to guess that your G/Ls are different from what the Call Report software is expecting to see.

If you do not want to classify your 400 series gain/loss accounts as income accounts, you can simply disable the auto-pop routines for those particular Account Codes and manually enter the numbers yourself.

If you do want to use the auto-pop routines, it is a simple matter of switching the classification in your Chart of Accounts. Be aware, however, that you may need to tweak your financial report configuration a bit so that your balance sheet still makes sense. In general you will want to list your income accounts with a “net income before gain/loss” sub-title, then expenses, then show the Net Gain (Loss) below that.

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.

Be sure to use Recalc Totals (F8) to re-calculate the Totals after you have modified an Account Code.

When you have completed your call report, use "Create XML file" (F14) to prepare to upload your data to the NCUA.  

Field Descriptions

Field Name

Description

Account Code

The NCUA defined Account Code.

Description

The Account Code description.

Data for …

The data for the Account Code. You can manually enter data or auto-populate data.

 

Buttons

Buttons

Description

Show/Hide Totals (F8)

Use this to display/not display the totals on the screen

Recalc Totals (F10)

Use this to recalculate the totals that display on the screen.

Change Comparison (F13)

Use this to change the Call Report year/quarter that displays as comparison data in the Comparison Data section of the screen

Create XML File (F14)

Use this to create an XML file of your Call Report data to be imported to the NCUA  A warning message will appear with hard errors you may choose to correct.

 

 

Link to ID: https://help.cubase.org/cubase/cubase.htm#UN53QTRFM-02.htm