Turnover report

Turnover report

Use the Turnover report to see who joined, who left and what your turnover rate or attrition is. It shows how many people left this year, how many resigned or were let go, which months and departments lost people, and why they left, so you can answer "what is our turnover?" with a figure you can explain.

Where: My Team › Tools & Reports, under Reports, select Turnover

You need: the My Team Reports right. The figures cover the people your access covers.

How to read your turnover

  1. Under Period, choose Last 3 months, Last 6 months, Last 12 months or Last 24 months. The page opens on the last 6 months.
  2. To narrow it, choose a Subsidiary, Department or Branch. All the figures recalculate. Clear all removes them.
  3. Read the cards: Headcount, Joiners, Leavers and Turnover Rate.
  4. Under Why people left, see the voluntary and involuntary split and each separation type.
  5. Under Monthly breakdown, select a month to see who left in it.
  6. Select All leavers for the full list. Search it, or select a separation type chip to narrow it.
  7. Select a name for the details, then Open Profile if you need to fix something.

Select Refresh to reload the figures after you change someone's last day or separation type.

The Turnover report's cards: Headcount, Joiners, Leavers and Turnover rate

How to export it

  1. Select Export.
  2. Choose Summary — monthly aggregates only, Detailed — one row per separated employee, or Both sheets (XLSX).

The XLSX file downloads straight away. It follows the period, filters and any separation type chips on screen. If your company leaves out end-of-contract exits, the file says so at the top.

How the figures are worked out

FigureWhat it counts
HeadcountPeople on the books at the end of the last month shown. Anyone with no last day recorded counts, including invited and uninvited staff
JoinersHire dates that fall in the months shown. The card also shows the average per month
LeaversLast days that fall in the months shown, whatever the reason, with how many were voluntary
Turnover RateLeavers divided by average headcount for the period, as a percentage
AnnualisedThat rate × 12 ÷ the number of months shown

Average headcount is worked out month by month: the midpoint of each month's opening and closing headcount, then the average of those months. A growing company is therefore not flattered by its final headcount, or punished by its first.

KAMI support logins and profiles never approved are left out of every figure. If your access covers only part of the company, every figure covers only those people, so two managers can see different rates.

The period always starts on the first of a month, and the current month counts as a whole month. So Last 12 months is 11 full months plus this month so far, and its annualised rate equals its period rate. Early in a month, annualised figures run low, because that month has hardly started.

The Monthly breakdown table

ColumnMeans
Joined / LeftHire dates and last days in that month
NettJoined minus left. Negative means the team shrank
HeadcountPeople on the books at the end of the month
Average active profilesThe midpoint of the month's opening and closing headcount, the denominator for the rate
Turnover RateThat month's leavers divided by its average active profiles

The Total row adds up the period. Each leaver row shows Department, Position, Last Day, Tenure at exit, Separation Type and Reason. On All leavers you can sort by name, department, last day or tenure.

Why voluntary and involuntary may not add up

Each separation type is marked voluntary or involuntary. A leaver with no separation type falls in neither and shows as Not classified. With 10 leavers, 6 voluntary and 2 involuntary, the other 2 are unclassified. They still count in Leavers and in the rate. To fix it, set a separation type on those people.

Movement and turnover rate by month, and the Why people left breakdown

When end-of-contract exits are left out

Your company can leave end-of-contract exits out of the rate, which suits businesses where fixed-term contracts ending on time are normal. The card then says Excludes N end-of-contract separations. Those people still count in Leavers and every list and export. Only the rate changes. This behaviour can be changed:

Where: Settings › Company › Details, select Edit on the Reports card and tick Leave end-of-contract exits out of the turnover rate

You need: the Company Details right. It applies to the whole company, so everyone who opens the report sees the same figure.

What Happens Next

The report changes nothing. It gives you a question to ask:

  • One department climbing: usually a manager or workload issue, not a company-wide one.
  • Short tenures: the page warns when people leave within 6 months of joining, and marks those tenures. That points at hiring or onboarding.
  • Lots of Not classified: fix your leaver data before you draw conclusions about why people leave.

If your company has KAMI AI, Ask Kita explains the report using the filters on screen.

Tips

  • Quote Last 12 months to a board. Short periods swing widely in a small company, where one or two departures move the rate by several points.
  • Quote the period rate for what happened, and the annualised rate to compare periods of different lengths.
  • Compare departments rather than companies. External benchmarks vary too much by sector and country.
  • Export at the same point each quarter, so the series is consistent.
  • Run company-wide figures from an account that covers everyone. A manager's view only counts their own people.

Troubleshooting / FAQ

Q: Why does someone who left not appear? They need a last day recorded. Without one, KAMI treats them as still here and counts them in Headcount. See Deactivating, terminating and rehiring employees. They must also be within your access.

Q: A month says 5 separations, but none show when I open it. A separation type chip is on. The monthly figures always show every separation, so a chip cannot hide that people left. Select Clear.

Q: Leavers shows more people than All leavers. Check for last days later this month. Leavers counts the whole current month, while All leavers and the voluntary split stop at today.

Q: Why is the reason blank or Not recorded? Reason comes from the termination pay record. If no termination pay was processed, it stays empty. That says nothing about why the person left.

Q: Why is tenure blank? The hire date or last day is missing.

Q: My rate is different from my colleague's. Each of you sees the people your own access covers, so the headcount and leavers differ.

Related articles