We now offer the ability to Import and Export time off balances as well as edit them directly in Hubstaff from your account. If your team members have existing time off hours from work they performed outside of Hubstaff, this guide will show you how to add those hours in to start them off with the correct amounts. It will also allow you to manually change hours, if needed.
Table of Contents:
Editing balances manually
A dialog box will open, and you will be able to choose the policy you are changing the time for as well as if you are wanting to add to the balance or replace the existing balance.
Example showing the Add to balance option (You can also enter a negative number if you wish to subtract from their current balance):
Example showing the Replace balance option:
Individual balances (specific member)
Exporting time off balances
Importing time off balances
We support CSV and XLS formats and the import file must contain the following fields, typed out exactly as is here: “User email”, “Policy name”, “Balance”.
The “User email” should be exactly the email of the user from the system
The “Policy name” should be the exact name of the policy, case sensitive.
The “Balance” is expressed in hours and it supports the following formats: “hh:mm”, “h”, “hh”, “h.d” (d-decimal). Examples: “16:30”, “16”, “16.5”
You will then need to click on Choose File in order to pick the file you are wanting to import. Clicking the Download spreadsheet template will provide a sample file containing all the necessary table headers and if there are time off balances in the system, it will contain all of the time off balances. Replacing the balances in the file and re-importing them would replace the existing balances in system with the data from the file.
During the import, the users will be automatically associated to the policy they have data to, this way it is not necessary to make the associations manually before importing new time off balances.
The import will not proceed if a user email or a policy does not exist in the system or if the balance is not in the aforementioned formats.