Warning
Product support for the Creative Solutions Accounting platform ended on September 30, 2020.
Help & How-To Center content for the Creative Solutions Accounting platform may be outdated and is used at your own risk.
Setting up payroll departments for time clock import
For the purpose of importing time clock files, each department description must begin with a two-digit department number. This number corresponds to the department number in the import file (positions 5 and 6).
If you have an existing client with departments already in use, you can rename the departments by doing the following:
- From the CSA main window, choose Setup > Payroll Departments.
- In the Departments dialog, highlight the department you wish to rename and then choose Rename Department from the F3 or right-click context menu.
- Enter the new name or description for the selected department, beginning with a two-digit department number.
Setting up employees for time clock import
Employee IDs must consist of four or fewer digits in order to import files from a time clock. The ID cannot have leading zeros, otherwise the time clock file will not import correctly. If employee IDs use less than four digits in CSA, you will need to pad the left digits with zeros in the time clock import file. For example, CSA employee ID 5 will correspond to 0005 in the import file.
Pay items
Each pay item must have a wage description number entered in the pay item properties. This number must consist of two numeric digits. This wage description number corresponds to the wage number in the time clock software and fills positions 7 and 8 in the import file. To enter this number, follow these steps:
- From the CSA main window, choose Setup > Employees.
- In the Employees window, highlight the appropriate employee, click the Edit button, and then click the Earnings tab.
- In the Earnings tab, click the Item Properties button for the appropriate pay item and then click the Other tab.
- Enter the wage description number in the Wage description number field.
Note: For existing employees, the wage description number needs to be added employee by employee as described in the preceding steps. If you are setting up new employees for time clock import, add the wage description number to the employee template prior to setting up the employees.
Deduction items
Deductions with regular fixed or percentage amounts do not need a deduction description number because they will calculate automatically. However, you can assign a number if you want the option to override the deduction amount for a check.
If you want to override the deduction amount for a check, follow these steps:
- From the CSA main window, choose Setup > Employees.
- In the Employees window, highlight the appropriate employee, click the Edit button, and then click the Tax Withholdings and Deductions tab.
- Click the Item Properties button for the appropriate deduction item and then click the Other tab.
- Enter the wage description number in the Wage description number field.
- In the timeclock import file, enter a new line specifying the override amount.
Related topics
Time Clock import file data structure
Importing from time clocks to Payroll CS
Was this article helpful?
Thank you for the feedback!