Importing Time Off Balances

Have more questions? Submit a request

This importer allows you to reset Time Off Balances in bulk for several employees at once. This importer is frequently used at the end of the year to reset all employees' Time Off balance to zero when not using our automatic carryover cap feature to do so. 

How to Import Time Off Balances

GIF Recording 2024-03-15 at 1.07.35 PM.gif

  1. In Time Off, head to the Settings tab.
  2. Scroll down to the bottom of the page and click the Import Time Off Balances button.
  3. In Step 1, select the Time Off Type that you want to import adjustments for from the dropdown menu.
  4. Next, click on the Download Bulk Import Template button and the template will automatically start downloading.
  5. Open the importer sheet as a CSV file.

    Don’t use the Numbers App on Mac

    If you're using a Mac, you must open the file using the Excel app and not the Numbers app because if you open it in Numbers, you won't be able to save the file as a CSV and will be unable to upload it to Humi.

  6. The import template includes the following columns:

    • Email
    • Balance (Days/Hours)
    • As-of date
    • Description (optional)
      If no description is provided: We import no description.
      If a description is provided: It will show up in the adjustment that is made on the Transactions Log, on employee Time Off Profiles.

    Use the same units as your Time Off Type

    Since you can only import balances for one Time Off Type at a time, the units will be the same units as the Time Off Type chosen (hours/days).

  7. When you open the template, the following information will be pre-filled from Humi:

    • Today's date
    • Each employee's email
    • The employee's Time Off balance
    • Description if applicable

    Formatting your dates

    Keep in mind that the importer will only accept dates in the format dd/mm/yyyy or yyyy-mm-dd.

  8. Once you've added all of your adjustments to the CSV file, click the Browse button and upload your file to Humi.

  9. Lastly, scroll up to the top and click the Import button to upload the document.
    Don't worry, you don't need to stay on this page. Your changes will be processed and uploaded in the background.

  10. Once completed, you'll receive an email notifying you that it's done.

  11. The results show up as “Manual Adjustments" added to the Transactions Logs for each employee whose balance was imported.


  Discover more about Time Off

Was this article helpful?
1 out of 1 found this helpful