QuickBooks W-2 Worksheet: Verifying Prefilled Data Before Filing

QuickBooks Desktop’s Form W-2 Worksheet pulls company and employee data directly from the company file, prefilling employer details, employee information, and key wage and tax boxes. But the prefilled numbers are only as accurate as the underlying records, and several fields warrant close review before any return is submitted.

What QuickBooks Prefills

The W-2 worksheet arrives with employer information, employee details, and boxes 15 through 17 already populated from QuickBooks payroll data. Wisconsin users should note that boxes 18 through 20 do not apply to their state filings.

For the 2020 tax year, two Social Security-related limits are in effect. The maximum Social Security wage base — the combined total of boxes 3 and 7 — cannot exceed $137,700. The Social Security tax withholding shown in box 4 should not surpass $8,537.40. Any figures exceeding these thresholds indicate a data entry or calculation problem that needs correction before filing.

Verifying Wage and Tax Amounts

The accepted approach is to cross-check the worksheet against a Payroll Summary report for the calendar year being reported. Running that report produces one column per employee paid during the year, with rows breaking down pay, deductions, and taxes withheld. Each line item should match the corresponding figure on the employee’s W-2 worksheet. Discrepancies between the report and the worksheet typically point to a data issue worth investigating before the return goes out.

Checking Box A: Employee Social Security Numbers

Box A displays the employee’s nine-digit Social Security number, which QuickBooks draws from the employee record. 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 Individual Taxpayer Identification Number in place of an SSN. ITINs are intended for resident and nonresident aliens who are not eligible for U.S. employment and need identification for other tax purposes — not for employee identification or W-2 reporting. An ITIN is identifiable by its format: a nine-digit number that begins with “9” and has a “7,” “8,” or “9” as the fourth digit, such as 9XX-7X-XXXX.

If the Social Security number on the worksheet is wrong, the fix requires closing the Payroll Tax Form window first. From the Employee Center, double-click the employee’s name to open their record, navigate to the Personal tab, and correct the number there. After saving, the updated SSN populates Box A when you return to the W-2.

Checking Box B: Employer Identification Number

Box B shows the company’s nine-digit federal Employer Identification Number — the same one used on Form 941, Form 943, or Form 944. QuickBooks pulls this from the Company Information window. If the EIN displayed in Box B is incorrect, the Payroll Tax Form window should be closed. From the Company menu, selecting Company Information opens the screen where the EIN can be edited. Once corrected and saved, the worksheet reflects the updated number.

Why Verification Matters

Because QuickBooks auto-populates the W-2 worksheet from existing company-file data, any errors in employee records or company settings carry directly onto the form. An incorrect SSN or EIN can trigger filing rejections or notices from the Social Security Administration or IRS. Wage and tax totals that do not reconcile to payroll reports can signal problems ranging from misclassified earnings to setup errors in deduction or contribution items.

The worksheet’s prefill feature saves time, but it is not a substitute for a line-by-line review. Comparing each field against source documents — Social Security cards, the company’s EIN assignment notice, and the Payroll Summary report — is the practical safeguard against filing incorrect returns.

For broader QuickBooks Desktop payroll help, including troubleshooting wage and tax discrepancies, community resources and knowledge bases cover common reporting issues.