Skip to content
Hypamoon

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

  1. Run the remaining balances report for the closing date.
  2. Run the overtime report from the start of time tracking.
  3. Export base salaries and weekly hours separately.
  4. 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.

Your request

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.