Verifying QuickBooks W-2 Worksheet Data Against Payroll Summary Reports

When preparing W-2 worksheets in QuickBooks, users frequently need to confirm that the data prefilled by the software matches their actual payroll records. QuickBooks automatically populates the employer and employee sections of the W-2 worksheet — including boxes 15 through 17 — using the company and employee information stored in the file. However, that automation does not eliminate the need for a careful review before filing.

Verifying Wage and Tax Amounts

The most reliable way to confirm that the dollar amounts on each employee’s W-2 worksheet are correct is to run a Payroll Summary report for the calendar year being reported. This report displays one column per employee paid during the year, with rows showing gross pay, deductions, and taxes withheld. Each figure on the report should line up with the corresponding amount on the employee’s W-2 worksheet. If anything does not match, the discrepancy should be investigated and corrected before the forms are finalized.

Checking Box A: Employee Social Security Numbers

Box A carries the employee’s Social Security number. QuickBooks pulls this directly from the employee’s record, so the first step is confirming it was entered correctly in the first place. The recommendation here is straightforward: compare the number against the employee’s actual Social Security card and keep a copy on file.

A common point of confusion involves Individual Taxpayer Identification Numbers, or ITINs. An ITIN is not a substitute for a Social Security number for employment or W-2 reporting purposes. ITINs are issued only to certain resident and nonresident aliens who are not eligible for U.S. employment but need a tax identification number for other reasons. They are recognizable by their format: a nine-digit number that begins with “9” and has a “7,” “8,” or “9” as the fourth digit. If an employee’s record contains an ITIN where a Social Security number belongs, it must be corrected.

To fix an incorrect Social Security number, close the payroll tax form window and open the Employee Center. From the Employees tab, double-click the employee’s name to open their record, navigate to the Personal tab, and update the number. Saving the change and returning to the W-2 form will reflect the corrected figure in Box A.

Checking Box B: Employer Identification Numbers

Box B displays the company’s nine-digit Employer Identification Number, or EIN — the same number used on federal employment tax returns such as Forms 941, 943, or 944. QuickBooks draws this from the Company Information window. If the EIN showing in Box B is wrong, the fix involves closing the tax form window, going to the Company menu, selecting Company Information, and editing the Federal Identification Number field. After saving, the corrected EIN will appear on the W-2.

Box C and Company Information

Box C carries the employer’s full legal name and address, which also originates from the Company Information window in QuickBooks. As with the EIN, any errors here should be corrected at the source so that the W-2 worksheet pulls the accurate details on the next refresh.

State-Specific Considerations

For users in certain states, not every box on the W-2 worksheet will apply. Montana filers, for example, do not need to complete boxes 18 through 20. Users in other states should confirm which boxes are relevant to their state filing requirements before spending time on data that does not need to be reported.

Social Security Wage Base

For tax year 2020, the Social Security wage base was set at $137,700, with the employer and employee tax rate withheld at 6.2 percent — capping the maximum withholding at $8,537.40 per employee. While QuickBooks calculates these figures automatically based on the payroll data in the file, the wage base and rate are useful benchmarks when reviewing the worksheet for reasonableness.

The Bottom Line

The W-2 worksheet in QuickBooks is a prefilled form, not a verified one. The software does the heavy lifting by pulling data from employee records and company settings, but the responsibility for accuracy still rests with the employer. Running a Payroll Summary report, confirming identification numbers against source documents, and verifying employer details in the Company Information window are the practical steps that catch errors before they reach the IRS or the employee.

For users dealing with broader payroll data discrepancies or damaged company files that are producing incorrect wage totals, the underlying data file itself may need attention before the W-2 worksheets can be trusted.