PowerSchool ERP Ohio

Federal 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 Federal 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 federal 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 federal tax settings in the Federal section of the Employee Tax Information page.

D

Tax Paid

The total federal tax withheld for the employee.

Retrieved from a calculated value during payroll processing.

The system automatically calculates federal tax withholding based on the federal withholding settings in the Federal section of the Employee Tax Information page.