Deposit Reports > Deposit Reports - Numerical Order

Availability

This report should be run daily in the afterhours.

Purpose

The Daily Institution Balancing Report accumulates the office totals found in each report section on the Daily Office Balancing Report (FPSDR194), then compiles them into one institution report. No miscellaneous options are used on this report. The report will sort by office number within each section of the report.

	Note: This report should typically be run in conjunction with the Daily Office Balancing Report (FPSDR194), which provides detail by teller for each report section.

The report includes the following 12 sections. See FPSDR195 Example for an example of each section:

1.Ending Cash Balances

2.Bank Deposits

3.Bank Withdrawals

4.Sell Cash to Branch

5.Buy Cash from Branch

6.Teller Cash Transfers

7.Teller Checks In Transfers

8.Teller Shorts

9.Teller Overs

10.G/L Cash Disbursements

11.Checks Cashed

12.Checks Issued/Voided

	Note: If no data appears for a particular section on the report, then that section will not be generated. Please refer to the documentation for the Daily Office Balancing Report (FPSDR194) for more information on how the totals are generated for each section of the report.

Information for Section 1: Ending Cash Balances

Column	Description
Office	This is the office number for which we are displaying the cash balances from the Deposit System and the General Ledger.
Ending Cash Balances	This is the total of the ending teller cash drawer balances for that office. Teller ending cash drawer balances are pulled from the Net Drawerfield on the Deposits > Definitions > Teller Information screen in CIM GOLD.
G/L Balance	This is the balance in the office’s General Ledger cash account at the time the report is run. The General Ledger cash account is set up in institution option GLCA.
Difference	This is the difference between the Ending Cash Balances and the G/L Balance columns on this report. The difference will be shown for the entire office.

Information for Section 2: Bank Deposits

Column	Description
Office	This is the office number where tellers performed the bank deposit transactions.
Cash	This is the total amount of cash deposited by all tellers in each office. Cash deposits are accounted for on the system when a teller runs a 1560 transaction code or a 1559 correction transaction code by cash. Both 1560 correction transactions and 1559 transactions reduce the total amount of cash deposits.
Checks	This is the total amount of check deposits made by all tellers in that office. Check deposits are accounted for on the system when a teller runs a 1559 correction transaction. The 1559 transactions reduce the total amount of check deposits.
Total	This is the total amount of all cash and check deposits made by each office.

Information for Section 3: Bank Withdrawals

Section 3 provides a total per office of bank withdrawal transactions.

Column	Description
Office	This is the office number where tellers performed the bank withdrawal transactions.
Amount	This is the total amount of bank withdrawals made by all tellers in each office. Bank withdrawals are accounted for on the system when a teller runs a 1570 transaction code. Withdrawals are reflected as a negative amount. The 1570 correction transactions reduce the total amount of bank withdrawals.

Information for Section 4: Sell Cash to Branch

Column	Description
Office	This is the office number where tellers performed the sell cash to branch transactions.
Amount	This is the total amount of cash sold to the branch by all tellers in each office. The amount of cash sold to the branch is accounted for on the system when a teller runs a 1572 transaction code. Cash sold to the branch is reflected as a negative amount. The 1572 correction transactions reduce the total amount of cash sold to the branch.

Information for Section 5: Buy Cash From Branch

Section 5 provides a total per office of buy cash from branch transactions.

Column	Description
Office	This is the office number where tellers performed the buy cash from branch transactions.
Amount	This is the total amount of cash bought from the branch by all tellers in each office. The amount of cash bought from the branch is accounted for on the system when a teller runs a 1573 transaction code. Cash bought from the branch is reflected as a positive amount. The 1573 correction transactions reduce the total amount of cash bought from the branch.

Information for Section 6: Teller Cash Transfers

Section 6 provides a total per office of cash transfer transactions.

Column	Description
Office	This is the office number where tellers performed the cash transfer transactions.
Amount	This is the total amount of cash transfers made by all tellers in each office. Cash transfers are accounted for on the system when a teller runs a 1520, 1521, 1530, 1531, 1540, 1541, 1550, or 1551 transaction code. Transaction codes 1520, 1521, 1540, and 1541 are reflected as negative amounts in the cash transfers total, while corrections are reflected as positive amounts. Transaction codes 1530, 1531, 1550, and 1551 are reflected as positive amounts in the cash transfers total, while corrections are reflected as negative amounts.

Column

Description

Office

This is the office number where tellers performed the cash transfer transactions.

Amount

This is the total amount of cash transfers made by all tellers in each office. Cash transfers are accounted for on the system when a teller runs a 1520, 1521, 1530, 1531, 1540, 1541, 1550, or 1551 transaction code. Transaction codes 1520, 1521, 1540, and 1541 are reflected as negative amounts in the cash transfers total, while corrections are reflected as positive amounts. Transaction codes 1530, 1531, 1550, and 1551 are reflected as positive amounts in the cash transfers total, while corrections are reflected as negative amounts.

Information for Section 7: Teller Checks In Transfers

Section 7 provides a total per office of check in transfer transactions.

Column	Description
Office	This is the office number where tellers performed the check in transfer transaction.
Amount	This is the total amount of check in transfers made by all tellers in each office. Check in transfers are accounted for on the system when a teller runs a 1555 transaction code. A 1555 transaction code is reflected as a positive amount in the checks in transfers total, while a 1555 correction is reflected as a negative amount.

Information for Section 8: Teller Shorts

Section 8 provides a total per office of teller short transactions.

Column	Description
Office	This is the office number where tellers performed the teller short transactions.
Amount	This is the total amount of short transactions run by all tellers in each office. Teller shorts are accounted for on the system when a teller runs a 1510 or 1511 transaction code. Teller shorts are reflected as negative amounts. 1510 or 1511 correction transactions reduce the total amount of teller shorts.

Information for Section 9: Teller Overs

Section 9 provides a total per office of teller over transactions.

Column	Description
Office	This is the office number where tellers performed the teller over transactions.
Amount	This is the total amount of over transactions run by all tellers in each office. Teller overs are accounted for on the system when a teller runs a 1500 or 1501 transaction code. Teller overs are reflected as positive amounts. The 1500 or 1501 correction transactions reduce the total amount of teller overs.

Information for Section 10: G/L Cash Disbursements

Section 10 provides a total per office of G/L cash disbursement transactions.

Column	Description
Office	This is the office number where tellers performed the G/L cash disbursement transactions.
Amount	This is the total amount of G/L cash disbursement transactions run by all tellers in each office. G/L cash disbursements are accounted for on the system when a teller runs an 1800 transaction by cash out or an 1810 correction by cash in. G/L cash disbursements are reflected as positive amounts.

Information for Section 11: Checks Cashed

Section 11 provides a summary of the total amount of checks cashed that particular day by the institution.

Column	Description
Office	This is the office number where tellers performed the check cash transactions.
Amount	This is the net amount of checks cashed by the institution that day. This is a 1400 transaction with any modifier. The amount of a check cashing transaction is shown as a positive amount. Any corrections are shown as negative on the report and are subtracted from the total.

Information for Section 12: Checks Issued/Voided

Section 12 provides a summary of the total amount and quantity of checks issued and/or voided that particular day by the institution.

Column	Description
Source	This field is a three-character code that defines where the checks were originated. Some examples of what you could see in this field are “TLR” for a teller-originated check, “A/P” for an Accounts Payable check, or “GTP” for a GOLDTrak PC check.
Amount Issued	This is the total amount of checks that have been issued by the institution that day.
Nbr Issued	This is the total quantity of checks that have been issued by the institution that day.
Amount Voided/Cross Ref	This is the total amount of checks that have been voided by the institution that day.
Nbr Voided/Cross Ref	This is the total quantity of checks that have been voided by the institution that day.
Net Total	This is the net amount of checks issued by the institution that day. The net total is equal to the difference between the amount issued and the amount voided.

Totals and Subtotals Provided

Institution totals are provided for each section on the report. Subtotals by office with information about individual tellers for each section of the report are generated on a separate report, the Daily Office Balancing Report (FPSDR194).

Daily Institution Balancing Report (FPSDR195)

Daily Institution Balancing Report (FPSDR195)