Employees Daily/weekly/monthly Attendance. - XLS Download - CiteHR
Jiguparmar
Autocad/plc/scada/adv.excel
Shubhag
Seasonal Hr Professional
Zainab Ali
Hr Admin Assistant

Cite.Co is a repository of information created by your industry peers and experienced seniors sharing their experience and insights.
Join Us and help by adding your inputs. Contributions From Other Members Follow Below...
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

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


Attached Files
Membership is required for download. Create An Account First
File Type: xls employees_register_2007_146.xls (70.5 KB, 7182 views)

Dear Shubha Its really awsome thx dear thx alot.But plz check my new query, my manager need to add more.
Please find new version of Salary Master with new Feactures..

Totally Usefriendly program.
You can enter your Company name,Address,Department,Designations
You can set Categoeries of Fixed earning-Other Earning-Fixed deduction-Other deduction in Salary Slip.
You can set limit of ESI,P.F,Income Tax Slab for Man and Woman,Surchage setting,Professional Tax.

Program is Designed on Two mode
(1) In Auto mode salary slip will be generated as per Your predefined data given in "Company Detail Sheet"
(2) In Manual mode Salary Slip will be generated as per Manual detail given by You.It will not concern with the data given by you in "Company detail sheet"
Ex: We need to generate salary for Regular Employee as per company Policy for that You may put this employees on Auto mode and it will generate Salary slip as per your predefined data (If Basic is 25% of Gross than auto calculate it)But Some Employees are Temperaroy or We don't Follow Rules as per Regular employee so that This Type of Employee Put on Manual mode and enter your Data manually(here You have manually enter Basic and other details).

Software Contains:

1-Attendance Register.
2-Payroll Register.
3-Generate Salary Slip.
4-Track Employees' Leave history.
5-Track Income Tax of All Employee.
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 one is 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 monitor Leave of employee each month when It goes minius Red indication is glow on that cell so You have to Put it on LWP otherwise minus leave will effect on salary sllip generation.
Requied Attention: Please be vigilant about Auto and Manual mode and P.F Selection.

If You find this is useful for You than Don't miss to deop Thanks...

https://www.citehr.com/234112-salary...ml#post1062605

This discussion thread is closed. If you want to continue this discussion or have a follow up question, please post it on the network.
Add the url of this thread if you want to cite this discussion.






About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service



All rights reserved @ 2020 Cite.Co™