Verifying Form W-2 Worksheet Data in QuickBooks Before Filing
QuickBooks users preparing annual W-2s can verify pre-filled worksheet amounts against payroll summary reports and correct mismatched employer or employee identification numbers.
QuickBooks Desktop’s Form W-2 worksheet pulls company and employee data automatically, but the prefilled values are only as accurate as the underlying records. Users who open the worksheet during year-end processing sometimes find that identification numbers, wage bases, or state-specific boxes need a second look before filing.
What QuickBooks Prefills
The W-2 worksheet in QuickBooks automatically populates the Employer section, the Employee section, and Boxes 15 through 17 using data stored in the company file. For Montana users, Boxes 18 through 20 do not apply and should be left as-is.
The Social Security Wage Base for tax year 2020 was set at $137,700, with employer and employee Social Security tax withheld at 6.2 percent — capped at $8,537.40 per employee. QuickBooks uses these figures when calculating the worksheet, but users should confirm that the prefilled data matches the federal W-2s they actually filed.
Verifying Wage and Tax Amounts
The accepted approach is to cross-reference the worksheet against a Payroll Summary report for the calendar year being reported. To run it, generate the report for the full tax year. QuickBooks will display one column per employee paid during that period, with rows showing gross pay, deductions, and taxes withheld. Each figure on that report should line up with the corresponding entry on the employee’s W-2 worksheet.
If any number on the worksheet does not match the Payroll Summary report, the discrepancy usually traces back to a data-entry error in the employee record or company information — not the worksheet itself.
Correcting an Employee Social Security Number (Box A)
Box A displays the employee’s nine-digit Social Security number, drawn directly from the employee’s record in QuickBooks. It is good practice to compare this against the employee’s actual Social Security card and to keep a copy on file.
One common pitfall: an Individual Taxpayer Identification Number, or ITIN, should never appear in Box A. ITINs are issued only to certain resident and nonresident aliens who are not eligible for U.S. employment and need a tax identification number for other purposes. An ITIN is recognizable because it is a nine-digit number that begins with “9” and has a “7,” “8,” or “9” as its fourth digit — formatted to look like an SSN.
If the SSN in Box A is wrong, close the Payroll Tax Form window by selecting Save & Close. Open the Employee Center, click the Employees tab, and double-click the employee’s name to open the Personal tab on their record. Edit the Social Security number there, click OK to save, and then return to the W-2 worksheet — the corrected number will appear in Box A.
Correcting the Employer Identification Number (Box B)
Box B shows the nine-digit Employer Identification Number assigned by the IRS. This must match the EIN used on federal employment tax returns — Form 941, 943, or 944. QuickBooks pulls this from the Company Information window.
If the EIN in Box B is incorrect, close the Payroll Tax Form window by selecting Save & Close. From the Company menu, choose Company Information, update the number in the Federal Identification No. field, and click OK. When you reopen the W-2 worksheet, the corrected EIN will populate Box B.
State and Local Boxes
Boxes 15 through 17 cover state-specific information — typically the state abbreviation, the employer’s state unemployment insurance account number, and the state wage and tax amounts. QuickBooks prefills these from the company and employee records, but because state filing requirements vary, users should confirm that the state data is accurate for their jurisdiction.
Boxes 18 through 20, which cover local wages and local income tax, are not universally applicable. For example, Montana users will see no relevant data in those boxes. Users in states or localities with additional withholding requirements should verify that any local wage or tax figures match their payroll records.
When Worksheet Data Won’t Update
In most cases, editing the source record — the employee’s Personal tab or the Company Information window — and then reopening the worksheet resolves the discrepancy. If the worksheet continues to display stale or incorrect figures after the underlying record has been updated, the company file itself may have a deeper data-integrity issue that standard editing will not fix. For guidance on troubleshooting damaged QuickBooks company files, including situations where payroll forms refuse to refresh corrected data, specialized repair tools or services may be necessary.
Bottom Line
The W-2 worksheet is a reflection of what is already stored in QuickBooks. Verifying its contents against a Payroll Summary report, confirming Social Security numbers against the actual cards, and checking the EIN in Company Information are the three steps that catch the most common filing errors before submission.