Skip to content
Hypamoon

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.

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.

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.