Report: Timesheet totals

In this article you can find out what the report Timesheet totals contains.

Basic_Premium Plan


🖥 Open in Shiftbase


With this report, you have insight into all data of the time tracking within Shiftbase for a certain desired period. The report shows the contract hours, hours worked and specified hours.

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 department: The contract department(s) whose data you want to query.

Caution: This filter will only display employees who are under contract to the selected contract department(s).

  • Contract type: The contract type whose data you want to retrieve.
  • Columns: The columns you want to see in the report. By default, these are all selected. Clicking on the checkbox in front of the column will uncheck them from the report and not be shown.

Columns

  • User ID: The ID of the employee determined by Shiftbase or the payroll integration.

  • Employee nr: The employee's number.

  • Name: The name of the employee.

  • Contract hours p/w: The number of contract hours of the employee per week within the selected period.

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

  • Shifts: The number of recorded shifts of the employee within the selected period.

  • 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.

  • Total incl. surcharge: The total of the hours worked and the supplement hours added together.

  • Wage: The wage cost for the employee, based on the hours worked. This is based on the employee's stated hourly wage.

  • Meals: The meals that are taken occasionally.

  • Kilometers: The incidental kilometers driven.

  • Coc: An estimate of the cost to the company, based on the scheduled shift.

  • Surcharges "%": All hours worked under surcharge, these are included under the surcharge settings.

  • Overtime: The number of hours worked in an overtime policy.
  • Regular time: The number of hours worked as regular time.