Dear All,
My manager has requested weekly and monthly reports for all staff members. He wants to know not only about their attendance but also the total working hours of each individual. Please assist me in creating this report in Excel, as we do not currently have any software for attendance tracking.
Thank you.
From Pakistan, Karachi
Acknowledge(0)
Amend(0)
12My manager has requested weekly and monthly reports for all staff members. He wants to know not only about their attendance but also the total working hours of each individual. Please assist me in creating this report in Excel, as we do not currently have any software for attendance tracking.
Thank you.
From Pakistan, Karachi
Acknowledge(0)Amend(0)
Dear Ali,
For attendance purposes, you can keep an Attendance Register with the reception or with the security guard. Please inform all the employees in your office to sign in and out every day.
To track the number of hours worked by the employees, please find the attached document. I hope this helps you.
Regards,
Shubha
From United Arab Emirates, Dubai
Acknowledge(0)Amend(0)
For attendance purposes, you can keep an Attendance Register with the reception or with the security guard. Please inform all the employees in your office to sign in and out every day.
To track the number of hours worked by the employees, please find the attached document. I hope this helps you.
Regards,
Shubha
From United Arab Emirates, Dubai
Acknowledge(0)Amend(0)
Dear Shubha Its really awsome thx dear thx alot.But plz check my new query, my manager need to add more.
From Pakistan, Karachi
Acknowledge(0)Amend(0)
From Pakistan, Karachi
Acknowledge(0)Amend(0)
Please find the new version of Salary Master with new features.
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 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, we need to generate 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). But some employees are temporary or we don't follow rules as per Regular employees, so this type of employee is put on Manual mode, and you 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 the employee each month. When it goes minus, a red indication glows 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...
[Link to the source](https://www.citehr.com/234112-salary-structure-calculator-8.html#post1062605)
From India, New Delhi
Acknowledge(0)Amend(0)
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 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, we need to generate 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). But some employees are temporary or we don't follow rules as per Regular employees, so this type of employee is put on Manual mode, and you 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 the employee each month. When it goes minus, a red indication glows 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...
[Link to the source](https://www.citehr.com/234112-salary-structure-calculator-8.html#post1062605)
From India, New Delhi
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.
152120-very-use ful-hr-manageme nt-software-bui lt-excel-psa-hr -manager-mainta in-payrrol-exce l-soft.zip
Employee Attendance Register - 2014-15.xls