Setting Up Your Time Import Interface
Harmony comes prepackaged with many of the most popular Time Clock / Time Import interfaces out of the box, but it is also possible to create your own should none of them fit your needs.
Pre-Requisites:
- Are able to export your existing time entries file into a comma delimited (.CSV) file format
- Can identify which columns in your file is referring to a field in Harmony
- Have set up your payroll categories
Note: Only unit-based payroll categories can be imported if you do not have the Labor sub-module. Ensure that the "Basis" of these payroll categories are set to 'Units'. If you have the Labor sub-module, the "Basis" can be either 'Salary' or 'Units'. - Have set up your Labor sub-module (if applicable)
- Have imported or created your employees
Steps:
- Navigate to Payroll > Admin Settings > Interfaces > Import Interfaces.
- Click on the "+ New" button to create a new import interface. You will be presented with two options for import interface types, depending on if your license includes the Labor sub-module or not
Enter the required fields.
Identify whether the import file has headers or not. If this checkbox is ticked, the import will ignore the first row of the file.
If you are using the "Timesheet" import interface type, select from the following fields and map them to a corresponding column number in your file. For example, if you enter the column number "1" for 'Employee Number', this means that the employee number in your file is in the first column (e.g. column "A" or "1").
Note: Ensure that you include all required fields in the import. Required fields are indicated by an asterisk (*) in the field name.
If you are using the "Labor" import interface type, select from the following fields and give the fields a corresponding column number in the import file.
Note: If you are unsure of what some of these fields refer to regarding your Labor module, please refer to the Setting Up Your Labor Module article.
- Click the 'Save' button to save your changes.
- Ensure you have selected the import template to be active with the toggle. Keep in mind, only one interface can be active at a time.