Re: Gratuity Formula In Excel Format - ZIP Download - CiteHR
Prime Sponsor - - Payroll Software with GPS Enabled Attendance, Travel, Performance Management, HRMS. Explore Features
Hellow I wanted gratuity format in excel. Regards Thanks
Cite.Co is a repository of information created by your industry peers and experienced seniors sharing their experience and insights.
Join Us and help by adding your inputs. Contributions From Other Members Follow Below...
Hi Friend,
you can write formula with your own.
Gratuity Rule is = Last Basic/26Days X 15 Days X Number of working years.
for example
if some one worked 6 years and his last Basic is 5000 (at the time of his exit.)
you simple calculate like this = 5000/26 you will get per day amount
after that = per day amount X 15 days then you will get per year amount
after that = per year amount X 6 years ( Number of Years worked )
then you will know the gratuity liability
I think you may clear now.
As you know these days lot of companies work only 22 days in a month. in this case employee will get more Gratuity. Is the 26 is common for all or will it differ as per company?
Hello Pawarmohan here the Excel format of the Gratuity Calculator Regards

Attached Files
Membership is required for download. Create An Account First
File Type: zip Excel_Gratuity (8.2 KB, 14929 views)

Normally we are giving to our staffs gratuity 21 days per year
Total Salary : 10000 * 12 =120000
Total Working Days : 455
Total year : 1.25
Daily Wages : 328.80
Gratuity : 21*328.80*1.25 = 8631
Hello there, Attached the Gratuity Working sheet, hope it will be helpful for calculating gratuity for number of employees. Cheers, Nithil

Attached Files
Membership is required for download. Create An Account First
File Type: xls Gratuity Calculation Sheet.xls (20.5 KB, 19195 views)

hello i have start job for 28/08/2004 and resign 05/01/2014 my monthly salary is 25000 so how many gratuity received me so plz send gratuity calculation. thanking you
Hi, If a employee worked for 5y 8months then how to calculate gratuity of the employee please reply me as early as possible
Hi Venkat, If Employee worked for 5y 8m then u have to consider 6 years as a no. of completed yrs of services. Formula for Calculation =Last Basic/26 X 15 X 6.
Please clear, how to calculate number of years working for gratuity. Example: If anyone has worked 5.5 years, How many years to be considered and paid? What is exact concept.. Please clear. Regards,
Prime Sponsor - "Interactive Anywhere Learning". Executive courses from top reputed institutes like IIM, XLRI, MICA. View Courses

This discussion thread is closed. If you want to continue this discussion or have a follow up question, please post it on the network.
Add the url of this thread if you want to cite this discussion.

About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2019 Cite.Co™