State/Local Income Tax Worksheet Columns

The State/Local Income Tax Worksheet contains a standard set of columns. You do not have the option to 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 you select on the General 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.

Column Description
Employee Number/ Name This column displays the employee's identification number and name.
Soc. Sec. No. This column displays the employee's Social Security number.
Gross Pay This column displays the employee's gross pay.
401(k) This column displays the 401(k) contributions withheld for the employee for the reporting periods.
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 Configuration.

Subject to Tax This column displays the amount of the employee's pay that is taxable for the tax locale for the reporting periods.