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.

  • Columns - Here you can select the columns you want to see in your report. By default, these are all selected, by clicking on the filter you will see two columns Excluded and Selected. What is in the left-hand column (Excluded) will not be included in your report. What is in the right-hand column (Selected) will be included in your report.

Columns

  • User id - User id created by the system.

  • Employee nr – Employee number, can be added under Employees > Select employee > Edit user.

  • Name - Name of 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 has 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 kilometres.

  • 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 seperately available.)

  • Plus min correction (Hourly employee) – Total of plus-minus hours that need to be paid out. These hours are added under: Plus-minus hours > + Add correction > Action - Payout.
    (This is for the employees with a flex hours contract type of which there has been chosen to add plus-min hours.)

  • Plus min correction (Contract hours) – Total of plus-minus hours that need to be paid out. These hours are added under: Plus-minus hours > + Add correction > Action - Payout.

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

  • Sick – The number of sick hours taken.

  • National day – The number of hours that fall under a national day absence.

  • Special leave - The number of hours that fall under a special leave absence.

  • Maternity leave – Total number of approved maternity leave hours.

  • Maternity leave – Total number of approved maternity leave hours.

  • Shortterm care leave – Number of approved hours for an shortterm care leave.

  • Longterm care leave – Number of approved hours for an longterm care leave.

  • Parental leave – Number of approved hours for an parental leave.

  • Unpaid leave – Number of approved hours 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.