No Tags Found!


Hellow I wanted gratuity format in excel. Regards Thanks
From India, Mumbai
Acknowledge(0)
Amend(0)

Hi Friend,

You can write the formula on your own. The Gratuity Rule is calculated as follows: Last Basic/26 Days X 15 Days X Number of working years.

For example, if someone worked for 6 years and their last Basic was 5000 (at the time of their exit), you can calculate as follows: 5000/26 to get the per day amount. Then, multiply the per day amount by 15 days to get the per year amount. After that, multiply the per year amount by 6 years (Number of Years worked) to determine the gratuity liability.

I hope this clears things up for you.

From India, Hyderabad
Acknowledge(12)
TH
HV
SK
ME

+7 more

Amend(0)

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
Acknowledge(4)
VN
VE
Amend(0)

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, 16238 views)

Acknowledge(5)
HV
LC
Amend(0)

Normally, we provide our staff with gratuity of 21 days per year. For example:
Total Salary: 10000 * 12 = 120000
Total Working Days: 455
Total Years: 1.25
Daily Wages: 328.80
Gratuity Calculation: 21 * 328.80 * 1.25 = 8631

From United Arab Emirates, Dubai
Acknowledge(3)
YK
AR
Amend(0)

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, 21104 views)

Acknowledge(7)

+2 more

Amend(0)

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
Acknowledge(1)
Amend(0)

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
Acknowledge(1)
Amend(0)
  • CA
    CiteHR.AI
    (Fact Checked)-The calculation of gratuity for an employee who has worked for 5 years and 8 months involves considering the total service period as 6 years for gratuity payment. (1 Acknowledge point)
    0 0

  • 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
    Acknowledge(1)
    SG
    Amend(0)

    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
    Acknowledge(2)
    AH
    Amend(0)
  • CA
    CiteHR.AI
    (Fact Checked)-The calculation of the number of years for gratuity should be rounded off to the nearest whole number. For someone who has worked 5.5 years, it would be considered as 6 years for gratuity payment. (1 Acknowledge point)
    0 0

  • Looking for something specific? - Join & Be Part Of Our Community and get connected with the right people who can help. Our AI-powered platform provides real-time fact-checking, peer-reviewed insights, and a vast historical knowledge base to support your search.







    Contact Us Privacy Policy Disclaimer Terms Of Service

    All rights reserved @ 2025 CiteHR ®

    All Copyright And Trademarks in Posts Held By Respective Owners.