Employee W2 File Update
Use the W2 Employee page to add, change, and delete employee records in your W2 workfile. This page also includes an Import item on the Action Bar which allows you to import DD - Employer-Sponsored Health Cost amounts from files stored on your PC or shared network, with extensions *.xml, *.exml, *.csv, *.txt, and *.unl.
Menu Path: Human Resources > Periodic Routines > Year End > W2 Processing > click Employee W2 File Update
Note
If changes are made in Human Resources > Entry & Processing > Employee > Employee Information to an employee's Social Security Number, Last Name, First Name, Middle Name, Suffix, Address (Lines 1-2), City, State, or Zip Code, a message displays, asking if you want to update the W2 and 1099R records with the changes. This message will only display if:
If the W2 Address Prompting Enabled checkbox on the W2 Processing page is selected.
The system month is January.
W2 / 1099R information exists for the prior year.
Selecting Yes on this message will update the W2 / 1099R information for that employee.
Prerequisites
Before running the Employee W2 File Update option, confirm that the following setup options have been run:
Set Up W2 Parameters
Set Up Employer Records
Copy W2 Information
Create Employee W2 File
Listing Employee Records
Select Human Resources > Periodic Routines > Year End > W2 Processing, and then click Employee W2 File Update to display the W2 Employee File Update page.
In the Search Criteria section, enter criteria to identify employee records for the tax year being reported. Except for the Tax Year, the section's fields accept multiple entries. For more information, refer to the Fields below.
Click OK when you finish your selection criteria. All records matching your criteria will display in the List section.
Adding Employee Records
Select Human Resources > Periodic Routines > Year End > W2 Processing, and then click Employee W2 File Update to display the W2 Employee File Update page.
Click Add New on the Toolbar.
Complete the tab's fields, as specified in the Fields section.
When you complete the last field in a tab, the next tab displays.Repeat Step 3 for each tab.
When you press <Tab> in the last field of the Deductions tab (the last tab), the cursor returns to the Continuous checkbox in the Header tab.Click OK to save the record when you complete your entries.
If you selected the Continuous checkbox, you may enter another record by repeating Steps 3-4. After you save the last record, click Back.
Changing Employee Records
Complete the procedure for Listing Employee Records.
In the W2 Employee File Update page's List section, select the record you want to change, and then click OK to access the Header tab.
Change the desired fields.
Click OK to save your changes and return to the List section.
Repeat Steps 2-4 for each record you need to change.
Deleting Employee Records
Complete the procedure for Listing Employee Records.
In the W2 Employers File Update page's List section, select the record you want to delete.
Select Delete on the Toolbar. A Confirmation dialog will display.
Click Yes to delete the record.
Repeat Steps 2-4 for each record you want to delete.
Click No to return to the Search Criteria section.
Search Criteria and List Sections
These sections contain the same fields, except for the List section’s Sequence Number field. Use the Search Criteria section to enter criteria for listing existing employee W2 records. After displaying records in the List section, you can select a record to view, update, or delete.
Field | Description |
|---|---|
Tax Year | Tax year that applies to the W2 information being submitted. |
Control Number | Control number. You can enter multiple control numbers by using the pipe ( | ) to separate each, for example, A123|B123|C123. Character/8 |
Employee Number | Employee’s ID number. You may use the pipe symbol to select multiple employees. Refer to the Control Number field for an example. |
Sequence Number | Sequential number identifying an employee’s workfile record in combination with the employee ID. This field only appears in the List section. For additional details, refer to the description of the Sequence Number field in the following section on the Header tab. |
First Name | Employee’s first name and middle initial. |
Last Name | Employee’s last name and suffix (if applicable). If you are searching for multiple employees, insert the pipe symbol between their last names, for example, BECK/TAYLOR JR/HENDRICKSON. In this case, you should leave the Search Criteria section’s First Name field blank. |
Header Tab
Use this tab to enter header information for the employee’s W2. All fields, except Continuous, are required.
Field | Description |
|---|---|
Tax Year | Calendar year being reported on the W2 form. The Tax Year and Control Number fields combine to identify a W2 workfile. As a result, neither of these fields can be changed. |
Control Number | Number or code identifying the current workfile in combination with the tax year. When adding a record, you must enter a valid tax year/control number combination. |
Employee Number | Employee’s ID number. The Employee Number and Sequence Number fields combine to identify an employee’s record within the W2 workfile. |
Sequence Number | One-digit sequential number identifying an employee workfile record in combination with the employee’s ID. When you run the Create Employee W2 File option, the system assigns the sequence number 0 to employees’ initial records. If additional records are generated for an employee in the same workfile, the system assigns 1 to the second record, 2 to the third record, and so forth. If needed, you may change the assigned number. You can have up to 10 records per employee (0-9), including the initial record. |
Employee Type | Code identifying the employee’s status in regard to FICA taxes: R - Regular - Identifies employees subject to the full FICA tax, which includes both Social Security and Medicare. |
Address Tab
Use this tab to further identify the employee. Except for the check location, this information appears on the employee’s W2. All fields are required, except the Address 2 field.
Field | Description |
|---|---|
Check Location | Code identifying the location where the employee receives pay checks or direct deposit vouchers, as defined in Personnel’s Location table. To facilitate W2 form distribution, enter the check location code from the Payroll tab of the employees’ Employee Information detail page in Human Resources. |
Social Security | Employee’s Social Security number (SSN). The system provides the dashes. This should match the SSN stored in the Employee Information page. |
First Name | Employee’s first name as it should appear on the W2. Character/30 |
Middle Name | Employee’s middle name as it should appear on the W2. Character/30 |
Last Name | Employee’s last name as it should appear on the W2. Character/30 |
Suffix | Employee’s suffix as it should appear on the W2. |
Address 1-2 | Two fields for the employee’s address, the first for the street name and number and the second for additional address information, such as a post office box or rural delivery number.Character/30 each |
City | City where the employee resides. |
State | Standard two character abbreviation for the state where the employee resides. The drop-down list includes abbreviations for all 50 states. |
Zip Code | Two fields for the zip code, the first for the five-digit code and second for the four-digit extension. The system provides the dash before the extension. |
Foreign Address | Checkbox indicating the employee has a foreign address. |
Foreign State | The foreign state where the employee resides. |
Foreign Postal Code | The foreign postal code where the employee resides. |
Foreign Country Code | The two-character foreign country code where the employee resides. |
Wages Tab
Use this tab to identify the Federal, Social Security, Medicare, State, and Local taxes and wages reported for the current employee. Tax and Wages fields are provided for each category. The tab also includes State and Locality fields. These are the four sets of unlabeled fields the bottom of the tab.
The W2 form only accommodates two states and two localities. If you need to report tax data for other states and localities for an employee, you must prepare an additional form, depending on state and local reporting requirements.
Field | Description |
|---|---|
Federal | Federal taxes withheld and wages received in the tax year. |
Social Security | Social Security taxes withheld and FICA wages received in the tax year. |
Medicare | Medicare tax withheld and Medicare wages in the tax year. For employees who earn $200,000 and over, this will include the *AM deduction amount taken for the year. |
State 1-2 (unlabeled) | Two fields with drop-down lists, the first for the employee’s current state and the second for an additional state. State taxes withheld and wages received for tax year. |
Locality 1-2 (unlabeled) | Two fields, the first for the employee’s current locality and the second for an additional locality. You may abbreviate the names as needed. Local taxes withheld and wages received for the tax year. Character/8 each
|
Tips Tab
Use this tab to enter certain designations and to report amounts for tips, income credits, dependent care, and deferrals.
Field | Description |
|---|---|
Statutory Employee | Checkbox for identifying a statutory (942) employee. A statutory employee is subject to Social Security or Medicare but not federal income tax. For additional information, refer to the IRS Circular E, Employer's Tax Guide. |
Retirement Plan | Checkbox for identifying an employee who is an active participant in a retirement plan. The system selects this box if the employee has one of the deduction codes identified in the W2 Workfile Pension page. |
Third Party Sick | Checkbox for indicating that the employee has received third-party sick pay. Leave the box blank if this does not apply. |
Dependent Care | Amount paid or incurred for dependent care benefits under Section 129 of the IRS Code. |
Allocated Tips | Allocated tips subject to federal taxes. |
Social Security Tips | Tips subject to Social Security taxes. |
Nonqualified Section 457 | Distributions from non-qualified section 457 plans. |
Nonqualified Non-Section 457 | Distributions from non-qualified nonsection 457 plans. |
Deductions Tab
Use this tab to enter codes and amounts related to employee deductions and benefits, as required for Box 12 of the W2 form. If an employee has more than four of the deductions identified in the W2 Workfile Box 12 page (Create Employee W2 File option), you must submit separate W2 forms to report the additional deductions.
Field | Description |
|---|---|
Box 12 A-D | Four lines of two fields each. In the first field, select a code identifying Box 12 income as defined in the IRS Circular E, Employer's Tax Guide. In the second field, enter the amount. Following are the IRS codes. Note that the descriptions are spelled out here, whereas they are abbreviated in the drop-down list. A - Uncollected Social Security Tax on Tips |
Box 14 | Five lines of two fields each for entering Box 14 information, as defined by the deductions and pay codes entered in the W2 Workfile Box 14 page (Create Employee W2 File option).
|
Import Box 12 and Box 14 amounts
For information about importing Box 12 and Box 14 amounts, refer to Employee W2 File Update - Import Box 12 and Import Box 14.