Gratuity Calculation in Excel
I have Attached Gratuity Calculation Tool
Gratuity Calculation | ||||
Name of the Employee | : | ASD | ||
Father’s/Husband’s Name | : | ZXC | ||
Date of Birth | : | 7/1/1965 | ||
Date of Joining | : | 5/1/2005 | ||
Date of Separation | : | 10/30/2011 | ||
Last Drawn Basic Salary | : | 5000.00 | ||
Last Drawn D.A | : | 0.00 | ||
No.of years served | : | 6 | (Roundup nearest 1 Year) | |
Gratuity Amount | : | 17308.00 |
Categories: HR Tags: Calculation, Gratuity, tool
Gratuity Calculation tool
I have Attached Gratuity Calculation tool
Gratuity Calculation | |||
Name of the Employee | : | ABC | |
Father’s/Husband’s Name | : | XYZ | |
Date of Birth | : | 7/1/1965 | |
Date of Joining | : | 5/1/2005 | |
Date of Separation | : | 10/30/2009 | |
Last Drawn Basic Salary | : | 5000.00 | |
Last Drawn D.A | : | 2000.00 | |
No.of years served | : | 5 | |
Gratuity Amount | : | 18178.61 |
Categories: HR Tags: Calculation, Gratuity, tool