Federal 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 Federal 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 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.
E	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.
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.