Hi All,
I have attached an Excel sheet that integrates all ESI-PF based statutory preparations on a monthly and annual basis. The interesting part of the Excel Sheet is that it requires only one data entry point. This data is then automatically referenced in all other necessary places. I am continuously working on improving its automation.
Please feel free to get in touch with me for the implemented version of the same.
Regards,
Anand
From India, Coimbatore
Acknowledge(0)
Amend(0)
23I have attached an Excel sheet that integrates all ESI-PF based statutory preparations on a monthly and annual basis. The interesting part of the Excel Sheet is that it requires only one data entry point. This data is then automatically referenced in all other necessary places. I am continuously working on improving its automation.
Please feel free to get in touch with me for the implemented version of the same.
Regards,
Anand
From India, Coimbatore
Acknowledge(0)Amend(0)
Hello Anand, Excel sheet you have prepared was good, but if the excel sheet would include only calculations of PF & ESI that would be more useful. Cheers ! Prasad
From India, Hyderabad
Acknowledge(2)Amend(0)
From India, Hyderabad
Acknowledge(2)Amend(0)
Please find the new version of Salary Master with new features.
It is a totally user-friendly program. You can enter your company name, address, department, and designations. You can set categories of fixed earning, other earning, fixed deduction, and other deduction in the salary slip. Additionally, you can set the limit of ESI, P.F, income tax slab for men and women, surcharge setting, and professional tax.
The program is designed in two modes:
1. In Auto mode, the salary slip will be generated as per your predefined data given in the "Company Detail Sheet."
2. In Manual mode, the salary slip will be generated as per the manual details given by you. It will not concern the data given in the "Company Detail Sheet."
For example, you need to generate a salary for regular employees as per the company policy. For that, you may put these employees on Auto mode, and it will generate the salary slip as per your predefined data. Some employees are temporary or do not follow rules like regular employees, so these types of employees are put on Manual mode for entering data manually.
The software contains various features:
1. Attendance Register
2. Payroll Register
3. Generate Salary Slip
4. Track Employees' Leave History
5. Track Income Tax of All Employees
6. Print out Leave History of Employee
7. Overtime Monitor
8. Master Data sheet of All Employees
9. Leave Calculation sheet
10. ESI Calculation (Set Your Requirements)
11. P.F Calculation
12. Pension Scheme (not more than 541 rs submission)
13. TDS Calculation
14. Annual Salary statement of Employee and Employer
15. Employer Monthly Salary statement
16. Income Tax Calculations
17. Generation of Form No-6 (For ESIC)
18. Generation of Form no-3A (PF)
19. Generation of Form no-6A (PF)
Limitation: You have to monitor the leave of employees each month. When it goes minus, a red indication will glow on that cell, and you have to put it on LWP; otherwise, minus leave will affect salary slip generation.
Required Attention: Please be vigilant about Auto and Manual mode and P.F selection.
If you find this useful, do not miss to drop thanks.
Download: [Free File Hosting & Video Downloads, Free File Sharing, Online Friends Network - Ziddu](http://www.ziddu.com/download/8908540/SalaryMaster-NewVersion-10.3.2010.zip.html)
Please follow the steps as per the given sequence.
First, open the "Company Detail Sheet":
1. Open "Company Detail Sheet"
2. Change company name and address.
3. Change salary descriptions: By default, I gave some categories for fixed earning/reimbursement/other deductions. Change the names of these categories as per your requirements.
4. As you enter details mentioned in step 3, the names of the categories will appear in the auto-generated salary just below the salary description.
5. Enter the percentage as per your company requirements to generate the salary of all employees (By default, I gave Basic = 25% of gross. You can change 25% and enter your %).
6. Enter % of ESI from employee and employer, and for P.F, choose your options.
7. For professional tax slab, enter your criteria.
8. Enter the names of departments/designations of employees of your organizations.
Second, open the "Master Data Sheet":
1. Enter employee name, gender, employee code.
2. Select his/her designation-department.
3. Enter PAN no, bank A/C no, bank name, P.F no, ESI no, DOB, DOJ, location.
4. Enter employees' gross salary/month.
5. If you choose Auto mode, the salary slip will be generated automatically as per (%wise detail) data given by you in the "Company Detail Sheet" (normally for regular employees put in Auto mode). If you don't want to follow the rules entered by you in the "Company Detail Sheet," put in manual mode where you can enter his/her Basic-HRA and all details of the salary manually.
6. Enter the amount of OT/Hr if the employee does OT.
7. Enter leave details, previous year leave, and this year leaves.
8. Enter rent paid by the employee for exemption under section 10&17.
9. Enter the amount for section 80c and 80D for U/S VIA deduction.
Third, open the "Attendance sheet according to a particular month":
1. Enter attendance/leave/holiday of employees.
2. Enter overtime of the employee.
Fourth, open the "Payroll sheet according to a particular month":
1. All salary details and attendance will automatically carry forward. You have to enter only reimbursement details and other deduction details.
2. Salary will be generated as per your data.
3. Enter the salary amount that you have paid.
4. Select the type of payment.
Most of the remaining sheets are monitoring or summary sheets.
From India, New Delhi
Acknowledge(1)Amend(0)
It is a totally user-friendly program. You can enter your company name, address, department, and designations. You can set categories of fixed earning, other earning, fixed deduction, and other deduction in the salary slip. Additionally, you can set the limit of ESI, P.F, income tax slab for men and women, surcharge setting, and professional tax.
The program is designed in two modes:
1. In Auto mode, the salary slip will be generated as per your predefined data given in the "Company Detail Sheet."
2. In Manual mode, the salary slip will be generated as per the manual details given by you. It will not concern the data given in the "Company Detail Sheet."
For example, you need to generate a salary for regular employees as per the company policy. For that, you may put these employees on Auto mode, and it will generate the salary slip as per your predefined data. Some employees are temporary or do not follow rules like regular employees, so these types of employees are put on Manual mode for entering data manually.
The software contains various features:
1. Attendance Register
2. Payroll Register
3. Generate Salary Slip
4. Track Employees' Leave History
5. Track Income Tax of All Employees
6. Print out Leave History of Employee
7. Overtime Monitor
8. Master Data sheet of All Employees
9. Leave Calculation sheet
10. ESI Calculation (Set Your Requirements)
11. P.F Calculation
12. Pension Scheme (not more than 541 rs submission)
13. TDS Calculation
14. Annual Salary statement of Employee and Employer
15. Employer Monthly Salary statement
16. Income Tax Calculations
17. Generation of Form No-6 (For ESIC)
18. Generation of Form no-3A (PF)
19. Generation of Form no-6A (PF)
Limitation: You have to monitor the leave of employees each month. When it goes minus, a red indication will glow on that cell, and you have to put it on LWP; otherwise, minus leave will affect salary slip generation.
Required Attention: Please be vigilant about Auto and Manual mode and P.F selection.
If you find this useful, do not miss to drop thanks.
Download: [Free File Hosting & Video Downloads, Free File Sharing, Online Friends Network - Ziddu](http://www.ziddu.com/download/8908540/SalaryMaster-NewVersion-10.3.2010.zip.html)
Please follow the steps as per the given sequence.
First, open the "Company Detail Sheet":
1. Open "Company Detail Sheet"
2. Change company name and address.
3. Change salary descriptions: By default, I gave some categories for fixed earning/reimbursement/other deductions. Change the names of these categories as per your requirements.
4. As you enter details mentioned in step 3, the names of the categories will appear in the auto-generated salary just below the salary description.
5. Enter the percentage as per your company requirements to generate the salary of all employees (By default, I gave Basic = 25% of gross. You can change 25% and enter your %).
6. Enter % of ESI from employee and employer, and for P.F, choose your options.
7. For professional tax slab, enter your criteria.
8. Enter the names of departments/designations of employees of your organizations.
Second, open the "Master Data Sheet":
1. Enter employee name, gender, employee code.
2. Select his/her designation-department.
3. Enter PAN no, bank A/C no, bank name, P.F no, ESI no, DOB, DOJ, location.
4. Enter employees' gross salary/month.
5. If you choose Auto mode, the salary slip will be generated automatically as per (%wise detail) data given by you in the "Company Detail Sheet" (normally for regular employees put in Auto mode). If you don't want to follow the rules entered by you in the "Company Detail Sheet," put in manual mode where you can enter his/her Basic-HRA and all details of the salary manually.
6. Enter the amount of OT/Hr if the employee does OT.
7. Enter leave details, previous year leave, and this year leaves.
8. Enter rent paid by the employee for exemption under section 10&17.
9. Enter the amount for section 80c and 80D for U/S VIA deduction.
Third, open the "Attendance sheet according to a particular month":
1. Enter attendance/leave/holiday of employees.
2. Enter overtime of the employee.
Fourth, open the "Payroll sheet according to a particular month":
1. All salary details and attendance will automatically carry forward. You have to enter only reimbursement details and other deduction details.
2. Salary will be generated as per your data.
3. Enter the salary amount that you have paid.
4. Select the type of payment.
Most of the remaining sheets are monitoring or summary sheets.
From India, New Delhi
Acknowledge(1)Amend(0)
hi, This is priya i want to learn calculation of salary and other deduction made for an employee in the industry.Plse help me out to improve and learn more on this part Regards priyananjayyanamath
From India, Bangalore
Acknowledge(1)Amend(0)
From India, Bangalore
Acknowledge(1)Amend(0)
Hi, I am Rakesh. Can anyone help me with where to deposit PF, ESIC, and PT? Where are the challans available, and how should the challans be filled? In whose name should the deposits be made, and should they be done monthly or yearly?
From India, Hyderabad
Acknowledge(0)Amend(0)
From India, Hyderabad
Acknowledge(0)Amend(0)
Hi Ashwini, Please find the attached file for all forms. For any clarification feel free to write or discuss. Regards, Prasenjit Mitra +91 8826726694
From India, Mumbai
Acknowledge(2)
Amend(0)
From India, Mumbai
Acknowledge(2)Amend(0)
Hi,
I am Vamsi. Can anyone help me by providing easy formulas for PF, ESI, and PT calculation? I know the rates, but calculating salaries for around 900 employees and checking whether PF, ESI, and PT are correct for each employee is becoming tough. I need an IF condition formula or any easy formula for calculation and setting conditions. For example, if an employee is earning 16,000/- P.M, then ESI should be Zero, and if they are earning 15,000/-, then ESI should be 1.75% on 15,000/-. I require one formula that can be applied to all employees. I hope this is understandable to solve my issue.
From India, Hyderabad
Acknowledge(2)Amend(0)
I am Vamsi. Can anyone help me by providing easy formulas for PF, ESI, and PT calculation? I know the rates, but calculating salaries for around 900 employees and checking whether PF, ESI, and PT are correct for each employee is becoming tough. I need an IF condition formula or any easy formula for calculation and setting conditions. For example, if an employee is earning 16,000/- P.M, then ESI should be Zero, and if they are earning 15,000/-, then ESI should be 1.75% on 15,000/-. I require one formula that can be applied to all employees. I hope this is understandable to solve my issue.
From India, Hyderabad
Acknowledge(2)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.
Salary Sheet & PF PT Calculation & Challan Nov 2010.xls
CiteHR.AI
(Fact Checked)-The PF, ESIC, and PT challans should be deposited monthly under their respective authorities' names. Challans can be accessed from the respective websites or offices. (1 Acknowledge point)