Philadelphia
This format requires comma-separated fields.
The following are the records included:
There is one header and total record in the file.
Header Record
The following table lists the data item, description, and position of the Philadelphia report type’s header record.
Data Item | Description | Position |
---|---|---|
SOCIAL SEC NUMBER | Constant value | 1 |
LAST NAME | Constant value | 2 |
FIRST | Constant value | 3 |
MIDDLE | Constant value | 4 |
EMPLOYEE ADDRESS | Constant value | 5 |
CITY | Constant value | 6 |
STATE | Constant value | 7 |
ZIP | Constant value | 8 |
TAX YEAR | Constant value | 9 |
TAX MONTH | Constant value | 10 |
LOCAL TAXABLE EARNINGS FOR MONTH | Constant value | 11 |
AMT | Constant value | 12 |
PSD CODE | Constant value | 13 |
Detail Records
The following table lists the data item, description, and position of the Philadelphia report type’s detail records.
Data Item | Description | Position |
---|---|---|
Employee SSN# | 9 numeric digits only, no dashes | 1 |
Employee Last Name | No commas, quotes or any other punctuation | 2 |
Employee First Name | No commas, quotes or any other punctuation | 3 |
Employee Middle Name | No commas, quotes or any other punctuation | 4 |
Employee Address | No commas, quotes or any other punctuation | 5 |
Employee City | No commas, quotes or any other punctuation | 6 |
Employee State | Two letter US Postal abbreviation | 7 |
Employee Zip | Must be 5 numeric digits or ZIP + 4 | 8 |
Tax Year | The 4 digit of the tax year YYYY | 9 |
Tax Month | The month the payment is for. | 10 |
Local Taxable Earnings for the Month | The total earnings for the month being reported | 11 |
Withholding Amount | The total withholding amount for the month | 12 |
PSD Code | 6 digit code | 13 |
Total Record
The following table lists the data item, description, and position of the Philadelphia report type’s total record.
Data Item | Description | Position |
---|---|---|
Blank | 1,2,3,4,5,6,7,8,9,10 | |
Total Earnings for the Month | Total of the detail records | 11 |
Total Withholding Amount for the Month | Total of the detail records | 12 |
Blank | 13 |