Payroll
      Back to home
      1. Help Center
      2. Reports
      3. Payroll

      Report: Payroll

      Payroll report


      🖥 Open in Shiftbase


      The payroll report specifies all the worked hours and other relevant information from the timesheet registration. This report is composed of a variety of columns containing worked hours, possible payout of overtime, and possible costs and fees that are important for the payroll of your employees.

      This report can be exported as either Excel or CSV to the payroll administration.

      Filters

      • Contract hours period: For all employees with fixed contracts.

      • Worked hours period: For all employees with zero-hour contracts.

      • Contract departments: The contract department (or departments) you want to filter on.

      ⚠️ Note: This is not the same as Team, employees can appear in multiple teams in different departments. Employees always have only one contract department.

      • Contract type: The contract type you want to filter on.

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

      Columns

      • User ID: User ID created by the system.

      • Employee nr: The employee's personal number.

      • Name: The name of the employee. 

      • Type: The contract type of the employee. This is not a physical contract, calculations are done with these predefined contract settings.

      • Warning: When an employee has two types of contracts for which hours are raised during the same period. The name will appear twice.

      • Days: The number of contact days the employee has in the period. The start and end date of the contract have an impact on the given days.

      • Shifts: Number of shifts that are registered for an employee.

      • Meals: The occasionally listed meals.

      • Kilometers: The occasionally listed kilometers.

      • Payout Vacation hours (Hourly employee): The payout of the first/standard type of time off balance of an employee with a flex hours contract.
        (If you are using multiple time off balances, then these columns are separately available.)

      • Payout Vacation hours (Contract hours): The pay out of the first/standard type of time off balance of an employee with a fixed hours contract.
        (If you are using multiple time off balances, then these columns are separately available.)

      • Worked "%" (Contract hours): The number of hours an employee has received with a surcharge. For example: On a Sunday, a 6-hour shift with a surcharge of 150%, surcharge hours (time) is 3 hours for the employee.
        (If you are using multiple percentages for the surcharges, then these columns are separately available.)

      • Worked "%" (Hourly employee): The number of hours an employee has received with a surcharge. For example: On a Sunday, a 6-hour shift with a surcharge of 150%, surcharge hours (time) is 3 hours for the employee.
        (If you are using multiple percentages for the surcharges, then these columns are separately available.)

      • Plus min correction (Hourly employee): Total of plus-minus hours that need to be paid out.

      • Plus min correction (Contract hours): Total of plus-minus hours that need to be paid out. 

      • Wait hours from salary: The waiting hours for an employee during sickness. These waiting hours are deducted from the salary.

      • Wait hours from vacation: The waiting hours for an employee during sickness. These waiting hours are deducted from the leave hours.
        (Should you use multiple time-off balances, then these columns are separately available.)

      The following columns are absence types, these are all divided between Hourly employee and Contract hours.

      • Vacation: The number of holiday hours/days taken.

      • Sick: The number of sick hours/days taken.

      • National day: The number of hours/days that fall under a national day absence.

      • Special leave: The number of hours/days that fall under a special leave absence.

      • Maternity leave: Total number of approved maternity leave hours/days.

      • Short-term care leave: Number of approved hours/days for a short-term care leave.

      • Long term care leave: Number of approved hours/days for a long-term care leave.

      • Parental leave: Number of approved hours/days for parental leave.

      • Unpaid leave: Number of approved hours/days for an unpaid leave.

      • Custom fields: If you are using custom fields involving the timesheet, these columns will be available as the last columns of this report.