QuickBooks W-2 Worksheet: Verifying Data and Correcting SSN Errors

QuickBooks Desktop users preparing annual W-2 forms encounter a pre-filled worksheet that pulls federal wage and tax data directly from the company file — but the accuracy of that data depends on what was entered throughout the year, and several fields require manual review before submission.

What QuickBooks Pre-Fills on the W-2 Worksheet

The W-2 worksheet arrives with employer and employee identifying information already populated, along with boxes 15 through 17 (state and local tax data). For users on QuickBooks 2011 or later, federal wage and tax amounts in boxes 1 through 13 are also pre-filled from payroll records. Users on QuickBooks 2010 or earlier must manually copy figures from their federal W-2s into those boxes, since the older versions do not auto-populate them.

Box 12, Code DD — the cost of employer-sponsored health coverage — is tracked by QuickBooks and appears on the worksheet. For small employers (those who filed fewer than 250 W-2 forms for the prior year), reporting this amount is optional. Employers at or above that threshold are required to report it.

Verifying Amounts Against Payroll Records

The accepted guidance is to run a Payroll Summary report for the calendar year being reported. This report produces one column per employee paid during the year, with rows showing gross pay, deductions, and taxes withheld. Each figure should match the corresponding amount on the employee’s W-2 worksheet. Discrepancies between the report and the worksheet typically indicate a data-entry error or a payroll item mapped to the wrong box earlier in the year.

Correcting an Employee Social Security Number

Box A on the worksheet contains the employee’s Social Security number, pulled from the employee record in QuickBooks. The recommendation is to check the number against the employee’s actual Social Security card and keep a copy on file.

A common error is using an ITIN (Individual Taxpayer Identification Number) in place of an SSN. ITINs are issued only to resident and nonresident aliens who are not eligible for U.S. employment and need a tax identification number for other purposes. An ITIN can be identified by its format: a nine-digit number beginning with “9” that has a 7, 8, or 9 as the fourth digit (for example, 9NN-7N-NNNN). QuickBooks users who discover an ITIN was entered where an SSN belongs must correct the employee record before filing.

Steps to Fix the SSN in the Employee Record

If the Social Security number on the W-2 worksheet is wrong, close the Payroll Tax Form window by clicking Save & Close. Then:

1. Open the Employee Center from the QuickBooks navigation panel.
2. Click the Employees tab at the top of the window.
3. Double-click the employee’s name in the list to open their record.
4. The Personal tab appears by default — this is where the Social Security number field lives.
5. Correct the number in the SSN field.
6. Click OK to save the employee record.
7. Return to the W-2 worksheet; the corrected SSN should now appear in Box A.

Fields Not Applicable to All Users

Boxes 8, 14, and 18 through 20 do not apply to Illinois users, per the worksheet guidance. Users in other states should consult their state’s W-2 instructions to determine which of these boxes require entries.

A Note on Older Versions

Users still running QuickBooks 2010 or earlier face the added burden of manually completing boxes 1 through 13, since those versions lack the auto-fill capability introduced in 2011. For anyone maintaining an older installation — whether by choice or necessity — keeping QuickBooks Desktop running on unsupported versions is possible, though the manual W-2 workflow is one of the trade-offs.