W-2 Detail Report
  • 19 Nov 2024
  • 2 Minutes to read
  • Dark
    Light
  • PDF

W-2 Detail Report

  • Dark
    Light
  • PDF

Article summary

The W-2 Detail report displays employee W-2 details for each box on the federal W-2 form. This report is used to audit data accuracy and box placement during the year end W-2 review process.

The W-2 Detail report will be blank if W-2s have not been generated for review. Refer to the year end checklist for the dates of the W-2 review period for the current year.


Navigation

To download the W-2 Detail report:

  1. Navigate to the Workforce Reports page.

  2. Scroll to the People section.

  3. Click the Download button associated with the W-2 Detail report


W-2 Review Steps

W-2s will be available for review during the first week of January.

In the first week of January, W-2s should to be checked for accurate data placement on the form and employee totals for earnings and taxes. Any corrections must be submitted to R365 Support as W-2C requests.

Review Steps:

  1. Download the W-2 Detail report.

  2. Download the Payroll by Pay Date report for the entire year.

  3. Confirm the accuracy of totals per employee.

  4. Ensure that all boxes on the W-2 form are correctly filled with the appropriate data.

  5. If discrepancies are identified, submit data placement and employee total issues to R365 Support as W-2C requests.


Report Columns

The W-2 Detail report has the following columns:

For box definitions and general W-2 instructions, please refer to the IRS documentation.

Column

Column Title

A

Employer Identification Number

B

Employer's Name Line 1

C

Employer's Name Line 2 (Optional)

D

Employer's Disregarded Entity

E

Employer's Address (Line 1)

F

Employer's Address Line 2 (Optional)

G

Employer's City

H

Employer's State

I

Employer's Zip Code

J

Employer's Country

K

Employer's Email(Optional)

L

Employer's Phone Number

M

Business Was Terminated During This Tax Year (Optional)

N

Employee's Social Security Number

O

Employee's First Name

P

Employee's Middle Name (Optional)

Q

Employee's Last Name

R

Employee's Suffix (Optional)

S

Employee's Address Line 1

T

Employee's Address Line 2 (Optional)

U

Employee's City

V

Employee's State

W

Employee's Zip Code

X

Employee's Country

Y

Employee's Email Address (Optional)

Z

Employee's Phone Number (Optional)

AA

Wages Tips & Other Compensation (Box 1)

AB

Federal Income Tax Withheld (Box 2)

AC

Social Security Wages (Box 3)

AD

Social Security Tax Withheld (Box 4)

AE

Medicare Wages And Tips (Box 5)

AF

Medicare Tax Withheld (Box 6)

AG

Social Security Tips (Box 7)

AH

Allocated Tips (Box 8)

AI

Dependent Care Benefits (Box 10)

AJ

Nonqualified Plans (Box 11)

AK

Box 12A Code (Box 12a)

Box12a contains the code for uncollected Social Security taxes

AL

Box 12A Amount (Box 12a)

Box12a contains the amount of uncollected Social Security taxes

AM

Box 12B Code (Box 12b)

Box12b contains the code for uncollected Medicare taxes

AN

Box 12B Amount (Box 12b)

Box12b contains the amount of uncollected Medicare taxes

AO

Box 12C Code (Box 12c)

AP

Box 12C Amount (Box 12c)

AQ

Box 12D Code (Box 12d)

AR

Box 12D Amount (Box 12d)

AS

Statutory Employee (Box 13)

AT

Retirement Plan (Box 13)

This box will be checked when the employee has a Simple IRA deduction. The amount of the Simple IRA deduction will be in Box 12 Code S.

AU

Third-Party Sick Pay (Box 13)

AV

Other Line 1 (Box 14)

AW

Other Line 2 (Box 14)

AX

Other Line 3 (Box 14)

AY

Other Line 4 (Box 14)

AZ

Other Line 5 (Box 14)

BA

Other Line 6 (Box 14)

BB

Other Line 7 (Box 14)

BC

Other Line 8 (Box 14)

BD

State Name 1 (Box 15)

BE

State Name 2 (Box 15)

BF

State Name 3 (Box 15)

BG

State Name 4 (Box 15)

BH

State ID 1 (Box 15)

BI

State ID 2 (Box 15)

BJ

State ID 3 (Box 15)

BK

State ID 4 (Box 15)

BL

State Wages Tips Etc 1 (Box 16)

BM

State Wages Tips Etc 2 (Box 16)

BN

State Wages Tips Etc 3 (Box 16)

BO

State Wages Tips Etc 4 (Box 16)

BP

State Income Tax 1 (Box 17)

BQ

State Income Tax 2 (Box 17)

BR

State Income Tax 3 (Box 17)

BS

State Income Tax 4 (Box 17)

BT

Local Wages Tips Etc 1 (Box 18)

BU

Local Wages Tips Etc 2 (Box 18)

BV

Local Wages Tips Etc 3 (Box 18)

BW

Local Wages Tips Etc 4 (Box 18)

BX

Local Income Tax 1 (Box 19)

BY

Local Income Tax 2 (Box 19)

BZ

Local Income Tax 3 (Box 19)

CA

Local Income Tax 4 (Box 19)

CB

Local Name 1 (Box 20)

CC

Local Name 2 (Box 20)

CD

Local Name 3 (Box 20)

CE

Local Name 4 (Box 20)

CF

User Id


Was this article helpful?