Index
 
File Import
Employer W-2 (Transmittal) Annual Withholding Reconciliation Statement REV-1667
 
The file you upload needs to be a Comma Delimited file (i.e. CSV format) and contain all of the information specified below. It should contain a minimum of 17 columns of data.
Note: Before uploading the REV-1667 (Transmittal) Annual Withholding Reconciliation Statement, you must insert the W-2 and 1099-R employee wage/distribution records.
 
Required Column Data Format
  Employer Tax Account Number The 8-digit PA state assigned employer tax account number, containing no dashes or spaces.
  Tax Year 4-digit value of year reported.
  Number of Employee W-2(s) Number of Employee W-2(s). This MUST match the number submitted to e-TIDES.
  Number of W-2(s) reported by other means Number of Employee W-2(s) reported by other submission methods (must be at least 0). These figures will be added to the number of Employee W-2(s) submitted to e-TIDES and will display on Line 1a in Part I of the REV-1667. Note: CD-ROM is no longer accepted.
  Number of 1099-R Forms with PA Withholding Tax Number of 1099-R forms (must be at least 0). Note: CD-ROM is no longer accepted.
  Total Compensation Total Compensation/Distribution Subject to PA Withholding Tax (not negative). This is the total of the W-2 and 1099-R compensation.
  PA Income Tax Withheld Total amount of PA Income Tax Withheld. (not negative)
  1st Quarter Taxable Wages Wages/Distribution subject to PA Withholding Tax for the First Quarter. (not negative) This is the total of the W-2 and 1099 income tax withheld.
  2nd Quarter Taxable Wages Wages/Distribution subject to PA Withholding Tax for the Second Quarter. (not negative) This is the total of the W-2 and 1099 income tax withheld.
  3rd Quarter Taxable Wages Wages/Distribution subject to PA Withholding Tax for the Third Quarter. (not negative) This is the total of the W-2 and 1099 income tax withheld.
  4th Quarter Taxable Wages Wages/Distribution subject to PA Withholding Tax for the Fourth Quarter. (not negative) This is the total of the W-2 and 1099 income tax withheld.
  1st Quarter PA Tax Withheld Amount of PA Income Tax Withheld in First Quarter. (not negative)
  2nd Quarter PA Tax Withheld Amount of PA Income Tax Withheld in Second Quarter. (not negative)
  3rd Quarter PA Tax Withheld Amount of PA Income Tax Withheld in Third Quarter. (not negative)
  4th Quarter PA Tax Withheld Amount of PA Income Tax Withheld in Fourth Quarter. (not negative)
  Entity ID Entity ID for business being filed. Usually an EIN or SSN.
  Type of Entity ID This indicates the type of number used for the Entity ID. Click here to view Code List.