Submit a ticket

Standard AQ - Get Employee Fed W2

Updated on Follow
0 out of 0 found this helpful

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

 

 

 

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
   
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.

 


Have more questions? Submit a request

0 Comments


This space is for article feedback only. To make a request of the Avionté Support Team, please submit a ticket to https://support.avionte.com.