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.

 

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
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 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
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 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

4rd Quarter PA Tax Withheld

Numeric 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 Name

Business Name, 50 characters max.

Yes**

Employer Address Line 1

Apartment Number, Box Number, Street Address, or Unit and Box for U.S. Military Address, 50 characters max.

Yes**

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.

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 Code

2 character country code as specified in EFW2 Publication 42-007.

Yes**

Original/Amended Indicator

1 alpha character
Original File - O
Amended File - A

Yes

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