Senior Manager/freelance Consultant

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.
11th June 2015 From India, New Delhi
Kindly unzip the attached file to extract the excel sheet. thanks
11th June 2015 From India, New Delhi

Attached Files
Membership is required for download. Create An Account First
File Type: rar GRATUITY AMOUNT CALCULATIONS.rar (2.06 MB, 1497 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
11th June 2015 From India, Secunderabad
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.
11th June 2015 From India, New Delhi
do we have a form for payment of gratuity.( Challan or Voucher) format
23rd August 2018 From India, Bhilai
Add Reply Start A New Discussion

Cite.Co - is a repository of information created by your industry peers and experienced seniors. Register Here and help by adding your inputs to this topic/query page.
Prime Sponsor: TALENTEDGE - Certification Courses for career growth from top institutes like IIM / XLRI direct to device (online digital learning)

About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2019 Cite.Co™