Deposit Reports > Deposit Reports - Numerical Order

Availability

This report should be run daily in the afterhours.

Purpose

The GL File Balancing Report Summary–Differences Only is similar to the General Ledger File Balancing Report (FPSDR076), except that FPSDR277 shows differences only between the Loan and General Ledger or Deposit and General Ledger in a summarized format. 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 G/L 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 amount on the bottom of the report.

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

Deposits: The File Balancing Report reads balances for open and closed deposit accounts but excludes unopened accounts.

Report Column Information

See FPSDR277 Example for an example of this report.

Account Number

This is the General Ledger account number to which the activity will be posted.

Account Description

This is the description of the account number as found in the

General Ledger System.

File Balance

This shows the total dollar amount of balances on accounts that met the criteria indicated.

	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 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 Balancing Report Summary - Differences Only (FPSDR277)

GL File Balancing Report Summary - Differences Only (FPSDR277)