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.

 

Articles in this section

Was this article helpful?
0 out of 0 found this helpful
Share

Comments

0 comments

Please sign in to leave a comment.