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.
Comments
0 commentsPlease sign in to leave a comment.