Skip to main content

Introduction: Report Library

The report library gathers all BitaBIZ reports and key figures in one place. Get data on vacation, absence, hour bank, projects, payroll hou

Written by Alberte Raaschou Villefrance

Intro to the Report Library in BitaBIZ

Get an overview of reports, statistics, and exports in BitaBIZ, and find the right report for vacation, leave, time registration, payroll hours, project hours, hour bank, mileage, HR key figures, and employee data.

Quick answer about the Report Library

The Report Library gathers your company’s reports and key figures in one place in BitaBIZ.

Use the Report Library when you need to follow up on registrations, balances, hours, leave, vacation, projects, job codes, or HR data across employees, departments, companies, countries, and periods.

The Report Library is used for analysis, follow-up, and export to Excel. It is not used for payroll processing itself. If approved registrations need to be exported to the payroll system and marked as processed, you should use Payroll Export.

This article is for

Administrators, HR, payroll managers, and other users who work with reports, statistics, registration data, and exports in BitaBIZ.

Important prerequisite

Before you choose a report, you need to know what type of data you want to see.

For example, it could be:

  • payroll hours

  • project hours

  • hours on job codes

  • overtime, time off, and hour bank balance

  • vacation and vacation balances

  • sick leave

  • mileage

  • employee data

  • HR key figures

You also need access to the Report Library. The Report Library requires the HR Statistics role and must be activated as an add-on to your company’s subscription plan.

What does the Report Library consist of?

The Report Library contains reports based on your company’s registrations, policies, employee profiles, approval flows, and selected periods.

Report data can therefore depend on:

  • the employee’s policy

  • registration type

  • approval status

  • selected period

  • selected filters

  • whether the employee uses time registration with or without hour bank

Always check the period, filters, registration status, policy, and registration type when analyzing or exporting report data.

Which report should I use?

Use the overview below to choose the right report.

If your question is about

Start here

Payroll hours

Project hours

Hours on job codes

Registered work hours without balance

Basis for payroll for hourly paid employees

Weekly work hours or EU’s 48-hour rule without hour bank

Flex time

Hour bank balance

Overtime

Time off

Hour bank adjustments, payouts, or corrections

Weekly work hours or EU’s 48-hour rule with hour bank

Vacation accrual, usage, or balances

Supplementary balance

(e.g. other vacation, care days, 6th vacation week)

Sick days, child sick, 120-day rule, Bradford factor, or sick leave percentage

Other leave

(e.g. leave of absence, parental leave, or unpaid leave)

Company-specific registrations (e.g. travel days, working from home, seminar, on-call duty)

Mileage registrations for mileage registration

Active and inactive employees, departments, payroll numbers, or approvers

Number of employees (FTE analysis)

Employee inflow/outflow, staff turnover

Payroll hours and project hours

If you need to see payroll hours, project hours, or hours on job codes, you should use the report:

HR Statistics → Report Library → Time Registration - Without hour bank

The report shows registered hours. It does not show balances or accrued hours.

Use:

  • Registration log if you want to see individual time registrations

  • Sum per period if you want to see totals per employee, project, or job code

  • Sum per week if you want to see weekly work hours or the EU’s 48-hour rule

If you need an overview of payroll hours, job codes, or project hours, the answer is that the Time Registration - Without hour bank report is the right place to look.

Hour bank, flex time, overtime, and time off

If you need to see hour bank balance, flex time, overtime, time off, payouts, or hour bank adjustments, you should use the report:

HR Statistics → Report Library → Time Registration - With hour bank

Use:

  • Registration log if you want to see the entries behind the hour bank balance calculation

  • Sum per period if you want to see totals of e.g. overtime, time off, or flex time

  • Sum per week if you want to see weekly work hours or the EU’s 48-hour rule

  • Balance per selected month if you want to see the hour bank balance at the end of a selected month

Vacation, leave, and balances

If you need to follow up on vacation, supplementary balance (other vacation), sick leave, or other types of leave, you should choose the report that matches the registration type.

Examples:

  • Use Vacation when you want to see vacation accrual, usage, transfers, and balances.

  • Use Sick leave when you want to see sick days, child sick, 120-day rule, Bradford factor, or sick leave percentage.

  • Use Other leave when you want to see registrations for e.g. leave of absence, parental leave, or unpaid leave.

  • Use the Supplementary balance report when you want to see other vacation, care days, or 6th vacation week.

HR key figures and employee data

If you need to see employee data or HR key figures, you should use HR key figures.

The report can be used for:

  • employee log

  • active and inactive employees

  • departments

  • payroll numbers

  • approvers

  • number of employees

  • staff turnover

  • inflow and outflow in a selected period

Status category in the reports

This matrix shows which status category different reports and registration types typically belong to in BitaBIZ.

The status category tells you how the registration should be understood in reports and overviews. For example, a registration can show whether the employee is at work, working elsewhere, or is absent.

Status category

Report / registration

Example

Absent

Vacation

Vacation day

Absent

Supplementary balance

Other vacation, FF days, OK days, 6th vacation week, Care days

Absent

Sick leave

Sick, child sick

Absent

Other leave

Leave of absence, parental leave, unpaid leave

Absent

Time registration - With hour bank

Time off

At work

Time registration - With hour bank

Overtime

At work

Time registration - With hour bank

Work hours

At work

Time registration - Without hour bank

Payroll hours, project hours, time registrations

At work

Custom registration types

On-call duty

Working elsewhere

Custom registration types

Working from home

Working elsewhere

Custom registration types

Seminar

Working elsewhere

Custom registration types

Travel

Absent

Custom registration types

Fixed day off

Absent

Custom registration types

Private appointment

ℹ️ There is no report that contains all registration types.

💁 The Team Calendar has standard filters for the status categories. Use the Team Calendar for a combined graphical overview of one or more status categories.

Select period

When you generate a report, you need to select the period the report should cover.

Here's how:

  1. Choose how the period should be filtered: year, quarter, month, or from/to date.

  2. Select the desired period.

  3. Click Apply and show report.

  4. Use any filters to narrow down the report.

  5. Export to Excel if you need to work further with the data.

You can generate reports for a maximum of one year at a time. If you need data for a longer period, you must generate multiple reports and combine them afterwards.

Important to know

The report library displays data based on your company's registrations and setup.

If a report does not show the expected data, it is often due to:

  • incorrect period selected

  • active filters

  • incorrect registration type

  • missing or changed approval status

  • the employee using a different time registration solution

  • the data being in a different report than expected

  • the employee having changed policy or department

The report library is not used to mark registrations as payroll processed. Use Payroll export when registrations need to be exported to the payroll system and included in payroll processing.

FAQ

Do you have a report that pulls all leave?

No. Each leave type has its own report. This is partly because there may be special logic attached to a leave type report. Vacation has a balance per selected month. Sick leave has a sick leave percentage.

In BitaBIZ, leave types are distributed across these reports:

There may also be leave types under the Planning report (Custom registration types)

Custom registration types with status absent are typically:

  • Fixed day off

  • Private appointment

I need an overview of payroll hours. Which report should I use?

Use Time registration - Without hour bank.

If you want to see the individual registrations, use Registration log. Select the job codes/pay rates you want to include in the report.

If you want to see the sum per employee, use Sum per period. Select the job codes/rates you want to calculate a sum for.

I need a report on project hours. Which report should I use?

Use Time registration - Without hour bank.

Project hours and hours on job codes are found in the report for time registration without hour bank. Use Sum per period if you want to see totals for a selected period on one or more projects or job codes.

If you want to see the individual registrations on a project or job codes, use Registration log.

What is the difference between time registration with and without hour bank in the Report Library?

Time registration - Without hour bank shows registered hours, e.g. payroll hours, project hours, and hours on job codes.

Time registration - With hour bank shows registrations and balances related to the hour bank, such as flex time, overtime, time off, payouts, earning, and adjustments.

Which report should I use for the EU's 48-hour rule?

It depends on the employee's time registration solution.

Use:

  • Time registration - Without hour bank, if the employee registers time without hour bank

  • Time registration - With hour bank, if the employee registers time with hour bank

In both reports, use the Sum per week view for weekly work hours and average work hours for a selected reference period.

Why can't I find the hours I'm looking for?

Start by checking:

  • selected period

  • filters

  • employee

  • policies

  • job code or registration type

  • approval status

  • whether the hours belong to time registration with or without hour bank

If your question is about payroll hours, project hours, or job codes, start in Time registration - Without hour bank.

If your question is about balance, flex time, overtime, or time off, start in Time registration - With hour bank.

Who has access to the Report Library?

The Report Library requires the HR Statistics role.

The role is assigned by a user with Setup Admin rights.

The HR Statistics role is a global role that gives access to the company's reports and registration data.

The Report Library is an add-on that must be activated on the subscription plan page.

When should I use Payroll export, Calendar access, and the Report Library?

Use Payroll export when approved registrations need to be exported to the payroll system and marked as payroll processed.

Use Calendar access when you need to check or adjust registrations and balances for a single employee.

Use Report Library when you need to follow up on data across employees, periods, departments, and registration types.

Together, these tools cover the process from follow-up and reconciliation to payroll processing and analysis.

Can I generate a report for multiple years?

No. You can only pull data for one year at a time in the Report Library.

If you need a longer period, you must generate multiple reports and combine them.

Can reports be exported to Excel?

Yes. All reports in the Report Library can be exported to Excel.

Click Export to continue working in Excel.

To avoid conversion issues, it is recommended to use the same decimal separator in BitaBIZ as in Excel.

Do you need a report to give the canteen an overview for lunch planning? Which report should I use?

If your goal is to see how many employees are absent on a specific day or week for your canteen or lunch program, we recommend using the Team Calendar instead of the report library.

The Team Calendar gives you a real-time overview of the number of absent employees and those working elsewhere.

Absence status typically covers:

  • Vacation

  • Supplementary balance (e.g. other vacation, OK days)

  • Sick leave (Sick days and child sick)

  • Other leave (Types of leave)

  • Time off

  • Fixed day off (custom registration type with absent status)

Working elsewhere status covers:

Custom registration types with status working elsewhere typically cover:

  • Working from home

  • Seminar

  • Travel

  • Working from another office

When should I use the Time Registration report with or without hour bank?

Use the time registration reports when you need an overview, analysis, or export of work hours for multiple employees, a department, or a specific period.

If you need to check one specific employee’s calendar, registrations, or balance, you should generally use the employee’s calendar in Payroll Admin.

When choosing a report, first check whether the employee group uses time registration with or without hour bank.

Need

Use this report

Typically used for

Overview of registered hours without hour bank

HR Statistics → Report Library → Time Registration - Without hour bank

Payroll hours, project hours, job code hours, weekly work hours, and EU 48-hour rule

Overview of time registration with hour bank

HR Statistics → Report Library → Time Registration - With hour bank

Flex time, overtime, time off, plus/minus hours, hour bank balance, hour bank transactions, and 48-hour rule

Use Time Registration - Without hour bank when the employee group does not use an hour bank and you need to export or analyze registered hours.

Use Time Registration - With hour bank when the employee group uses an hour bank and you need to see work hours, flex time, plus/minus hours, overtime, time off, or the hour bank’s balance and transactions.

Do not select a report before you have clarified whether employees use time registration with or without hour bank. If you look in the wrong report, you will not be able to find the employees’ hours.

Example

If you need an overview of total hours for a department over a period, you should use the Report Library.

If the department uses an hour bank, select:

HR Statistics → Report Library → Time Registration - With hour bank

If the department does not use an hour bank, select:

HR Statistics → Report Library → Time Registration - Without hour bank

If, on the other hand, you need to check one specific employee’s registrations or balance, open the employee’s calendar in Payroll Admin.

Did this answer your question?