PowerSchool ERP Ohio

State Tax Report - Report by Employee/Check (C) - File Layout and Data Mapping

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

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

Check Number

The check number for the payment

Retrieved from a system-generated value during payroll processing.

The check number is automatically assigned when checks are created during payroll check processing.

D

Taxable Wages

The total wages subject to state 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 state tax settings in the State section of the Employee Tax Information page.

E

Tax Paid

The total state tax withheld for the employee.

Retrieved from a calculated value during payroll processing.

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

F

Date Issued

The date the check was issued.

Retrieved from the Check Date field on the Check History page.

This is the date the check was issued during payroll processing.

G

Flag

Indicates whether the check is voided or manual.

Valid values: 

  • V = Voided check (Set when a check is voided on the Void Check page.)

  • M = Manual check (Set when a check is created on the Manual Checks page.)

Retrieved from a system-generated value during payroll processing.

H

Date Voided

The date the check was voided.

Included when voided checks are selected

Retrieved from the Void Date field on the Void Check page.