Submit a ticket

Standard AQ - Get Employee State W2

Updated on Follow
0 out of 0 found this helpful

Report Description

This report shows all State W2 information for an employee.

GetEmployeeStateW2.png

 

GetEmployeeStateW22.png

 

GetEmployeeStateW23.png

 

 

 

Parameters

Parameter Name

Options

Description

Supplier

All available Suppliers

 

Year ID

Pass a Year ID

 

State

 

 

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

Gross Wages

Total Gross Wages

Tax State

Tax State of State Tax

Avionte Taxable Gross

Total Taxable Gross for State Tax from Avionte

Avionte Tax Amount

Total State Tax Amount from Avionte

 

 

 

Following fields are shown in report for Data Source = 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

Gross Wages

Total Gross Wages

Tax State

Tax State of State Tax

GShades Taxable Gross

Total Taxable Gross for State Tax from GShades

GShades Tax Amount

Total State Tax Amount from GShades

 

 

 

Following fields are shown in report for Data Source = Compare and Return Type = Summary

Tax State

Tax State of State Tax

Payee Count

No of Employees with respective State Tax

Avionte Taxable Gross

Total Taxable Gross for State Tax from Avionte

GShades Taxable Gross

Total Taxable Gross for State Tax from GShades

Avionte Tax Amount

Total State Tax Amount from Avionte

GShades Tax Amount

Total State Tax Amount from GShades

 

 

 

Following fields are shown in report for Data Source = GShades and Return Type = Summary

Tax State

Tax State of State Tax

Payee Count

No of Employees with respective State Tax

GShades Taxable Gross

Total Taxable Gross for State Tax from GShades

GShades Tax Amount

Total State Tax Amount from GShades

 

 

 

Following fields are shown in report for Data Source = Avionte and Return Type = Summary

Tax State

Tax State of State Tax

Payee Count

No of Employees with respective State Tax

Avionte Taxable Gross

Total Taxable Gross for State Tax from Avionté

Avionte Tax Amount

Total State Tax Amount from Avionté

 

 

 

 

 

Special Logic

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

Data Source = Compare and Return Type = Results

 

 

 

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.