Deposit Reports > Deposit Reports - Numerical Order

Availability

This report must be processed daily to be useful.

Purpose

The Proof Cash In and Out Report aids in balancing the cash drawers for individual tellers. This report is only useful for those institutions using a proof of deposit system. The proof cash-in and cash-out tickets are sorted by teller number. The total cash-ins and cash-outs are calculated. The beginning cash for the day is added to arrive at a net cash amount based on the proof ticket. That amount is compared to the net drawer amount for the processing day, found on the Teller Information Screen (function 419/420) in the Deposit System (Application 4).

GOLDPoint Systems Only: The sorting and subtotal field that must be used for this report is 80 Teller Number (2).

The critical position must be from 1 to 6.

There are no miscellaneous options used on this report.

Report Column Information

See FPSDR032 Example for an example of this report.

Teller Number	This is the teller number that was encoded on the cash-in or cash-out ticket. It is generally pre-encoded on the MICR line of cash-in and cash-out tickets when they are ordered.
Cash In Amount	This is the amount of the item if it was a cash-in ticket.
Cash Out Amount	This is the amount of the item if it was a cash-out ticket.
General Ledger Account Number	This is the General Ledger account number that was encoded on the cash-in or cash-out ticket. The actual posting to the General Ledger is handled through the Autopost system, so it is not necessary to transmit the General Ledger account number with the item. This field may be blank.
Trace Number	This is the trace number of the item in the transmission. It is assigned during the proof processing before the transmission comes to GOLDPoint Systems. It is useful in being able to trace an item back to the original paper item from which it was generated.
Proof Sequence	The proof sequence number is a number assigned by the system to each item in a proof batch. It represents the actual order in which the items were received by GOLDPoint Systems. It is useful on this report to trace the item back to the Proof Items for Posting report to find all items associated with the cash ticket.

Totals and Subtotals Provided

The totals for this report are the teller’s beginning of day balance, total cash in, total cash out, net cash activity, ending drawer balance, and amount out of balance. An amount out of balance total will only appear if a teller’s beginning of day balance plus net cash activity does not equal the end of day balance. Information for these totals is taken from the Teller Information Screen (function 419/420) in the Deposit System (Application 4). Tellers must sign on for Next Day Processing for the current day in GOLDTeller for these totals to pull correctly.

Proof Cash In and Out Report (FPSDR032)

Proof Cash In and Out Report (FPSDR032)