For teams that run on Papershift
Papershift absence report per employee per year
Papershift lists absences by period, status, type and employee, and you can export that list. Turning it into days per person per type, such as how often someone was ill this year, takes counting by hand or a report in the Insights add-on.
How it goes today
- Filter the absence overview by type and period.
- Filter again by employee to see one person at a time.
- Divide the hours of each absence by the daily target to get days.
- Count the days by hand, leaving out weekends and public holidays.
How it can go
Sick days, leave and training days per employee, counted for the year.
One sheet with a row per employee and a column per absence type: days and hours of sickness, leave, training and any other type you use in Papershift, for this year so far next to last year. You can filter it by location or tag, and a short version arrives at the start of each month. Requests that are not yet confirmed are counted on their own line.
Say this in ChatGPT, Claude or Copilot
Your chat gets connected to Hypamoon first, with this request filled in. Papershift first switches on access for your company when you ask them, which can take a few business days. After that you get the key, or create it yourself, and paste it in the portal, never in the chat.
With Hypamoon, make a sheet from Papershift with a row per employee and a column per absence type, showing days and paid hours for this year so far and for last year. Count confirmed absences, and list the unconfirmed ones separately. Let me filter it by location and tag, and email me a short version on the first working day of each month.
Papershift first switches on the API add-on for your company, through their sales team or your customer success manager. After that an account admin creates the key under Account Settings, API. It stays yours.
More for teams on Papershift
- I want to see the overtime of my whole team at once, with planned time off already deducted.
- I want to print the hours I worked, in normal hours and not in decimals.
- I want night and Sunday hours on the export, in the layout our payroll office uses.
- I want the school holidays in our leave calendar so we can plan the summer.
- I have to create next year's leave allowance for each employee by hand.
- I put the maximum hours in my minijobbers' names so I don't plan them over.
- When someone asks for leave I want to see if the shifts on those days are still covered.
- Everything for Papershift