The Turnover report in Ciphr HR can be used to examine staff turnover figures and this information
can be grouped according to requirements.

Contents

• To run the Turnover report
• Turnover report calculations
• To create a Turnover group

To run the Turnover report

• Navigate to
  • Latest (left-hand) menu: Reporting > Reports
  • Pre-2025 menu: Reports > Reports
• From the Manpower group of reports, select Turnover

• A Filter selection can be applied or a Saved Filter reused as required
• The report can optionally be presented by different groupings
• Department, Location and Grade are standard options within Ciphr HR
• Turnover Group is a grouping that can be determined for your Ciphr HR system and enables several departments to be collected together for the purpose of reporting. E.g. lead generation, account management and new business could all be grouped under the turnover group of Sales
• Click Continue to run the report

Turnover report calculations

The columns in the report are calculated as follows:

• Staff at Start: All staff with a job and pay record valid at "Turnover Start". This will not include employees who have a job and pay record that starts on the beginning of the period that has the Starter Flag within the job and pay record flagged
• Staff at End: All staff with a job and pay record valid at "Turnover End"
• Average Staff: The average between the "Staff at start" and "Staff at end"
• Transfers In: Staff who have a previous job and pay record with consecutive dates and the turnover group is different
• Transfers Out: Where the next job and pay record has consecutive dates and the turnover group is different
• Starters: Staff in the period who have the Starter Flag marked within the job and pay record flagged
• Leavers: Staff in the period who have the Leaver Flag marked within the job and pay record flagged
• Annual Wastage %: Leavers / Average Staff * (365 / (1+Date difference in period)
   

To create a Turnover group

• Turnover Groups are created in the OrgUnit1 code table (in this instance “Department”)
• Navigate to
  • Latest (left-hand) menu: Data Management > Code Tables
  • Pre-2025 menu: System > System Administration > Code Tables
• From the Group of Job and Pay select “Department”

• The screen will display all of the existing entries in the Department code table
• To assign a Turnover Group to an existing entry, click on the required entry

• Click on the dropdown list for Turnover and select the required group OR
• If a new grouping is to be created simply type the name of the group
• Newly-typed group names will be automatically added to the entries in this list and can then be re-used to assign to other departments as required
• If the turnover group assigned needs to be changed, either select one from the existing list or click on the ‘X’ alongside the existing name to clear it and then enter the new name