This excel is for understanding the Gratuity Calculation, which is a tentative Calculation to find the amount for Gratuity when person left from the organisation. or we say at the time of full and final settlement.
Formula :- Last Drawn Salary/26*15*No of Yrs Service.
Rules :-
1) Which consist of Minimum 5 Yrs Service as per Gratuity Act 1972. and if person complete more than 6 month , then its consists 1 Year.
2 )But the person who is minimum 4 yrs & 8 month service is consider as "0" zero years of gratuity service.
3) And if his is work for 4 Yrs & 8 Month and more but less than 5 yrs, then also he is consider as 5 yrs of services for gratuity is applicable.

From India, Pune

Attached Files (Download Requires Membership)
File Type: xlsx SACHIN GRATUITY FORMULA SHEET.xlsx (12.6 KB, 175 views)

Get Empowered With Critical Leadership Skills That Drive Change →
Promoted: XLRI Leadership & Change Management
Hello! What type of music do you like to listen? What about me, I like rock music, but my friend like to listen heavy metal music and I am going to write an article about the impact of metal music on the human psyche by using this great online writing service. So, fellas, if you are interested, simply click on this website and buy your papers.
From United Kingdom, Rugby
Revised formula for error 5.6 yrs convert in 6 yrs.
From India, Pune

Attached Files (Download Requires Membership)
File Type: xlsx SACHIN GRATUITY FORMULA SHEET (1).xlsx (12.6 KB, 76 views)

If you are knowledgeable about any fact, resource or experience related to this topic - please add your views using the reply box below. For articles and copyrighted material please only cite the original source link. Each contribution will make this page a resource useful for everyone.

Please Login To Add Reply →

About Us Advertise Contact Us Testimonials
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2021 CiteHR.Comô

All Material Copyright And Trademarks Posted Held By Respective Owners.
Panel Selection For Threads Are Automated - Members Notified Via CiteMailer Server