Local Tax Report - Report by Employee (E) - File Layout and Data Mapping

The following table shows the columns, column names, descriptions, and data sources or valid values for the Local Tax Report - Report by Employee (E).

Column	Column Name	Description	Data Source or Valid Values
A	Employee Number	The employee’s identification (ID) number.	Retrieved from the Employee Number field on the Employee Information page.
B	Name	The employee's full name.	Retrieved from the Last Name and First Name fields on the Employee Information page.
C	Taxable Wages	The total wages subject to local tax for the employee.	Retrieved from a calculated value during payroll processing. The system automatically calculates the taxable gross wages based on the employee's local tax settings in the Local section of the Employee Tax Information page.
D	Tax Paid	The total local tax withheld for the employee.	Retrieved from a calculated value during payroll processing. The system automatically calculates local tax withholding based on the local withholding settings in the Local section of the Employee Tax Information page.