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