Report: Turnover

Turnover report


🖥 Open in Shiftbase


Turnover reporting reflects revenue indicated through the log, turnover and the expenses are shown per department per day.

Filters

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

  • Departments - The department (or several departments) you want to filter on.

  • Group by location - How you want the information to be grouped, here you have the options: Team, Department, Location or Account.

  • Group by period - How you want the information to be grouped, here you have the options: Day, Week, Month, Quarter, Year or Total.

  • 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

  • Period - The date that is shown.

  • Location - Location name.

  • Location id - The assigned id from Shiftbase of the location.

  • Department - Department name.

  • Department id - The assigned id from Shiftbase of the department.Vacation - The total amount of vacation hours taken in the selected period.

  • Sick - The total amount of sick hours taken in the selected period.

  • National holiday - The total amount of national holiday hours taken in the selected period.

  • Special leave - The total amount of special leave taken in the selected period.

  • Maternity leave - The total amount of maternity leave taken in the selected period.

  • Short term care leave - The total amount of short term care leave taken in the selected period.

  • Long term care leave - The total amount of long term care leave taken in the selected period.

  • Parental leave - The total amount of parental leave taken in the selected period.

  • Unpaid leave - The total amount of unpaid leave taken in the selected period.

  • Manually added absence types - The total amount of hours taken in the selected period for the manually added absence types. If you added more than 1 absence type these will visible in their own columns.

  • Budget salary - The budget specified in the schedule based on salary for the selected period.

  • Budget time - The budget specified in the schedule based on time for the selected period.

  • Turnover - Sales indicated in the journal.

  • Expected turnover - Sales revenue forecast in the schedule tab.

  • Expenses - Expenses posted in the log.

  • Pay - The total worked hours to be paid including surcharges.

  • Wage - Total labour costs of all pay types together including the absence. The costs of the absence are booked on the contract department of the employee.
    Employees can be deployed on multiple departments but the absence costs will only be booked on the contract department.

  • Coc Salary - Wage costs at company level. Estimate of what the company is paying on total wage costs.

  • Coc - An estimate of the cost for the company based on the worked hours.

  • Hours worked - Total of hours worked.

  • Hours absent - Total absence in hours.

  • Contract hours - The number of contract hours per department for the selected period.

  • Sick leave percentage - The percentage of registered sickness hours in comparison to contract hours.

  • Turnover per hour - Turnover divided by the number of hours worked.

  • Salary - The salary divided by the amount of hours worked.

  • Percentage of turnover - Percentage of salary relative to revenue.

  • Percentage of Coc - Percentage of cost of company in respect of sales.

Did this answer your question?