Skip to main content

Legal

Tax & Accounting

Trade & Supply

Risk & Fraud

News & Media

Books

Developers

Integrate payroll data

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 a
    single
     payroll item.
    example paycheck for single payroll 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 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's assumed to be an hourly rate.
  • 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.

This article applies to:

  • Product: Accounting CS, Accounting CS Client Access
Chat now

error-icon

Triva isn't available right now.

Check out the support page for our phone number and hours

error-close