Standard AQ - Get W2 Details AQ

Overview

Updated 07/27/2021

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.

Report Description

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

Parameters

Parameter Name	Options	Description
Supplier	All created suppliers
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
SSN	Social Security Number of Employee
Last Name	Last Name of Employee
First Name	Frist Name of Employee
Middle Name	Middle Initial of Employee
Full Name	Full Name of Employee
Street 1	Street 1 Address of Employee
Street 2	Street 2 Address of Employee
City	City of Residence for Employee
State	State of Residence for Employee
Zip	Zip code of Employee
Email Address	Employee Email Address
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 Income of Employee
Fed Taxable Gross	Federal Taxable Gross Income of Employee
Federal Tax Amount	Amount of Federal Tax Deducted from Employee
FICA Taxable Gross	Amount of FICA Taxable Gross of Employee
FICA Tax Amount	Amount of FICA Tax Deducted from Employee
Med Taxable Gross	Amount of Medicare Taxable Gross of Employee
Med Tax Amount	Amount of Medicare Tax Deducted from Employee
Tax State	Taxed State for Employee
State Taxable Gross	State Taxable Gross Pay of Employee
State Tax Amount	Amount of State Tax Deducted
Local Tax Name	Local Tax Name within State
Local Tax State	Name of State with Local Tax
Local Taxable Gross	Local Taxable Gross Pay of Employee
Local Tax Amount	Local Taxable Amount Deducted of Employee

Report Fields

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

Field	Description
SSN	Social Security Number of Employee
Last Name	Last Name of Employee
First Name	Frist Name of Employee
Middle Name	Middle Initial of Employee
Full Name	Full Name of Employee
Street 1	Street 1 Address of Employee
Street 2	Street 2 Address of Employee
City	City of Residence for Employee
State	State of Residence for Employee
Zip	Zip code of Employee
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
Local Tax States	Number of States with Local Tax
Local Taxable Gross	Local Taxable Gross Pay of Employee
Local Tax Amount	Local Taxable Amount Deducted of Employee

Report Fields

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 Names	Number of Local Tax Names
Local Tax States	Number of States with Local Taxes
Local Taxable Gross	Total Amount of Local Taxable Gross Wages
Local Tax Amount	Total Local Tax Amount
BoldTalentID	Employee identifier in AviontéBOLD (Front Office)

Report Fields

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

Back to Top