The simplest way to calculate employee turnover is to divide the number of employees who left during a period by the average number of employees, then multiply by 100 to get a percentage.
What Is the Turnover Rate?
To calculate turnover (employee churn), you divide the number of employees who left during a period by the average number of employees in that same period, then multiply by 100 for a percentage, using the formula: (Leavers / Average Employees) x 100, where average employees are (Start Count + End Count) / 2.
If 8 employees left over the quarter and your average workforce was 80, the turnover rate is (8 ÷ 80) × 100 = 10%. A high turnover percentage may indicate deeper retention issues, while a low number suggests a more stable, satisfied workforce.
Put simply, turnover is the total amount of money your business receives from the sale of goods and services – minus discounts and VAT. Turnover is calculated over a specific period of time, usually a quarter or financial year.
To calculate your annual business turnover, add your total sales from all 12 months in the last financial year. If you're a product-based business, this means the total money you received from the products you sold.
Average turnover of micro and small businesses
Micro businesses with 1-9 employees reported an average turnover of £446,872 per year, while small companies with 10 or more employees reported an average turnover of £2,802,670 in 2022.
FAQ: Turnover Rate Calculation Spreadsheet
The turnover rate is calculated using this formula: (Number of Employees Who Left / Average Number of Employees) x 100.
The lack of relevant data and insights to identify room for improvement supports the perception that a staff turnover rate under 10% - 12% is completely ok. This is true if it is lower than the market average. However, what is good can always be improved.
Data collection for turnover prediction (what data you actually need) To employ AI capabilities and start to predict employee turnover, you will need to collect employee data from different sources. These include job satisfaction surveys, performance evaluations, interactions on internal platforms, and feedback.
For example, if an Indian company generates 10,00,000 INR annually from its sales or services, this amount constitutes its turnover. Accurate and detailed record-keeping is essential for Indian businesses to track their sales and revenue effectively.
A 20% turnover means 20% of something has been replaced or sold within a period, commonly referring to employee turnover (20% of staff left) or portfolio turnover (20% of investment assets traded), both indicating the rate of change, with high rates often signaling issues like poor culture or active (potentially costly) trading, though low turnover in investments often suggests a buy-and-hold strategy.
Employee turnover: An employee decides to leave a company and, in response, the company recruits and hires someone else to fill the position. This will be included in the company's turnover rate. Employee attrition: An employee retires and leaves the company.
Most experts say it's 10%. You want some attrition, ideally from the bottom performers. But the Bureau of Labor Statistics shows turnover rates are in constant flux. At one time, the national average was as high as 57%!
In order to calculate this metric when it comes to your company, you just have to divide the number of hires in calculation period that were terminated within the first 90 days of the contract by the total number of new hires during the same period of time and then multiply the end result with 100.
Some suggest that a good revenue per employee benchmark ranges from $43,000 per employee for companies making $1,000,000 or less to $230,000 for companies making $50,000,000 or more.
The Retail and Wholesale industry in the US has the highest turnover rate at 26.7%. Meanwhile, the Insurance/Reinsurance industry enjoys the lowest turnover rate at just 8.2%. Here's how turnover rates vary by department in the US: Head of organizations and executives: 5.2%
Companies often measure employee turnover rate as a percentage. It's calculated by dividing the number of employees who leave in a year (or another time period) by the average number of employees at the organization during the same period.
Pro tip: It's important to note that turnover rates vary significantly from industry to industry. However, turnover rates should (ideally) be lower than 10%, which is a very healthy turnover rate across the board.