Quarterly PA EIT Keystone Export (AQ)

Keystone Collections Group (Keystone) is responsible for collecting local taxes on behalf of municipalities, school districts, and counties throughout Pennsylvania. They manage the collection process for various local tax types, ensuring that local governments receive the necessary funding for public services.  Their website is https://keystonelogin.pa.gov/

The Quarterly PA EIT Keystone Export provides a summary of the earned income taxes collected and distributed over a selected period. It shows how much tax was collected, any changes or corrections, and how the money was shared with local communities and schools.

A Quarterly PA EIT Keystone 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 EIT Keystone

Parameters 

Name	Value
FEIN	Employer's FEIN
Check Start Date	Check Date (Start Date)
Check End Date	Check Date (End Date)

Export Data

Submitter Record (RA)

COLUMN	FIELD	Explanation
A	RA	Record Identifier
B	SubmitterFEIN	Employer's FEIN
C	CompanyName	Employer's Name
D	LocationAddress	Employer's location address
E	DeliveryAddress	Employer's delivery address
F	City	Employer's City
G	StateCode	Employer's State
H	ZipCode	Employer's ZipCode
I	ZipCodeExt	Employer's Zip Code Extension
J	ContactName	Employer Contact Name (Pulled from Supplier property : GSXMLFeed_Contact_ContactName)
K	ContactPhone	Employer Contact Phone (Pulled from Supplier property: GSXMLFeed_Contact_ContactPhone)
L	ContactPhoneExt	Employer Contact Phone Extension (Pulled from Supplier property: GSXMLFeed_Contact_ContactPhoneExt)
M	ContactEmail	Employer Contact Email (pulled from Supplier property: GSXMLFeed_Contact_ContactEmail)
N	ContactFax	Employer Contact Fax (Pulled from Supplier property: GSXMLFeed_Contact_ContactFax)

Employer Record (RE)

COLUMN	FIELD	Explanation
A	RE	Record Identifier
B	TaxYear	Tax year
C	TaxQuarter	Tax Quarter
D	EmployerFEIN	Employer's FEIN
E	EmployerName	Employer's Name
F	LocationAddress
G	DeliveryAddress	Employer's delivery address (Worksite address Street1 and Street 2 )
H	City	Employer's City (Worksite address City)
I	State	Employer's State  (Worksite address State)
J	Zip Code	Employer's ZipCode (Worksite address zip code)
K	Zip Code Extension	Employer's Zip Code Extension (Worksite address zip code extension)
L	Record Change Notice	0 = new file or no changes , 1= Changes to Name, Address or Jurisidication
M	Foreign State	Employer’s foreign State/province (Worksite Address State)
N	Foreign Postal Code	Employer’s foreign postal code (Worksite Address Postal Code)
O	Country Code	Employer's applicable Country Code (Worksite Address Country Code)
P	Employer PSD Code	Employer's PSD Code (Worksite PSD Code)
Q	Monthly Filling Indicator	Monthly Filling Indicator (M =Montthly , Q =Quarterly)
R	Reporting Period	Reporting Period (Year and Month)
S	Tax Type	Tax Types (E= EIT, L=LST, W=W2)
T	Employer Total School District Only Payments
U	Employer Total Exemptions

State Wage records (RS)

COLUMN	FIELD	Explanation
A	RS	Record Identifier
B	Worksite ID
C	SSN	W2 Employee's SSN
D	FirstName	W2 Employee FirstName
E	MiddleName	W2 Employee MiddleName
F	LastName	W2 Employee LastName
G	Suffix
H	LocationAddress
I	DeliveryAddress	W2 Employee's Primary Address (Street1 and Street2)
J	City	W2 Employee's Primary Address City
K	State	W2 Employee's Primary Address State
L	ZipCode	W2 Employee's Primary Address Zipcode
M	ZipcodeExtension	W2 Employee's Primary Address Zip Code Extension
N	Foreign State	W2 Employee's Primary Address (Street1 and Street2)
O	Foreign Postal Code
P	Country Code
Q	Record Change Notice	0 = new file or no changes , 1= Changes to Name, Address or Jurisdiction
R	Reporting Period	Reporting Period (Year and Month)
S	Stage Wages State Code
T	state wage tax with held
U	TaxType	Tax Types (E= EIT, L=LST, W=W2)
V	LocalwageTaxable	Sum of Taxable Gross per Worksite Address
W	LocalwageTaxableWithHeld	Sum of Employee Tax Amount Withheld per Worksite Address (Excluding Philadelphia Taxes)
X	StateControlNumber
Y	TaxingJurisdiction	Employee's Resident PSD Code
Z	SchoolDistOnlyPayments

Employer Total record (RT)

COLUMN	FIELD	Explanation
A	RT	Record Identifier
B	TotalStateWageRecords	Employer's Total Stage Wages
C	TotalLocalWages	Employer's Total Local Wages
D	TotalLocalTaxWithheld	Employer's Total Local Taxes withheld

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.