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?

Back to The Essentials Back to Performance & Recharge

The Essentials

Step-by-step guides for configuring your space, customizing your rules, connecting your tools, and managing your account.

Performance & Recharge

Leverage Recharge Energy Levels and PTO analytics to keep your team performing at Peak Energy.

Configuring Your Space Customizing Your Rules Your Connections Account Management
Powering Performance Rest-Performance Correlation

Last updated on October 10, 2025

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

  1. Sign in at app.vacationtracker.io as an Admin.
  2. In the left menu, expand Reports and click Reports.
  3. On the Reports page, click Generate and export on the Leave Balance Report card.
  4. Adjust the filters along the top of the report.
  5. Optionally click Edit columns in the top-right to add or hide specific columns.
  6. 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

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)?

What's Next?

All Report Types Export a Leave Request Report Check My Own Balance
Need help?
Contact our Support team via email or chat, Monday to Friday, 9 AM – 5 PM EST.

Was this article helpful?

Thanks for your feedback!

On this page

Still have questions? Let us show you how Vacation Tracker can help.