🖥 Open in Shiftbase

With this report you have insight into all data within Shiftbase of a certain period. Think of hours worked, scheduled shifts and turnover compared to labor costs.

Filters within the report

  • Period: The period from which you want to retrieve the data.

  • Team: The team (or teams) whose data you want to query.

  • Employee: The specific employee whose data you want to query.

  • Contract departments: The contract department(s) whose data you want to query.
    ⚠️ Note: This filter will only display employees who are under contract to the selected contract department(s).

  • Contract type: The contract type of which you want to retrieve the data.

  • Group by period: The way you want the information to be grouped.

  • Columns: The columns you want to see in the report. By default these are all selected, clicking on the field will bring up two fields called Excluded and Selected. The columns in the left field are not included in the report, the columns in the right field are.

Columns

  • User id: The id of the employee determined by Shiftbase.

  • Name: The name of the employee.
    ⚠️ Note: If the employee's name occurs multiple times, then the employee has also registered hours under other department(s).

  • Employee number: The employee's employee number.

  • Location: The standard location of the employee.

  • Department: The standard department of the employee.

  • Contract type: The employee's contract type within Shiftbase.

  • Days: The number of contract days of the employee within the selected period.

  • Contract hours: The number of contract hours of the employee within the selected period.

  • Days worked: The number of approved worked days of the employee within the selected period.

  • Hours worked: The number of approved hours worked by the employee within the selected period.

  • Surcharge hours (paid): The number of hours the employee has been paid extra through a surcharge.
    👀 Example: Employee worked 2 hours on Saturday with a 200% allowance card, then the allowance hours (paid) are 2 hours.

  • Supplemental hours (time): The number of plus hours that the employee has obtained extra by means of a supplement.
    👀 Example: On a Sunday, 6 hours are worked with a time-for-time allowance card of 150%, then the allowance hours (time) are 3 hours.

  • Meals: The occasional meals taken.

  • Kilometers: The incidental kilometers driven.

  • Wait hours: The number of wait hours of the employee within the selected period.

  • Correction plus min: Total of the entered plus/minus corrections in the period.

  • Pay plus min hours: The number of plus/minus hours to be paid of the employee within the selected period.

  • Plus min period: The number of plus/min hours of the employee within the selected period, including corrections made. The value shown, is the difference in balance between the start and end date of the selected period.

  • Plus min at start of period: The position of plus/minus hours at the beginning of the selected period.

  • Plus min at end of period: The balance of plus/minus hours at the end of the selected period.

  • Pay plus min hours total: All plus hours that have been or are to be paid out by correction.

  • Plus min total last week: The total balance of plus/minus hours from the past week.

  • Plus min total: The current total balance of plus/minus hours.

  • Vacation: The number of hours recorded for a vacation.

  • Sick: The number of sick hours recorded.

  • National holiday: The number of hours recorded under the national holiday type.

  • Special leave: The number of hours recorded under the special leave type.

  • Maternity leave: The number of hours recorded under the type of maternity leave.

  • Short-term care leave: The number of hours recorded under the short-term care leave type.

  • Long-term care leave: The number of hours recorded under the long-term care leave type.

  • Parental leave: The number of hours recorded under the type of parental leave.

  • Unpaid leave: The number of hours recorded under the unpaid leave type.

  • Surcharge salary: The part of the salary that has been obtained with a supplementary allowance. This has already been deducted from the salary.

  • Salary: The salary of the employee. This is made up of the hours worked, absence, allowances and corrections.

  • Wage tax: Indicates whether the employee is using payroll tax.

  • Locations and departments: The hours worked that were performed within the respective department(s).

Did this answer your question?