There might be scenarios where you might want to update the time off balance for a specific time off type. For instance, adding compensatory leaves for a large number of employees who might have worked over the weekend, or adding 3 additional leaves for the entire team to cope with tough pandemic times.  


Here is how you can update time off balances in bulk. 


  • Go to Settings > Timeoff Import/Export > Import balances


  • Select the ‘Add Balance’ option


  • Download a sample CSV file by clicking on the ‘Download Sample CSV’ option. The sample sheet that you download would look like this. 


  • Update the data in the given format by filling in the following fields

    • email: Email id of the employees whose balance you want to edit.

    • leave_type: Time off type for which you want to edit the balance. This has to be among the existing 

    • balance: The balance that needs to be added to the corresponding employees.

    • leave_units_type: Choose between ‘days’ and ‘hours’  depending on whether the corresponding employee is mapped to a daily or an hourly time off policy. 

    • comment: A text field to keep a track of why the balance is being added. You can enter any text value here. 

Here is an example filled spreadsheet: 


  • Click on the ‘Choose file’ option and upload the updated spreadsheet in .csv format. 

  • Click on the ‘Start Import’ button. 

  • Once your import is complete, you would receive a notification email with the success/error report of the import. 


Open the CSV file to see the records that failed to import. The last column shows the specific error because of which the corresponding row was not imported. 


Hope this was easy. For any further queries, please write to us at support@freshteam.com and we would love to help!