Harpreetwalia
Consultant-labour Laws
Srikanth1989
Excutive-hr

Cite.Co is a repository of information and resources created by industry seniors and experts sharing their real world insights. Join Network
Dear Friends,
Few days ago I was exploring the citehr to find some automated gratuity calculator in excel which works at its own and only the basic details like date of joining and date of exit with salary need to be mentioned. Yes I did find many however there were some flaws in it ie: if the DOJ remain as blank then wrong calculations were happening, calculating the exact time considering the 6 month and above to the next level of year and so on.
So then I made a calculator which is attached for you all also. This will help you all to understand that what is the gratuity amount payable till date you/your company is liable for. Just feed the DOJ, salary and other editable columns of emp name, emp id (if any) and other basic personal details. it will calculate the amount for you. the one in yellow will tell how the total amount outstanding to all.
Please send your feedbacks if you find anything requires modification as per law.

Kindly unzip the attached file to extract the excel sheet. thanks

Attached Files
File Type: rar GRATUITY AMOUNT CALCULATIONS.rar (2.06 MB, 1608 views)

Dear harpreetwalia....
as per gratuity act the person who is have a 5 years continues service in a same organisation he is eligible for the gratuity
or the amendment of gratuity act is the person have 4 years and next year have 240 days service he is eligible for gratuity.

gratuity calculation= last basic*15*no of years service/26

sir the law remains the same of continous 5 yrs service however few state high courts have give judgement in favour of 4 years and 240 days.
do we have a form for payment of gratuity.( Challan or Voucher) format
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 @ 2020 Cite.Co™