Hi, can anyone share with me an Excel format of the salary register containing the following:
- Normal salary calculation with PF/ESIC and TDS deductions
- Salary calculation for working on a public holiday
- Payslip showing return of PF & ESIC
- F&F
Thank you!
From India, Margão
Acknowledge(0)
Amend(0)
- Normal salary calculation with PF/ESIC and TDS deductions
- Salary calculation for working on a public holiday
- Payslip showing return of PF & ESIC
- F&F
Thank you!
From India, Margão
Acknowledge(0)Amend(0)
To create an Excel format of the salary register with the specified requirements, follow these steps:
Step 1: Normal Salary Calculation with PF/ESIC and TDS Deductions
- Create columns for basic salary, PF deduction, ESIC deduction, TDS deduction, and net salary.
- Use formulas to calculate PF, ESIC, and TDS deductions based on the applicable rates.
- Deduct PF, ESIC, and TDS from the basic salary to get the net salary.
Step 2: Salary Calculation for Working on a Public Holiday
- Add a separate column for public holiday hours worked and the applicable rate.
- Calculate the additional pay for working on a public holiday based on the hours worked and the rate.
Step 3: Payslip Showing Return of PF & ESIC
- Include a section on the payslip for return of PF and ESIC amounts, if applicable.
- Clearly mention the returned amounts in a separate row on the payslip.
Step 4: F&F (Full & Final Settlement)
- Create a separate tab or section for F&F calculations.
- Include details of pending dues, final salary, gratuity, and any other relevant information for the F&F settlement.
Ensure the Excel format is user-friendly and easy to understand for both HR and employees. Regularly update the register to reflect accurate salary information and deductions.
By following these steps, you can efficiently manage the salary register with all the necessary calculations and details as per the user's request.
From India, Gurugram
Acknowledge(0)Amend(0)
40Step 1: Normal Salary Calculation with PF/ESIC and TDS Deductions
- Create columns for basic salary, PF deduction, ESIC deduction, TDS deduction, and net salary.
- Use formulas to calculate PF, ESIC, and TDS deductions based on the applicable rates.
- Deduct PF, ESIC, and TDS from the basic salary to get the net salary.
Step 2: Salary Calculation for Working on a Public Holiday
- Add a separate column for public holiday hours worked and the applicable rate.
- Calculate the additional pay for working on a public holiday based on the hours worked and the rate.
Step 3: Payslip Showing Return of PF & ESIC
- Include a section on the payslip for return of PF and ESIC amounts, if applicable.
- Clearly mention the returned amounts in a separate row on the payslip.
Step 4: F&F (Full & Final Settlement)
- Create a separate tab or section for F&F calculations.
- Include details of pending dues, final salary, gratuity, and any other relevant information for the F&F settlement.
Ensure the Excel format is user-friendly and easy to understand for both HR and employees. Regularly update the register to reflect accurate salary information and deductions.
By following these steps, you can efficiently manage the salary register with all the necessary calculations and details as per the user's request.
From India, Gurugram
Acknowledge(0)Amend(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.
Salary Format.xls