Local Tax Report - Local Tax Summary Report - File Layout and Data Mapping

The following table shows the columns, column names, descriptions, and data sources or valid values for the Local Tax Summary Report.

Column	Column Name	Description	Data Source or Valid Values
A	Local Tax Type	The type of local tax.	Valid values: S = School R = Residential W = Worksite O = Other Retrieved from the Local Tax Type field on the Local Tax Codes page.
B	Code	The six-character locality code.	Retrieved from the Location Code field on the Local Tax Codes page.
C	Description	The locality description.	Retrieved from the Description field on the Local Tax Codes page.
D	Total Taxable Wages	The total wages subject to this local tax.	Retrieved from a calculated value during payroll processing. The system automatically aggregates taxable gross wages for each locality based on the employee's local tax settings in the Local section of the Employee Tax Information page.
E	Total Tax Paid	Total local tax withheld for this locality	Retrieved from a calculated value during payroll processing. The system automatically aggregates local tax withheld for each locality based on the local withholding settings in the Local section of the Employee Tax Information page.