Quarterly PA Jordan Tax Service Export (AQ)

This Quarterly PA Jordan Tax Service Export AQ creates an export file for the Jordan Tax Service collector in Pennsylvania for Earned Income Tax (EIT) and Local Services Tax (LST) reporting. The export will allow client companies to provide required tax withholding information for their employees to the tax collector in a standardized file format.

The following Export contains detailed records of all employee earnings, the taxes withheld, and other relevant financial information required for compliance with Pennsylvania's local tax regulations.

A Quarterly PA Jordan Tax Service export has been added to the Weekly Process section. Users can be granted permission to this export via Desktop Application > Admin Tools > System > Report > Advance Query > User.

To run this export from the Desktop Application:

1. Click on Weekly Process
   
   
2. Click Export/Import right side tab
   
   
3. Select feed Quarterly PA Jordan Tax Service

Parameters 

Name	Value	Description
FEIN	List of Suppliers along with their FEIN	Use this filter to refine the records per Supplier
Check Start Date
Check End Date
Tax Type	EIT, LST

Export Data

Header Record – Employer Submitter Record

One Occurrence Per File – First Record of File

Column	Field Name	Description	Notes
A	TaxType	Tax type being filed	Constant "E" for EIT Constant "L" for LST Constant "W" for W-2s
B	Employer EIN	Employer Tax ID Number	No hyphens, 9 digits
C	Account Nbr	JTS assigned account number (Primary/Main Location)	Numeric
D	Tax Year	Tax year being reported	4 digits required
E	Combined Filing Flag	Flag denoting if this submission is a "Combined Filing" (to multiple TCDs) as defined by Act 32 of 2008.	C = Combined, Blanks if not.
F	Report Period End	2-digit month representing the end of reporting period	2-digits Ex: 03 = March<br>Use 12 for W-2s
G	Employer Name	Employer Name	No commas permitted
H	Submitter Contact Name	Person for JTS to contact if problems arise with this file submission
I	Submitter Address 1	1st address line of submitter's address	No commas permitted
J	Submitter Address 2	2nd address line of submitter's address	No commas permitted
K	Submitter City	City of submitter's address	No commas permitted
L	Submitter State	State of submitter's address	2-character postal abbreviation required
M	Submitter Zip Code	Zip Code (1st 5 digits) of submitter's address	Must contain 5 digits
N	Submitter ZIP+4 Extension	Zip+4 Code (last 4 digits) of submitter's address. Leave blank if unavailable.	Must contain 4 digits or all blanks
O	Submitter Telephone Number	Telephone number for JTS to contact if problems arise with this file submission	10 digits. No punctuation. e.g. 4125551212
P	Submitter Email Address	Email address for JTS to contact if problems arise with this file submission	Must contain valid email address.

Detail Record – Employee Withholding Record

Multiple Occurrences per File

Column	Field Name	Description	Notes
A	Social Security Number	Employee Social Security Number	No hyphens 9 digits required
B	Tax Year	Tax year being reported	4 digits required
C	Report Period End	2-digit month representing the end of reporting period	2-digits Ex: 03 = March Use 12 for W-2s
D	Employee Name	Employee Name	Last Name + space + First name + space + Middle Initial + space + Suffix Example: PUBLIC JOHN Q JR No commas or titles (e.g. Mr. Dr.) permitted
E	Address 1	Employee 1st address line	No commas permitted
F	Address 2	Employee 2nd address line	No commas permitted
G	City	Employee City	No commas permitted
H	State	Employee State Abbreviation	2-character postal abbreviation required
I	Zip Code	Employee Zip Code (1st 5 digits)	Must contain 5 digits
J	Zip+4 Extension	Employee Zip+4 Code (last 4 digits)	Leave blank if unavailable. Must contain 4 digits or all blanks
K	JTS Employer Location Account Number	Account Number assigned to Employer by JTS for this Work Location.	Leave blank if unable to supply the account number for this specific work location.
L	PSD code of Work Location	PSD Code for physical location of Employee's Work place.	Must contain 6 digits
M	PSD code of Employee's Residence	PSD Code for this Employee's physical residence.	Must contain 6 digits
N	Total Rate Withheld	Optional. Total EIT Rate Withheld for this Employee, if known. (Enter zero if reporting LST or W-2)	e.g. 0.01 = 1% withheld. 0 = Unknown or LST (Enter zeros if unknown or if reporting LST or W-2)
O	Employee Wages	Employee Wages for this reporting period	Numeric digits and decimal points only. No commas, parentheses or currency symbols (e.g. "$") are permitted.
P	Local EIT or LST Withheld	Local EIT withheld for this employee for this reporting period. (LST withheld if this file contain LST submissions.)	Numeric digits and decimal points only. No commas, parentheses or currency symbols (e.g. "$") are permitted.

3rd party link Disclaimer: These links are being provided as a convenience and for informational purposes only; they do not constitute an endorsement or an approval by Avionte of any of the products, services or opinions of the corporation or organization or individual. Avionte bears no responsibility for the accuracy, legality or content of the external site or for that of subsequent links. Contact the external site for answers to questions regarding its content.