Standard AQ - Get Employee Fed W2

Overview

Updated 07/27/2021

Report Description

This report shows all federal W2 information for an employee.

Parameters

Parameter Name	Options	Description
Supplier	All available Suppliers
Year ID	Pass a Year ID
State
Local Tax
SSN
Data Source	Avionte / Compare / GShades	If Data Source = Avionte, pull Taxable Gross and Tax Amount from Avionte Tables If Data Source = GShades, pull Taxable Gross and Tax Amount from GShades Tables If Data Source = Compare, show comparison between Taxable Gross and Tax Amount between Avionte data and GShades data
Sort By	Name / SSN
Return Type	Results / Summary	If Return Type = Results, Show data in employee level If Return Type = Summary, show data as Summary for a selected Supplier

Report Fields

Field Name	Description
Following fields are shown in report for Data Source = Avionte or GShades and Return Type = Results
SSN	Employee’s SSN
First Name	Employee’s First Name
Middle Name	Employee’s Middle Name
Last Name	Employee’s Last Name
Full Name	Employee’s full name
Fed Taxable Gross	Total Taxable Amount for Federal Tax
Fed Tax Amount	Total Federal Tax deducted from employee’s paycheck
FICA Taxable Gross	Total Taxable Amount for FICA Tax
FICA Tax Amount	Total FICA Tax deducted from employee’s paycheck
Med Taxable Gross	Total Taxable Amount for MED Tax
Med Tax Amount	Total MED Tax deducted from employee’s paycheck
BoldTalentID	The identifier for the employee in AviontéBOLD (Front Office)
Following fields are shown in report for Data Source = Compare and Return Type = Summary
Payee Count	Total Employee Count in selected Year for selected Supplier
Total Gross	Total Gross Amount from Check
GShades Fed Taxable Gross	Total Taxable Gross for Federal Tax from GShades
Avionte Fed Taxable Gross	Total Taxable Gross for Federal Tax from Avionte
GShades Fed Tax Amount	Total Fed Tax Amount from GShades
Avionte Fed Tax Amount	Total Fed Tax Amount from Avionte
GShades FICA Taxable Gross	Total Taxable Gross for FICA Tax from GShades
Avionte FICA Taxable Gross	Total Taxable Gross for FICA Tax from Avionte
GShades FICA Tax Amount	Total FICA Tax Amount from GShades
GShades Med Taxable Gross	Total Taxable Gross for Med Tax from GShades
Avionte Med Taxable Gross	Total Taxable Gross Med Tax from Avionte
GShades Med Tax Amount	Total Med Tax Amount from GShades
Avionte Med Tax Amount	Total Med Tax Amount from Avionte
Following fields are shown in report for Data Source = Avionte and Return Type = Summary
Payee Count	Total Employee Count in selected Year for selected Supplier
Total Gross	Total Gross Amount from Check
Avionte Fed Taxable Gross	Total Taxable Gross for Federal Tax from Avionte
Avionte Fed Tax Amount	Total Fed Tax Amount from Avionte
Avionte FICA Taxable Gross	Total Taxable Gross for FICA Tax from Avionte
Avionte FICA Tax Amount	Total FICA Tax Amount from Avionte
Avionte Med Taxable Gross	Total Taxable Gross Med Tax from Avionte
Avionte Med Tax Amount	Total Med Tax Amount from Avionte
BoldTalentID	The identifier for the employee in AviontéBOLD (Front Office)
Following fields are shown in report for Data Source = GShades and Return Type = Summary
Payee Count	Total Employee Count in selected Year for selected Supplier
Total Gross	Total Gross Amount from Check
GShades Fed Taxable Gross	Total Taxable Gross for Federal Tax from GShades
GShades Fed Tax Amount	Total Fed Tax Amount from GShades
GShades FICA Taxable Gross	Total Taxable Gross for FICA Tax from GShades
GShades FICA Tax Amount	Total FICA Tax Amount from GShades
GShades Med Taxable Gross	Total Taxable Gross for Med Tax from GShades
GShades Med Tax Amount	Total Med Tax Amount from GShades

Special Logic

Combination of following parameter is not valid; and will give random results:

Data Source = Compare and Return Type = Results

Shows data for Quarter 4 only and should have data in gs_EmployeeFedW2 for Q4.

Required Setup

AQ is using Supplier Property: GenerateSeparateGSXMLFile and UseRootConfigTaxStaffingSupplier

If GenerateSeparateGSXMLFile = True and UseRootConfigTaxStaffingSupplier = False, data is pulled for Root Supplier.

Back to Top