I want gratuity calculation in excel for multiple employees. this is for making year end or monthly gratuity provision
From India , Mumbai
Acknowledge(0)
Amend(0)
2From India , Mumbai
Acknowledge(0)Amend(0)
To calculate gratuity in Excel for multiple employees in Mumbai, India, follow these steps:
Step-by-Step Guide
1. Understand the Gratuity Calculation Formula: In India, the gratuity amount is calculated using the formula: Last drawn salary (basic salary + dearness allowance) * number of completed years of service * 15 / 26.
2. Prepare Your Excel Sheet:
- Create columns for employee name, basic salary, dearness allowance, years of service, and gratuity amount.
- Enter the relevant data for each employee in the respective columns.
3. Calculate Gratuity Amount for Each Employee:
- In the gratuity amount column, use the formula to calculate the gratuity amount for each employee based on the provided data.
- For example, if an employee's last drawn salary is ₹50,000, years of service is 5 years, the gratuity amount would be calculated as: ₹50,000 * 5 * 15 / 26.
4. Sum Up Total Gratuity Provision:
- Create a cell to sum up the total gratuity provision for all employees by adding up the gratuity amounts calculated for each employee.
5. Review and Verify:
- Double-check all calculations to ensure accuracy and make any necessary adjustments.
6. Save and Maintain Records:
- Save the Excel sheet for future reference and to track gratuity provisions over time.
7. Compliance Check:
- Ensure that the gratuity calculations comply with the Payment of Gratuity Act, 1972, which governs gratuity payments in India.
By following these steps, you can efficiently calculate gratuity in Excel for multiple employees in Mumbai, India.
From India, Gurugram
Acknowledge(0)Amend(0)
Step-by-Step Guide
1. Understand the Gratuity Calculation Formula: In India, the gratuity amount is calculated using the formula: Last drawn salary (basic salary + dearness allowance) * number of completed years of service * 15 / 26.
2. Prepare Your Excel Sheet:
- Create columns for employee name, basic salary, dearness allowance, years of service, and gratuity amount.
- Enter the relevant data for each employee in the respective columns.
3. Calculate Gratuity Amount for Each Employee:
- In the gratuity amount column, use the formula to calculate the gratuity amount for each employee based on the provided data.
- For example, if an employee's last drawn salary is ₹50,000, years of service is 5 years, the gratuity amount would be calculated as: ₹50,000 * 5 * 15 / 26.
4. Sum Up Total Gratuity Provision:
- Create a cell to sum up the total gratuity provision for all employees by adding up the gratuity amounts calculated for each employee.
5. Review and Verify:
- Double-check all calculations to ensure accuracy and make any necessary adjustments.
6. Save and Maintain Records:
- Save the Excel sheet for future reference and to track gratuity provisions over time.
7. Compliance Check:
- Ensure that the gratuity calculations comply with the Payment of Gratuity Act, 1972, which governs gratuity payments in India.
By following these steps, you can efficiently calculate gratuity in Excel for multiple employees in Mumbai, India.
From India, Gurugram
Acknowledge(0)Amend(0)Join 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.
Gratuity calculation.doc
PF Calculation & Challan Excel.xls
Gratuity notification amendment in definition of employees.pdf