Deposit Reports > Deposit Reports - Numerical Order

Availability

This report should be processed daily in the afterhours.

Purpose

Verafin is used to help financial institutions comply with BSA, OFAC, and USA Patriot Act requirements. Verafin accumulates data that is supplied from GOLDPoint Systems loan and deposit systems and performs various calculations using the data. This data can then be accessed through features of Verafin that identify risks specific to the customer. New name records in CIF are checked each day against the OFAC and other required lists, including new names added to the government lists.

The Verafin Balancing Report lists all transactions sent to Verafin for BSA, AML, and other compliance and risk monitoring. The purpose of this report is to reconcile what was sent to Verafin with what was posted to customers’ accounts for the current run date. The report subtotals the activity based on how the transaction was categorized in the export to Verafin (e.g., cash, check, ATM, transfer, etc.) and categorizes all amounts into cash, check, and journal amounts. The totals on this report should balance with those listed at the end of the Verafin version of the Teller Posting Journal (FPSDR034).

Report Column Information

See FPSDR236 Example for an example of this report.

Column Heading	Description
Class	This column lists how the transaction was categorized or classified in the Verafin export. For example, ACH, ATM, Cash, Wire, etc.
Account Number	This column shows the account classification sent to Verafin (e.g. DDA, SAV, LNA) followed by the deposit or loan account number.
Date	This is the date the transaction was posted to the account.
HH:MM	This is the time the transaction was posted to the account.
Tran-MD	This is the host transaction code and modifier.
Cash In	This column shows the portion of the transaction amount that was sent to Verafin as cash in.
Cash Out	This column shows the portion of the transaction amount that was sent to Verafin as cash out.
Check In	This column shows the portion of the transaction amount that was sent to Verafin as check In.
Check Out	This column shows the portion of the transaction amount that was sent to Verafin as check out.
JNL In	This column shows the portion of the transaction amount that was sent to Verafin as journal in.
JNL Out	This column shows the portion of the transaction amount that was sent to Verafin as journal out.

Totals and Subtotals Provided

The total number of transactions, total cash in and out, total check in and out, total journal in and out, and the overall total in and out are listed at each change in transaction classification. These totals are also provided in aggregate at the end of the report.

A list of adjustments to the various cash, check, and journal amounts is printed following the final totals. These adjustments are necessary to account for differences in the way some transactions are classified for Verafin reporting versus how the transaction is posted to account history. These adjustments are:

•Adjustments to Cash In and Cash Out: Non-customer cash—Cash transactions run for a non-customer (e.g., bond redemption) are reported to Verafin under the tax ID entered by the teller. However, some of these transactions are not included in the totals on the teller posting journal and are therefore adjusted here.

•Adjustments to Check In: Checks cashed—Only the cash portion of a 1400-03 check cashing transaction is sent to Verafin. However the teller posting journal lists and totals both the check in and cash out amounts. Therefore, the total check in amount of these transactions is added to the Verafin check in total to balance with the teller posting journal.

•In addition to the adjustments listed here, other adjustments to reconcile the Verafin Balancing Report (FPSDR236) with the Teller Posting Journal (FPSDR034) are listed on the Verafin Balancing section of the Teller Posting Journal. Please refer to the Teller Posting Journal (FPSDR034) documentation for an explanation of these adjustments.

	GOLDPoint Systems Only: No miscellaneous options or parameters are defined for this report. Set the Sort Key Fields order to "80," "81," and "82." Set the Sort Key Starting Critical Position to "1" and the Sort Key Ending Critical Position to "11."