Sample time clock import file - ASCII
For live payroll processing only
The following example shows 2 lines of an import file for an employee who works as a customer service representative in a fast-food restaurant.
Example
- Employee ID.1001 - John Smith
- Department.02 - Service Staff
- Pay item 1.Wages - pay description number 10. (40 hours regular pay, 10 hours overtime this week)
- Pay item 2.Shift Premium - pay description 41 (10 hours this week)Each payroll item must have its own line entered in the import file. Within each line you can combine the regular, overtime, and double-time hours for asinglepayroll item.

- Tipped employees.If the employee is a tipped employee with a Reported Tips pay item, you can include the tips amount in position 47-54 on the same line as the tipped-wages hourly pay item.
- Wage rate changes.Wage rate changes made using the special characterW(position 36) can be included on either the same line as the regular hours or can be entered using a separate line. For salaried items, the 444444444 amount is annualized and entered as an annual salary. For hourly items, it's assumed to be an hourly rate.noteIf a rate change is included in the import file, the change will take effect on that check regardless of the location of the rate change line.
- Deduction amount override.If you want to override the deduction amount normally calculated on a check, you must use a separate line for each deduction item.
note
You can't use ASCII/TCI format files to import accruable benefit hours. If you need to import accruable benefit hours, you'll need to use an XML import file or use a spreadsheet import.