Verifying QuickBooks W-2 Worksheet Data Against Payroll Records

QuickBooks prefills the Form W-2 Worksheet with company and employee data already stored in the company file, but those figures still need a careful review before filing. The worksheet pulls wage bases, tax rates, and identification numbers from QuickBooks records, and any discrepancy between those records and what was actually reported to federal agencies needs to be caught and corrected before the form goes out.

What QuickBooks Prefills on the Worksheet

The W-2 Worksheet automatically populates the Employer and Employee sections, along with Boxes 15 through 17, using data from the company file. Some state-specific boxes may not apply depending on location. For instance, North Dakota users do not need to complete Boxes 18 through 20.

The Social Security Wage Base for tax year 2020 was set at $137,700, with employer and employee Social Security tax withheld at 6.2 percent — capped at $8,537.40 per employee.

Verifying Wage and Tax Amounts

The accepted approach is to cross-reference the worksheet against a Payroll Summary report. Running that report for the calendar year in question produces one column per employee paid during the year, with rows showing pay, deductions, and taxes withheld. Those figures should line up with what appears on each employee’s W-2 Worksheet. If a number does not match, the underlying payroll data — not the worksheet itself — is the first place to look.

Correcting an Employee Social Security Number

Box A displays the employee’s Social Security number, drawn directly from the employee record in QuickBooks. The recommendation here is straightforward: compare the number against the employee’s actual Social Security card and keep a copy on file.

A common pitfall is the use of an ITIN in place of an SSN. An Individual Taxpayer Identification Number is formatted like a Social Security number but always begins with a “9” and has a “7,” “8,” or “9” as the fourth digit. ITINs are issued to resident and nonresident aliens who are not eligible for U.S. employment and should never be used for employee identification or W-2 reporting.

If the Social Security number on the worksheet is wrong, the fix requires closing the Payroll Tax Form window first. From the Employee Center, double-click the employee’s name to open the Personal tab, correct the number, and save. Returning to the W-2 form will reflect the updated SSN in Box A.

Correcting the Employer Identification Number

Box B shows the company’s nine-digit federal Employer Identification Number — the same EIN used on Form 941, 943, or 944. QuickBooks pulls this from the Company Information window.

An incorrect EIN on the worksheet means the company record itself needs updating. Close the Payroll Tax Form window, then navigate to the Company menu and select Company Information. Edit the Federal Identification No. field, save the change, and return to the W-2 form. The corrected EIN will appear in Box B.

Company Address and Box C

Box C carries the employer’s full address as recorded in the same Company Information window. As with the EIN, any address errors on the worksheet trace back to that record and can be corrected in the same location.

Why the Verification Step Matters

Because the worksheet draws entirely from existing QuickBooks data, its accuracy depends on the accuracy of the underlying employee and company records. A mismatch discovered after filing — whether a transposed SSN digit, an outdated EIN, or a wage figure that does not reconcile with the Payroll Summary report — creates downstream problems with both federal and state tax agencies. Running the verification steps above before the forms are finalized is the simplest way to avoid that outcome.

For broader QuickBooks payroll help, including troubleshooting wage and tax discrepancies that surface during W-2 preparation, our network covers common issues users encounter at year-end.