Begin Main Content Area

File Import

REV-1667 Annual Withholding Reconciliation Statement (Transmittal) (CSV)

myPATH - Pennsylvania Tax Hub

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 ID9-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 ID3-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. 
Tax Year4-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 MethodsNumber 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 MethodsNumber 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 MethodsNumber of 1099-MISC and 1099-NEC forms submitted through other submission methods.Yes
Total Compensation, Distribution and Other
Income Subject to PA Withholding
Numeric only including 2 decimal places. Do not report negative figures, minimum value 0.00, maximum value 9999999999.99.Yes
PA Personal Income Tax WithheldNumeric 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
Income paid Subject to PA Withholding
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
Income paid Subject to PA Withholding
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
Income paid Subject to PA Withholding
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
Income paid Subject to PA Withholding
Numeric only including 2 decimal places. Do not report negative figures, minimum value 0.00, maximum value 9999999999.99.Yes
1st Quarter PA Tax WithheldNumeric only including 2 decimal places. Do not report negative figures, minimum value 0.00, maximum value 9999999999.99.Yes
2nd Quarter PA Tax WithheldNumeric only including 2 decimal places. Do not report negative figures, minimum value 0.00, maximum value 9999999999.99.Yes
3rd Quarter PA Tax WithheldNumeric only including 2 decimal places. Do not report negative figures, minimum value 0.00, maximum value 9999999999.99.Yes
4rd Quarter PA Tax WithheldNumeric only including 2 decimal places. Do not report negative figures, minimum value 0.00, maximum value 9999999999.99.Yes
The fields below are required for employers outside of Pennsylvania that do not have a PA state assigned employer withholding tax account number. Not required for employers who have a PA state assigned employer withholding tax account number.
Employer NameBusiness Name, 50 characters max.Yes**
Employer Address Line 1Apartment Number, Box Number, Street Address, or Unit and Box for U.S. Military Address, 50 characters max.Yes**
Employer Address Line 2Street Address if not on Address Line 1, 50 characters max. 
Employer Address Line 3Hamlet, Village or other information if it needs to appear before the City or Town, 50 characters max. 
Employer City/TownCity, Town, etc., APO, FPO, DPO for U.S. Military Address, 50 characters max.Yes**
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, 30 characters max.Yes**
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.Yes**
Employer Country Code2 character country code as specified in EFW2 Publication 42-007.Yes**
Original/Amended Indicator1 alpha character
Original File - O
Amended File - A
Yes

**Note: Employer Name and Address is required only when the Account Number is not entered.