Sample time clock import file - ASCII

Alerts and notices
Leave feedback

Internal Employees: Submit feedback

Contact information (optional):

Leave this blank:

Please tell us how we can make this information more helpful.


Characters left:

Change to CS Support service hours

Our Support department is closed on Friday, April 28th for a company event. However, limited Accounting CS phone support is available on that date from 9 AM - 5 PM ET due to the approaching deadline for quarterly payroll tax forms.

Links to our most popular payroll tax processing topics are available in the Alerts and notices section on the right side of most pages.

For live payroll processing only

The following example shows two 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 single payroll item.

Timeclock import file ascii ex

  • 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 special character W (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 is assumed to be an hourly rate.

    Note: If 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 cannot use ASCII/TCI format files to import accruable benefit hours. If you need to import accruable benefit hours, you will need to use an XML import file or use a spreadsheet import.

Related topics

Time clock import overview

Time clock ASCII import file data structure

Time clock imports supported by the application

Share This