Hello All I need some information how to make salary slip in Excel, Attendance and payroll like PF,PT ESIC, Bonus, Sample excel file to understand the basic criteria. Thanks Tanushri
From India, Mumbai
Acknowledge(0)
Amend(0)
From India, Mumbai
Acknowledge(0)Amend(0)
Hi Tanushri,
Sure, I can guide you on how to create a salary slip and attendance sheet in Excel.
Creating a Salary Slip in Excel
1. Open a new Excel sheet.
2. At the top, list the following details: Company name, Employee name, Employee ID, Department, and month for which the salary is being paid.
3. Below this, create sections for earnings and deductions. Under earnings, you can list basic salary, HRA, DA, Conveyance, and other allowances, if any.
4. Under deductions, list items like PF (Provident Fund), PT (Professional Tax), ESIC (Employees' State Insurance Corporation), and any other deductions.
5. Create another section below this for totals, where you will calculate the total earnings and total deductions.
6. Finally, calculate the net salary (total earnings - total deductions) and display it at the bottom.
Creating an Attendance Sheet in Excel
1. Open a new Excel sheet.
2. List the names of employees in the first column.
3. List the dates for the month in the first row, starting from the second column.
4. You can mark attendance by filling in 'P' for present, 'A' for absent, and 'L' for leave.
Payroll Elements
1. PF (Provident Fund): As per the Employees' Provident Fund and Miscellaneous Provisions Act, 1952, 12% of the basic wage, dearness allowance, and retaining allowance, if any, is contributed towards PF.
2. PT (Professional Tax): This varies by state. In Maharashtra, it ranges from INR 175 to INR 2500 per annum, based on the income slab.
3. ESIC (Employees' State Insurance Corporation): As per the ESI Act, 1948, the employee's contribution is 0.75% of the wages and the employer's contribution is 3.25% of the wages.
4. Bonus: As per the Payment of Bonus Act, 1965, a bonus is to be paid at a rate of 8.33% to 20% of the wages.
I hope this helps! Please note that the above information is a simplified representation of salary slip creation and payroll calculations. Actual calculations may vary based on several factors, including company policy and local labor laws. Always consult with a professional for accurate information.
Unfortunately, I cannot share an Excel file here. However, you can find many templates online by searching for 'Salary slip Excel template' or 'Attendance sheet Excel template'.
From India, Gurugram
Acknowledge(0)Amend(0)
32Sure, I can guide you on how to create a salary slip and attendance sheet in Excel.
Creating a Salary Slip in Excel
1. Open a new Excel sheet.
2. At the top, list the following details: Company name, Employee name, Employee ID, Department, and month for which the salary is being paid.
3. Below this, create sections for earnings and deductions. Under earnings, you can list basic salary, HRA, DA, Conveyance, and other allowances, if any.
4. Under deductions, list items like PF (Provident Fund), PT (Professional Tax), ESIC (Employees' State Insurance Corporation), and any other deductions.
5. Create another section below this for totals, where you will calculate the total earnings and total deductions.
6. Finally, calculate the net salary (total earnings - total deductions) and display it at the bottom.
Creating an Attendance Sheet in Excel
1. Open a new Excel sheet.
2. List the names of employees in the first column.
3. List the dates for the month in the first row, starting from the second column.
4. You can mark attendance by filling in 'P' for present, 'A' for absent, and 'L' for leave.
Payroll Elements
1. PF (Provident Fund): As per the Employees' Provident Fund and Miscellaneous Provisions Act, 1952, 12% of the basic wage, dearness allowance, and retaining allowance, if any, is contributed towards PF.
2. PT (Professional Tax): This varies by state. In Maharashtra, it ranges from INR 175 to INR 2500 per annum, based on the income slab.
3. ESIC (Employees' State Insurance Corporation): As per the ESI Act, 1948, the employee's contribution is 0.75% of the wages and the employer's contribution is 3.25% of the wages.
4. Bonus: As per the Payment of Bonus Act, 1965, a bonus is to be paid at a rate of 8.33% to 20% of the wages.
I hope this helps! Please note that the above information is a simplified representation of salary slip creation and payroll calculations. Actual calculations may vary based on several factors, including company policy and local labor laws. Always consult with a professional for accurate information.
Unfortunately, I cannot share an Excel file here. However, you can find many templates online by searching for 'Salary slip Excel template' or 'Attendance sheet Excel template'.
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.