Verifying QuickBooks W-2 Worksheet Data for Accurate Filing
QuickBooks users preparing Form W-2 can verify employee and employer details, Social Security numbers, and EINs before submitting annual payroll tax forms electronically.
QuickBooks Desktop users working through the Form W-2 Worksheet during year-end processing have raised questions about how to verify pre-filled data and complete electronic filing and payment steps. The worksheet pulls information directly from company and employee records, but the responsibility for confirming accuracy rests with the employer before submission.
What QuickBooks Pre-Fills on the W-2 Worksheet
QuickBooks automatically populates the W-2 worksheet with data stored in the company file. The Employer and Employee sections, along with Boxes 15 through 17, are completed using existing QuickBooks records. However, several boxes may not apply depending on your state. For example, Boxes 8, 14, and 18 through 20 are generally not applicable to Illinois users.
Because the worksheet draws from data already entered throughout the year, reviewing that information against federal W-2 forms already filed is a critical step before moving forward.
Verifying Amounts Against Payroll Records
To confirm that the figures on each employee’s W-2 worksheet are correct, 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. The totals on this report should match what appears on each employee’s W-2 worksheet.
If the numbers align, the worksheet amounts are working as intended. If they do not match, the discrepancy typically points back to a data entry issue earlier in the year that needs correction before filing.
Checking Box A: Employee Social Security Numbers
Box A contains the employee’s Social Security number, pulled from the employee record in QuickBooks. It is worth checking the actual Social Security card rather than relying on what was originally typed into the system, since a transcription error at the time of setup can carry through to the W-2 undetected.
One specific issue to watch for: an Individual Taxpayer Identification Number, or ITIN, should never appear in Box A. ITINs are formatted like Social Security numbers but begin with the digit 9 and have a 7, 8, or 9 as the fourth digit. They are issued to certain resident and nonresident aliens who are not eligible for U.S. employment. Using an ITIN instead of an SSN on Form W-2 creates filing problems.
If the Social Security number is wrong, close the Payroll Tax Form window and open the Employee Center. From the Employees tab, double-click the employee’s name to open the Personal tab, where the number can be corrected. After saving the change, returning to the W-2 form will display the updated number in Box A.
Checking Box B: Employer Identification Number
Box B shows the nine-digit Employer Identification Number assigned by the IRS. This should match the EIN used on federal employment tax returns — Form 941, Form 943, or Form 944. QuickBooks pulls this from the Company Information window.
If the EIN in Box B is incorrect, close the Payroll Tax Form window and go to the Company menu. Select Company Information, update the Federal Identification No. field, and save. The corrected EIN will then appear in Box B when you return to the W-2.
Checking Box C: Company Legal Name and Address
Box C displays the company’s full legal name and address, again sourced from the Legal Information section in QuickBooks. This should match what appears on federal employment tax returns. If the legal name or address on file does not match what the IRS has on record, the Company Information window is where corrections are made before returning to the worksheet.
Why Verification Matters Before Filing
The W-2 worksheet is designed to streamline year-end filing, but it is only as accurate as the underlying data in the company file. Social Security numbers entered incorrectly at hire, an outdated company address, or a mistyped EIN can all cause filing rejections or notices from the SSA or IRS. Running the Payroll Summary report and comparing it box-by-box against the worksheet is the most reliable way to catch problems before submission.
For users troubleshooting broader payroll data issues or working with damaged company files during year-end processing, verifying these core fields early can prevent delays when filing deadlines are approaching.