How Do I Import Time Off in Lieu Balances?

If your team earns Time Off in Lieu (TOIL) for the extra hours or days they put in, you can bulk-import those approved TOIL events into Vacation Tracker. The import takes one row per TOIL event with start and end dates — same shape as a regular leave import.

What Gets Imported

This is an import of approved TOIL leaves, not a one-time balance number. Each row is a TOIL event tied to a User, a Leave Type, and a date range (or date + time range for partial days). All imported records are recorded as Approved.

Before You Start

Only Admins can run this import. Make sure these are in place first:

• All Users you want to import for are added and active
• The TOIL Leave Type you'll reference exists and is enabled on the relevant Locations
• Approvers are assigned to the Departments (each row needs an Approver email)

Steps

1. Sign in at app.vacationtracker.io as an Admin.
2. In the left menu, expand Workspace Settings and click Bulk Uploads.
3. On the Bulk Uploads page, click View on the Time Off in Lieu card.
4. Click Download Template to grab a file with the correct headers.
5. Open the template, fill in one row per TOIL event, and save.
6. Back on the Time Off in Lieu page, click Start Import.
7. Walk through the wizard: drop or select your file → Select header row → Match Columns → Validate data → Confirm.

Required and Optional Fields

The 4-Step Wizard

Once you click Start Import:

1. Time Off in Lieu — drop your file or click Select file. Accepts .xlsx, .xls, .csv.
2. Select header row — confirm the first row of your file is the header.
3. Match Columns — map your file's headers to Vacation Tracker fields. With our template, columns match automatically.
4. Validate data — fix any rows the wizard flags in red, then click Confirm.