Administering Payroll for United States End-of-Year Processing (2024)

Use the W-2 Register report to review your year-end data before distributing your Forms W-2, W-2GU, and W-2PR. This flow supports employee year-end forms for the US and Guam.

Use this report for:

  • Preprint verification

  • Balance verification

  • Exception verification

  • Identification of employees with0 or negative totals in specific boxes on the forms

  • Identification of Puerto Rico employees missing their control number

  • Identification of balance mismatchesfor Pennsylvania locals

This report analyzes data collected by the Archive End-of-Year Payroll Results flow. Use it to validate payroll data for:

  • US states

  • District of Columbia

  • Guam

  • Puerto Rico

To run this report:

  1. From MyClient Groups, click Payroll.

  2. Click Submit a Flow.

  3. Select your US legislative datagroup.

  4. Search for and select W-2 Register.

Before You Start

Successful completion of the Archive End-of-Year Payroll flow. For further info, see Archive End-of-Year Payroll Results for the US in the Help Center.

Report Parameters

Payroll Flow

Meaningful name of your payroll flow.

Tax Report Year

Four-digit calendar year.

Payroll Statutory Unit

Payroll statutory unit (PSU) of the employees you'reprocessing. The flow analyzes the year-end data of employees belongingto this PSU only.

Year-End Form

Select the form type results you want to review.

Tax Reporting Unit

TRU and federal Employer Identification Number (EIN)registered name of the employees you're processing. The flow analyzesthe year-end data of employees belonging to this TRU only.

Payroll Relationship Group

Select the payroll relationship group name, if you have defined one. Payroll relationship groups limit the persons processed by payroll, data entry, and reporting. This can be a dynamic payroll relationship group.

Note: Use the Object Groups task to define the payroll relationship group before you can select it here.

State

To limit the report results to only employees ina state, select it here.

Leaving this field blank reports on all states.

Create Employee Detail Report

Determines if the W-2 Register output includes detailedemployee info.

This value

Does this

Pipe-Delimited Output

Creates an output file suitable for viewing in aspreadsheet.

PDF Output

Creates a PDF output file.

Pipe-Delimited and PDF Output

Creates both file types.

None

Creates no output file.

Create Totals Report

Determines if the W-2 Register output includes infoabout year-end form totals.

Select Yes togenerate output for box totals of all employees within a TRU.

Reporting Info Data Source

The Archive End-of-Year Payroll Results flow captures New York and Puerto Rico W-2 info from the employee Reporting Information Card.

This field provides you with the option to pull this data from the archive or use live data.

Process Configuration Group

Process configuration group for logging and performancepurposes.

Note: Select a process configuration group that has thisparameter set to N: XML Data Source For documentof records delivery options performance purposes, determines if XMLis derived from the database. Default: Y This ensures the flow properly publishes your year-endforms to the Document Records. Use the Payroll Process Configurationtask to set this value.

Report Output

This report displays the amounts reported in eachbox of the year-end form for all employees in a specified PSU or TRUfor the reporting year. The data is organized by:

  • W-2 box number (1 through 20)

  • W-2GU box number (1 through 14)

  • W-2PR box number (1 through 26)

You can display it at the TRU level, as well as theemployee level.

The parameter selections you make when you run the W-2 Register report determine what output is delivered and their file format. This report produces multiple output files.

Report name

How you use it

Employee Detail

For a given reporting year, lists the amounts ofeach box of the W-2 for every employee in a PSU. The data is organizedby W-2 box number (1 through 20), and all boxes are listed, even ifthey're 0 or blank.

Includes the employee's name, Social Security Number,and the individual box totals.

This file is sorted by:

  1. PSU

  2. TRU

Based on your elections when you run the flow, thisreport can be a PDF file, a pipe-delimited spreadsheet file, or both.

Totals

For a given reporting year, lists the total amountsreported in each box of the year-end form for all employees in a TRU.

All boxes are listed, even if they're 0 or blank.

This file is sorted by:

  1. PSU

  2. TRU

The data is organized by TRU type.

US TRUs

  • Federal Totals and Information(Boxes 1 through 14)

  • State Totals (Boxes 15, 16, and17)

    Box 15 is the state.

  • Local Totals (Boxes 18, 19, and20)

    Box 20 is the locality.

  • Total employees successfully processed

  • Total employees receiving only online W-2s

  • Total employees receiving printedand online W-2s

  • Total amount of paper stock required

Guam TRUs

  • Federal Totals and Information (Boxes 3 through 7 and Box 11, 12, and 14)

  • State Totals and Information (Boxes1 and 2)

  • Total employees successfully processed

  • Total employees who received a W-2

Puerto Rico TRUs

  • Federal Totals and Information (Box 5 and 20 through 26)

  • State Totals and Information (Boxes 6 through 19)

  • Total employees successfully processed

  • Total employees receiving only online W-2s

  • Total employees receiving printed and online W-2s

  • Total amount of paper stock required

Exceptions

Includes the following.

  • Exception reporting for all employees,including employees with 0 or negative totals in specific form boxes.

    This lists the following as exceptions.

    US and DC

    • Any one of the following boxeshaving a negative value: 1 through 12 and 16 through 19

    • All the following boxes having 0 values: 1 through 12, 16 through 19

    Guam

    • Any one of the following boxeshaving a negative value: 1 through 7 and 11, 12, and 14

    • All of the following boxes having0 values: 1 through 7 and 11, 12, and 14

    Puerto Rico

    • Any one of the following boxeshaving a negative value: 5 through 26

    • All the following boxes having 0 values: 5 through 26

    • Control Number box is blank

  • TRU totals for those employeesthat meet the exception criteria. Use them to reconcile the differencebetween those that were successfully processed and those that weren't.

  • Following exception count info.

    • Total employees with zero or negative wages

    • Total employees with error in Year End Archive

Pipe-Delimited Output

Available row types for the US and Guam

  • Federal

  • State

  • Box 12

  • Box 14

Available row types for Puerto Rico

  • Federal

  • State

  • Employee box 16

    This row type includes values for boxes 16, 17, and 18.

Warnings

This reports info on:

  • Number of employees whose local balance data doesn't match the individual city and school balances

    Employee details are provided for this warning.

  • Total employees with errors in the year-end archive

Administering Payroll for United States End-of-Year Processing (2024)
Top Articles
Latest Posts
Article information

Author: Duncan Muller

Last Updated:

Views: 6516

Rating: 4.9 / 5 (59 voted)

Reviews: 90% of readers found this page helpful

Author information

Name: Duncan Muller

Birthday: 1997-01-13

Address: Apt. 505 914 Phillip Crossroad, O'Konborough, NV 62411

Phone: +8555305800947

Job: Construction Agent

Hobby: Shopping, Table tennis, Snowboarding, Rafting, Motor sports, Homebrewing, Taxidermy

Introduction: My name is Duncan Muller, I am a enchanting, good, gentle, modern, tasty, nice, elegant person who loves writing and wants to share my knowledge and understanding with you.