Whats is the calculation of Gratuity and Leave salary (15) if Gross Salary of Employee 38500?
From India, Vadodara
Pan Singh Dangwal
Joint Manager
+1 Other


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/-

From India, Haridwar
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
From India, Vadodara

Attached Files (Download Requires Membership)
File Type: zip (7.7 KB, 324 views)

Hello dear i had gone trough with your salary sheet i have little bit confusion , How we can ensure gross salary amount
From India, Delhi
Pan Singh Dangwal

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.

From India, Delhi

Attached Files (Download Requires Membership)
File Type: xls Gratuity-Leave calculation on CTC-Rev..xls (29.5 KB, 1273 views)

If You Are Knowledgeable About Any Fact, Resource or Experience Related to This Topic and Want to Be Part of Such Discussions in Future - Please Register and Log In to Cite Community.

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

All rights reserved @ 2023 CiteHRŽ

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