SOURCE:    Vacation Tracker
TITLE:     How Do I Export Employee Leave Balances?
URL:       https://vacationtracker.io/knowledge-base/how-do-i-export-employee-leave-balances/
LANG:      en
PUBLISHED: 2020-12-29
UPDATED:   2025-10-10
READING:   1 min
SUMMARY:   If you are looking for the best overview of all of the remaining leave amounts for your users, use our leave balance report to export the information into a simple spreadsheet view!

# How Do I Export Employee Leave Balances?

# How Do I Export Employee Leave Balances?

The Leave Balance Report exports each User's entitled, taken, and remaining balance per Leave Type for whichever period you pick. Quickest way to get a workspace-wide snapshot of where everyone stands.

## Steps

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

- In the left menu, expand Reports and click Reports.

- On the Reports page, click Generate and export on the Leave Balance Report card.

- Adjust the filters along the top of the report.

- Optionally click Edit columns in the top-right to add or hide specific columns.

- Review the report table below the filters, then click Download in the top-right and pick CSV or Excel.

![Leave Balance Report view with the filter bar across the top, the Edit columns and Download buttons in the top-right, and per-User entitlement and remaining balances in the table](https://cms.vacationtracker.io/uploads/helpdesk_artikal_how_do_i_export_employee_leave_balances_first_image_place_1095176b89.png)

## Filters You Can Apply

FilterWhat it controls

ShowTime period — Current Year, Last Month, Previous Year, Next Year.

DisplayShow balances in Days or Hours.

LocationsFilter to specific Locations only.

DepartmentsFilter to specific Departments only.

LabelsFilter by labels assigned to Users.

UsersPick specific Users when other filters aren't enough.

Leave TypesShow only the Leave Types you want.

User StatusInclude inactive and deleted Users (active-only by default).

A Clear Filters button at the bottom of the filter panel resets everything.

## What's in the File

Per User, per Leave Type: entitlement, days/hours taken, scheduled (upcoming approved leaves), brought-forward, and the remaining balance. Plus identifying fields — Department, Location, Employee ID — for cross-referencing in payroll or HR systems.

## Edit Columns

Use Edit columns in the top-right to toggle which fields appear. Useful when you only need entitlement vs. remaining for a year-end check, and want to drop the rest.

Use it for

Year-end accruals, finance accruing the leave liability, prepping balances ahead of an annual reset, sanity-checking totals before a rollover.

Need history instead?

For the actual log of who requested what, when, and the approver — use the Leave Request Report. See How Do I Export a Leave Request Report (Leave History)? (https://vacationtracker.io/knowledge-base/how-do-i-export-a-leave-request-report-leave-history/)

### What's Next?

All Report Types (https://vacationtracker.io/knowledge-base/what-types-of-reports-can-i-export/)
Export a Leave Request Report (https://vacationtracker.io/knowledge-base/how-do-i-export-a-leave-request-report-leave-history/)
Check My Own Balance (https://vacationtracker.io/knowledge-base/how-do-i-check-my-remaining-leave-balance/)

Need help?

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