QuickBooks W-2 Worksheet: Verifying Employee and Employer Data
QuickBooks prefills W-2 worksheets with company and employee data, but errors in source records carry through to filings unless reviewed before submission.
QuickBooks Desktop’s Form W-2 Worksheet pulls employer and employee information directly from company records, but the prefilled data is only as accurate as what lives in those underlying fields. Users who review the worksheet before filing can catch mismatches that would otherwise create filing errors or require corrections after submission.
How QuickBooks Populates the Worksheet
The W-2 Worksheet automatically fills in the Employer section, the Employee section, and Boxes 15 through 17 using data stored in QuickBooks. Because the software draws from existing company and employee records, any error in those source fields flows directly into the worksheet. The prefilled amounts should be cross-checked against a Payroll Summary report for the calendar year being reported. That report displays one column per employee paid during the year, with rows showing pay, deductions, and taxes withheld — figures that should match what appears on each employee’s W-2.
Verifying Employee Identification
Box A contains the employee’s Social Security number, pulled 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 IRS 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 but need identification for other tax purposes. They are recognizable by their format: a nine-digit number beginning with “9” and having a “7,” “8,” or “9” as the fourth digit.
If the SSN needs correction, the fix requires closing the Payroll Tax Form window and opening the Employee Center. From the Employees tab, double-click the employee name to reach the Personal tab, where the Social Security number can be edited. Saving the change updates Box A when you return to the worksheet.
Verifying the Employer Identification Number
Box B holds the company’s nine-digit federal Employer Identification Number — the same number used on federal employment tax returns such as Forms 941, 943, or 944. QuickBooks pulls this from the Company Information window.
An incorrect EIN in Box B means the source data in QuickBooks is wrong. Correcting it requires closing the Payroll Tax Form window, navigating to the Company menu, selecting Company Information, and editing the Federal Identification No. field. After saving, the corrected EIN populates Box B on the worksheet.
Verifying Company Name and Address
Box C carries the company’s full legal name and address — again, the same information that should appear on federal employment tax returns. QuickBooks populates this from the Legal Information section of company settings. If the name or address is wrong on the worksheet, the underlying legal information in QuickBooks needs to be updated before filing.
Boxes That May Not Apply
Depending on the state, certain W-2 boxes may not be relevant. For Georgia filers, for example, Boxes 8, 14, and 18 through 20 are not applicable. Users in other states should confirm which boxes apply to their specific filing requirements rather than assuming every box needs to be populated.
State Filing Deadlines
State due dates for W-2 submissions vary. Georgia’s filing deadline aligns with the federal January 31 deadline, but users should verify the specific deadline for their own state each tax season, as these can change.
Social Security Wage Base
The Social Security wage base is set annually by the Social Security Administration and changes from year to year. QuickBooks payroll updates typically reflect the current year’s limits, but users should confirm that their payroll tables are up to date so withholding calculations match the correct threshold and rate for the filing year.
The Core Takeaway
The W-2 Worksheet is a prefilled document, not a verified one. Every field it contains originates from somewhere else in QuickBooks — employee records, company information, or legal information settings. The review process exists because those source fields can and do contain errors, and those errors propagate into tax filings unless caught at the worksheet stage. Running a Payroll Summary report and comparing it line by line against the worksheet remains the most reliable way to confirm that what QuickBooks generated matches what actually happened during the year. When a field is wrong on the worksheet, the fix is almost always to correct the underlying record — not to overwrite the worksheet field alone.