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