Step 6.2. Create Overtime/Deduction Rate/Daily Rate Description in Bulk

Step 6.2. Create Overtime/Deduction Rate/Daily Rate Description in Bulk

Note: Please be informed this article also refers to the step on how to create Deduction Rate and Daily Rate Description in bulk. You will just need to replace the Overtime keyword in the steps to Deduction Rate/Daily Rate if you are creating Deduction Rate/Daily Rate.


If you have multiple Overtime Descriptions that you need to create, there is a way to do it fast and easy. 

The secret is to use the Import/Export feature. 

Firstly, go to  Payroll ->Overtime setting -> Overtime Description Setting 


Click on 'Export' button.  

Once the file is download, open the file. You should see the table below: 



Key in all the Overtime Description that you want to create here and save the file. 

Step 5: After you saved the file, go back to the application page, click 'Import'. 


Step 6: Click on the 'Select File' button and browse to the location of the file that you have just saved (in this case, the default name for the file is Overtime Description). 

Step 7: Note that there are a few options for you to choose if there is a duplicate data in the file you imported and data in system. For example, there might be a 'Weekend Overtime' in your file, but the system also have the same record (because you created it in the system earlier). Click on the drop down to see list of actions that you want to system to perform if this happens. 

Show Error: if system detected same Description in the import file then the system will show an error message and will NOT process the Description 

Ignore Record: system will ignore Description in the import file and maintain the record in the system

Overwrite Record: system will use Description in the import file and overwrite the record in the system 

Choose whichever is appropriate for you and click 'Data Import'. Please note the size limit of 4MB. 


 

If successful, you will see this message at the center of the screen. If the unsuccessful, the system will download another file (with the same file name but with (1) at the end), open the file, and check the error log. 


    • Related Articles

    • Step 6.1. Create Overtime/Deduction Rate/Daily Rate Description

      Note: Please be informed this article also refers to the step on how to create Deduction Rate and Daily Rate Description. You will just need to replace the Overtime keyword in the steps to Deduction Rate/Daily Rate if you are creating Deduction ...
    • Step 6.4. Create New Overtime/Deduction/Daily Rate Setting

      Note: Please be informed this article also refers to the step on how to create Deduction Rate and Daily Rate Setting. You will just need to replace the Overtime keyword in the steps to Deduction Rate/Daily Rate if you are creating Deduction ...
    • Step 6.0. Configure Overtime /Deduction Rate/Daily Rate Policy

      Setting up Company Policy is important to ensure you have accurately translate the Policy into the form that system understand and execute for you. Key steps for setting up OT Policy: 6.1. Creating Overtime/Deduction Rate/Daily Rate Description 6.2. ...
    • Step 6.5. Create Overtime/Deduction Rate/Daily Rate Group

      Note: Please be informed this article also refers to the step on how to create Deduction Rate and Daily Rate Group. You will just need to replace the Overtime keyword in the steps to Deduction Rate/Daily Rate if you are creating Deduction Rate/Daily ...
    • Step 6.3. Create Overtime/Deduction Rate/Daily Rate Formula

      Note: Please be informed this article also refers to the step on how to create Deduction Rate and Daily Rate Formula. You will just need to replace the Overtime keyword in the steps to Deduction Rate/Daily Rate if you are creating Deduction ...