Deposit Reports > Deposit Reports - Numerical Order

Availability

This report should be run daily in the afterhours.

Purpose

The GL File Balance Report Detail—Differences Only is similar to the General Ledger File Balance Report (FPSDR076), except that FPSDR276 shows differences only between your institution's aggregate of a particular loan type compared to the General Ledger balance for that particular loan type. It also compares deposit product codes and their corresponding General Ledger balances. 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. If any differences exist, only those GL accounts with differences will be displayed. The dollar difference amounts are indicated in the DIFFERENCE column.

This report can be sorted by General Ledger account number or by ACCOUNT NUMBER (80), SYSTEM FIELD (81), and the LOW/HIGH FIELDS (82).

If your institution uses the Daily Interest Accrual options (institution options PACD=Y and AFBR=Y), then the interest accrual posting will be displayed on the report and added to the total deposit and loan amounts on the bottom of 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.

Report Column Information

See FPSDR276 Example for an example.

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 on the GOLD Services > General Ledger > Posting Fields screen in CIM GOLD. Appendix B of the GOLD Services manual lists all the available posting fields for the Loans, Deposits, or other systems.

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. This error will print when Autopost Parameters cannot resolve down to a General Ledger account number.

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

GL File Balance Report Detail - Differences Only (FPSDR276)

GL File Balance Report Detail - Differences Only (FPSDR276)