Navigation: Deposit Reports > Deposit Reports - Numerical Order >
Availability
This report should be run daily in the afterhours. It is used in balancing your cash letters for Inclearing and ACH items.
Purpose
The Automated Entry Register includes all monetary ACH and Inclearing transactions. All of these transactions will be printed on the report, whether they posted successfully or were rejected.
The report is printed in ACH batch format, with the transactions sorted by account number within the batch. No sort key fields can be used with this report. Option 1 will insert page breaks on every batch. Option 2 will print the addenda record (ACH 7 record) on each item. Both options require GOLDPoint Systems setup and require a work order.
Note: Inclearing items follow the same format as ACH items. In this documentation, inclearings items are considered ACH items. |
---|
Transactions post to the accounts in a specific order based on transaction origination codes. Deposits post first, then withdrawals, and inclearing checks post last. Transactions post as follows:
TRAN CODE |
TYPE |
TORC |
---|---|---|
1120 |
ATM |
301 |
1120 |
POS |
302 |
1120 |
POS |
316 |
1120 |
ACH |
305 |
1220 |
ACH |
305 |
1120 |
ACH |
309 |
1120 |
ACH |
314 |
|
LOAN |
CREDITS |
|
CDT |
CREDITS |
1130 |
ATM |
301 |
1130 |
ATM |
314 |
|
POS |
302 |
|
POS |
316 |
1130 |
ACH |
305 |
|
CDT |
DEBITS |
|
LOAN |
DEBITS |
1130 |
INCLEARINGS |
306 |
If miscellaneous parameter 5 is set to “Y” (yes), then the account number and amount will not print in payroll batches. This is used in conjunction with the miscellaneous option to exclude names on payroll batches.
GOLDPoint Systems Only: MISCPARM = Prenote. This option will separate all prenote ACH items on a separate report.
MISCPARM = Batch Name. Must begin in position 10, length 15, and be identical to company name in ACH record. This option replaces the customer name with asterisks for internal payroll batches.
OPTION 1 = If "Y," a page break will occur on each batch.
OPTION 2 = If "Y," will print the addenda record (7 record) for each ACH item that has one.
To print addenda record 7, option 2 =Y. To print inclearings only, option 3 =Y. To exclude inclearings, option 4 = Y. Options 3 + 4 = no report. |
---|
Batch Heading Information
See FPSDR002 Example for an example of this report. All information in these fields is taken directly from the ACH transaction batch as sent to GOLDPoint Systems.
Heading |
Description |
---|---|
ACH 7 Record |
This is an addenda file that contains additional information about the transaction such as address, company name, etc. It is optional and requires a work order. |
Company ID |
This is the company identification number of the institution sending this batch of ACH transactions. |
Originator |
This is the name of the institution where this batch of ACH transactions originated. |
Type Description |
This briefly describes the type of transactions in the batch. You may see any of the following descriptions, among others, or an abbreviation of the name of the business originating point of sale ACH transactions:
•Div •Dividends •Drafts •Checks •Ins. Prem. •Insurance Premiums •Payroll •Automatic Payroll Deposits |
Batch Effective Date |
This is the effective date for this batch of ACH transactions. |
Originator ID |
This is the identification number of the originator of this batch of transactions. |
Entry Type |
This is a 3-character code for the type of transactions included in this batch. Several codes may be used. The most common are listed here. POS Point of Sale PPD Prearranged Payments and Deposits RET Returns MTE Machine Transfer Entries |
Batch Total |
This is the total balance for this batch. It can be used to balance with the total lines that follow the individual transactions in the batch. |
Batch Line Item Information
See FPSDR002 Example for an example of this report.
Line Item |
Description |
||
---|---|---|---|
Account Nbr |
This is the office number (DMACTO), account number (DMACTA), and check digit (DMCKDG) of the account used in this ACH transaction. |
||
Customer Name |
This information is taken directly from the incoming ACH data. In the majority of transactions, this will be the name of the owner of the account in the Account Nbrcolumn. |
||
ID Number |
This information is taken directly from the incoming ACH data. It may contain the name of the customer, the payroll number of the customer, the number of the check, etc. |
||
Web Pmt Type |
This is the payment type for ACH transactions done over the web. An “R” in this field stands for recurring, an “S” stands for single. |
||
Trace Number |
This information is taken directly from the incoming ACH data. It is the trace number for the ACH item. |
||
Tape# |
This is the tape number on which this ACH transaction is stored. |
||
Tran Type |
This is a brief description of the type of transaction. This will normally be the same as the type description in the batch header. |
||
Transaction Amount |
This is the amount of this ACH transaction. If the transaction amount is 0 and the batch is ETF, the transaction is a purchase authorization. If the transaction amount is not 0 and the batch is not an ETF, it is a prenote. |
||
Action Taken |
This is a description of the action taken by the system regarding this ACH transaction. If the ACH transaction was posted, “POSTED” will appear in this field. If the transaction was rejected, this column will indicate why the transaction was rejected. If the transaction was posted through Rejected Items Processing, it will appear here as “POSTED SUSPECT.” If the transaction was posted as a fee, it will appear here as “POSTED FEE.” If the error message “ACCOUNT NOT FOUND” appears, the original ACH information will appear so that a notification of change can be created. NOTE: All ACH return and notification of change items will print the original ACH information. The Action Taken column will display either “Return” for returned items or “NOC” for notification of change items. |
||
TORC |
This is the transaction origination code for this transaction. |
||
Effective |
This is the effective date for the batch of ACH transactions just listed. |
||
Settlement |
This is the settlement date for the batch of ACH transactions just listed. |
||
ACH Record |
The ACH(6) record is printed when the account is not found and only the account number was expanded. An example is displayed below. See the italicized line.
The following example is separated into sections. The sections are described below the example.
A is the transaction code. B is the routing transit number. C is the account number. D is the amount. E is the individual identification number. F is the individual name. G is discretionary data. H is the trace number.
The ACH information block is printed when the account is not found AND data was changed in the record. An example of how the information is printed is shown below.
|
Totals and Subtotals Provided
See FPSDR002 Example for an example of this report. Subtotals are provided for each ACH transaction batch for the following:
1.Total Transactions; number and amount
2.Transactions Processed; number and amount
3.Transactions Not Processed; number and amount
4.Transactions Processed Suspect; number and amount
5.Fees Assessed
At the end of the report, institution totals are provided for all ACH transaction batches for the information stated above.