Columns for the State or Local Income Tax Worksheet

The State/Local Income Tax Worksheet contains a standard set of columns. You cannot select columns for this report. The header area of the worksheet displays the Form W-2 year and quarter for which you generated the report.

The body of the worksheet displays the gross pay, 401(k) contributions, 125/Cafeteria contributions, additional deductions, and income tax amounts for each employee for the reporting periods that you select on the Options tab. The report also provides subtotals for each state and locality.

If any employees are listed for more than one state or local tax locale, the totals at the end of the worksheet for gross pay, 401(k) contributions, and 125/Cafeteria contributions will not be correct, because those amounts for those employees are included more than once in the final totals.

Columns

Field Description
Employee Number/Name This column displays the identification number and name of the employee who charged labor to the project.
Social Security Number This column displays the person's Social Security number.
Gross Pay This column displays the employee's gross pay for the reporting periods.
401(k) This column displays the 401(k) contributions withheld for the employee for the reporting period.
125/Cafeteria This column displays the 125/Cafeteria contributions withheld for the employee for the reporting periods.
Income Tax This column displays the income tax amount withheld for the employee for the tax locale for the reporting periods.
Additional deductions This column displays the amount withheld for additional deductions for the employee for the reporting periods. You can set up additional deductions in Payroll Settings.
Subject to Tax This column displays the amount of the employee's pay that is taxable for the tax locale for the reporting periods.