Deposit Reports > Deposit Reports - Numerical Order

Availability

This report should be run daily in the afterhours and can only be processed one time per night.

Purpose

The Large Transaction Journal provides information by Social Security number for check transactions totaling over the institution set limit for large transactions, or a default value of $3,000.00 for the day.

All check transactions are added up for a particular account. All accounts associated with a Social Security number are then totaled. If the check in or check out totals for each Social Security number are more than the institution limit or the default of $3,000.00, then all accounts associated with that Social Security number are printed with their respective check in and check out totals.

For transactions with no account and Social Security number such as teller check in and check out, a detail line with office number, teller number, transaction code and modifier, and description is placed under the account number, which will be zero. These transactions have no Social Security number or account number, and will be placed at the top of the report if the transaction is $3,000.00 or more.

Any transaction with no Social Security number will be placed at the top of the report. Any transaction with a Social Security number and no account number will be placed individually under the Social Security number. If a corresponding name cannot be found for the Social Security number, "N/A not available" will be shown instead of the name.

The report is typically sorted by Social Security number.

GOLDPoint Systems Only: The amount considered for large transactions is stored in the Misc Parm field. The field is 14-digits long. For $3,000.00, the default is 00000000300000.

In order for this report to function correctly, it needs to run on UPSI13. Reports set up on UPSI13 will run daily.

To process the detail of this report, set Misc Opts 1 to “Y.”

Report Column Information

See FPSDR081 Example for an example of this report.

Column	Description
Account Number	This is the office number (DMACTO), account number (DMACTA), and check digit (DMCKDG) for the account. For teller check in/check out transactions, this column will contain zeros. These types of transactions should appear first on the report.
Soc Sec # or Fed ID#	This is the Social Security number or federal identification number of the person or organization making the check transaction. This number must be entered by the teller when the transaction is performed if it is not associated with an account. If no number is displayed in this field, it means that either this is a teller check in/check out transaction, or that a Social Security number was not entered with this transaction. Transactions with blank Social Security fields will be shown first on the report.
Number Trans	This is the total number of check transactions for the account that were processed on the date the report was run.
Name	This is the name of the person or organization whose Social Security number or federal identification number appears on this line of the report. If the system cannot locate a name for this Social Security number, "N/A NOT AVAILABLE" will appear here.
Journal In	This is the total amount of journal in for this account on the date the report was run.
Journal Out	This is the total amount of journal out for this account on the date the report was run.

Totals and Subtotals Provided

Institution totals are provided for total number of transactions for all accounts and the total check in and out amounts for all account detail lines on the report.

Large Journal Transaction Report (FPSDR081)

Large Journal Transaction Report (FPSDR081)