Deposit Reports > Deposit Reports - Numerical Order

Availability

This file and report must process daily and can only run once per day. To run this report, your bank must have a license for GlobalVision’s PATRIOT OFFICER third-party interface for Bank Secrecy Act (BSA) compliance.

Purpose

PATRIOT OFFICER is a product of GlobalVision Systems, Inc., that is used to help financial institutions comply with BSA, OFAC, and USA Patriot Act requirements. PATRIOT OFFICER 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 PATRIOT OFFICER that identify risks specific to the customer. New name records in CIS/CIS are checked each day against the OFAC and other required lists, including new names added to the government lists. In addition, the lists are checked against all names at monthend.

PATRIOT OFFICER creates a master file that is sent each day for the prior day’s work to the PATRIOT OFFICER database stored on a server at GOLDPoint Systems. Data is sent based on specifications and fields that the PATRIOT OFFICER software uses to examine transactional and customer information in order to help your bank comply with your Bank Secrecy Act program.

A file is uploaded and a report is created for your institution each day. Account numbers are sent based on your institution format. There are seven different categories of transactions sent in the file each day. They are based on the transaction code, transaction type, and funding type (cash, check, or journal).

Monetary Instruments

Cashier’s checks, money orders, and traveler’s checks—transaction codes 1410, 1420, and 1440. (If the monetary instrument transaction contains any journal amounts, they will be processed in the “Other’”category.)

ATM Transactions

Any transaction that is processed at a point-of-sale (POS) device, or deposits made at the ATM.

ACH Transactions

Any transaction that is processed as an ACH debit or credit, including Federal Reserve ACH and outgoing customer direct transfer (CDT) transactions. (POP, ARC, and BOC transactions originated through ACH will be processed in the “Check’”category.)

Wire Transfers

Any transaction processed in GOLDTeller as a tran code 1750 (Misc Debit) or 1780 (Misc Credit) descriptors 38, 39, 40, or 41. Wire transfers processed through EFT GOLD are exported to PATRIOT OFFICER through a separate process and are therefore not included on this report (1750/3 and 1780/3).

Transfer Transactions

Any transaction that is processed as a transfer in or transfer out.

Check Transactions

Any transaction that is processed with check in or check out as the funding type, including inclearing, on-us, and check deposits, POP, ARC, and BOC SEC codes through ACH. In addition, charge-back transactions processed with transaction code 1750, descriptor 20.

Cash Transactions

Any transaction that is processed with cash in or cash out as any portion of the funding type, including ATM cash withdrawal.

Other Transactions

Any transaction that is not identified by some other transaction category. This includes such things as interest, interest withholding, service charges, fees, journal transactions, and any other system-generated transaction that affects the balance of the account.

The initial files that are created for your institution are processed manually during the day. GOLDPoint Systems will send master and transaction data for the period you specify. This time frame is contingent upon how much history you store for your accounts. The default is 90 days.

Any transaction processed as a correction on the same day as the original transaction will be ignored, along with the original transaction. Any correction processed on a different day than the original transaction will be sent in the file as the reverse of the original transaction. For example, if a correction transaction is processed for a deposit by cash, the correction will be sent as a “cash out” transaction in order to make the net of all transactions for that customer report accurately.

Report Column Information

This report can be sorted and subtotaled by branch, account number, customer identification number, or transaction classification (CLASS). See FPSDR211 Example for an example of this report.

Column Heading	Description
Account Number	This is the office number (DMACTO), account number (DMACTA), and check digit (DMCKDG) for the account.
Customer ID	This is the tax ID number of the IRS owner of the account. This number identifies the customer to the PATRIOT OFFICER system.
Tran-MD-TORC	This is the transaction code, transaction modifier, and transaction origination code of the transaction listed.
Trans Date	This is the date or as-of date, if applicable, that the transaction occurred.
Class	This is the transaction classification. It corresponds to the PATRIOT OFFICER classification for the transaction listed. Note that–with the exception of monetary instruments–if a transaction contains multiple amount components (such as cash in or check out), then each amount is exported as a separate transaction to the PATRIOT OFFICER system. Valid values for this column are CASH, CHECK, ATM, ACH, XFER, MOI (monetary instrument), WIRE, and OTHER.
Credit Amt	This is the amount reported to the PATRIOT OFFICER system as the total credit amount of the transaction.
Debit Amt	This is the amount reported to the PATRIOT OFFICER system as the total debit amount of the transaction.
Net Cash	This is the net (credit – debit) amount of cash associated with the transaction.
Net Check	This is the net (credit – debit) amount of checks associated with the transaction.
Net Journal	This is the net (credit – debit) amount of journal associated with the transaction.
Transaction Description	This is an optional field that can be included on the report as an additional print line below the net amount information outlined above. It shows the description that was sent to the PATRIOT OFFICER system for each transaction.

Totals and Subtotals Provided

Totals are provided for the number of transactions, the credit amount, and the debit amount.

GOLDPoint Systems Only: Input Records: DM, MN, TG for daily run; DM, MN, DZ for special runs.

Misc Parm: Days = 090 (as the default for number of days for history sent in special report); must be blank on daily run. The institution can determine this value.

Misc Opts: 15 and 16 must be set to “Y” for a special run and Days = 001 to run for a specific date.

Misc Opts: Used to send specified categories in file:

1. Set to “Y” for Cash transactions

2. Set to “Y” for ACH transactions

3. Set to “Y” for ATM transactions

4. Set to “Y” for Other transactions

5. Set to “Y” for Check transactions

6. Set to “Y” for Monetary instruments

7. Set to “Y” for Transfer transactions

8. Set to “Y” for Wire transfer transactions

9. Set to “Y” for the transaction description line

These options control the data sent to PATRIOT OFFICER and should all be set, except when special runs for individual files are necessary.

JCL must be set up in order for the PATRIOT OFFICER files to process. FPSDR211, FPSRP290, and the configuration for each bank must be set up on the PATRIOT OFFICER server for daily transmissions.

FPatriot is the program used to send all name and address information to the PATRIOT OFFICER database. FPatriot processes with PATRIOT OFFICER each day, sending the names and addresses changed that day. To catch up any records not previously sent, the prior run date can be changed to incorporate all the records needed by using it as the new start date.

Sort Options Available:

•80 - Office number (length 2)

•81 - Account number (length 5)

•82 - Customer ID (length 11)

•83 - Transaction classification (length 5)

PATRIOT OFFICER® Transaction File (FPSDR211)

PATRIOT OFFICER® Transaction File (FPSDR211)