QuickBooks W-2 Worksheet: Verifying Employee and Employer Data Before Filing

QuickBooks Desktop users working through the Form W-2 Worksheet during year-end processing have raised questions about how to verify the amounts the software pre-fills — and, more fundamentally, how to confirm that the identifying information on each form is correct before filing. The accepted guidance walks through both the number-verification process and the steps for fixing two of the most common data-entry errors: a wrong Social Security number on an employee record and an incorrect Employer Identification Number on the company file.

What QuickBooks Pre-Fills on the Worksheet

When you open the W-2 worksheet, QuickBooks automatically populates the employer section, the employee section, and boxes 15 through 17 using data stored in your company file. For New Jersey users, boxes 18 through 20 are noted as not applicable. The guidance stresses that you should review every pre-filled value against the federal W-2 forms you actually filed rather than assuming the numbers are correct simply because the software entered them.

Verifying Wage and Tax Amounts

The recommended method for confirming that the dollar amounts on each employee’s W-2 worksheet are accurate is to run a Payroll Summary report for the calendar year being reported. That report displays one column per employee paid during the year, with rows showing gross pay, deductions, and taxes withheld. Each figure should line up with the corresponding entry on the employee’s W-2 worksheet. If a discrepancy appears, the payroll data itself — not the worksheet — is where the investigation should begin.

Correcting an Employee Social Security Number (Box A)

Box A on the worksheet contains the employee’s nine-digit Social Security number, which QuickBooks pulls directly from the employee record. The guidance recommends checking the number against the employee’s actual Social Security card and keeping a copy on file.

One point the answer highlights clearly: an Individual Taxpayer Identification Number, or ITIN, is never a valid substitute for an SSN on Form W-2. ITINs are issued only to certain resident and nonresident aliens who are not eligible for U.S. employment and need a tax identifier for other purposes. You can spot an ITIN because it is a nine-digit number that begins with “9” and has a “7,” “8,” or “9” as the fourth digit — formatted to look like an SSN but legally distinct.

If the SSN in Box A is wrong, the fix is straightforward. Close the Payroll Tax Form window by clicking Save & Close, then open the Employee Center and select the Employees tab. Double-click the employee’s name to open the Personal tab on their record, edit the Social Security number, and click OK to save. When you return to the W-2 worksheet, the corrected number appears in Box A automatically.

Correcting the Employer Identification Number (Box B)

Box B carries the nine-digit EIN the IRS assigned to your company — the same identifier you use on Form 941, Form 943, or Form 944. QuickBooks draws this number from the Company Information window. If the EIN displayed in Box B is incorrect, close the Payroll Tax Form window, go to the Company menu, and choose Company Information. Edit the number in the Federal Identification No. field, click OK, and the corrected EIN will populate the worksheet when you return.

Why These Corrections Matter

Errors in Box A or Box B are not cosmetic. A mismatched SSN can cause the Social Security Administration to reject earnings credits for the employee, while an incorrect EIN can trigger matching failures on your federal employment tax returns. Catching both before you e-file — and confirming that every dollar figure ties back to a Payroll Summary report — is the cleanest path to a clean filing season.

For broader year-end payroll help, including worksheet troubleshooting and form-preparation walkthroughs, our QuickBooks payroll resources cover common scenarios Desktop users encounter.