REV-1667 Annual Withholding Reconciliation Statement (Transmittal) (CSV)
The file you upload needs to be a Comma Delimited file (i.e. CSV format) and contain a data element for each column specified below. It should contain a minimum of 29 columns of data.
Note: Before uploading the REV-1667 (Transmittal) Annual Withholding Reconciliation Statement, you must upload the W-2s (Employee wage records), 1099-R (Distribution records), 1099-MISC (Miscellaneous income records) and 1099-NEC (Nonemployee Compensation income records).
Column | Data Format | Required |
---|---|---|
Entity ID | 9-digit Entity ID number for business. Usually a Federal Employer Identification Number (FEIN) or Social Security Number (SSN), containing no dashes or spaces. | Yes |
Type of Entity ID | 3-digit number indicates the Entity ID Type. Please refer to Appendix A for Code List. | Yes |
Account Number | The 8-digit Withholding ID or the 11-digit Account Number for the Withholding Reconciliation Account containing no dashes or spaces. | Yes |
Tax Year | 4-digit value of year reported. | Yes |
W-2s Filed Through myPATH | Number of W-2 forms submitted through myPATH upload and/or entry screen. | Yes |
W-2s Filed by Other Submission Methods | Number of W-2 forms submitted through other submission methods. | Yes |
1099-Rs Filed Through myPATH | Number of 1099-R forms submitted through myPATH upload and/or entry screen. | Yes |
1099-Rs Filed by Other Submission Methods | Number of 1099-R forms submitted through other submission methods. | Yes |
1099-MISC and 1099-NEC Filed Through myPATH | Number of 1099-MISC and 1099-NEC forms submitted through myPATH upload and/or entry screen. | Yes |
1099-MISC and 1099-NEC Filed by Other Submission Methods | Number of 1099-MISC and 1099-NEC forms submitted through other submission methods. | Yes |
Total Compensation, Distribution and Other | Numeric only including 2 decimal places. Do not report negative figures, minimum value 0.00, maximum value 9999999999.99. | Yes |
PA Personal Income Tax Withheld | Numeric only including 2 decimal places. Do not report negative figures, minimum value 0.00, maximum value 9999999999.99. | Yes |
1st Quarter Wages, Distributions and Other | Numeric only including 2 decimal places. Do not report negative figures, minimum value 0.00, maximum value 9999999999.99. | Yes |
2nd Quarter Wages, Distributions and Other | Numeric only including 2 decimal places. Do not report negative figures, minimum value 0.00, maximum value 9999999999.99. | Yes |
3rd Quarter Wages, Distributions and Other | Numeric only including 2 decimal places. Do not report negative figures, minimum value 0.00, maximum value 9999999999.99. | Yes |
4th Quarter Wages, Distributions and Other | Numeric only including 2 decimal places. Do not report negative figures, minimum value 0.00, maximum value 9999999999.99. | Yes |
1st Quarter PA Tax Withheld | Numeric only including 2 decimal places. Do not report negative figures, minimum value 0.00, maximum value 9999999999.99. | Yes |
2nd Quarter PA Tax Withheld | Numeric only including 2 decimal places. Do not report negative figures, minimum value 0.00, maximum value 9999999999.99. | Yes |
3rd Quarter PA Tax Withheld | Numeric only including 2 decimal places. Do not report negative figures, minimum value 0.00, maximum value 9999999999.99. | Yes |
4th Quarter PA Tax Withheld | Numeric only including 2 decimal places. Do not report negative figures, minimum value 0.00, maximum value 9999999999.99. | Yes |
Employer Name | Business Name, 50 characters max. |
|
Employer Address Line 1 | Apartment Number, Box Number, Street Address, or Unit and Box for U.S. Military Address, 50 characters max. |
|
Employer Address Line 2 | Street Address if not on Address Line 1, 50 characters max. |
|
Employer Address Line 3 | Hamlet, Village or other information if it needs to appear before the City or Town, 50 characters max. |
|
Employer City/Town | City, Town, etc., APO, FPO, DPO for U.S. Military Address, 50 characters max. |
|
Employer Governing District | U.S. States use 2 character abbreviation, Canadian Providences use 2 character abbreviation, Mexico Federal Districts use 3 character abbreviation, U.K. County use county name etc., U.S. Military Addresses use AE, AP, or AA, 6 characters max. |
|
Employer Postal Area | U.S. Zip Code, Canadian/Mexico Postal Code, U.K. Postal Code, etc., 15 characters max. U.S. Military Address use 5-digit Zip Code. |
|
Employer Country Code | 2 character country code as specified in EFW2 Publication 42-007. |
|
Original/Amended Indicator | 1 alpha character | Yes |