Pan Singh Dangwal
Joint Manager
+1 Other

PRIME SPONSOR - FACTOHR - Payroll Software with GPS Enabled Attendance, Travel, Performance Management, HRMS. Explore Features
Whats is the calculation of Gratuity and Leave salary (15) if Gross Salary of Employee 38500?
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...
Dear Parul,
Gratuity is calculated after completion of service of 5 years. it is calculated on basic salary, for an example if an employee's basic salary is Rs-25000/-per month & his service period is 5 years then calculation will be done as below.
Basic salary 25000/26*15 *5= 72115/-
Regards,
Pankaj
Dear sir
But how to show gratuity in salary Breakup
I have enclosed attachment with this .I dont know what is the formula please help

Attached Files
Membership is required for download. Create An Account First
File Type: zip Book1.zip (7.7 KB, 186 views)

Hello dear i had gone trough with your salary sheet i have little bit confusion ,
How we can ensure gross salary amount
Dear Parul,
In the sheet gratuity amt correctly shown (it will be always 4.81% of current basic). However while calculating the leave I have inserted the formula. 15 days annual leave for 26 days monthly working.
Pleased find attached the corrected sheet, hope this will serve your purpose.
Fellow members can put more light on it.

Attached Files
Membership is required for download. Create An Account First
File Type: xls Gratuity-Leave calculation on CTC-Rev..xls (29.5 KB, 661 views)

PRIME SPONSOR - TALENTEDGE "Interactive Anywhere Learning". Executive courses from top reputed institutes like IIM, XLRI, MICA. View Courses
Add Reply Start A New Discussion






About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service



All rights reserved @ 2019 Cite.Co™