Please find attached an Excel sheet to track monthly attendance and calculate employees' payroll. The same sheet has also been posted in the "HR Administration" section. I hope this file will be useful for all the newcomers who need to maintain attendance records for their employees.
Seniors and experienced HR peers, please share your valuable advice and comments on how the sheet can be improved.
Regards,
Ambersaleem
From India, Hyderabad
Acknowledge(0)
Amend(0)
10Seniors and experienced HR peers, please share your valuable advice and comments on how the sheet can be improved.
Regards,
Ambersaleem
From India, Hyderabad
Acknowledge(0)Amend(0)
Hi all!
21 views and not a single comment or advice! Very upsetting!
For the kind information of all, please note that the attendance sheet has been designed entirely as an individual effort by me. Of course, for some, it might look as simple as an ordinary Excel sheet. But if you look into this seriously and apply a bit of concentration on it, you may surely feel compelled to comment or provide advice, which may be of great help in further developing/enhancing it.
Regards,
Ambersaleem.
From India, Hyderabad
Acknowledge(0)Amend(0)
21 views and not a single comment or advice! Very upsetting!
For the kind information of all, please note that the attendance sheet has been designed entirely as an individual effort by me. Of course, for some, it might look as simple as an ordinary Excel sheet. But if you look into this seriously and apply a bit of concentration on it, you may surely feel compelled to comment or provide advice, which may be of great help in further developing/enhancing it.
Regards,
Ambersaleem.
From India, Hyderabad
Acknowledge(0)Amend(0)
Dear Amber Saleem, the attendance sheet created by you was really useful ! I appreciate your effort ! Regards, Mohsin.H.M.
From India, Madras
Acknowledge(0)Amend(0)
From India, Madras
Acknowledge(0)Amend(0)
Please find the new version of Salary Master with new features.
It is a 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. You can set limits of ESI, P.F, Income Tax Slab for Man and Woman, 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 manual details given by you. It will not concern with the data given by you in the "Company detail sheet." For example, you need to generate salary for Regular Employees as per company policy. For that, you may put these employees on Auto mode, and it will generate the Salary slip as per your predefined data. But some employees are Temporary or do not follow rules as per regular employees, so this type of employee should be put on Manual mode and enter the data manually (here you have to manually enter Basic and other details).
The software contains:
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 (Here there are Two Options: if Basic <= 6500 than Basic*12% otherwise 6500*12%. Second is 12% of Basic).
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. So, you have to put it on LWP; otherwise, minus leave will affect the salary slip generation. Required Attention: Please be vigilant about Auto and Manual mode and P.F Selection.
If you find this useful, don't 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 "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 auto-generated salary just below the Salary description. 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 %).
5. Enter % of ESI from Employee and Employer, and For P.F Choose your Options.
6. For Professional tax Slab, enter your criteria.
7. Enter the Name of Departments/Designation of Employees of your Organizations.
Second open "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. Hereafter, If You choose Auto mode, then 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 Auto mode). But if You don't want to follow the rules entered by You in the "Company detail sheet," put manual mode here. You can Enter his/her Basic-HRA and all details of the salary manually.
6. Enter Amount of OT/Hr if Employee does OT.
7. Enter leave detail, Previous Year Leave-This Year Leaves.
8. Enter Rent paid by Employee for exemption under section 10 & 17.
9. Enter Amount for section 80c and 80D for U/S VIA deduction.
Third open "Attendance sheet according to a particular Month":
1. Enter Attendance/Leave/Holiday of Employee.
2. Enter Overtime of The Employee.
Fourth open "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 only.
2. Salary will generate as per your data.
3. Enter Salary Amount Which You have Paid.
4. Select Type of Payment.
Most of the remaining sheets are monitoring or summary sheets.
From India, New Delhi
Acknowledge(0)Amend(0)
It is a 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. You can set limits of ESI, P.F, Income Tax Slab for Man and Woman, 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 manual details given by you. It will not concern with the data given by you in the "Company detail sheet." For example, you need to generate salary for Regular Employees as per company policy. For that, you may put these employees on Auto mode, and it will generate the Salary slip as per your predefined data. But some employees are Temporary or do not follow rules as per regular employees, so this type of employee should be put on Manual mode and enter the data manually (here you have to manually enter Basic and other details).
The software contains:
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 (Here there are Two Options: if Basic <= 6500 than Basic*12% otherwise 6500*12%. Second is 12% of Basic).
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. So, you have to put it on LWP; otherwise, minus leave will affect the salary slip generation. Required Attention: Please be vigilant about Auto and Manual mode and P.F Selection.
If you find this useful, don't 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 "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 auto-generated salary just below the Salary description. 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 %).
5. Enter % of ESI from Employee and Employer, and For P.F Choose your Options.
6. For Professional tax Slab, enter your criteria.
7. Enter the Name of Departments/Designation of Employees of your Organizations.
Second open "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. Hereafter, If You choose Auto mode, then 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 Auto mode). But if You don't want to follow the rules entered by You in the "Company detail sheet," put manual mode here. You can Enter his/her Basic-HRA and all details of the salary manually.
6. Enter Amount of OT/Hr if Employee does OT.
7. Enter leave detail, Previous Year Leave-This Year Leaves.
8. Enter Rent paid by Employee for exemption under section 10 & 17.
9. Enter Amount for section 80c and 80D for U/S VIA deduction.
Third open "Attendance sheet according to a particular Month":
1. Enter Attendance/Leave/Holiday of Employee.
2. Enter Overtime of The Employee.
Fourth open "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 only.
2. Salary will generate as per your data.
3. Enter Salary Amount Which You have Paid.
4. Select Type of Payment.
Most of the remaining sheets are monitoring or summary sheets.
From India, New Delhi
Acknowledge(0)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. 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 detail given by you. It will not concern with the data given by you in the "Company detail sheet."
For example, we need to generate a salary for Regular Employee as per company Policy. For that, you may put these employees on Auto mode, and it will generate the Salary slip as per your predefined data (If Basic is 25% of Gross, then auto-calculate it). However, some Employees are Temporary or We don't Follow Rules as per Regular employees, so these types of Employees are put on Manual mode to enter your data manually (here You have to manually enter Basic and other details).
The software contains:
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 (Here there are Two Options: if Basic <= 6500, then Basic*12%, otherwise 6500*12%. The second option is 12% of Basic).
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. So, you have to put it on LWP; otherwise, minus leave will affect the salary slip generation.
Required Attention: Please be vigilant about Auto and Manual mode and P.F Selection.
If you find this useful, don't 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 the 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 auto-generation 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 Name of Departments/Designation 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, then 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 Auto mode). But if You don't want to follow the rules entered by You in the "Company detail sheet," put manual mode here. You can Enter his/her Basic-HRA and all details of salary manually.
6. Enter the Amount of OT/Hr if Employee does OT.
7. Enter leave details, Previous Year Leave-This Year Leaves.
8. Enter Rent paid by 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 particular Month":
1. Enter Attendance/Leave/Holiday of Employee.
2. Enter Overtime of The Employee.
Fourth, open the "Payroll sheet according to particular Month":
1. All salary details and attendance will automatically carry forward. You have to enter only reimbursement details and other deduction details only.
2. Salary will generate as per your data.
3. Enter Salary Amount Which You have Paid.
4. Select the Type of Payment.
Most of the remaining sheets are monitoring or summary sheets.
From India, New Delhi
Acknowledge(0)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. 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 detail given by you. It will not concern with the data given by you in the "Company detail sheet."
For example, we need to generate a salary for Regular Employee as per company Policy. For that, you may put these employees on Auto mode, and it will generate the Salary slip as per your predefined data (If Basic is 25% of Gross, then auto-calculate it). However, some Employees are Temporary or We don't Follow Rules as per Regular employees, so these types of Employees are put on Manual mode to enter your data manually (here You have to manually enter Basic and other details).
The software contains:
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 (Here there are Two Options: if Basic <= 6500, then Basic*12%, otherwise 6500*12%. The second option is 12% of Basic).
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. So, you have to put it on LWP; otherwise, minus leave will affect the salary slip generation.
Required Attention: Please be vigilant about Auto and Manual mode and P.F Selection.
If you find this useful, don't 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 the 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 auto-generation 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 Name of Departments/Designation 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, then 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 Auto mode). But if You don't want to follow the rules entered by You in the "Company detail sheet," put manual mode here. You can Enter his/her Basic-HRA and all details of salary manually.
6. Enter the Amount of OT/Hr if Employee does OT.
7. Enter leave details, Previous Year Leave-This Year Leaves.
8. Enter Rent paid by 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 particular Month":
1. Enter Attendance/Leave/Holiday of Employee.
2. Enter Overtime of The Employee.
Fourth, open the "Payroll sheet according to particular Month":
1. All salary details and attendance will automatically carry forward. You have to enter only reimbursement details and other deduction details only.
2. Salary will generate as per your data.
3. Enter Salary Amount Which You have Paid.
4. Select the Type of Payment.
Most of the remaining sheets are monitoring or summary sheets.
From India, New Delhi
Acknowledge(0)Amend(0)
Hello Mr. Jiguparmar,
I was very happy to see your software mentioned above. It is very exhaustive and user-friendly as well. I wonder if there are members on this site who put in so much effort to prepare software like the one above, share it with other fellow members, and in return just seek their advice or comments.
Thanks once again for sharing your salary software with all of us.
YR Rao Miyapur, Hyderabad.
From India, Hyderabad
Acknowledge(0)Amend(0)
I was very happy to see your software mentioned above. It is very exhaustive and user-friendly as well. I wonder if there are members on this site who put in so much effort to prepare software like the one above, share it with other fellow members, and in return just seek their advice or comments.
Thanks once again for sharing your salary software with all of us.
YR Rao Miyapur, Hyderabad.
From India, Hyderabad
Acknowledge(0)Amend(0)
Hi Amber,
Thank you for providing the attendance Excel sheet. It is greatly helpful for a fresher like me. Could you please assist me further? I need to understand how to present this data in a PowerPoint presentation, including all the necessary details.
Hoping for a positive response.
Regards,
Lopamudra
From India, New Delhi
Acknowledge(0)Amend(0)
Thank you for providing the attendance Excel sheet. It is greatly helpful for a fresher like me. Could you please assist me further? I need to understand how to present this data in a PowerPoint presentation, including all the necessary details.
Hoping for a positive response.
Regards,
Lopamudra
From India, New Delhi
Acknowledge(0)Amend(0)Gathering data for an AI comment.... Sending emails to relevant members...
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.
152120-very-use ful-hr-manageme nt-software-bui lt-excel-psa-hr -manager-mainta in-payrrol-exce l-soft.zip