Sample time clock import file

Alerts and notices
Leave feedback

Contact information (optional):

Leave this blank:

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

Characters left:

Important reminder!

Product support for Engagement CS is ending on September 30, 2020. See Engagement CS license expiration 2020 - frequently asked questions for more information.

Licenses for Payroll CS, Trial Balance CS, and Write-Up CS permanently expired on March 1, 2017.

Some processes documented in the Help & How-To Center are no longer applicable, due to the discontinuation of Creative Solutions Accounting.

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.

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 number 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.


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.

Accruable benefit pay items - Accruable benefit pay items such as Sick or Vacation time may be listed in one of two methods.

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.

Top of page

Related topics

Time Clock Import dialog

Time Clock import file data structure

Setting up a CSA client for time clock import

Importing from time clocks to Payroll CS

Importing employee time entry from an Excel spreadsheet

Top of page

Share This