Skip universal navigation
Skip to main content

Department of Taxation and Finance

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

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 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: