Skip to main content

PrompTax prepaid sales tax on motor fuel and diesel motor fuel ACH credit format

ACH credit CCD+ format record format specifications and layout

For ACH Credit prepaid sales tax payments on motor fuel and diesel motor fuel, 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 prepaid sales tax on motor fuel and diesel motor fuel return information.

The specifications and layouts, including examples, for Record 6 and Record 7 are detailed on the following pages. All ACH Credit prepaid sales tax payments on motor fuel and diesel motor fuel 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 0 $$$$$$$$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 prepaid sales tax on motor fuel and diesel motor fuel payment \1 40-54 15 $$$$$$$$$$$$$cc This is your prepaid sales tax on motor fuel and diesel motor fuel 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,650,250.00.
Field position 1 2  3 4  6  7  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 5 0 2 5 0 0 0 0 0 0 0 0 0 1 6 5 0 2 5 0 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.
Separator 23 1/1 *
Tax type code 24-28 1/5 FT Input is always 'FT'.
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 F Input is always 'F'.
Separator 38 1/1 *
Amount of prepaid sales tax on motor fuel and diesel motor fuel 39-48 1/10 Numeric This specifies the amount of your prepayment of prepaid sales tax on motor fuel and diesel motor fuel payment. Input is right justified. Do not put a decimal between dollars and cents.
Separator 49 1/1 *
Access code 50-55 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 56 1/1 \ Input is always '\'.
Filler 57-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 prepaid sales tax on motor fuel and diesel motor fuel payment (FT) for the period end date of January 22, 2016.  They are reporting NYS prepaid sales tax on motor fuel and diesel motor fuel payment of $1,650,250.00.  Their access code is 778899.  
Field position 1 2 4 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        * F 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 52 53 54 55 56
 Value 1 6 0 1 2 2 * F *   1 6 5 0 2 5 0 0 0 * 7 7 8 8 9 9 \
 
Field position 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                              
 
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*FT*160122*F*165025000*778899\

Updated: