Quickbooky

Accounting News

Payroll

QuickBooks W-2 Worksheet: Verifying Prefilled Data Before E-Filing

QuickBooks prefills Georgia W-2 worksheets with company and employee data, but users should verify every field against payroll records before submitting.

QuickBooks W-2 Worksheet: Verifying Prefilled Data Before E-Filing

QuickBooks Desktop’s Form W-2 worksheet arrives largely prefilled with employer and employee data, but the community guidance for Georgia filers underscores a recurring point of confusion: users need to verify the imported data against their own payroll records before submitting, and several fields require manual correction outside the worksheet itself.

What QuickBooks Prefills

For Georgia users, QuickBooks automatically populates the Employer section, the Employee section, and Boxes 15 through 17 of the W-2 worksheet. Boxes 8, 14, and 18 through 20 are not applicable to Georgia filers and are left blank. The prefilled amounts are drawn from the company file’s payroll data, and the recommendation is that users cross-check every figure against the federal W-2s they have already filed.

Verifying Wage and Tax Amounts

The accepted guidance directs users to run a Payroll Summary report for the calendar year being reported. That report produces one column per employee paid during the year, with rows showing pay, deductions, and taxes withheld. Each line item should match the corresponding figure on the employee’s W-2 worksheet. Any discrepancy between the report and the worksheet signals a data problem worth investigating before filing.

Correcting the Employee Social Security Number

Box A on the worksheet carries the employee’s Social Security number, pulled directly from the employee record in QuickBooks. The guidance emphasizes checking the number against the employee’s actual Social Security card rather than relying on what was entered during onboarding.

A specific caution applies here: an Individual Taxpayer Identification Number, or ITIN, is not a valid substitute for an SSN on Form W-2. ITINs are issued only to resident and nonresident aliens who are not eligible for U.S. employment and need identification for other tax purposes. They are recognizable by the format — a nine-digit number that begins with “9” and has a “7,” “8,” or “9” as the fourth digit.

If the SSN is wrong, the fix does not happen inside the worksheet. Users must close the Payroll Tax Form window, open the Employee Center, select the Employees tab, and double-click the employee name to reach the Personal tab. After editing the Social Security number and saving, the corrected value appears in Box A upon returning to the W-2.

Fixing the Employer Identification Number

Box B displays the company’s nine-digit federal Employer Identification Number, the same number used on Form 941, Form 943, or Form 944. QuickBooks draws this from the Company Information window. When the EIN is incorrect, users again need to leave the worksheet — closing the Payroll Tax Form window, then navigating to the Company menu, selecting Company Information, and updating the Federal Identification No. field. Saving the change propagates the corrected EIN to Box B.

Company Name and Address

Box C carries the employer’s full legal name and address, which should match what appears on federal employment tax returns. As with the EIN, this information originates in the Company Information window and must be corrected there if it does not match official records.

The Broader Takeaway

The pattern across every field on the worksheet is consistent: QuickBooks imports data from the company file, but the accuracy of that data depends entirely on what was entered during day-to-day bookkeeping. The worksheet is a review and filing tool, not a correction tool. Social Security numbers, EINs, and company addresses all require leaving the form, editing the underlying record, and returning — a workflow that catches users off guard when they expect to type directly into the worksheet fields.

For filers working through year-end forms, the practical order is straightforward: run the Payroll Summary report first, compare it line by line against the worksheet, and then address any identity or company-information discrepancies at their source before attempting to e-file or e-pay through QuickBooks.

← Back to Community Issues