ACH Transmission

The ACH file is configured in the Cash Management application in the Banks master file. The deposit amounts come from the same calculations that are used in the Trial Check Report and direct deposit forms.

If your bank does not accept the National Standard (NACH) format, contact Centriq Support for assistance.

To access the ACH Transmission window, go to Payroll > Process Checks > ACH Transmission. [+]

To transmit the ACH file

The Deposit Date field defaults to the date of the current payroll being processed.

  1. In the Transmission Type field, use the drop-down list to select the option that identifies the type of transmission file to create. Choose from the following options: 1 - Deposits Only, 2 - Prenotes Only, or 3 - Both.

  2. The Location of ACH File field displays the directory where the ACH file will be stored as defined in Cash Management > Master Files > Banks > Payroll ACH tab, and cannot be edited.

  3. Click Continue.

  4. A message is displayed stating the transmission was successful. Click OK to close the window.

Once the download file is created, the following message is displayed if the Company master file in Centriq Administration is set up for auto-deletion: Downloads of this type are subject to auto deletion when saved to a local directory. If not saved to a network or shared drive, this file will be deleted on MM/DD/CCYY HH:MM. Click OK to continue. Click Cancel to change the download path. To change the location, go to Cash Management > Master Files > Banks > Payroll ACH tab.

ACH File Layout

National Standard Format

File Header

Field

Positions

Length

NACHA Description

Centriq Parameter at CM > Master Files > Banks > Payroll ACH

Notes/Typical Values

1

01-01

1

Record Type Code

NA

Hard coded value: 1

2

02-03

2

Priority Code

NA

Hard coded value: 01

3

04-13

10

Immediate Destination #

Immediate Destination

Processing bank's routing number

4

14-23

10

Immediate Origin #

Immediate Origin

Typically the payroll company's federal tax ID number; In the file this is right justified and padded with blanks (e.g. parameter value "123456789" creates ACH file value "[blank]123456789")

5

24-29

6

Transmission Date

NA

Program logic uses date of file creation

6

30-33

4

Transmission Time

NA

Program logic uses time of file creation

7

34-34

1

File ID Modifier

File ID Modifier

Select '0-9' for numeric or 'A-Z' for alpha; Current programming only generates '0' or 'A' and does not increment this value when multiple files are created on the same day

8

35-37

3

Record Size

NA

Hard coded value: 094

9

38-39

2

Blocking Factor

NA

Hard coded value: 10

10

40-40

1

Format Code

NA

Hard coded value: 1

11

41-63

23

Destination Name

Immediate Destination Name

Processing bank's name

12

64-89

23

Origin Name

Immediate Origin Name

Payroll company's name

13

87-94

8

Reference Code

Reference Code

Optional field for payroll company's internal use

Company Batch Header

Field

Positions

Length

NACHA Description

Centriq Parameter at CM > Master Files > Banks > Payroll ACH

Notes/Typical Values

1

01-01

1

Record Type Code

NA

Hard coded value: 5

2

02-04

3

Service Class Code

Write Company Debit in ACH file

Value if checked: 200; Value if unchecked: 220

3

05-20

16

Company Name

Company Name

Payroll company's name

4

21-40

20

Company Discretionary Data

Company Discretionary Data

Optional field for payroll company's internal use

5

41-50

10

Company Identification

Company Identification

Typically the payroll company's federal tax ID number; In the file this is right justified and padded with blanks (e.g. parameter value "123456789" creates ACH file value "[blank]123456789")

6

51-53

3

Standard Entry Class Code

NA

Hard coded value: PPD (Prearranged Payments and Deposit entries)

7

54-63

10

Company Entry Description

Company Entry Description

"Payroll" is the typical value

8

64-69

6

Company Descriptive Date

NA

Hard coded value: [blanks]

9

70-75

6

Effective Entry Date

NA

Program logic uses the payroll's pay date

10

76-78

3

Settlement Date

NA

Hard coded value: [blanks]

11

79-79

1

Originator Status Code

NA

Hard coded value: 1

12

80-87

8

Originator ID

Originating DFI Identification

First 8 digits of processing bank's routing number

13

88-94

7

Batch Number

NA

Hard coded value: 0000001; Current programming allows only one batch per file, so this value does not increment

Detail Transactions

DEPOSIT RECORDS:

 

 

 

 

EMPLOYEE ENTRIES

 

 

 

 

Field

Positions

Length

NACHA Description

Centriq Parameter at CM > Master Files > Banks > Payroll ACH

Centriq Parameter at PY > Master Files > Employees > Direct Deposit

Notes/Typical Values

1

01-01

1

Record Type Code

NA

NA

Hard coded value: 6

2

02-03

2

Transaction Code

NA

Type

For deposits, if Type is C - Checking: 22; If Type is S - Savings: 32; If Type is L - Loan: 52

3

04-11

8

Routing/Transit Number

NA

Routing#

First 8 digits of employee bank's routing number

4

12-12

1

Routing Transit Check Digit

NA

Routing#

9th digit of employee bank's routing number

5

13-29

17

Individual Account Number

NA

Account#

The employee's bank account number

6

30-39

10

Amount

NA

Amount/Percent of Net

Program logic uses the correct portion of the employee's net pay as determined by the employee direct deposit setup

7

40-54

15

Individual ID

Use Employee Number instead of Social Security Number in ACH file

Employee Number/Employee SSN

If checked in CM: Employee Number; If unchecked in CM: Employee SSN

8

55-76

22

Individual Name

NA

Employee Last Name/First Name/Middle Name

The employee's name formatted as "Last, First Middle"

9

77-78

2

Discretionary Data

Discretionary Data

NA

Optional field for payroll company's internal use

10

79-79

1

Addenda Indicator

NA

NA

Hard coded value: 0; Current programming does not allow for addenda records

11

80-94

15

Trace Number

Receiving DFI Identification

NA

First 8 digits of Receiving DFI Identification + hard coded sequence starting with 0000001 and incrementing thereafter

 

 

 

 

 

 

 

PAYROLL COMPANY ENTRY (This entry will be written if the "Write Company Debit in ACH" file flag is checked)

 

Field

Positions

Length

NACHA Description

Centriq Parameter at CM > Master Files > Banks > Payroll ACH

Notes/Typical Values

 

1

01-01

1

Record Type Code

NA

Hard coded value: 6

 

2

02-03

2

Transaction Code

Company Debit Transaction Code

27 - Checking; 37 - Savings

 

3

04-11

8

Routing/Transit Number

Receiving DFI Identification

First 8 digits of processing bank's routing number

 

4

12-12

1

Routing Transit Check Digit

Receiving DFI Identification

9th digit of processing bank's routing number

 

5

13-29

17

Company Account Number

DFI Account Number

Payroll company's bank account number

 

6

30-39

10

Amount

NA

Program logic sums the employee entries to obtain the amount

 

7

40-54

15

Company ID

Company ID Number

Typically the payroll company's federal tax ID

 

8

55-76

22

Company Name

Company Name

The payroll company's name

 

9

77-78

2

Discretionary Data

Discretionary Data

Optional field for payroll company's internal use

 

10

79-79

1

Addenda Indicator

NA

Hard coded value: 0; Current programming does not allow for addenda records

 

11

80-94

15

Trace Number

NA

First 8 digits of Receiving DFI Identification + hard coded sequence starting with 0000001 and incrementing thereafter

 

 

 

 

 

 

 

 

PRENOTE RECORDS:

 

 

 

 

EMPLOYEE ENTRIES

 

 

 

 

Field

Positions

Length

NACHA Description

Centriq Parameter at CM > Master Files > Banks > Payroll ACH

Centriq Parameter at PY > Master Files > Employees > Direct Deposit

Notes/Typical Values

1

01-01

1

Record Type Code

NA

NA

Hard coded value: 6

2

02-03

2

Transaction Code

NA

Type

For prenotes, if Type is C - Checking: 23; If Type is S - Savings: 33; If Type is L - Loan: 53

3

04-11

8

Routing/Transit Number

NA

Routing#

First 8 digits of employee bank's routing number

4

12-12

1

Routing Transit Check Digit

NA

Routing#

9th digit of employee bank's routing number

5

13-29

17

Individual Account Number

NA

Account#

The employee's bank account number

6

30-39

10

Amount

NA

NA

For prenotes the amount will be $0.00

7

40-54

15

Individual ID

Use Employee Number instead of Social Security Number in ACH file

Employee Number/Employee SSN

If checked in CM: Employee Number; If unchecked in CM: Employee SSN

8

55-76

22

Individual Name

NA

Employee Last Name/First Name/Middle Name

The employee's name formatted as "Last, First Middle"

9

77-78

2

Discretionary Data

Discretionary Data

NA

Optional field for payroll company's internal use

10

79-79

1

Addenda Indicator

NA

NA

Hard coded value: 0; Current programming does not allow for addenda records

11

80-94

15

Trace Number

Receiving DFI Identification

NA

First 8 digits of Receiving DFI Identification + hard coded sequence starting with 0000001 and incrementing thereafter

Company Batch Control

Field

Positions

Length

NACHA Description

Centriq Parameter at CM > Master Files > Banks > Payroll ACH

Notes/Typical Values

1

01-01

1

Record Type Code

NA

Hard coded value: 8

2

02-04

3

Service Class Code

Write Company Debit in ACH File

Value if checked: 200; Value if unchecked: 220

3

05-10

6

Entry/Addenda Count

NA

Program logic uses total number of detail records in the batch

4

11-20

10

Entry Hash

NA

Program logic sums the routing numbers in the batch

5

21-32

12

Total Debits Dollar Amount

NA

Program logic sums the debit amounts in the batch

6

33-44

12

Total Credits Dollar Amount

NA

Program logic sums the credit amounts in the batch

7

45-54

10

Company Identification

Company Identification

Typically the payroll company's federal tax ID number; In the file this is right justified and padded with blanks (e.g. parameter value "123456789" creates ACH file value "[blank]123456789")

8

55-73

19

Message Authentication Code

NA

Hard coded value: [blanks]

9

74-79

6

Reserved

NA

Hard coded value: [blanks]

10

80-87

8

Originator ID

Originating DFI Identification

First 8 digits of processing bank's routing number

11

88-94

7

Batch Number

NA

Hard coded value: 0000001; Current programming allows only one batch per file, so this value does not increment

File Control

Field

Positions

Length

NACHA Description

Centriq Parameter at CM > Master Files > Banks > Payroll ACH

Notes/Typical Values

1

01-01

1

Record Type Code

NA

Hard coded value: 9

2

02-07

6

Batch Count

NA

Program logic uses the total number of batches in the file; Centriq programming currently allows for one batch

3

08-13

6

Block Count

NA

Program logic uses the number of blocks in the file; Each block is 10 lines in the file

4

14-21

8

Entry/Addenda Count

NA

Program logic uses the total number of detail records in the file

5

22-31

10

Entry Hash

NA

Program logic sums the routing numbers in the file

6

33-43

12

Total Debits Dollar Amount

NA

Program logic sums the debit amounts in the file

7

44-55

12

Total Credits Dollar Amount

NA

Program logic sums the credit amounts in the file

8

56-94

39

Reserved

Write federal tax ID in the File Control record

Value if checked: Tax ID # from Federal Taxes Master; Value if unchecked: [blanks]

Security Record

The Security Character check box in the Banks master file enables this functionality.  This row will not be generated into the file if the box is not checked.  Do not use these parameters if the bank does not require them.

Field

Positions

Length

Centriq Parameter at CM > Master Files > Banks > Payroll ACH

Notes/Typical Values

1

01-09

9

NA

Hard coded value: $$ADD ID=

2

10-17

8

RID

Remote ID

3

18

1

NA

Hard coded value: [blank]

4

19-23

5

NA

Hard coded value: BID='

5

24-29

6

File Type

File Type

6

30-37

8

BID

Batch ID

7

38

1

NA

Hard coded value: '