QuickBooks W-2 Worksheet: Verifying Employee Data Before Filing

QuickBooks Desktop users working through the Form W-2 Worksheet during tax season frequently ask how to verify the data the software pre-fills — and how to proceed with electronic filing and payment. The worksheet pulls wage and tax information directly from each employee’s record, but the responsibility for confirming accuracy before submission remains with the employer.

What QuickBooks Pre-Fills on the W-2 Worksheet

The W-2 worksheet in QuickBooks Desktop automatically populates the Employer and Employee sections, along with Boxes 15 through 17, using data stored in the company file. Boxes 18 through 20, which cover local wages and taxes, are not applicable for all states — Wisconsin users, for instance, can skip those fields entirely.

Because the worksheet draws from existing payroll data, any errors in the underlying employee records or company information will carry through to the form. The worksheet is only as accurate as the data feeding it.

Verifying Amounts Against the Payroll Summary Report

The accepted approach for confirming W-2 figures 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 pay, deductions, and taxes withheld. Each figure should match what appears on that employee’s W-2 worksheet.

If a discrepancy surfaces, the underlying payroll data needs to be corrected in the employee record or company settings before the form is finalized.

Checking Social Security Numbers in Box A

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

A common error is using an Individual Taxpayer Identification Number (ITIN) in place of an SSN. ITINs are issued only to resident and nonresident aliens who are not eligible for U.S. employment and need identification for other tax purposes. An ITIN is recognizable because it is a nine-digit number that begins with “9” and has a “7,” “8,” or “9” as the fourth digit — formatted similarly to an SSN but never valid for W-2 reporting.

If the Social Security number on the worksheet is wrong, the fix requires closing the Payroll Tax Form window and navigating to the Employee Center. From there, double-clicking the employee’s name opens the Personal tab, where the SSN can be edited. Saving the change and returning to the W-2 worksheet will display the corrected number in Box A.

Correcting the Employer Identification Number in Box B

Box B carries the nine-digit Employer Identification Number assigned by the IRS — the same number used on federal employment tax returns (Forms 941, 943, or 944). QuickBooks pulls this from the Company Information window.

If the EIN displayed in Box B is incorrect, the Payroll Tax Form window should be closed. The correction is made through the Company menu by selecting Company Information, where the EIN field can be edited. Once updated, the worksheet reflects the corrected number.

Social Security Wage Base and Tax Limits

The worksheet enforces annual caps on Social Security wages and withholding. The combined total of Box 3 (Social Security wages) and Box 7 (Social Security tips) cannot exceed the annual wage base limit set by the Social Security Administration. Similarly, the Social Security tax withheld in Box 4 is capped at a percentage of that wage base.

These limits change each year, so the figures that applied for one tax year will not match the next. QuickBooks applies the correct limits for the tax year selected on the worksheet, but users should confirm that the year shown matches the period they intend to report.

Electronic Filing and Payment

For users asking specifically about e-filing and e-paying through QuickBooks, the worksheet is the starting point — but the actual electronic submission depends on having active payroll services configured in the company file. The e-file and e-pay options appear within the Payroll Tax Form workflow once the worksheet data has been reviewed and saved.

Before initiating any electronic submission, confirming that all employee and employer identification numbers are correct — and that wage and tax totals match the Payroll Summary report — reduces the likelihood of rejection or the need for amended filings.