Employer W-3 Return Quartlerly Reconciliation
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 35 columns of data.
Note: Quarterly Filers enter the Record of PA Withholding Tax as Withholding Tax. Monthly Filers enter the Record of PA Withholding Tax by Period for Period Withholding 1,2, and 3 leaving 4, 5, and 6 blank. Semi-Monthly Filers enter the Record of PA Withholding Tax by Period for Period Withholding 1 through 6.
Column |
Data Format |
Required |
---|---|---|
Account Number |
The 8-digit Withholding ID or the 11-digit Account Number for the Withholding Tax Account containing no dashes or spaces. |
Yes |
Period End Date |
The end date for the period you wish to submit the return or payment for. The following are valid formats for the date |
Yes |
Period Withholding 1 |
Amount Withheld for first period end date within the quarter. This field to be used for Monthly, Semi-Monthly and Semi-Weekly Filers. |
Yes |
Period Withholding 2 |
Amount Withheld for second period end date within the quarter. This field to be used for Monthly, Semi-Monthly and Semi-Weekly Filers. |
Yes |
Period Withholding 3 |
Amount Withheld for third period end date within the quarter. This field to be used for Monthly, Semi-Monthly and Semi-Weekly Filers. |
Yes |
Period Withholding 4 |
Amount Withheld for fourth period end date within the quarter. This field to be used for Semi-Monthly and Semi-Weekly Filers. |
Yes |
Period Withholding 5 |
Amount Withheld for fifth period end date within the quarter. This field to be used for Semi-Monthly and Semi-Weekly Filers. |
Yes |
Period Withholding 6 |
Amount Withheld for sixth period end date within the quarter. This field to be used for Semi-Monthly and Semi-Weekly Filers. |
Yes |
Period Withholding 7 |
Amount Withheld for seventh period end date within the quarter. This field to be used for Semi-Weekly Filers. |
|
Period Withholding 8 |
Amount Withheld for eighth period end date within the quarter. This field to be used for Semi-Weekly Filers. |
|
Period Withholding 9 |
Amount Withheld for ninth period end date within the quarter. This field to be used for Semi-Weekly Filers. |
|
Period Withholding 10 |
Amount Withheld for tenth period end date within the quarter. This field to be used for Semi-Weekly Filers. |
|
Period Withholding 11 |
Amount Withheld for eleventh period end date within the quarter. This field to be used for Semi-Weekly Filers. |
|
Period Withholding 12 |
Amount Withheld for twelfth period end date within the quarter. This field to be used for Semi-Weekly Filers. |
|
Period Withholding 13 |
Amount Withheld for thirteenth period end date within the quarter. This field to be used for Semi-Weekly Filers. |
|
Period Withholding 14 |
Amount Withheld for fourteenth period end date within the quarter. This field to be used for Semi-Weekly Filers. |
|
Period Withholding 15 |
Amount Withheld for fifteenth period end date within the quarter. This field to be used for Semi-Weekly Filers. |
|
Period Withholding 16 |
Amount Withheld for sixteenth period end date within the quarter. This field to be used for Semi-Weekly Filers. |
|
Period Withholding 17 |
Amount Withheld for seventeenth period end date within the quarter. This field to be used for Semi-Weekly Filers. |
|
Period Withholding 18 |
Amount Withheld for eighteenth period end date within the quarter. This field to be used for Semi-Weekly Filers. |
|
Period Withholding 19 |
Amount Withheld for nineteenth period end date within the quarter. This field to be used for Semi-Weekly Filers. |
|
Period Withholding 20 |
Amount Withheld for twentieth period end date within the quarter. This field to be used for Semi-Weekly Filers. |
|
Period Withholding 21 |
Amount Withheld for twenty-first period end date within the quarter. This field to be used for Semi-Weekly Filers. |
|
Period Withholding 22 |
Amount Withheld for twenty-second period end date within the quarter. This field to be used for Semi-Weekly Filers. |
|
Period Withholding 23 |
Amount Withheld for twenty-third period end date within the quarter. This field to be used for Semi-Weekly Filers. |
|
Period Withholding 24 |
Amount Withheld for twenty-fourth period end date within the quarter. This field to be used for Semi-Weekly Filers. |
|
Period Withholding 25 |
Amount Withheld for twenty-fifth period end date within the quarter. This field to be used for Semi-Weekly Filers. |
|
Period Withholding 26 |
Amount Withheld for twenty-sixth period end date within the quarter. This field to be used for Semi-Weekly Filers. |
|
Period Withholding 27 |
Amount Withheld for twenty-seventh period end date within the quarter. This field to be used for Semi-Weekly Filers. |
|
Compensation |
Total Compensation subject to PA Tax. |
Yes |
Withholding Tax |
Total of all period withholdings reported (periods 1-27 for Quarterly, Monthly, Semi-Monthly and Semi-Weekly) |
Yes |
Deposits |
Total of all Payments remitted for period end date of return being filed, including verified overpayments. |
Yes |
Payment |
Amount due when deposits are less than Withholding Tax for the quarter. May be equal to, but not less than zero. |
Yes |
Entity ID |
Entity ID for business being filed. Usually an EIN or SSN. |
Yes |
Type of Entity ID |
This indicates the type of number used for the Entity ID. Click here to view Code List. |
Yes |