PrompTax Metropolitan Commuter Transportation Mobility Tax ACH Credit Format
ACH credit CCD+ format record format specifications and layout
For ACH Credit Metropolitan Commuter Transportation Mobility Tax (MCTMT) 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 MCTMT information.
The specifications and layouts, including examples, for Record 6 and Record 7 are detailed on the following pages. All ACH Credit MCTMT 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 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 MCTMT payment \1 | 40-54 | 15 | $$$$$$$$$$$$$cc | This is your MCTMT 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
XYZ Corporation is making an ACH credit payment for $334.75.
|
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 |
0 |
0 |
0 |
0 |
3 |
3 |
4 |
7 |
5 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
3 |
3 |
4 |
7 |
5 |
||||
|
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 |
|
|||||||||||||||||||||||||||
| 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/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 | 2/5 | MT | Input is always 'MT'. |
| Separator | 29 | 1/1 | * | |
| Payroll date | 30-35 | 6/6 | YYMMDD (numeric) | Specifies the payroll which you are reporting. Input is always numeric and in YYMMDD format. |
| Separator | 36 | 1/1 | * | |
| Amount type code | 7 | 1/1 | M | Input is always 'M'. |
| Separator | 38 | 1/1 | * | |
| MT gross wages | 39-52 | /14 | Numeric | This specifies the amount of MCTMT gross wages. Do not put a decimal between dollars and cents. |
| Separator | 53 | 1/1 | * | |
| Amount type code | 54 | 1/1 | T | Input is always 'T'. |
| Separator | 1/1 | * | ||
| MT amount | 56-65 | 1/10 | Numeric | This specifies the amount MCTMT payment. Do not put a decimal between dollars and cents. |
| Separator | 66 | 1/1 | * | |
| Access code | 67-72 | 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 | 73 | 1/1 | \ | Input is always '\'. |
| Filler | 74-83 | 10/10 | 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
XYZ Corporation's taxpayer identification number is 010203045. They are making a metropolitan commuter transportation mobility tax (MT) payment for the payroll date of January 20, 2016. They are reporting gross wages of $320,500.25 and a metropolitan commuter transportation mobility tax payment of $334.75. 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 |
* |
M |
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 |
|||
|
Value |
1 |
6 |
0 |
1 |
2 |
0 |
* |
M |
* |
3 |
2 |
0 |
5 |
0 |
0 |
2 |
5 |
* |
T |
* |
|||||||||
|
Field position |
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 |
81 |
82 |
83 |
|
|
Value |
0 |
0 |
0 |
0 |
0 |
3 |
3 |
4 |
7 |
5 |
* |
7 |
7 |
8 |
8 |
9 |
9 |
\ |
|
||||||||||
|
Field position |
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*MT*160120*M*32050025*T*33475*778899\