Overview
The Employee Turnover Report(s) are a useful HR tool designed to track and analyse employee departures over a chosen period. It provides a clear view of how many employees have left an organisation, as well as the percentage of turnover based on the average headcount. It offers visibility into who left and why, enabling organisations to identify trends, assess retention strategies, and address potential issues within specific Locations, Divisions, or Job Titles.
This article references two reports:
- Employee Turnover Report - offers a more granular breakdown by division and job title within each location (as well as overall totals) for a specified date range
- Employee Turnover Report by Location - provides a higher-level summary focused on turnover by a single location across the selected months
Contents
Employee Turnover Report
Running the Employee Turnover Report
To run the Employee Turnover Report, go to:
- HR > Reports > Employee Turnover Report
Fig.1 - Employee Turnover Report - Parameters Screen
- Enter the necessary criteria, select Locations, and then Search
Please Note: More information on the reports search criteria can be found in the Appendix at the end of this article.
Fig.2 - Employee Turnover Report - Applying Parameters
The report results will be displayed onscreen.
Fig.3 - Employee Turnover Report - Generated
- To export the report, select Export to Excel (See Fig.3), and it will look like this in Excel:
Fig.4 - Employee Turnover Report - Exported to Excel
Breakdown of the Employee Turnover Report
Fig.5 - Employee Turnover Report - Breakdown
Chosen Parameters and Filters
(Purple Box in Fig.5)
See Running the Employee Turnover Report section, as well as Appendix.
-
Show Employees By: Allows selection by All, Salary Paid or Hourly/Shift Paid
-
Date Range: Defined by Date From and Date To.
Location & Division (or Job Titles) Columns:
(Orange Box in Fig.5)
-
When Divisions are selected:
-
Shows the number of employees who left each division within each location.
-
Also displays the percentage of that division’s workforce at the location, that have left.
-
Example: "4 (8.7%)" = 4 leavers, which is 8.7% of that division's employees at that location.
-
-
When Job Titles are selected:
-
Shows the number of employees who left each job title within each location.
-
Also displays the percentage of employees in that job title who left.
-
Example: The report may show "4 (13.3%)" in location row, under a particular job title (e.g. Bartender). This means 4 bartenders left, which is 13.3% of all bartenders at that location.
-
Total Leavers:
(Blue Box in Fig.5)
-
Displays the total number of leavers per location, along with the overall turnover rate for that location.
-
Example: "4 (4) (7.4%)"
-
4 = total leavers
-
(4) = number of leavers marked as Re-Employ = Yes (Found in Employees Termination Details Page)
-
7.4% = 4 ÷ 54 (total employees, see below) × 100
-
Total Employees
(Red Box in Fig.5)
-
Shows the average number of employees at each location during the reporting period.
-
Example: If Location 1 had 65 employees on 1st January 2025 (Date From Parameter) and 43 on 31st May 2025 (Date To Parameter), the average shown would be 54 employees.
Bottom Row Totals
(Green Box in Fig.5)
Provides totals across all locations and divisions/job titles based on selected filters:
-
Total Leavers by Division / Job Title
-
Total Leavers
-
Overall Turnover Rate
-
Total Average Workforce
Termination Analysis - Detailed Breakdown of Leavers
The Termination Analysis feature allows users to dive further down into the employee turnover report to view a detailed pop-up showing who the leavers are, including their name, job title, division, location, start and leave dates, termination reason, and length of service. It also provides a summary breakdown of termination reasons and length of service, grouped into meaningful increments. with counts and percentages to support deeper analysis.
- After running the Employee Turnover Report, select any of the cells specified below, with the following detailing what will be presented:
Fig.6 - Employee Turnover Report - Cells that will allow Termination Analysis
-
Termination Analysis by single Division at a single Location
(Blue Box - Fig.6) -
Termination Analysis by Location (All Divisions)
(Orange Box - Fig.6) -
Termination Analysis by Division (All Locations)
(Purple Box - Fig.6) -
Termination Analysis - All Locations & Divisions
(Red Box - Fig.6)
Fig.7 - Termination Analysis - Single Division, Single Location
Employee Turnover Report by Location
Running the Employee Turnover Report by Location
To run the Employee Turnover Report, go to:
- HR > Reports > Employee Turnover Report by Location
Fig.8 - Employee Turnover Report by Location - Parameters Screen
- Enter the necessary criteria, select Locations, and then Search
Please note: More information on the reports search criteria can be found in the Appendix at the end of this article.
Fig.9 - Employee Turnover Report by Location - Applying Parameters
The report will be presented onscreen.
Fig.10 - Employee Turnover Report by Location- Generated
- To export the report, select Export to Excel (See Fig.10), and will look like this in Excel:
Fig.11 - Employee Turnover Report by Location - Exported to Excel
Breakdown of the Employee Turnover Report by Location
Fig.12 - Employee Turnover Report by Location- Breakdown
Chosen Parameters and Filters
(Blue Box in Fig.12)
See Running the Employee Turnover Report by Location section, as well as Appendix.
-
Show Employees By: Allows selection by All, Salary Paid or Hourly/Shift Paid
-
Date Range: Defined by Date From and Date To.
Location & Month Columns:
(Purple Box in Fig.12)
-
Shows the number of employees who left each in the month within each location.
-
Also displays the percentage of that months workforce at the location, that have left.
-
Example: "6 (4.5%)" = 6 leavers, which is 4.5% of that division's employees at that location in that month
Total Leavers:
(Red Box in Fig.12)
-
Displays the total number of leavers per location, along with the overall turnover rate for that location during the reporting window selected
-
Example: "4 (4) (7.4%)"
-
4 = total leavers
-
7.4% = 4 ÷ 54 (total employees, see below) × 100
-
Total Employees
(Green Box in Fig.12)
-
Shows the average number of employees at each location during the reporting period.
-
Example: If Location 1 had 65 employees on 1st January 2025 (Date From Parameter) and 43 on 31st May 2025 (Date To Parameter), the average shown would be 54 employees.
Bottom Row Totals
(Orange Box in Fig.12)
Provides totals across all locations and month based on selected filters:
-
Total Leavers by Month
-
Total Leavers
-
Overall Turnover Rate
-
Total Average Workforce
Termination Analysis - Detailed Breakdown of Leavers
The Termination Analysis feature allows users to dive further down into the employee turnover report to view a detailed pop-up showing who the leavers are, including their name, job title, division, location, start and leave dates, termination reason, and length of service. It also provides a summary breakdown of termination reasons and length of service, grouped into meaningful increments. with counts and percentages to support deeper analysis.
After running the Employee Turnover Report, select any of the cells specified below, with the following detailing what will be presented:
Fig.13 - Employee Turnover Report by Location - Cells that will allow Termination Analysis
-
Termination Analysis by single month at a single Location
(Orange Box - Fig.13) -
Termination Analysis by Location (All Months)
(Blue Box - Fig.13) -
Termination Analysis by Month (All Locations)
(Purple Box - Fig.13) -
Termination Analysis - All Locations & Months
(Red Box - Fig.13)
Fig.14 - Termination Analysis - Single Division, Single Location
Appendix
Employee Turnover Report Parameters
This report offers multiple ways to refine and filter the data returned:
- Data From & Data To - Specify the date range for which data is retrieved
- By: Job Title or Division - Location will be further broken down by either Job title or Division, depending on the user's selection.
-
Show Employees: The options are All, Paid by Rota Only or Salaried Only
- All: All employees will be in scope of the report
- Paid by Rota Only: Only employees paid by the hour or shift will be in scope of the report
- Salaried Only: Only employees paid by a salary will be in scope of the report
-
Selection Location: This is an assignment table where the user can assign all, or select, locations to be in scope of the report. To move locations between Available and Selected, use the arrow buttons in the middle of the table:
-
Select a location and use the single right arrow to move it to Selected.
-
Use the double right arrow to move all locations to Selected.
-
To undo, select a location in Selected and select the single left arrow to move it back to Available.
-
Use the double left arrow to move all locations back to Available.
-
Employee Turnover by Location Report Parameters
This reports offers multiple ways to refine and filter the data returned:
- Data From & Data To - Specify the date range for which data is retrieved. This will display in months and years, but when picking, it uses a calendar to select by day. If any day in January, for example, is selected, then the month of January will be used.
-
Show Employees: The options are All, Paid by Rota Only or Salaried Only
- All: All employees will be in scope of the report
- Paid by Rota Only: Only employees paid by the hour, or shift, will be in scope of the report
- Salaried Only: Only employees paid by a salary will be in scope of the report
-
Selection Location: This is an assignment table where the user can assign all, or select, locations to be in scope of the report. To move locations between Available and Selected, use the arrow buttons in the middle of the table:
-
Select a location and use the single right arrow to move it to Selected.
-
Use the double right arrow to move all locations to Selected.
-
To undo, select a location in Selected and select the single left arrow to move it back to Available.
-
Use the double left arrow to move all locations back to Available.
-
Comments
Please sign in to leave a comment.