Skip to main content
Department of Taxation and Finance

PrompTax sales and compensating use tax ACH credit format

ACH credit CCD+ format record format specifications and layout

For ACH Credit sales and compensating use tax 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 sales and compensating use tax return information.

The specifications and layouts, including examples, for Record 6 and Record 7 are detailed on the following pages. All ACH Credit sales and compensating use tax payments must adhere to these specifications so that they can be properly identified and correctly applied by the Department.

Record 6 specifications and layout
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 Tax Department. This field is 10 positions, right-justified, numeric and without a decimal point or commas. Any unused spaces should be filled with zeros.
Total sales and compensating use tax payment \1 40-54 15 $$$$$$$$$$$$$cc This is your sales and compensating use tax payment amount. 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 amount of their tax payment.

\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

Record 6 example: XYZ Corporation is making an ACH credit payment for $1,660,575.00.
Field position 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29
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 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54
Value 0 1 6 6 0 5 7 5 0 0 0 0 0 0 0 0 1 6 6 0 5 7 5 0 0
 
Field position 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76
Value X Y Z C O R P >O R A T I O N
 
Field position 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94
Value 1
Record 7 specifications and layout
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 or dashes.
Separator 23 1/1 *
Tax type code 24-28 1/5 ST Input is always 'ST'.
Separator 29 1/1 *
Tax period end date 30-35 6/6 YYMMDD (numeric) Specifies the end date of the tax period that you are reporting. Input is always numeric and in YYMMDD format.
Separator 36 1/1 *
Amount type code 37 1/1 R Input is always 'R'.
Separator 38 1/1 *
Amount of 23-EOM payment 39-48 1/10 numeric This specifies the amount of your day 23-end of month payment. Do not put a decimal between dollars and cents.
Separator 49 1/1 *
Amount type code 50 1/1 E Input is always 'E'.
Separator 51 1/1 *
Amount of 1-22 payment 52-61 1/10 numeric This specifies the amount of your day 1-22 payment. Do not put a decimal between dollars and cents.
Separator 62 1/1 *
Access code 63-68 1/1 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 69 1/1 \ Input is always '\'.
Filler 70-83 14/14 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.

Sample ACH credit PrompTax payments using CCD+ format

Record 7 example:  XYZ Corporation's taxpayer identification number is 010203045. They are making a sales tax payment (ST) for the period end date of January 22, 2016. They are reporting December 23-EOM, 2015 sales tax payment of $900,000.00 and January 1-22, 2016 tax payment of $760,575.00. Their access code is 778899.
Field position 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29
Value 7 0 5 T X P * 0 1 0 2 0 3 0 4 5 * S T *
                                                                                                         
Field position 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51
Value 1 6 0 1 2 2 * R * 9 0 0 0 0 0 0 0 * E *
  
Field position 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80
Value 7 6 0 5 7 5 0 0 * 7 7 8 8 9 9 \
                                                        
Field position 81 82 83 84 85 86 87 88 89 90 91 92 93 94
Value 0 0 0 1

The information above is formatted as follows:

705TXP*010203045*ST*160122*R*90000000*E*76057500*778899\

Updated: