Template · Contact centre operations
Agent attrition tracker
In short
An attrition tracker template is a log with one row per employee who leaves, capturing tenure, team, exit type, reason and whether the loss was regrettable, plus a monthly summary that calculates attrition rate by site, team and tenure band. Use it to see where and when agents leave, not just how many.
Attrition Tracker template
Attrition Tracker
Part A is completed for every separation within 3 business days of the last day worked. Part B is calculated on the first business day of each month. Keep one tracker per site or program and roll them up for the operation.
Part A: Separation record (one per leaver)
- Employee name
- Employee ID
- Site
- Program / client / queue
- Team lead
- Job title and level
- Hiring class or cohort ID
- Recruiting source
- Hire date
- Last day worked
- Separation date
- Tenure band at exit
- In classroom trainingIn nesting0-90 days in production91-180 days181-365 days1-2 yearsOver 2 years
- Separation type
- Voluntary resignationJob abandonment / no-call no-showInvoluntary: performanceInvoluntary: attendanceInvoluntary: conductLayoff / end of programTransfer to another program (internal, not counted)Promotion out of role (internal, not counted)Other
- Primary reason
- PaySchedule or shiftCommute or locationSupervisor relationshipJob content or stressBetter opportunity elsewhereReturn to schoolFamily or personalHealthRelocationUnknown
- Secondary reason
- Regrettable loss
- YesNo
- Last QA score / performance rating
- Notice given (days)
- Exit interview completed
- YesDeclinedNot reachable
- Eligible for rehire
- YesNoReview required
- Notes
Part B: Monthly attrition report
- Month
- Headcount at start of month
- Headcount at end of month
- Average headcount = (start + end) / 2
- Total separations (excluding internal moves)
- Voluntary separations
- Involuntary separations
- Regrettable separations
- Monthly attrition % = total separations / average headcount x 100
- Voluntary attrition %
- Annualized attrition % = monthly % x 12, or sum of last 12 months
- Separations by tenure band (training, nesting, 0-90, 91-180, 181-365, 1 year+)
- Separations by team lead
- Top three exit reasons this month
- Training-class attrition: starts vs graduates for classes that graduated this month
- Actions agreed and owners
Review sign-off
- Prepared by (HR / WFM)
- Reviewed by site director
- Date reviewed
How to use this template
- Set up the tracker as a spreadsheet tab or report with the Part A fields as columns, and lock the drop-down values so reasons stay comparable.
- Log every separation within three business days, using the exit interview and the team lead's notes for the reason.
- Exclude internal transfers and promotions from attrition counts but keep them in the log so you can see internal movement.
- On the first business day of each month, calculate Part B for each site and for the whole operation.
- Break the numbers down by tenure band, team lead and hiring source; that is where the actionable patterns are.
- Review the report with operations and recruiting each month and record the actions and owners.
How to calculate attrition rate
The standard monthly formula is separations during the month divided by average headcount, times 100. Average headcount is the start-of-month count plus the end-of-month count, divided by two.
A 250-seat center with 236 agents on the first of the month and 244 on the last has an average of 240. If 18 agents left, monthly attrition rate is 18 / 240 = 7.5%. Annualized, that is about 90%, which is high but not unusual for entry-level contact center work. Many centers sit somewhere between 30% and 60% a year; outsourced and seasonal programs often run higher.
For a more accurate annual number, add up the last 12 monthly rates rather than multiplying one month by 12. A single bad month around a program change can distort the picture.
Decide up front whether agents still in classroom training count in headcount. Many centers report training losses separately as class attrition and only count agents from nesting onward in operational attrition. Either is fine; mixing the two methods across sites is not.
Fields that make the tracker useful
A list of names and dates tells you how many people left. These fields tell you why and what to fix:
- Tenure band. In most contact centers, a large share of leavers go in the first 90 days. If your attrition is concentrated there, the fix is in hiring, training and nesting, not in pay for tenured agents. The glossary entry on new hire turnover covers how to measure that slice.
- Team lead. Agents leave supervisors. Two teams with 3% and 12% monthly attrition on the same queue is a management problem you can act on this month.
- Hiring class and source. A cohort or job board that consistently loses people in training is telling you something about screening or the job preview.
- Regrettable flag. Losing a struggling agent is different from losing a top performer. Track regrettable attrition separately so a falling total does not hide the loss of your best people.
- Reason codes. Keep the list short and fixed. Free text is fine as a secondary note, but you cannot chart it.
Getting honest exit reasons
Team leads tend to code exits as "better opportunity" or "personal" because those reasons do not reflect on them. Have HR or a neutral party complete the reason after an exit interview form or short survey, and compare it with what the team lead entered. Where they disagree, the exit interview usually wins. For job abandonment cases where nobody is reachable, record the reason as unknown rather than guessing.
Turning the data into action
Look at attrition alongside performance data from the call center agent scorecard. If leavers in their second and third months had QA scores and handle times similar to people who stayed, the issue is not capability. Look at schedule, pay and supervisor instead.
Set up a standing monthly report so nobody has to rebuild it. A reporting dashboard that pulls separations from the HRIS and splits them by site, team and tenure band saves hours and removes arguments about whose numbers are right. The glossary entry on call center attrition covers the common causes and fixes in more depth.
Common mistakes
- Counting internal promotions and transfers as attrition, which punishes sites that develop people.
- Using end-of-month headcount instead of the average, which overstates the rate in a shrinking month and understates it in a growing one.
- Reporting one operation-wide number that hides a single site or team driving most of the losses.
- Changing reason codes every quarter so nothing is comparable over time.
- Logging leavers weeks late, so the monthly report is always missing the latest exits.
Frequently asked questions
What should an attrition report template include?
Headcount at the start and end of the period, average headcount, total, voluntary, involuntary and regrettable separations, attrition rates, and breakdowns by tenure band, team, site and exit reason, plus the actions agreed.
How do I make an employee turnover spreadsheet?
Create one row per leaver with hire date, separation date, tenure band, team, site, separation type, reason and a regrettable flag. Add a second tab that counts separations by month and divides by average headcount to get the monthly rate.
What is the formula for monthly attrition?
Monthly attrition = separations in the month / average headcount x 100, where average headcount = (headcount at start + headcount at end) / 2. For example, 18 separations on an average of 240 is 7.5%.
Should training attrition count in the attrition tracker?
Track it, but report it separately. Losses during classroom training usually reflect hiring and job-preview issues, while losses after nesting reflect day-to-day operations. Combining them makes both harder to fix.
What is a good attrition rate for a call center?
There is no single benchmark. Many in-house centers run 30 to 45% a year, and outsourced and entry-level programs often exceed 50%. Compare yourself against your own trend and between your sites and teams first.
Can I use a turnover tracker in Excel?
Yes. A spreadsheet with locked drop-downs for the reason and tenure fields and a pivot table for the monthly report works well up to a few hundred leavers a year. Larger operations usually move it into their HRIS or reporting tool.