Quickbooky

Accounting News

Payroll

QuickBooks W-2 Worksheet: Verifying Data and Correcting Errors Before Filing

QuickBooks pulls W-2 data from employee records and paychecks. Here is how to verify amounts and fix incorrect information before submitting forms.

QuickBooks W-2 Worksheet: Verifying Data and Correcting Errors Before Filing

QuickBooks Desktop users preparing annual W-2 forms have asked how the built-in W-2 Worksheet pulls its data, where to verify the amounts, and how to correct errors before filing. The accepted guidance from the community confirms that QuickBooks assembles each W-2 automatically from existing employee records and paychecks within the company file. When those underlying records are complete and accurate, manual edits to the form itself should be unnecessary.

How QuickBooks Populates the W-2 Worksheet

The software gathers every figure on an employee’s W-2 from two sources: the employee record and the paychecks recorded in the company file for the calendar year being reported. Because the worksheet is generated rather than manually entered, the recommended workflow is to keep those source records current throughout the year.

If a discrepancy does appear on the form, the correct approach is to close the W-2 without saving, return to the employee record or the affected paychecks, and make the adjustment there. Any changes typed directly onto the W-2 itself are not saved back to the employee record or to the underlying paycheck data, which means the form and the company file can fall out of sync.

The W-2 that QuickBooks produces conforms to IRS Publication 1141, which governs substitute forms. That publication covers formatting requirements such as field placement, numbering, and font size.

Verifying Amounts Against the Payroll Summary Report

Before reviewing individual boxes, you can confirm that the wage and tax totals are correct by running a Payroll Summary report for the calendar year reported. The report displays one column per employee paid during the year, with rows showing pay, deductions, and taxes withheld. Those figures should match what appears on each employee’s W-2 worksheet.

Correcting Box A: Employee Social Security Number

Box A contains the employee’s Social Security number, which QuickBooks pulls directly from the employee record. The recommendation is to check the number against the employee’s actual Social Security card and to keep a copy of the card on file.

If the number is wrong, the fix is straightforward:

  1. Close the Payroll Tax Form window without saving.
  2. Open the Employee Center and click the Employees tab.
  3. Double-click the employee’s name to open the Personal tab.
  4. Correct the Social Security number in the appropriate field.
  5. Click OK to save.

When you return to that employee’s W-2, the corrected number appears in Box A automatically.

ITINs and When They Apply

An IRS Individual Taxpayer Identification Number, or ITIN, can appear in place of an SSN for identification or W-2 reporting in certain situations. ITINs are issued only to resident and nonresident aliens who are not eligible for U.S. employment but need a taxpayer identification number for other tax purposes. You can recognize an ITIN because it is a nine-digit number that begins with “9” and has a “7,” “8,” or “9” as the fourth digit, formatted in the same pattern as an SSN.

Box B: Employer Identification Number

Box B holds the nine-digit Employer Identification Number assigned to the company by the IRS. This should match the EIN the business uses on other payroll tax filings. If it does not, the correction is made in the company-level setup rather than on the form itself.

Tracking and Reconciliation

The list of selected employees in the W-2 workflow can be used to track which forms have been prepared and distributed. For reconciling W-2 amounts against other payroll tax returns, the IRS instructions for Forms W-2 and W-3 include a section covering reconciliation across multiple return types.

Key Takeaway

The W-2 Worksheet is designed to reflect what is already in the company file. Editing the form directly creates a disconnect between the printed W-2 and the underlying payroll data, so the consistent recommendation is to fix the source — the employee record or paycheck — and let QuickBooks regenerate the form. For broader QuickBooks payroll help, the same principle applies: correcting data at its origin prevents recurring discrepancies on tax forms and reports.

← Back to Community Issues