Skip to agency navigation
Skip to main content

Official website

of the Commonwealth of Pennsylvania

    The .gov means it's official.

    Local, state, and federal government websites often end in .gov. Commonwealth of Pennsylvania government websites and email systems use "pennsylvania.gov" or "pa.gov" at the end of the address. Before sharing sensitive or personal information, make sure you're on an official state website. 

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

    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
    Original File - O
    Amended File - A

    Yes