Navigation:  Deposit Reports > Deposit Reports - Numerical Order >

Automated Entry Register (FPSDR002)

Navigation:  Deposit Reports > Deposit Reports - Numerical Order >

Automated Entry Register (FPSDR002)

Previous pageReturn to chapter overviewNext page  Print this Topic

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.

 

paperclipnote

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.

 

honeycombgoldgpsonly

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.

 

fpsdrdr002calc

 

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.

 

paperclipnote

Note: If you use GOLD ExceptionManager option (GEXM) then the detail will be printed for every transaction that is present in the exception file. The 6 record data is never printed.

 

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.

©2021 GOLDPoint Systems. All rights reserved.