Verifying W-2 Worksheet Data in QuickBooks Desktop Payroll

QuickBooks Desktop’s Form W-2 Worksheet pulls payroll data directly from a company file, but the pre-filled amounts and identifying numbers still need a careful review before any return goes out the door. The worksheet is designed to save time by auto-populating employer details, employee information, and key tax boxes — yet several common trouble spots can cause a filing to be rejected or require correction after the fact.

Confirming the Pre-Filled Amounts

QuickBooks populates the W-2 worksheet using the data already stored in the company file. Employer and employee sections, along with boxes covering state tax information, are filled in automatically. North Dakota users should note that certain state-level boxes are not applicable and will remain empty.

The recommended way to verify that the worksheet amounts 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 on the report should line up with the corresponding entry on the employee’s W-2 worksheet. Discrepancies between the two typically point to a data-entry error or a misclassified paycheck earlier in the year.

Social Security Wage Base

For tax year 2020, the Social Security wage base is set at $137,700. The employer and employee portions of Social Security tax are each withheld at 6.2 percent, up to a maximum of $8,537.40 per side. QuickBooks uses these figures when calculating the amounts that appear on the worksheet, but it is still worth confirming that no employee exceeded the cap without the withholding stopping at the correct point.

Box A: Employee Social Security Numbers

Box A carries the employee’s nine-digit Social Security number, which QuickBooks draws directly from the employee record. The guidance is straightforward: compare the number on the worksheet against the employee’s actual Social Security card and keep a copy on file.

A frequent error is the accidental use of an Individual Taxpayer Identification Number, or ITIN, in place of a valid 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. They are recognizable by the fact that they begin with a “9” and have a “7,” “8,” or “9” as the fourth digit. An ITIN must never be used for employee identification or W-2 reporting.

If the number in Box A is wrong, close the Payroll Tax Form window by choosing Save & Close. Open the Employee Center, select the Employees tab, and double-click the employee’s name to reach the Personal tab. Edit the Social Security number there, click OK, and the corrected value will appear in Box A when you return to the worksheet.

Box B: Employer Identification Number

Box B holds the company’s nine-digit federal Employer Identification Number — the same number used on Form 941, Form 943, or Form 944. QuickBooks pulls this from the Company Information window. When the EIN shown in Box B does not match the number on filed employment tax returns, the fix is to close the tax-form window, go to the Company menu, select Company Information, and update the Federal Identification No. field. After saving, the corrected EIN will display on the worksheet.

Why Verification Matters

Rejected W-2 filings are frequently traced back to mismatched identification numbers or totals that do not reconcile with the underlying payroll records. Running the Payroll Summary report and checking each box against source documents catches these issues before submission, when corrections are still simple edits rather than amended returns.

For broader help with payroll setup, reporting, and troubleshooting in QuickBooks Desktop, readers can browse the knowledge base at QuickBooksUsers.com.