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.
Comments
0 comments
Please sign in to leave a comment.