Loan/Share Trial Balance Review

Screen ID:	IMBSUM-03
Screen Title:	Loan/Share Trial Balance Review
Panel ID:	4587
Tool Number:	478
		Click here to magnify

Access this screen by selecting to view the Branch view from the Summary or Product screen.

This information is created during beginning-of-day processing and stored in two data files: MBALSUM and MBALDET. These files store the daily trial balance information that allows this interactive inquiry. These files are also designed to be used in independent Queries and printed analysis

Learn more about the Loan/Share Trial Balance (access the Summary screen).

This screen lists the summary balances of different G/Ls.

Use Audit (F15) to view inquiry screen that compares you credit union’s Member Trial Balance totals to the appropriate General Ledger accounts, making it easy to see where the two are out of balance.

Use View Exclusions (F16) to view the G/Ls that are excluded from the dashboard.  If you want to exclude a G/L from this screen (such as your loan loss G/L, 719.00) you can mark to exclude it in the Charge of Accounts maintenance tool for that individual amount using F23-Exclude G/L.

Select to view all loans, or only the credit union owned or investor owned portions by using the "Loan balances include" section at the top of the screen.

To view summary balances for a single date and number of accounts, enter a Corp ID and a "Date range from" and use Enter. The list will display a summary for each product type as of that date. (Remember that this information is compiled as a “snapshot” during beginning-of-day processing. Use a date prior to today.)

To view a comparison of balances between data from two different dates, enter a Corp ID,  and a "Date range from" and a "Date range to" and use Enter. The list will display a summary for each application type comparing the two dates. A net change is calculated showing the difference in balance and number of accounts.

HINT: Loan to Share ratios are always calculated using the Record Date. Also, because the comparison automatically calculates the net difference between the dates, it is helpful to put the earlier of the two dates in the Record Date field.

HINT: If a G/L does not have data, then this G/L did not have a balance for that month.

Field Descriptions

Field Name	Description
Corp ID	Enter the company ID number to see balances for that corporation (generally 01).
Date range (from)	Enter a date to see products as of that single date along with the number of accounts.  Or use this with the a "to" date to compare balance of two dates
Date range (to)	This field can be used if you wish to compare current data to past data. First, enter the From as usual. Then enter a different date in the To fields. NOTE: Loan to Share ratios are always computed using the Record Date.
Loans to include	Select whether to show all loans, only the credit union owned portion of the loans, or only the investor owned portion of the loan.

Buttons

Button	Description
Backup (F3)	Returns you to the previous screen.
G/L by Product(F4)	Select any line item and use this to see detail screen showing all of the individual dividend applications, certificate types or loan categories by branch that make up the summary balance.
Summary (F6)	If the detail list is displayed, use this to return to the summary list.
Cancel (F7)	Use this to return to the Home Page.
Export (F14)	Use this to export your data to a file for use with Report Builder.
Audit (F15)	Access an inquiry screen that compares you credit union’s Member Trial Balance totals to the appropriate General Ledger accounts, making it easy to see where the two are out of balance.
Exclusions (F16)	Use this to view the G/Ls that are excluded from the dashboard.  If you want to exclude a G/L from this screen (such as your loan loss G/L, 719.00) you can mark to exclude it in the Charge of Accounts maintenance tool for that individual amount using F23-Exclude G/L.