Reviewing GL ACH History

Related Topics

The GL ACH History Inquiry dialog box displays ACH entry detail for a specific GL account (transaction codes 42 and 47). A 170 button will appear on the GL History – Prior Day window if the GL entry was posted via ACH. Click the button to view the GL ACH History Inquiry dialog box.

GL ACH History Inquiry

How do I? and Field Help

You can use the GL ACH History Inquiry dialog box to help you complete the Notification of Change window or to confirm how/why/why not a general ledger item posted. Click Close to close the dialog box.

Field Description
Account Number

The member's account number, or the general ledger account number followed by the branch.

Reporting Analytics: ACH Information » ACH General Ledger History » ACCOUNT NUMBER

Account Name

The name of the member associated with the account.

Reporting Analytics: ACH Information » ACH General Ledger History » ACH MEMBER NAME

Payroll ID

The payroll/transfer group number.

Reporting Analytics: ACH Information » ACH General Ledger History » PR NBR

Batch Description

The description of the items in the batch. The description will appear on the member's statement.

Length: 10 alphanumeric

Keyword: DE

Reporting Analytics: ACH Information » ACH General Ledger History » BATCH DESC

Batch Discretionary Data

The batch discretionary data. This information can be used to enable special handling of ACH items in the batch, as defined by the originating and the receiving financial institutions.

Length: 20 alphanumeric

Keyword: BD

Reporting Analytics: ACH Information » ACH General Ledger History » BATCH DISC DATA

Standard Entry Class

The type of items in the batch. The valid options are:

ACK - ACH Payment Acknowledgment

ADV - Automated Account Advices

ARC - Accounts Receivable Entry

ATX - Financial EDI Acknowledgment

BOC - Back Office Conversion

CCD - Corporate Credit or Debit

CIE - Customer Initiated Entries

COR - Automated Notification of Change

CTP - Corporate Trade Payment

CTX - Corporate Trade Exchange

DNE - Death Notification Entries

ENR - Automatic Enrollment Entry

IAT - International ACH Transaction

MTE - Machine Transfer Exchange

POP - Point of Purchase Entry

POS - Point of Sale

PPD - Pre-arranged Payments and/or Deposits

RCK - Represented Check Entry

TEL - Telephone Initiated Entry

TRC - Truncated Entries

TRX - Truncated Entries Exchange

WEB - Internet Initiated

XCK - Destroyed Check Entry

Length: 3 alphanumeric

Keyword: SE

Reporting Analytics: ACH Information » ACH General Ledger History » STND ENTRY

Service Class Code

The service class code for the batch which the item is in. The valid options are:

200 - ACH Entries Mixed Debits and Credits

220 - ACH Credits only

225 - ACH Debits only

280 - ACH Automated Accounting Advices

  • If the Service Class Code field is 200, 220 or 280, the NACHA Transaction Code field should be 22, 23, 32 or 33.
  • If the Service Class Code field is 200, 225 or 280, the NACHA Transaction Code field should be 27, 28, 37, or 38.
  • If the NACHA Transaction Code field is 24 or 34, the Service Class Code field must be 200 (for Acknowledgments).

This information also appears in the ACH Received in Order of Transmission section of the 170 Report.

Length : 3 alphanumeric

Keyword: SC

Reporting Analytics: ACH Information » ACH General Ledger History » SERVICE CLASS

Routing/Transit

The routing and transit number of the originating financial institution for an ACH transaction.

Length: 8 numeric

Keyword: OR

Reporting Analytics: ACH Information » ACH General Ledger History » OFI ROUTE TRNST

Company ID

The unique company ID of the originator of the ACH transaction. The originator can be the credit union or the company sending the ACH item. For ACH scheduled transfers, you can leave this field blank if posting by company name and/or OFI. On the ACH Processing Options window, enter zeroes in this field if posting by company name or batch description.

Length: 10 alphanumeric

Keyword: CI

Reporting Analytics: ACH Information » ACH General Ledger History » COMPANY ID

Company Name

The name of the originating financial institution as it should appear at the receiving institution.

The company name, OFI, and/or company ID can be used as the criteria for posting ACH. The company name can be used in addition to the OFI and/or company ID to post ACH or in place of the OFI and/or company ID. You can leave this field blank if posting by company ID and/or OFI.

To post by company name only on the Member Transfer File Information dialog box, specify the company name in this field. The company name must be an exact match to the company name appearing on the ACH file. Leave the Originating Financial Institution and Company ID fields blank.

On the ACH Processing Options window:

  • To post by company name only, specify the company name in this field. The company name must be an exact match to the company name appearing on the ACH file. Leave the Originating Financial Institution field blank. In the Company ID field, enter zeroes. The Post by Company Name check box must be selected on the Credit Union Profile – ACH/Payroll tab to post ACH items through the post by company name only table first.
  • To post by batch description, specify the batch description in this field. The batch description must be an exact match to the batch description appearing on the ACH file. Leave the Originating Financial Institution field blank. In the Company ID field, enter zeroes. The Post by Batch Description check box must be selected on the Credit Union Profile – ACH/Payroll tab to post ACH items through the post by batch description table first. If the Match On field is Batch Description on the ACH Processing Options window, Portico will only allow 10 characters in the field.

Length: 16 alphanumeric

Keyword: CN

Reporting Analytics: ACH Information » ACH General Ledger History » COMPANY NAME

Item Descriptive Date

The ACH item descriptive date.

Length: 6 numeric in MM/DD/YY format

Keyword: DD

Reporting Analytics: ACH Information » ACH General Ledger History » DESC DATE

Individual ID

The individual identification number that is the accounting number by which the receiver is known to the originator. For incoming Person-to-Person (P2P) transactions using the code ‘WEB,’ the sender’s name will appear in the Individual ID field on the incoming transaction. To help your members determine where a transaction originated, Portico will move the name from the Individual ID field to the Statement Description field in the member's financial transaction history.

Length : 22 alphanumeric

Keyword: II

Reporting Analytics: ACH Information » ACH General Ledger History » INDIVIDUAL ID

Effective Date

The date on which settlement should occur for ACH origination items. Or, the date on which the NOC was sent for ACH NOC items.

Length: 6 numeric in MM/DD/YY format

Keyword: ED

Reporting Analytics: ACH Information » ACH General Ledger History » EFFECTIVE DATE

Bank Account Number

The bank account number for the ACH item.

Length: 17 alphanumeric

Keyword: BI

Reporting Analytics: ACH Information » ACH General Ledger History » BANK ACCT NBR

Trace Number

The trace number assigned by the originating institution.

Length: 7 alphanumeric

Keyword: TR

Reporting Analytics: ACH Information » ACH General Ledger History » SHORT TRACE

Discretionary Data

The discretionary data (DD) code as specified on the ACH file and is used to additionally qualify an ACH item. This field will be blank if there is not a DD code on the ACH file.

If the item is a point-of-sale (POS) transaction that you are returning, you must specify a card transaction type code in this field even if the item was sent to Fiserv without a discretionary data code. If you do not, the Federal Reserve Bank will reject the item with an R26 - Mandatory Field Error. The valid card transaction code types are:

01 - Purchase of goods or services

02 - Cash

03 - Return reversal

11 - Purchase reversal

12 - Cash reversal

13 - Return

21 - Adjustment

99 - Miscellaneous transaction

Length: 2 alphanumeric

Keyword: ID

Reporting Analytics: ACH Information » ACH General Ledger History » ITEM DISC DATA

NACHA Txn Code

The required NACHA transaction code specified on the item received. The system will convert the incoming ACH transaction code to the appropriate transaction code. The valid options for the GL ACH History Inquiry dialog box are:

42 - Credit to General Ledger

47 - Debit to General Ledger

Reporting Analytics: ACH Information » ACH General Ledger History » TXN CODE

Name The financial institution member name used in association with ACH item processing.
Txn Amount

The amount of this ACH transaction. A valid ACH transaction amount can be 0 through 99,999,999.99.

Length: 11 numeric including decimal

Keyword: AM

Reporting Analytics: ACH Information » ACH General Ledger History » TRANSACTION AMOUNT

Additional Reporting Analytics Query Items:

Reporting Analytics: ACH Information » ACH General Ledger History » ACTUAL DATE

Reporting Analytics: ACH Information » ACH General Ledger History » CAN

Reporting Analytics: ACH Information » ACH General Ledger History » Return Date

Reporting Analytics: ACH Information » ACH General Ledger History » SYSTEM DTE

Reporting Analytics: ACH Information » ACH General Ledger History » SYSTEM TIME

Reporting Analytics: ACH Information » ACH General Ledger History » CUID