SOURCE:    Vacation Tracker
TITLE:     How Do I Import Time Off in Lieu Balances?
URL:       https://vacationtracker.io/knowledge-base/how-do-i-import-time-off-in-lieu-balances/
LANG:      en
PUBLISHED: 2025-08-25
UPDATED:   2026-03-11
READING:   1 min
SUMMARY:   If your team gets Time Off in Lieu (TOIL) for those extra hours or days worked, you can bring those balances right into the Vacation Tracker.

# How Do I Import Time Off in Lieu Balances?

# 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

- Sign in at app.vacationtracker.io (https://app.vacationtracker.io/signin) as an Admin.

- In the left menu, expand Workspace Settings and click Bulk Uploads.

- On the Bulk Uploads page, click View on the Time Off in Lieu card.

- Click Download Template to grab a file with the correct headers.

- Open the template, fill in one row per TOIL event, and save.

- Back on the Time Off in Lieu page, click Start Import.

- Walk through the wizard: drop or select your file → Select header row → Match Columns → Validate data → Confirm.

![Time Off in Lieu import page with the Download Template button and Start Import button, plus the auto-approval warning banner](https://cms.vacationtracker.io/uploads/helpdesk_artikal_how_do_i_import_time_off_in_lieu_balances_first_image_place_0ea92283f8.png)

## Required and Optional Fields

FieldRequiredNotes

EmailMandatoryThe User's email — must match Vacation Tracker.

Leave TypeMandatoryExact name of the TOIL Leave Type as configured in your workspace.

Date FromMandatoryFormat: YYYY-MM-DD

Date ToMandatoryFormat: YYYY-MM-DD

Is Half Day / HourlyOptionalFor partial-day TOIL. Applies only to requests less than one full day.

Hour FromConditionalFor half-day or hourly only — start hour.

Minute FromOptionalStart minute: 0, 15, 30, 45.

Hour ToConditionalFor half-day or hourly only — end hour.

Minute ToOptionalEnd minute: 0, 15, 30, 45.

ReasonMandatoryFree-text reason for the TOIL.

Approver EmailMandatoryEmail of an existing Approver on the User's Department.

## The 4-Step Wizard

Once you click Start Import:

- Time Off in Lieu — drop your file or click Select file. Accepts .xlsx, .xls, .csv.

- Select header row — confirm the first row of your file is the header.

- Match Columns — map your file's headers to Vacation Tracker fields. With our template, columns match automatically.

- Validate data — fix any rows the wizard flags in red, then click Confirm.

All imported records are approved

The page shows the warning "Leave status will be set to 'Approved' for all leaves you import." — there's no separate review step.

Granting future TOIL one User at a time

If you only need to add TOIL for a single User after this initial import, use Add TOIL on their User profile rather than re-running this bulk flow. See How Do I Add TOIL for a User? (https://vacationtracker.io/knowledge-base/how-do-i-add-toil-for-a-user/)

### What's Next?

Import Brought Forward Balances (https://vacationtracker.io/knowledge-base/how-do-i-import-users-initial-brought-forward-balances/)
Import Leave Data (https://vacationtracker.io/knowledge-base/how-can-i-import-my-leave-data-into-vacation-tracker-leave-data-import/)
Add TOIL for One User (https://vacationtracker.io/knowledge-base/how-do-i-add-toil-for-a-user/)

Need help?

Contact our Support team via email (mailto:hello@vacationtracker.io) or chat (#), Monday to Friday, 9 AM – 5 PM EST.