betterjobs

Free template template · Word

Employee Relations Tracker

An employee relations tracker is a monthly summary sheet that turns individual cases into trends for leadership. It counts cases by type and location, tracks average resolution time and outcomes, flags repeat issues and lists the preventive actions HR is running, without naming individuals.

  • Editable Word (.docx)
  • Made for India
  • 14 fill-in fields highlighted
  • Free, no sign-up

Preview of the template

[Highlighted] = fill in
[Company Logo][Company Name]

EMPLOYEE RELATIONS TRACKER

Company:
[Company Name]
Period:
[Month / Quarter, Year]
Prepared by:
[HR Name]
Classification:
Internal – anonymised

1. Cases by Category

CategoryOpenedClosedOpen at Month EndAvg. Days to Resolve
Grievances (pay, leave, conditions)[Number][Number][Number][Number]
Conduct and behaviour complaints[Number][Number][Number][Number]
Bullying / discrimination / retaliation[Number][Number][Number][Number]
Ethics / whistleblower (count only)[Number][Number][Number][Number]
POSH referrals to IC (count only)[Number][Number][Number][Number]

2. Cases by Location / Department

Site / DepartmentHeadcountCases OpenedCases per 100 EmployeesTop Theme
[Work Location][Number][Number][Number][Theme]
[Work Location][Number][Number][Number][Theme]
[Department][Number][Number][Number][Theme]

3. Outcomes

UpheldPartly UpheldNot UpheldWithdrawnAppeals
[Number][Number][Number][Number][Number]

4. Preventive Actions

ThemeActionOwnerStatus
[Theme][e.g., manager training on respectful communication][Owner][Status]
[Theme][e.g., payroll cut-off reminder][Owner][Status]

5. Commentary

[Two or three lines on key trends, risks and support needed from leadership. Do not include names or identifying details.]

Prepared by
[HR Name]
Date: [Date]
Reviewed by
[HR Head]
Date: [Date]

What this template includes

  • Monthly case counts by category
  • Breakdown by site or department
  • Average days to resolve
  • Outcome split: upheld, partly upheld, not upheld, withdrawn
  • Repeat themes and hotspots
  • Preventive actions and their status

When to use it

  • Preparing a monthly or quarterly ER report for the leadership team
  • Comparing grievance levels across plants, branches or departments
  • Checking whether preventive actions are reducing cases
  • Reporting to the board or an investor on people risk

How to customise this template

  1. 1Pull numbers from your ER case tracker or complaint register
  2. 2Add or remove sites and categories
  3. 3Use charts in Excel to show trends
  4. 4Add an engagement survey score column if you run surveys
  5. 5Keep it anonymised for wider circulation

HR tips

  • A rise in cases may mean better trust in reporting, not worse conditions; read alongside context
  • Report POSH data only as numbers, as per your IC's annual reporting
  • Track time to resolve as closely as volume
  • Agree a few metrics and report them consistently

For HR & hiring managers

Hire top talent from BetterJobs

Experienced and fresher candidates across India — blue, grey and white collar. Post a job in 5 minutes and start receiving applications.

  • Post in 5 minutesDescribe the role in one line — we write the job description.
  • Verified applicantsEvery applicant has a verified mobile number.
  • Resume databaseSearch experienced candidates by skill, city and experience.

Frequently asked questions

What is an employee relations tracker?+

A summary sheet of ER metrics such as cases by type, resolution time and outcomes, used to spot trends and report to leadership.

How is it different from an ER case tracker?+

The case tracker manages individual open cases; this tracker summarises numbers and trends over time.

Which ER metrics should be tracked?+

Common ones are case volume by type and site, average days to resolve, outcomes, repeat issues and appeal rates.