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. [+]
The Deposit Date field defaults to the date of the current payroll being processed.
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.
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.
Click Continue.
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.
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 |
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 |
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 |
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 |
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] |
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: ' |