For teams that run on Sesame HR
Sesame HR annual hours report per person
Sesame has reports for clocked time, for absences and for the hours balance. To see in one place how the worked hours and the paid and unpaid absences of a person add up over a year, teams often combine reports in a spreadsheet.
How it goes today
- Download the clock-in report for the year.
- Download the absence report for the same period.
- Put both in a spreadsheet and match the rows per person.
- Add the paid absences to the worked hours with formulas.
How it can go
Worked hours and absence hours per person, added up per month and for the year.
On the first working day of each month HR gets a report with one row per person: hours clocked, hours of paid absence by type, hours of unpaid absence and holiday hours, for last month and for the year so far, with the hours to work from Sesame next to it. You can filter it by department and open it as a spreadsheet.
Say this in ChatGPT, Claude or Copilot
Your chat gets connected to Hypamoon first, with this request filled in. You paste your Sesame HR key in the portal, never in the chat.
With Hypamoon, on the first working day of each month, make a report from Sesame HR with one row per employee: hours clocked, hours of paid absence by type, hours of unpaid absence and holiday hours, for last month and for the year so far, with the hours to work from Sesame next to it. Let me filter by department and download it as a spreadsheet.
An administrator switches on the API in Sesame under Applications, Plans and pricing (it comes with the top plan, otherwise as an add-on), then creates a token under Settings, Integrations, API and notes the data region shown on that page. It stays yours.
More for teams on Sesame HR
- I want to see the holidays of the whole team for the whole year on one page, before I approve a request.
- I want to see how many holiday days each person has left, and which days from last year run out soon.
- I want to download the org chart as a PDF to share it, for the whole company or one department.
- I want to know the next day who did not clock in once and had no absence registered.
- I want to know which approved absences still have no proof attached, and remind the person.
- I want a reminder before someone's ID card or medical check runs out, and a list of who still has to hand in a document.
- I want to record which equipment and safety gear each employee received, with their signature.
- I want to see when someone's sick leave falls on days they had booked as holiday.
- Everything for Sesame HR