Skip to content
English
  • There are no suggestions because the search field is empty.

Sick leave report

A simple, reliable way to export sick leave and absence data, built for both compliance and insights.

 

Table of Contents

 

 

Sick leave report

Reporting on absence has traditionally been manual, time-consuming, and error-prone. Many teams rely on Excel and patchwork workflows just to meet requirements.

You can now export sick leave from Huma with a one-click Excel report that supports flexible filtering and produces structured output ready for SSB/NAV and internal analysis. Resulting in faster reporting, more accurate and reliable data, and easier access to insights for both HR and managers.

 

 

Roles

To export the sick leave report, the user must have a System role with full access to Absence.

Access Role
  • Configure and manage absence settings
  • Export a spreadsheet of your organization’s absence
  • Add, update and delete absences on behalf of your colleagues
  • Accept or reject absence requests
  • Transfer days between periods
  • Manually adjust one period’s available days
 
System role: Absence: Absence Management

 

 

 

How to generate the report

To export the sick leave report, you must have the system role mentioned above.

  1. Go to the Absence module
  2. Click "Export" in the top right corner
  3. Choose "Sick leave report"
    1. Filter on absence types, who the report should include, statuses, and time period
    2. Absence entries in the report are grouped by their duration. Customize the grouping by defining your own thresholds, or use your country's default
    3. Absence entries, even the ones that only partially occur within the specified time period, will be included in their entirety in the report
  4. Click "Generate report" and receive the export on your email

 

⚠️ Note

If an absence entry only partially falls within the selected time period, the absence will still be included in its entirety in the report. This is worth keeping in mind when interpreting figures at the start or end of a longer absence period.

 

Understanding the Sick Leave Report

The Sick leave report gives you a structured Excel export of sick leave and absence data, ready for SSB/NAV reporting and internal analysis. This article explains exactly how each column is calculated, so you can trust the numbers and answer questions from managers and compliance teams.

The file contains two sheets: Absence sick leave with the data and summary rows, and Details with the exact filter parameters used, so the export is reproducible and auditable.

 

Who is included?

All active users who match your filters are included. Deactivated users can be included via the User status filter. Only approved absences are included by default, but you can extend this to other statuses in the filter. An absence that only partially overlaps the period is included, but only the days that fall inside the period are counted.

 

Columns explanation

Column Contains
Identification (A–G) Employment ID, Name, Email, Companies, Teams, Locations, Gender
Workdays (H) The number of work days the person was expected to work in the period, weighted by employment percentage. For each position the person held during the period, Huma takes the working days defined in their work schedule (e.g. Monday–Friday, minus public holidays for their country), intersects them with the position's contract dates, and multiplies by the employment percentage. Example: An 80% position active for a month with 22 working days gives 17.6 workdays.
Absence days (I) The total absence days in the period across all selected absence types, weighted by grade. Full-day absences count as 1.0 per day. A 50% graded sick leave counts as 0.5 per day. Weekends and public holidays are not included.
Absence % (J) Absence days / Workdays. This is a live Excel formula, so it updates if you edit the sheet.
Sick leave days (K) Same as absence days, but limited to sick leave types (self-certification and doctor-certified). Grade-weighted.
Sick % (L) Sick leave days / Workdays. This is your sick leave percentage.
Sick leave by duration (M–AB) Sixteen columns: four duration groups × two sick leave types (Self certification, Sick leave) × two metrics (Instances, Workdays). Each absence entry is placed in a duration group based on calendar days (end date − start date + 1). Instances shows the number of separate absence entries in the group. Workdays shows the grade-weighted sum of working days for those entries inside the report period. Duration groups use calendar days because Norwegian rules for self-certification and the employer period are defined in calendar days, while the reported value is the actual working days the person was away from work.
Other absence (AC–AL) For Sick Child, Vacation, Parental Leave, Paid Time Off, and Unpaid Time Off: Instances and Workdays per type. No duration grouping.
Gender summary (bottom rows) Male / Female / Other / Total. Uses live Excel formulas, so the summary updates if you edit the data rows.

 

How position percentage and dates affect the numbers

The Workdays column, and therefore Absence % and Sick %, depends on both how many days the employee was employed during the period and the employment percentage on each of those days.

  • Position dates clip the period. Only days where the person had an active position are counted. Someone who started on January 15 gets workdays from January 15 onward only, not from January 1. The same applies to terminations, days after the end date are not counted.

  • Employment percentage weights every day. An 80% position across 22 working days gives 17.6 workdays. A 50% position across the same period gives 11 workdays.

  • If someone moves from 100% to 60% in the middle of the period, each day is weighted by the percentage in effect on that day. There is no smoothing.

  • If the person holds several positions at once, for example 60% and 40%, the percentages add up. A day with 60% and 40% contributes 1.0 workday.

  • People with no active position in the report period show 0 workdays and 0% for both absence and sick percentages. This is usually a sign of a gap in employment history, and it that happens; check the users profile.

 

For part-time employees: check how part-time is modelled

There are two ways to set up part-time positions in Huma, and the choice affects how the sick leave percentage is calculated.

1. Reduced work schedule

Set the work schedule to only include the days the person actually works, for example Monday–Wednesday for a 60% position, and keep the employment percentage at 100%. Huma will then automatically calculate the correct number of working days, and the sick leave percentage will be correct regardless of how the absence is registered.

2. Full work schedule with reduced percentage

Keep the work schedule as Monday–Friday, but set the employment percentage to 60%. In this case, absence registrations must be graded to match the employment percentage – otherwise the sick leave percentage can exceed 100%. This is because Huma sees absence registered on days marked as working days, and with fewer working days in the denominator, the percentage quickly becomes too high.

⚠️ If a part-time employee shows a surprisingly high sick leave percentage, it is usually because the absence was registered at 100% while the position is set up using full work schedule with reduced percentage. 

 

 

SSB / NAV reporting

The structure and defaults – 3, 16, and 56 calendar day thresholds, split between self-certification and doctor-certified sick leave, and gender aggregation – are chosen to align with SSB and NAV reporting requirements. You can use the export as-is or paste the data into your own report templates.

 

 

Frequently asked questions

My sick percentage is not 100% even though I was fully on sick leave the whole period. Why?

Check that the absence is approved and that it overlaps the report period. Also verify that the work schedule and employment percentage on the profile are correct – they drive the workdays denominator.

 

A 5-day absence ended up in the 4–16 day group, not the 1–3 day group. Why?

The 1–3 day group covers up to and including 3 calendar days. 5 days belongs in the 4–16 day group.

 

My absence ran from Friday to Monday. Duration shows 4 days, but only 2 workdays. Is this a bug?

No. Duration counts calendar days (Friday, Saturday, Sunday, Monday = 4), while workdays counts actual working days (Friday and Monday = 2).

 

Why does a 50% employee have a higher sick percentage than a full-time employee with the same number of sick days?

The workdays denominator is halved for the 50% employee, so the same number of sick days produces twice the percentage. This is correct and matches standard SSB reporting.

 

The numbers don't match the Insights dashboard.

Insights often uses a different time frame or different statuses. Check filters in both places. The export only counts approved absences by default.

 

Can I change the duration groups?

Yes, in the export dialog. The defaults follow Norwegian practice, but you can adjust them to fit internal reporting needs.

 

Can I include people who have left the company?

Yes. Set user status to Deactivated or All before exporting. Useful for year-end reports.