---
title: "BambooHR time off balances: one sheet · Hypamoon"
description: "Want each BambooHR time off balance in one view? A monthly sheet with each employee, each type of leave, days used and the balance expected on a date you pick."
url: https://hypamoon.com/connect-to/bamboohr/time-off-balances
---

1.  [Connect to](https://hypamoon.com/connect-to)
2.  [BambooHR](https://hypamoon.com/connect-to/bamboohr)
3.  Time off balances

For teams that run on BambooHR

# BambooHR time off balances: one sheet

BambooHR shows each employee's balance on their profile, and the Time Off Balances report shows one category at a time. Seeing vacation, sick leave and other types side by side for the whole company means running the report again for each type.

[Start free](https://app.hypamoon.com/?mode=signup&utm_source=connect-to&utm_campaign=bamboohr/time-off-balances)

## How it goes today

1.  Run the Time Off Balances report for vacation.
2.  Run it again for each other type of leave.
3.  Combine the exports into one spreadsheet.
4.  Check the history of anyone whose balance looks wrong.

## How it can go

**See each employee's time off balance, per type of leave, on one sheet.**

Once a month you get one sheet with a row per employee and a column per type of leave: the balance today, what was used this year, and the balance expected on a date you choose, such as the end of the year. Leave that is granted as needed is listed separately, because BambooHR shows it with a zero balance. With many employees the sheet takes a while to build, so it arrives later in the day.

## Say this in ChatGPT, Claude or Copilot

Your chat gets connected to Hypamoon first, with this request filled in. You paste your BambooHR key in the portal, never in the chat.

Your request

> With Hypamoon, once a month, make one sheet from BambooHR with a row per employee and a column per type of time off: the balance today, what was used this year, and the balance expected on the date I choose, such as the end of the year. List leave that is granted as needed separately. Email the sheet to me and mark anyone with a high balance close to that date.

[Build this in your chat](https://hypamoon.com/connect?via=connect-to~bamboohr/time-off-balances&say=a%20monthly%20sheet%20of%20each%20employee's%20time%20off%20balance%20in%20BambooHR%2C%20per%20type%20of%20leave%2C%20with%20days%20used%20and%20the%20balance%20expected%20on%20a%20date%20I%20choose.)

[Start free](https://app.hypamoon.com/?mode=signup&utm_source=connect-to&utm_campaign=bamboohr/time-off-balances)

You create the BambooHR key yourself under API Keys in the menu behind your name, and it sees what your user may see. It stays yours.

## More for teams on BambooHR

-   [**We run a BambooHR account for each company, and I want the group numbers in one place.**](https://hypamoon.com/connect-to/bamboohr/group-reporting)
-   [**I want the same numbers for our directors each month without rebuilding the report.**](https://hypamoon.com/connect-to/bamboohr/monthly-report)
-   [**Our payroll is outside BambooHR, so each month I retype the changes.**](https://hypamoon.com/connect-to/bamboohr/payroll-changes)
-   [**I check who is out every day, and the calendar makes that hard.**](https://hypamoon.com/connect-to/bamboohr/whos-out)
-   [**I can't let a department head see just the openings of their own department.**](https://hypamoon.com/connect-to/bamboohr/hiring-by-department)
-   [**Everything for BambooHR**](https://hypamoon.com/connect-to/bamboohr)
