No Tags Found!

SH

Shai89308

Executive Hr

AS

Ammu Shanvi

Human Resource

GS

G SHASHI KRISHNA

Senior Manager - Hr

AH

Aizant HR

Human Resources

MA

MARSHAL

Safety Officer

AK

Anish Katoch

Hr Executive

PR

PranjalR

Hr Recruiter

AP

Alka Pal

Hr Executive

Karthikeyan8195

Management Consultant

MK

Mohit Kumar Puri

Head Marketing

AU

Austex

Accounts Manager


pawarmohan
10

Hellow I wanted gratuity format in excel. Regards Thanks
From India, Mumbai
TELIKEPALLI
84

Hi Friend,
you can write formula with your own.
Gratuity Rule is = Last Basic/26Days X 15 Days X Number of working years.
for example
if some one worked 6 years and his last Basic is 5000 (at the time of his exit.)
you simple calculate like this = 5000/26 you will get per day amount
after that = per day amount X 15 days then you will get per year amount
after that = per year amount X 6 years ( Number of Years worked )
then you will know the gratuity liability
I think you may clear now.

From India, Hyderabad
grajenda
4

As you know these days lot of companies work only 22 days in a month. in this case employee will get more Gratuity. Is the 26 is common for all or will it differ as per company?
From United Kingdom, Otley
meharwade
6

Hello Pawarmohan here the Excel format of the Gratuity Calculator Regards
From India, Bangalore
Attached Files (Download Requires Membership)
File Type: zip Excel_Gratuity Calculator.zip (8.2 KB, 15997 views)

mashhood123
3

Normally we are giving to our staffs gratuity 21 days per year
example
Total Salary : 10000 * 12 =120000
Total Working Days : 455
Total year : 1.25
Daily Wages : 328.80
Gratuity : 21*328.80*1.25 = 8631

From United Arab Emirates, Dubai
nithil69kewl
8

Hello there, Attached the Gratuity Working sheet, hope it will be helpful for calculating gratuity for number of employees. Cheers, Nithil
From India, Coimbatore
Attached Files (Download Requires Membership)
File Type: xls Gratuity Calculation Sheet.xls (20.5 KB, 20818 views)

abhishek_mehta123
1

hello i have start job for 28/08/2004 and resign 05/01/2014 my monthly salary is 25000 so how many gratuity received me so plz send gratuity calculation. thanking you
From India, Surat
venkat naidu
1

Hi, If a employee worked for 5y 8months then how to calculate gratuity of the employee please reply me as early as possible
From India, Tiruchi
f49b4a5bd7dda0029a78415c
2

Hi Venkat, If Employee worked for 5y 8m then u have to consider 6 years as a no. of completed yrs of services. Formula for Calculation =Last Basic/26 X 15 X 6.
From India , Mumbai
frzahd. Firoz Ahmad
3

Please clear, how to calculate number of years working for gratuity. Example: If anyone has worked 5.5 years, How many years to be considered and paid? What is exact concept.. Please clear. Regards,
From India, New Delhi
Find answers from people who have previously dealt with business and work issues similar to yours - Please Register and Log In to CiteHR and post your query.





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

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.