Skip to main content

Report: Time registration - WITH hour bank

Flexitime & overtime/time off deviation registration

Esben Hedegaard avatar
Written by Esben Hedegaard
Updated over a month ago

Navigation: Click HR Statistics -> Report library -> Time registration - WITH hour Bank

Time registration - WITH hour Bank

From the Time Registration — with hour bank module, all registrations and records are shown.

The report gives HR and Payroll a flexible tool to track working hours, overtime, flexitime, and compliance (48h rule).

  • It also calculates and explains employees’ hour bank balance

  • supporting both operational insights and regulatory monitoring.

Contents

The report contains four views:

1. Registration log

2. Sum per period

3. Sum per week

(48-hour rule)

4. Hour bank balance per selected month

On this page all registrations and records created are shown for a selected period:

  • Overtime

  • Time off

  • Hour bank adjustments

  • Hour bank earnings

On this page you see the sum of registrations per employee for a selected period.

💁 Remember to choose which sum you want calculated:

  • Overtime

  • Time off in lieu

  • Flexitime

  • Hour bank adjustments

For a selected period this page shows:

  • The sum of working hours per employee per week

  • The average working hours per employee per week for the selected period

💁 This view is suitable for monitoring the EU 48‑hour rule.

Calculates your employees' hour bank balance per a selected month.

1. Registration log

On this page you see all registrations and records created for a selected period.

This view is useful for getting a complete overview of any registrations or records going into the hour bank balance:

  • Manual hour bank balance adjustments and payouts

  • Fixed earning connected to the time bank balance

  • Registered overtime

  • Registered flexitime (Work hours)

  • Registered time off in lieu

💁 Remember to choose which registration types you want listed.

2) Sum for selected period

On this page you see the sum of registrations per employee for a selected period.

This view is useful for overview of (per employee):

  • Sum of overtime hours

  • Sum of time off in lieu hours

  • Sum of fixed earnings

  • Sum of flexiTime registrations (Work hours)

💁 Remember to choose which sum you want calculated.

3) Sum per week

For a selected period this page shows:

  • The sum of work hours per employee per week

  • The average working hours per employee per week

This view is developed for monitoring the EU 48‑hour rule.

The report offers two calculation options:

  1. Working hours*

  2. Working hours* + Absence hours

EU 48‑hour rule

Option 2 is used to monitor compliance with the EU 48‑hour rule. When calculating the rule, absence hours must be included in the weekly average.

  • By default, the report calculates the average weekly working hours over a 17‑week reference period (four months), which is the official EU requirement.

  • The current active week is excluded by default because the week has not yet finished. Therefore, the default period ends with the previous week. You can change the period as needed.

Absence types included when selecting option 2 (Working time + Absence hours):

  • Vacation and other vacation days

  • Sick days and child sick

  • Leave types

  • Public holidays

  • Day bank – minus days

  • Time off in lieu**

* Important regarding how weekly working hours is calculated

The method depends on how the employee is required to manage their working hours:

  1. FlexiTime registration
    Daily registrations of working hours (check‑in/out) plus any registered overtime on job codes are used to calculate the weekly working time.

  2. Deviation registration
    Daily registrations of overtime and flex leave offset against standard time are used to calculate the weekly working time (as plus/minus of official working hours).

** Note about deviation registration: Time off in lieu is not counted as absence when using deviation registration, because Time off in lieu is used together with overtime and daily official working hours to adjust the working hours for the day.

1. FlexiTime

For daily registration of workhours (clock in/out), these registrations + any registered overtime on job codes contribute to the actual working hours.

ℹ️ The example above:

  • Working hours = 12 hours

  • Working hours + Absence hours = 44 hours

2. Deviation Registration

The deviation registration method. Absence, time off, and overtime are used to calculate the actual working hours based on the subtraction/addition of official working hours.

ℹ️ The example above:

  • Working time = 0 hours

  • Working time + Absence hours = 39.5 hours

4. Hour bank balance per selected month

On this report page, the hour bank balance is calculated per a selected month (end of month):

  • Each employee's hour bank balance

  • The total hour bank balance for your company

The hour bank balance calculation consists of the following variables:

⬅️ manual deductions

➡️ manual additions

⬅️ manual payouts of hours

➡️ earning that follow the earning rules attached to a policy

⬅️ approved time off in lieu

➡️ approved overtime

➡️⬅️ daily flex time registration minus official work hours

= REMAINING BALANCE

💁 To investigate the calculation of an hour bank balance, use the Registration log. It contains all the variables used to calculate an employee’s hour bank balance.

How to use the report

Select the month for which you want the balance calculated at end of month (EOM).

Select period

You have more options to select a period:

  • Year

  • Quarters

  • Month

  • Days/weeks (date from - date to selection)

Export

Click export to work with the search results in Excel.

❗When exporting to Excel: To avoid number conversion issues, select the same decimal separator for your BitaBIZ export as set up in your Excel.

Did this answer your question?