QuickBooks W-2 Worksheet: Verifying Data Before E-Filing and E-Paying

QuickBooks Desktop users working through the Form W-2 worksheet during year-end payroll processing frequently need to confirm that the data prefilled by the software is accurate before submitting forms electronically. The W-2 worksheet in QuickBooks automatically populates employer details, employee information, and several wage boxes directly from the company file, but the software still relies on the user to verify that those figures match official records.

Where the Numbers Come From

QuickBooks pulls W-2 data from the information stored in the company file — employee records, company information, and payroll transactions processed throughout the year. The worksheet prefills fields such as the employer identification number, company name and address, employee Social Security numbers, and wage totals. Because that data originates from what was entered during routine payroll processing, any errors in the underlying records will carry through to the W-2 unless they are caught and corrected first.

Verifying Amounts With the Payroll Summary Report

The most reliable way to confirm W-2 figures is to run a Payroll Summary report for the full 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 employee’s totals on that report should align with the corresponding entries on their W-2 worksheet. Discrepancies between the two typically indicate a data-entry error or a misclassified payroll item that needs to be corrected before filing.

Checking Employee Social Security Numbers

Box A of the W-2 contains the employee’s Social Security number, which QuickBooks draws from the employee record. Users should compare this figure against the employee’s actual Social Security card rather than relying on a prior form or a handwritten note. If the number is wrong, the correction happens outside the tax-form window. Close the W-2 worksheet, open the Employee Center, double-click the employee’s name to access their personal information, update the Social Security number field, and save the change. Returning to the W-2 worksheet will then display the corrected number.

One point that catches some employers off guard: an Individual Taxpayer Identification Number, or ITIN, is not a substitute for a Social Security number on Form W-2. ITINs are issued to certain resident and nonresident aliens who are not authorized to work in the United States and need a tax identification number for other purposes. An ITIN is recognizable because it begins with the digit 9 and has a 7, 8, or 9 as the fourth digit. Employees who present an ITIN instead of an SSN should not have wages reported on a W-2 using that number.

Verifying the Employer Identification Number

Box B carries the nine-digit federal Employer Identification Number, or EIN, assigned to the company by the IRS. This number must match what appears on federal employment tax returns — Forms 941, 943, or 944, depending on the filing schedule. QuickBooks populates Box B from the Company Information window. If the EIN is incorrect, the fix requires closing the tax-form window, navigating to the Company menu, selecting Company Information, updating the Federal Identification Number field, and saving. The corrected EIN will then appear on the worksheet.

Confirming Company Name and Address

Box C displays the company’s full legal name and address, which should also match federal employment tax filings. As with the EIN, QuickBooks pulls this information from the company file’s legal information section. If the legal name or address on file is outdated or was entered incorrectly, updating it in the same Company Information area ensures the W-2 reflects the correct details.

The Broader Takeaway

The W-2 worksheet is designed to streamline year-end filing, but it is only as accurate as the data stored in the company file. Running a full-year Payroll Summary report and cross-checking identifying information against source documents — Social Security cards, IRS correspondence, and prior tax returns — remains the most effective way to catch errors before electronic submission. Correcting a wrong Social Security number, EIN, or company address after the fact is straightforward, but only if the user spots the discrepancy before filing.