For teams that run on Personio
Personio vacation accrual for year-end closing
The report in Personio shows remaining time off on the date you pick, and overtime takes a second report that starts when time tracking began. Putting both next to salary and working out a value per person happens in a spreadsheet each year.
How it goes today
- Run the remaining balances report for the closing date.
- Run the overtime report from the start of time tracking.
- Export base salaries and weekly hours separately.
- Join the three files in a spreadsheet and work out a day rate per person.
How it can go
Vacation days left and overtime at year end, valued per person, ready for the accountant.
On the closing date you choose, one sheet per legal entity with a row per person: vacation days left, overtime hours, base salary and weekly hours from Personio, and a value per person using the day rate method your accountant gives. Totals per cost center sit at the bottom, and the layout stays the same each year so the years compare easily.
Say this in ChatGPT, Claude or Copilot
Your chat gets connected to Hypamoon first, with this request filled in. You paste your Personio key in the portal, never in the chat.
With Hypamoon, on the last day of our financial year, take from Personio for each employee the vacation days left, the overtime balance from our overtime report, the base salary and the weekly hours. Make one sheet per legal entity with a row per person and a value using the day rate method our accountant gives, with totals per cost center, and send it to me and our accountant.
An administrator creates a custom integration in Personio under Marketplace, Connected integrations, and picks what it may read and change. This needs the Core Pro plan. It stays yours.
More for teams on Personio
- I want to remind people of their remaining vacation days, with the number in the message.
- Requests wait for approval and nobody gets a reminder.
- I want every document of one employee in one download, not one by one.
- I need the overtime balance per person at the end of the month, for each team lead.
- Nobody is told when someone leaves a working day without hours.
- We keep a spreadsheet to see if too many people in a team are off at once.
- I want a list of employees who have not uploaded a required document yet.
- I want to change an attribute for many employees with a future date.
- Everything for Personio