Deposit Reports > Deposit Reports - Numerical Order

Availability

This report should be run daily in the afterhours.

Purpose

The General Ledger File Balance Report shows General Ledger accounts and balances after the posting of the daily work. Loan and deposit balances are also read after the posting of the daily work. The autopost parameters are used, with the posting fields and values, to determine which General Ledger accounts represent the money in the customer accounts. These “file balances” are then totaled by General Ledger account number and compared with the current balance in the General Ledger account. Any differences are indicated in the difference column.

This report can be sorted by General Ledger account number or by Account Number (80) and the Low/High Fields (81).

This report uses one miscellaneous option. It is the left-most option on the report setup screen. This report may be run with and without detail in the same run. This option indicates that detail should be shown on the report.

Loans: The File Balance Report reads balances for open and closed loans but excludes released and unopened loans.

Deposits: The File Balance Report reads balances for open and closed deposit accounts but excludes unopened accounts. If your institution uses the Daily Interest Accrual options (institution options PACD=Y and AFBR=Y), then the interest accrual posting is added to the total deposit amount on the bottom of this report. (Also see the Interest Accrual Report (FPSDR009) for more information).

Report Column Information

See FPSDR076 Example for an example of this report.

Column	Description
Account Number	This is the General Ledger account number to which the activity will be posted.
Amount Number*	This is the amount that tells which balance we are displaying on the customer accounts.
Amount Description*	This is the description of the amount number.
Account Description	This is the description of the account number as found in the General Ledger System.
Posting Field Description*	This tells which posting fields are used to post this amount to the General Ledger. There are up to 10 posting fields for each amount.The posting fields for each amount field are chosen by the user in the Posting Field Setup (Application 8, function 601/602).
Low*	This shows the money is classified as a low value according to the posting field values.
High*	This shows the money is classified as a high value according to the posting field values.
File Balance*	This shows the total dollar amount of balances on accounts that met the criteria indicated in the posting fields and low and high values. NOTE: If a loan is set for non-performing/non-accrual status, the system uses the book balance rather than the loan principal balance for this report.
Gen Led Balance	This is the balance in the General Ledger account at the time the report is run.
Difference	This is the difference between the General Ledger account balance and the file balance for the General Ledger account.

Note: Two different error messages can be printed on this report:

1) ***ACCT NOT FND*** WOULD HIT SUSPENSE. This error will print when autopost parameters can resolve down to a General Ledger account number, and it is either not on file or is inactive.

2) ***ACCT NOT FND*** WOULD HIT ERROR LIST will print when autopost parameters can not resolve down to a General Ledger account number.

These types of errors will also be printed on the General Ledger Autopost Error List (FPSDR013).

General Ledger File Balance Report (FPSDR076)

General Ledger File Balance Report (FPSDR076)