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 Format Letter
I have Attached Gratuity Format Letter
FORM ‘I’
[See sub-rule (1) of rule 7]
Application of gratuity by an employee
To ………………………………………………………………………………………………………….
[Give here name or description of the establishment with full address]
Sir/Gentlemen,
I beg to apply for payment of gratuity to which I am entitled under sub-section (1) of section 4 of the Payment of Gratuity Act, 1972 on account of my superannuation/retirement/resignation after completion of not less than five years of continuous service/ total disablement due to accident/ total disablement due to disease with effect from the …………… Necessary particulars relating to my appointment in the establishment are given in the statement below:
Statement
1. Name in full.
2. Address in full
3. Department/Branch/Section where last employed.
4. Post held with Ticket No. or Serial No., if any.
5. Date of appointment.
6. Date cause of termination of service.
7. Total period of service.
8. Amount of wages last claimed.
9. Amount of gratuity claimed.
I was rendered totally disabled as a result of
[Here give Detail of the nature of disease or accident]
Payment may please be made in cash/open or crossed bank Cheque.
As the amount of gratuity payable is less than Rupees one thousand, I shall request you to arrange for payment of the sum to me by Postal Money Order at the address mentioned above after deducting postal money order commission therefrom.
Yours faithfully,
Place Signature/Thumb impression of
Date the applicant employee.
Note:
1. Strike out words not applicable.
2. Strike out paragraph or paragraph not applicable.
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
Payment of Gratuity
Dear Raghavendra K,
Attached herewith Format of Form-F under Payment of Gratuity Act 1972.
How to fill Form 19 and Form 10C
Please find Guidelines for filling up of Provident Fund, Superannuation & Gratuity related Forms.
Categories: Uncategorized Tags: Form 10C, Form 19, Gratuity, Provident Fund, Superannuation