Question

Where the information coming from in IFS to an ACH file

  • 17 March 2022
  • 3 replies
  • 364 views

Userlevel 3
Badge +9

This is the ACH output file sent to the bank.

 

 

1234567891123456789212345678931234567894123456789512345678961234567897123456789812345678991234

Sample Batch Header:

5220Company Name                        1999999999PPDPayroll   YYMMDDYYMMDD   1042000010000001

 

 

 

And below are the fields of the ACH file

 

 

 

 

FIELD

POSITION

SIZE

CONTENTS

DESCRIPTION

1

01-01

1

5

Record Type Code / NACHA MANDATORY FIELD

 

 

 

 

 

2

02-04

3

 

Service Class Code / NACHA MANDATORY FIELD                             200 - Mixed Debits and Credits                        220 - Credits Only                                        225 - Debits Only

 

 

 

 

 

3

05-20

16

 

Company Name – Name of the company by which it is known to & readily recognized by the Receiver of the entry, left justify, blank fill / NACHA MANDATORY FIELD

 

 

 

 

 

4

21-40

20

 

Company Discretionary Data - Company Information significant only to your company, left justify, blank fill /  NACHA OPTIONAL FIELD

 

 

 

 

 

5

41-50

10

 

Company ID - Nine digit Federal Tax ID with a '1' as first character unless notified by U.S. Bank that first character will be different / NACHA MANDATORY  FIELD

 

 

 

 

 

6

51-53

3

 

**Standard Entry Class Code – Applicable code (see below) / NACHA MANDATORY FIELD

 

 

 

 

 

7

54-63

10

 

Company Entry Description - Description of what entries are (payroll,..) left justify, blank fill/ NACHA MANDATORY FIELD

 

 

 

 

 

8

64-69

6

YYMMDD

Company Descriptive Date / NACHA OPTIONAL FIELD

 

 

 

 

 

9

70-75

6

YYMMDD

Effective Entry Date - Date transactions are to post to the receiving account / NACHA REQUIRED FIELD

 

 

 

 

 

10

76-78

3

 Blanks

Settlement Date - Blank spaces, Inserted by ACH Operator

 

 

 

 

 

11

79-79

1

1

Originator Status Code / NACHA MANDATORY FIELD

 

 

 

 

 

12

80-87

8

04200001

Originating DFI Identification - U.S. Bank routing-transit number (1st eight characters) / NACHA MANDATORY FIELD

 

 

 

 

 

13

88-94

7

 

Batch number - Indicate first batch by '1' sequentially increasing with each batch, right justify, zero fill / NACHA MANDATORY FIELD

 

 

EDCO Products, need to know where the information coming to these fields in ACH file,

 

Specially “effective entry date “

 

 

70-75

6

YYMMDD

Effective Entry Date - Date transactions are to post to the receiving account / NACHA REQUIRED FIELD


This topic has been closed for comments

3 replies

Userlevel 2
Badge +2

Hi Kanischka,

 

you should update the electronic bank details on your supplier master data (tab payment of supplier in IFS).

to create an ACH file for a domestic payment in United State, please enter the following value in electronic bank details :

Service level code : NURG

Local Instrument : /CCD

Payment Method : TRF

Clearing System Code : USABA

clearing systement member ID : ACH routing number from your supplier

 

Regards

Audrey

Userlevel 3
Badge +9

Hi Audrey,

 

thanks for the reply, but 

from where the information coming to the field effective entry date  in ACH file,

 

70-75

6

YYMMDD

Effective Entry Date - Date transactions are to post to the receiving account / NACHA REQUIRED FIELD

 

Userlevel 4
Badge +6

Hi @Kanishka Madushanka,

According to my understanding, i hope the Effective Entry Date is picked from the “Payment Date” field of the transaction from Supplier/Customer Payment Order window.

Hope this clarifies your question. Please let me know if you have any concerns.

Regards,

Lihini.