Dear All,
My Manager asked for Weekly & Monthly report of all his staff members, he wants to knows along with the attendance, he wants to know the total working hours of all.
plz help me to draft this on excel as we dont have any software for attendance yet so help me to design it in excel.
thanks
From Pakistan, Karachi
12My Manager asked for Weekly & Monthly report of all his staff members, he wants to knows along with the attendance, he wants to know the total working hours of all.
plz help me to draft this on excel as we dont have any software for attendance yet so help me to design it in excel.
thanks
From Pakistan, Karachi
Ensure smooth inspections and audits with clean, accessible records of all ESI filings and payments. See It In Action - Book Your Demo
Dear Ali ,
For attendance purpose, you can keep a Attendance Register with the reception or with security guard . Inform all the employees in your office to sign and enter the time in and time out everyday.
To know the no of hours worked by the employees . Please find the attached doc. Hope this helps you .
Regards
Shubha
From United Arab Emirates, Dubai
For attendance purpose, you can keep a Attendance Register with the reception or with security guard . Inform all the employees in your office to sign and enter the time in and time out everyday.
To know the no of hours worked by the employees . Please find the attached doc. Hope this helps you .
Regards
Shubha
From United Arab Emirates, Dubai
Dear Shubha Its really awsome thx dear thx alot.But plz check my new query, my manager need to add more.
From Pakistan, Karachi
From Pakistan, Karachi
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
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
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.
