This table gives the fields that are needed to Bulk File an A-1 or A-6 Withholding Return.
Field Position Number | Field Name | Max Size | Format | Status |
---|---|---|---|---|
1 | Account Number | 10 | Text Field 10 Digits-0000123456 or R Followed by 9 Digits – R007000000 | Required |
2 | Period End [CCYYMMDD] | 8 | Text Field | Required |
3 | Period [M (Monthly) or Q (Quarterly)] | 1 | Text Field | Required |
4 | Return Type [A6 (Monthly) or A1 (Quarterly)] | 2 | Text Field | Required |
5 | Number of Employees | 5 | Text Field | Required |
6 | Tax Withheld Amt (Total tax before credit for overpayment) | 13 | Must Include Decimal | Required |
7 | Tax Remitted First 2 Months | 13 | Must Include Decimal | Required if filing Form A1 |
8 | Credit for Overpayment: If claiming a Credit for Overpayment, then Credit Period, Withheld Amt and Paid Amt are required.) | 13 | Must Include Decimal | Required if claiming a Credit for Overpayment |
9 | Amount of Tax Due (Total tax after credit for overpayment) | 13 | Must Include Decimal | Required |
10 | Final Return Y (Yes), N (No) | 1 | Text Field | Required |
11 | Final Return Last Payment [CCYYMMDD] | 8 | Text Field | Required if filing a final return |
12 | Prior Year Credit [CCYY] | 4 | Text Field | |
13 | Prior Year Withheld Amt | 13 | Must Include Decimal | |
14 | Prior Year Paid Amt | 13 | Must Include Decimal | |
15 | Qtr 1 Current Year Credit [MMCCYY] | 6 | Text Field | |
16 | Qtr 1 Current Year Withheld Amt | 13 | Must Include Decimal | |
17 | Qtr 1 Current Year Paid Amt | 13 | Must Include Decimal | |
18 | Qtr 2 Current Year Credit [MMCCYY] | 6 | Text Field | |
19 | Qtr 2 Current Year Withheld Amt | 13 | Must Include Decimal | |
20 | Qtr 2 Current Year Paid Amt | 13 | Must Include Decimal | |
21 | Qtr 3 Current Year Credit [MMCCYY] | 6 | Text Field | |
22 | Qtr 3 Current Year Withheld Amt | 13 | Must Include Decimal | |
23 | Qtr 3 Current Year Paid Amt | 13 | Must Include Decimal | |
24 | Payment Method E (EFT Debit), V (EFT Credit), Z (zero tax due) | 1 | Text Field | Required |
25 | Funding Source Y (Yes) or N (No) | 1 | Text Field | Required if EFT Debit |
26 | Address (Employer’s) | 35 | Text Field | Required if EFT Debit and Funding Source is Y |
27 | City (Employer’s) | 33 | Text Field | Required if EFT Debit and Funding Source is Y |
28 | State (Employer’s) | 2 | Text Field | Required if EFT Debit and Funding Source is Y |
29 | Zip Code ( Employer’s) | 5 | Text Field | Required if EFT Debit and Funding Source is Y |
30 | Zip Plus 4 (Employer’s) | 4 | Text Field | Required if EFT Debit and Funding Source is Y |
31 | Payment Date [CCYYMMDD] (Only applies to current returns filed before the Remit Due Date, and cannot be a date beyond the Remit Due Date.) | 8 | Text Field | Required if EFT Debit |
32 | Bank Acct. Type: C (Checking), S (Savings) | 1 | Text Field | Required if EFT Debit |
33 | Bank Routing Number | 9 | Text Field | Required if EFT Debit |
34 | Bank Acct Number | 18 | Text Field | Required if EFT Debit |