Standard AQ - Get W2 Details AQ

Report Description

This standard report provides various details for employee W-2s useful for year-end audits such as gross wages, taxable wages (fed, state & local), as well as employer wages paid and taxes.

This AQ can serve as a W-3, showing totals on W-2s.

Parameters

Parameter Name	Options	Description
Supplier	All created suppliers
Branch (Employee)	All available branches	Branch of Employee
Year	Enter year for report to generate data from	Type field entry
Return Type	Detail, EE Summary, ER Summary, W2 Count	Detail = Information from all boxes of Employee’s W2 with additional personal information. EE Summary = Information from all boxes of Employee’s W2. ER Summary = Summarizes total of employee W2 information for selected supplier & year. W2 Count = Total # of W2 payees & W2 pages.

Report Fields

The following fields are shown in report where Return Type = Detail

Field Name	Description
Employee Branch	Employee's Branch
SSN	Employee’s SSN
Bold Talent ID	Employee's ID in AvionteBOLD
Last Name	Last Name of Employee
First Name	Frist Name of Employee
Middle Name	Middle Initial of Employee
Full Name	Employee’s Last 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	Zip code from Employee’s Primary Address
Email Address	Employee’s Email Address
Phone	Employee primary phone from contact method
Electronic W2	The Config Choice name is Electronic W-2 for Category, EmployeeInterview
Social Security Tips	Total of reported tips subject to Social Security tax
Allocated Tips	Employer Assigned Tips in addition to Employee reported tips
Dependent Care Benefits	Total amount of employer paid Dependent Care Benefits
Non-Qualified Pan 457	Reported distributions to an employee from a Nonqualified Plan
Box 12 Text One	Corresponding Box 12 Code
Box 12 Text Two	Corresponding Box 12 Code
Box 12 Text Three	Corresponding Box 12 Code
Box 12 Text Four	Corresponding Box 12 Code
Statutory Employee Indicator	Independent contractor who qualifies for employee treatment
Retirement Plan Indicator	Shows whether an employee is an active participant in company plan
Third Party Sick Pay Indicator	Sick Pay paid by a third party on behalf of employers to employees
Box 14 Text Final	Provided other information or reported amounts of employee
Total Gross	Total Gross Wages
Fed Taxable Gross	Federal Taxable Gross Wages
Federal Tax Amount	Federal Tax Amount
FICA Taxable Gross	FICA Taxable Gross Wages
FICA Tax Amount	FICA Tax Amount
Med Taxable Gross	Medicare Taxable Gross Wages
Med Tax Amount	Medicare Tax Amount
Tax State	State Code
State Taxable Gross	State Taxable Gross
State Tax Amount	Amount of State Tax
Local Tax Name	Local Tax Name
Local Tax State	Local Tax Code
Local Taxable Gross	Local Tax State Code
Local Tax Amount	Local Taxable Gross Pay of Employee

The following fields are shown in the report where Return Type = EE Summary

Field	Description
Employee Branch	Employee’s Branch
SSN	Employee’s SSN
Bold Talent ID	Employee's ID in AvionteBOLD
Last Name	Employee’s Last name
First Name	Employee’s First name
Middle Name	Employee’s Middle 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	Zip code from Employee’s Primary Address
Email Address	Employee’s Email Address
Phone	Employee primary phone from contact method
Electronic W2	The Config Choice name is Electronic W-2 for Category, EmployeeInterview
Social Security Tips	Total of reported tips subject to Social Security tax
Allocated Tips	Employer Assigned Tips in addition to Employee reported tips
Dependent Care Benefits	Total amount of employer paid Dependent Care Benefits
Non-Qualified Pan 457	Reported distributions to an employee from a Nonqualified Plan
Box 12 Text One	Corresponding Box 12 Code
Box 12 Text Two	Corresponding Box 12 Code
Box 12 Text Three	Corresponding Box 12 Code
Box 12 Text Four	Corresponding Box 12 Code
Statutory Employee Indicator	Independent contractor who qualifies for employee treatment
Retirement Plan Indicator	Shows whether an employee is an active participant in company plan
Third Party Sick Pay Indicator	Sick Pay paid by a third party on behalf of employers to employees
Box 14 Text Final	Provided other information or reported amounts of employee
Total Gross	Total Gross Wages
Fed Taxable Gross	Federal Taxable Gross Wages
Fed Tax Amount	Federal Tax Amount
FICA Taxable Gross	FICA Taxable Gross Wages
FICA Tax Amount	FICA Tax Amount
Med Taxable Gross	Medicare Taxable Gross Wages
Med Tax Amount	Medicare Tax Amount
Tax State	Number of Taxed States
State Taxable Gross	Total of State Taxable Gross
State Tax Amount	Total Amount of State Tax
Local Tax Name	Number of Local Tax Codes
Local Tax Code	Number of Local Tax Names
Local Tax State	Number of States with Local Taxes
Local Taxable Gross	Total Amount of Local Taxable Gross Wages
Local Tax Amount	Total Local Tax Amount

The following fields are shown in report where Return Type = ER Summary

Field	Description
SSN Count	Number of Employee Social Security Numbers
Total Gross	Total Gross Wages
Fed Taxable Gross	Total Federal Taxable Gross Wages
Fed Tax Amount	Total Federal Tax Amount
FICA Taxable Gross	Total FICA Taxable Gross Wages
FICA Tax Amount	Total FICA Tax Amount
Med Taxable Gross	Total Medicare Taxable Gross Wages
Med Tax Amount	Total Medicare Tax Amount
Tax States	Number of Taxed States
State Taxable Gross	Total of State Taxable Gross
State Tax Amount	Total Amount of State Tax
Local Tax Codes	Count of distinct Tax Code of Local Tax from Avionté
Local Tax Names	Count of distinct Tax Name of Local Tax from Avionté
Local Tax States	Count of distinct Tax State of Local Tax from Avionté
Local Taxable Gross	Sum of Taxable Gross for Local Tax from Avionté
Local Tax Amount	Total Amount of Local Taxable Gross Wages

The following fields are shown in report where Return Type = W2 Count

Field Name	Description
W2 Payee Count	Total Number of W2 Payees
W2 Page Count	Total Number of W2 Pages

3rd party link Disclaimer: These links are being provided as a convenience and for informational purposes only; they do not constitute an endorsement or an approval by [The author] of any of the products, services or opinions of the corporation or organization or individual. [The author] bears no responsibility for the accuracy, legality or content of the external site or for that of subsequent links. Contact the external site for answers to questions regarding its content.