In this article you can find out what the report Schedule totals contains.
This report gives you insight into all the data of the schedule within Shiftbase for a certain desired period.
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.
-
Shift: The shift(s) from which you want to retrieve the data.
-
Employee: The specific employee whose data you want to query.
- Contract departments: 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 you want to retrieve the data.
-
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 number.
- Name: The name of the employee.
❗Caution: If the employee's name appears multiple times, then the employee has also registered hours under other departments.
-
Days: The number of contract days of the employee within the selected period.
-
Shifts: The number of shifts for which the employee is scheduled.
-
Hours: The number of hours for which the employee is scheduled.
-
Wage: The wage cost for the employee, based on the hours worked. This is based on the given hourly wage of the employee.
-
Coc: An estimate of the cost to the business, based on the employee's hours worked.
- Surcharge hours (paid): The number of hours the employee has been paid extra by means of a supplement.
👀 Example: Employee worked 2 hours on Saturday with a surcharge card 200%, then the surcharge hours (paid) are 2 hours.
-
Total incl. surcharge: The total number of hours scheduled, including supplemental hours.
