Submit a ticket

Standard AQ - Get Employee Local W2

Updated on Follow
0 out of 0 found this helpful

 

Report Description

This report shows all local W2 information for an employee.

GetEmployeeLocalW21.png

 

 

GetEmployeeLocalW22.png

 

 

GetEmployeeLocalW23.png

 

 

 

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

Street 1

Street 1 from Employee’s primary address

Street 2

Street 2 from Employee’s primary address

City

City from Employee’s primary address

State

State from Employee’s primary address

Zip Code

Zip Code from Employee’s primary address

Gross Wages

Total Gross Wages

Local Tax Name

Tax Name of Local Tax from Tax master

Local Tax Code

Tax Code of Local Tax from GS Locality Mapping

Local Tax State

Tax State of Local Tax

Avionte Taxable Gross

Total Taxable Gross for Local Tax from Avionte

Avionte Tax Amount

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

Street 1

Street 1 from Employee’s primary address

Street 2

Street 2 from Employee’s primary address

City

City from Employee’s primary address

State

State from Employee’s primary address

Zip Code

Zip Code from Employee’s primary address

Gross Wages

Total Gross Wages

Local Tax Name

Tax Name of Local Tax from Tax master

Local Tax Code

Tax Code of Local Tax from GS Locality Mapping

Local Tax State

Tax State of Local Tax

GShades Taxable Gross

Total Taxable Gross for Local Tax from GShades

GShades Tax Amount

Total Local Tax Amount from GShades

 

 

 

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

Local Tax Name

Tax Name of Local Tax from Tax master

Locality Code

Tax Code of Local Tax from GS Locality Mapping

Local Tax State

Tax State of Local Tax

Payee Count

No of Employees with respective Locality Tax

Avionte Taxable Gross

Total Taxable Gross for Local Tax from Avionte

GShades Taxable Gross

Total Taxable Gross for Local Tax from GShades

Avionte Tax Amount

Total Local Tax Amount from Avionte

GShades Tax Amount

Total Local Tax Amount from GShades

 

 

 

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

Local Tax Name

Tax Name of Local Tax from Tax master

Local Tax State

Tax State of Local Tax

Payee Count

No of Employees with respective Locality Tax

GShades Taxable Gross

Total Taxable Gross for Local Tax from GShades

GShades Tax Amount

Total Local Tax Amount from GShades

 

 

 

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

Local Tax Name

Tax Name of Local Tax from Tax master

Local Tax State

Tax State of Local Tax

Payee Count

No of Employees with respective Locality Tax

Avionte Taxable Gross

Total Taxable Gross for Local Tax from Avionte

Avionte Tax Amount

Total Local Tax Amount from Avionte

 

 

 

 

 

 

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.