• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

ExcelDataPro

Free Excel Pro Templates

  • Glossary
    • Accounting Glossary
    • HR & Payroll Glossary
    • Tax Glossary
  • Templates
    • Accounting
      • Financial Analysis
      • Financial Statement
    • Educational
    • Taxation
      • Federal Income Tax
      • GST
      • UAE VAT
    • Human Resources
      • HR & Payroll
      • HR Metrics
    • School Management
    • Social Media
    • Personal Finance
    • Other
      • Health & Fitness
  • Calendars
    • Calendar 2019
    • Calendar 2020
  • Functions
  • FAQ’s
    • Amazon Inventory Upload
    • Federal Income Tax
    • GST
    • Microsoft Excel
    • UAE VAT
  • Blog
  • About
    • Contact
You are here: Home / Excel Templates / HR Metrics Templates / Download Monthly Employee Attrition Report Excel Template

Download Monthly Employee Attrition Report Excel Template

Download Monthly Employee Attrition Report Excel Template

HR professionals prepare the Attrition report monthly or yearly to monitor and rectify the causes of attritions in the organizations.

What is Attrition?

Attrition means the reduction in the number of employees of an organization through resignation, retirement or death.

In other words, attrition is defined as a voluntary and involuntary reduction of a company’s workforce due to retirements, transfers, resignations, terminations or deaths.

How To Calculate The Attrition Rate?

The attrition rate means calculating the proportion of employees leaving an organization over a specific period. It is also known as employee turnover rate.

A normal rate of attrition is expected in normal business operations. But a high rate of attrition leads to many problems and a lack of workforce.

HR professionals design and implement company compensation programs and motivation systems to keep the employees happy and attrition rates low.

Keeping the attrition rates as low as possible helps to save money. You can save money spent on advertising for hiring, training and completing paperwork for new employees.

Monthly Employee Attrition Report Excel Template

We have created an Excel template of the Attrition Report with predefined formulas.

Attrition Report

Just enter the number of employees leaving and joining the organization in the respective cells and it will automatically calculate the attrition rate for you.

With this template, you can easily monitor the monthly attrition rate of your organization and take relevant measures to decrease them.

Click here to Download Monthly Employee Attrition Report Excel Template.

Click here to Download All HR Metrics Excel Templates for Rs 199.

Mac users can now download the same attrition report in Apple Numbers from the link below:

Yearly Attrition Report Apple Numbers Template

Additionally, you can download HR Metrics Templates like New Hire Turnover Rate Calculator, Retention Rate Calculator, and Turnover Cost Calculator from here.

Let us discuss the contents of the template in detail.

Contents of the Employee Attrition Report Template

This template consists just of 2 sections

  1. Header Section.
  2. Data Input Section.

1. Header Section

Header section consists of the company name, company logo and heading of the sheet “Monthly Attrition Report – 2017”.

Attrition Report

2. Data Input Section

Data Input Section consists of the following subheadings:

Sr. No.: Enter Serial Number. Just enter number “1” in light blue colored cell and it will automatically display the following numbers as per the formula =1+B4 and so on.

Month: Name of Month from January till December.

Opening Balance: Opening balance of the employee count at the start of January. You just need to enter the opening balance of the first month. Later months automatically display balance according to the formula.

Opening Balance of current month = Closing Balance of previous Month

Attrition Report

Employee Joined: Here you need to enter the number of employees joined in the respective month.

Employees Left: Here you need to enter the number of employees left in the respective month.

Closing Balance: The template displays the current headcount of the employees at the end of each month.

Closing Balance = Opening Balance + Employees Joined – Employees Left.

The formula applied here is =IF(E4=””,””,D4+E4-F4).

Attrition %: Attrition rate shows the proportion of employees left during the respective month.

Attrition Rate = No. of employees left / Closing Balance of Employee Count

The formula applied here is =IF(G4=””,””,F4/G4).

To calculate the yearly attrition rate following formula will be applied:

Total Employees left during the year / Total number of employees working X 100.

We thank our readers for liking, sharing and following us on different social media platforms.

If you have any queries please share in the comment section below. I will be more than happy to assist you.

« Download Cost Per Hire Calculator Excel Template
Download Revenue Per Employee Calculator Excel Template »

Filed Under: HR Metrics Templates

About Fahim Lashkaria

I love working in Excel and I share functional excel templates at ExcelDataPro. Read more about me here or interact with me on twitter.

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

HR Metrics Templates

  • Cost Per Hire Calculator Excel Template
  • Monthly Employee Attrition Report Excel Template
  • Revenue Per Employee Calculator Excel Template
  • Profit Per Employee Calculator Excel Template
  • Time To Hire Calculator Excel Template
  • Time To Fill Calculator Excel Template
  • Employee Absent Rate Calculator Excel Template
  • Yield Rate Calculator Excel Template
  • Human Capital ROI Calculator Excel Template
  • Training Cost Per Employee Calculator Excel Template
  • Employee Productivity Calculator Excel Template
  • Employee Retention Rate Calculator Excel Template
  • Employee Turnover Cost Calculator Excel Template
  • Job Vacancy Rate Calculator Excel Template
  • Post Occupancy Rate Calculator Excel Template
  • Vacancy Costs Calculator Excel Template
  • Offer Acceptance Rate Calculator Excel Template
  • Offer Decline Rate Calculator Excel Template
  • Promotion Rate Calculator Excel Template
  • Total Compensation Spend Rate Calculator Excel Template
  • New Hire Turnover Rate Calculator Excel Template
  • Employee Base Salary Increase Rate Calculator Excel Template
  • Benefits Spend Rate Calculator Excel Template
  • Annual Benefit Spend Change Report Excel Template
  • EBIT Per FTE Calculator Excel Template
  • Training Spend Rate Calculator Excel Template
  • Average Training Hours Calculator Excel Template
  • Home
  • Contact
  • Privacy
  • Terms

© ExcelDataPro 2019. Content Licensed Under Creative Commons with Attribution Required

This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Cookie settingsACCEPT
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.
Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.

Necessary Always Enabled

Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.

Non-necessary

Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.