What is 15/26 in gratuity calculation
- how to calculate gratuity in excel
- how to calculate gratuity in excel sheet
- how to calculate tip in excel
- how to calculate gratuity years in excel
Gratuity calculator for private employees...
Monthly gratuity calculation in excel
Download Gratuity Calculator Template In Excel
Gratuity Calculator Template in Excel easily calculate your gratuity amount as per the Gratuity Act 1972 in India.
Gratuity Calculator with predefine formulas helps you calculate the end of service amount also known as Gratuity.
All you need to do is to enter your last drawn salary and the total years of service and it will automatically calculate your gratuity amount.
What is Gratuity?
Gratuity is end of service benefits provided by an employer to the employee for the service rendered to the organization.
An employee is entitled to gratuity when he/she:
- Resigns
- Retires
- Laid off
- Death or Disablement
Eligibility Criteria For Gratuity
According to the Gratuity Act, an employee is paid gratuity if he/she completes a minimum service of 5 years in that particular company.
Furthermore, in case of death or disablement, there is no minimum eligibility period.
Disablement means loss of the earning capacity of an employee. It is of two types; temporary disablement & permanent disablement.