PrompTax Withholding Tax ACH Credit Format
Record format specifications and layout
For ACH Credit Withholding Tax (WT) payments, the Tax Department uses the National Automated Clearing House Association (NACHA) Cash Concentration and Disbursement Plus One Addenda Record (CCD+) format.
There are two sections you must complete for the ACH Credit transaction:
- Record 6 (ACH Credit payment) - Includes the payment information, including to whom, how much and from whom.
- Record 7 (CCD+ Special Addenda Record) - Includes required WT return information.
The specifications and layouts, including examples, for Record 6 and Record 7 are detailed on the following pages. All ACH Credit WT payments must adhere to these specifications so that they can be properly identified and correctly applied by the Department.
Field description | Field position | Field size | Field input | Notes |
---|---|---|---|---|
Record type code | 1 | 1 | 6 | Input is always '6'. |
Transaction code | 2-3 | 2 | 22 | Input is always ‘22'. |
Receiving Depository Financial Institution (RDFI) | 4-12 | 9 | 121000248 | Input is always ‘121000248'. |
DFI account number | 13-29 | 17 | This is the Tax Department's bank account number. |
Please call PrompTax customer service at 518-457-2332 between the hours of 8:30 a.m. and 4:30 p.m. EST to obtain this number. Left justify and leave the last spaces in the field blank. |
ACH credit $ amount | 30-39 | 10 | $$$$$$$$cc | This is the amount of tax that will be remitted to the State of New York. This field is 10 positions, right-justified, numeric and without a decimal point or commas. Any unused spaces should be filled with zeros. |
Total withholding tax payment \1 | 40-54 | 15 | $$$$$$$$$$$$$cc | This is the total amount of New York State, New York City and Yonkers Tax withheld. Input is right justified, numeric and without a decimal between dollars and cents. Any unused spaces should be filled with zeros. |
Company legal name\2 | 55-76 | 22 | Alpha-numeric |
This is the name of the company remitting payment. Input is left-justified and alpha-numeric. Any unused field positions should be left blank. If your company name is longer than the 22 characters available, you should enter the first 22 characters just as they appear on your PrompTax enrollment application. |
Discretionary data | 77-78 | 2 | Alpha-numeric | Optional. |
Addenda record indicator | 79 | 1 | 1 | Input is always '1'. |
Trace Number | 80-94 | 15 | Numeric | For bank use. |
\1 - This field is typically named "Individual Identification Number" in NACHA standards publications. Although optional, it is recommended that taxpayers (if ACH credit originating software permits and if the field is not otherwise used by your company) enter in this field the total tax withheld, which is the sum of the individual liability fields, i.e., NYS tax withheld, NYC tax withheld, Yonkers tax withheld, on Record 7.
\2 - This field is typically named "Individual Name" in NACHA standards publications. It is formatted for this record to provide for entry of the taxpayer's name as it appears on the PrompTax registration application. Although optional, it is strongly recommended for control and identification purposes.
Sample ACH Credit PrompTax Payments Using CCD+ Format
XYZ Corporation is making an ACH credit payment for $150,575.00
Field position | 1 | 2 | 4 | 13 | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Value | 6 | 2 | 2 | 1 | 2 | 1 | 0 | 0 | 0 | 2 | 4 | 8 | Call the department to obtain our 10-digit bank account number. |
Field position | 30 | 40 | |||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Value | 0 | 0 | 1 | 5 | 0 | 5 | 7 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 5 | 0 | 5 | 7 | 5 | 0 | 0 |
Field position | 55 | |||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Value | X | Y | Z | C | O | R | P | O | R | A | T | I | O | N |
Field position | 77 | 79 | 80 | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Value | 1 |
Field description | Field positions | Min/max field size | Field input | Footnote |
---|---|---|---|---|
Record type | 1 | 1 | 7 | Input is always '7'. |
Addendum type code | 2-3 | 2 | 05 | Input is always '05'. |
Segment identifier | 4-6 | 3/3 | TXP | Input is always 'TXP'. |
Separator | 7 | 1/1 | * | |
Taxpayer identification | 8-22 | 1/15 | Alpha-numeric | Input is left-justified. Any unused positions should remain blank. Do not include check digit. |
Separator | 23 | 1/1 | * | |
Tax type code | 24-28 | 1/5 | WT | Input is always 'WT'. |
Separator | 29 | 1/1 | * | |
Payroll date | 30-35 | 6/6 | YYMMDD (numeric) | This is the date of the payroll which you are reporting. Input is always numeric and in YYMMDD format. |
Separator | 36 | 1/1 | * | |
Amount type code | 37 | 1/1 | S | If you have a liability to report, input is always 'S' denoting State. If reporting no State liability, continue to the next field entry. |
Separator | 38 | 1/1 | * | |
NYS tax withheld | 39-48 | 1/10 | Numeric | This is your New York State tax withheld. Do not put a decimal between dollars and cents. If your liability is zero, leave blank and continue to the next field entry. |
Separator | 49 | 1/1 | * | |
Amount type code | 50 | 1/1 | C | If you have a liability to report, input is always 'C', denoting City. If reporting no City liability, continue to the next field entry. |
Separator | 51 | 1/1 | * | |
NYC tax withheld | 52-61 | 1/10 | Numeric | This is your New York City tax withheld. Do not put a decimal between dollars and cents. If your liability is zero, leave blank and continue to the next field entry. |
Separator | 62 | 1/1 | * | |
Amount type code | 63 | 1/1 | L | If you have a liability to report, input is always 'L', denoting Local. If reporting no Local liability, continue to the next field entry. |
Separator | 64 | 1/1 | * | |
Yonkers tax withheld | 65-74 | 1/10 | Numeric | This is your Yonkers City tax withheld. Do not put a decimal between dollars and cents. If your liability is zero, leave blank and continue to the next field entry. |
Separator | 75 | 1/1 | * | |
Access code | 76-81 | 6/6 | Numeric | This is a confidential number provided by the New York State Department of Taxation and Finance. Input is always your six digit number. |
Segment terminator | 82 | 1/1 | \ | Input is always '\'. |
Filler | 83 | 1/1 | Blank | |
Special addendum sequence number | 84-87 | 4/4 | 0001 | Input is always '0001'. |
Entry detail sequence number | 88-94 | 1/7 | Numeric | For bank use. |
Note: If you are not reporting any of the three tax liability fields, do not include an entry for the respective amount type code and tax liability fields. However, you must include the separators which would normally follow the amount type codes and tax liability fields.
Record 7 example
XYZ Corporation's taxpayer identification number is 010203045. They are making a withholding tax payment (WT) for the payroll date of October 20, 2015. They are reporting New York State liability of $150,575.00, New York City liability of $0.00 and Yonkers liability of $0.00. Their access code is 778899.
Field position | 1 | 2 | 4 | 7 | 8 | 23 | 24 | 29 | |||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Value | 7 | 0 | 5 | T | X | P | * | 0 | 1 | 0 | 2 | 0 | 3 | 0 | 4 | 5 | * | W | T | * |
Field position | 30 | 31 | 36 | 37 | 38 | 39 | 49 | 50 | 51 | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Value | 1 | 5 | 1 | 0 | 2 | 0 | * | S | * | 1 | 5 | 0 | 5 | 7 | 5 | 0 | 0 | * | * |
Field position | 52 | 62 | 63 | 64 | 75 | |||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Value | * | * | * |
Field position | 76 | 82 | 84 | 88 | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Value | 7 | 7 | 8 | 8 | 9 | 9 | \ | 0 | 0 | 0 | 1 |
The information listed above is formatted as follows: 705TXP*010203045*WT*151020*S*15057500*****778899\