Skip universal navigation

New York State Universal header

Skip to main content

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:

  • 1. Record 6 (ACH Credit payment) - Includes the payment information, including to whom, how much and from whom.
  • 2. 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

4

13

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

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

X

Y

Z

C

O

R

P

O

R

A

T

I

O

N

Field position

77

79

80

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

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

4

7

8

23

24

29

7

0

5

T

X

P

*

0

1

0

2

0

3

0

4

5

*

S

T

*

Field position

30

31

36

37

38

39

49

50

51

1

6

0

1

2

2

*

R

*

9

0

0

0

0

0

0

0

*

E

*

Field position

52

62

63

69

7

6

0

5

7

5

0

0

*

7

7

8

8

9

9

\

Field position

84

88

0

0

0

1

The information above is formatted as follows:

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

Updated: