Gratuity Calculation Template - Xls Download

Just impute values and you get an automatic calculation
13th December 2010 From Nigeria, Lagos

Attached Files (Download Requires Membership)

gratuity_computation.xls (97.5 KB, 12020 views)

Dear Tobi Samuels, The excel sheet is static, i.e whatever input we feed no change in output. No calculation is possible with this excel sheet. Abbas.P.S
14th December 2010 From India, Bangalore

Hi Samuel,
As per Grauity we take no of years of service in round if 5.4 yrs we take as 5 years or if 5.7yrs we take his/her service as 6 yrs therefore this excel sheet will not help for calculate the Gratuity amount. It gives wrong calculation / more amount.
Regards,
Vidyaranya.
15th December 2010 From India, Bangalore

Check out this gratuity calculator i arranged!
15th December 2010 From Nigeria, Lagos

Attached Files (Download Requires Membership)

AUTOMATED GRATUITY CALCULATOR.xls (90.5 KB, 4673 views)

What if company rejects to pay gratuity to the employee who has left the company. He has been deducting is gratuity amount from his salary when he was working with company.
What he has to do to get his gratuity and what is the procedure?
Please give inputs...
Thanks,
Vaibhav P.
15th December 2010 From India, Mumbai

I have some doubt that, which basic we will consider present one or average of all the years. Kindly give the reply Regards, Ravi
15th December 2010 From India, Visakhapatnam

Dear Sir, Please tell me the returns which is to be submitted in government officials department monthly wise means H.R role in towards government officials department thanks and regards Kashinaths
15th December 2010 From India, Hyderabad

Dear sir, Please guide me the monthly returns which is to be submitted in government officials department which is H.R related work Please guide me thanks and regards Kashinaths
15th December 2010 From India, Hyderabad

Dear Manoj, Gratuity calculation will on Basic + DA as per Act, but few companies use to pay on Gross salary.
17th December 2010 From India, Bangalore

i am working with a private bank since February 2007.now i got another offer from a different bank and they agree the notice period of 3months.so i will be joining there on january2012.ie, i will complete 4years and 11 months..my question is ,Am i eligible for gratuity,and if my previous company is not ready to pay me the gratuity,what can i do for the same?..please help me in this regards
30th August 2011 From India, Kochi