Harmony comes prepackaged with many of the most popular Time Clock / Timesheet 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

...

1. Go Navigate to Payroll > Admin Settings > Interfaces > Import Interfaces.
2. Click on the "+ NEWNew" button to create a new import interface. You will be presented with two options for import interface types, depending on if your company has or uses labour imports, you will select a different import template.
   Image Removed
3. Give the category a code and a name.
   Image Removed
4. license includes the Labor sub-module or not.
   Image Added

5. Enter the required fields. 

   Image Added

   Field Name	Description
   Code	The unique code or short name of the time import interface.
   Name	The long name of the time import interface.

   
   

   
   

6. Identify Select whether the import file has headers or not. If this checkbox is ticked, the import will ignore the first row of the file. 
   Image RemovedImage Added
   
   

   1. If you are using the "Timesheet Single Category Per Row"" import interface type, select from the following fields and give the fields map them to a corresponding column number in the timesheet import fileyour 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.

      Target Field

      :

      	Description

      :

      Employee Number*	The unique employee ID

      that is

      or number in Harmony

      that is unique to each employee

      .
      Category Code*	The payroll category code (pay code) that

      is being imported.

      will be imported. For example, "102" for 'Hourly Wages'. Note: Only unit-based payroll categories can be imported for the Timesheet import interface type. Ensure that the "Basis" of these payroll categories are set to 'Units'.
      Work Date	The date

      in which the pay code was paid out

      of which the employee worked. Ensure that you also select the correct date format.
      Units	The number of units (days, hours, etc.) that

      are being paid out for the pay period. If you are using Labour, this may correspond to the pay date.

      will be imported.
      Amount	The

      Rate

      employee's per-unit rate (e.g. $15.00 an hour)

      in which employees are paid

      .

      * Indicates a required field

      
      

   2. If you are using the "Labour ModuleLabor" 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.

      Target Field

      :

      	Description

      :

      Employee Number *	The unique employee ID

      that is

      or number in Harmony

      that is unique to each employee

      .
      Category Code *	The payroll category code (pay code)

      that is being imported

      that will be imported. For example, "102" for 'Hourly Wages'.  Note: Only payroll categories that are used in labor can be imported using the labor import interface type. Navigate to Payroll > Payroll Setup > Labor Setup > Setup > 'Categories' tab to confirm.
      Work Date	The date

      in which the pay code was paid out.

      of which the employee worked. Ensure that you also select the correct date format.
      Units	The number of units (days, hours, etc.) that

      are being paid out for the pay period. If you are using Labour, this may correspond to the pay date

      will be imported.
      Amount	The total amount that employees are paid.
      Rate	The

      Rate

      employee's per-unit rate (e.g. $15.00 an hour)

      in which employees are paid

      .

      Dimension Codes

      Location Code

      The

      location code in which the job was done.Text

      With the Labour module, you will also have the option to define extra fields. 

      Target FieldsDescription:Record Identifier (D)Dimension CaptionDimension CodeDimension NameThe name of the dimension. Dimension RateCode of Parent Dimension

      dimensions of which the units are allocated to (e.g. branches, dimensions, jobs, projects), related to your Labor module setup.
      Department Code	The department code of which the units are allocated to.
      Location Code	The location code of which the units are allocated to.
      Text	The text fields of which the units are allocated to, related to your Labor module setup.

      
      

7. Click the 'save' button to save your changesClick on the Save button when you are done. 
8. Ensure you have selected the import template to be active with the pilltoggle. Keep in mind, only one interface can be active at a time.
   Image Removed