Jiguparmar
Autocad/plc/scada/adv.excel
+3 Others

Cite.Co is a repository of information and resources created by industry seniors and experts sharing their real world insights. Join Network
PFA an Excel Sheet to track the monthly attendance and in turn calculate the payroll of employees.
I've also posted the same sheet on "HR Administration" section as well.
Hope the attached file would be useful for all those freshers who've to maintain attendance of their employees.
Seniors & Experienced HR Peers: Pls. do let me know your valuable advice / comments on improving the sheet.
Regards
Ambersaleem


Attached Files
Membership is required for download. Create An Account First
File Type: xls Attendance Sheet.xls (101.5 KB, 2036 views)

Hi all!
21 views and not a single comment or advise!!!!
Very upsetting!
For the kind information of all, pls. 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 concentration on it, you may surely feel to comment or advice, that may be of a great help in further developing/enhancing it.
Regards
Ambersaleem.

Dear Amber Saleem, the attendance sheet created by you was really useful ! I appreciate your effort ! Regards, Mohsin.H.M.
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...

Download:Free File Hosting & Video Downloads, Free File Sharing, Online Friends Network - Ziddu
Please chase 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 discriptions: By default I gave some categories for Fixed earning/Reimberancement/Other deductions. Change the Names of This Categories as per your reqirements.
4- As you enter detail mentions in step 3 name of the categories will appear in auto generation salary just below the Salary discription.
Enter percentage as per your company requirements to generate 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 Name of Departments/Designation of Employees of your Orgenizations.
8-Enter Tax Slab for man and Woman.

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-Here after If You choose Auto mode than Salary slip will be generated autonatically as per (%wise detail) data given by you in "Company detail sheet"(nomally for Regular Employees put Auto mode).But if You don't want to follow the rules enter by You in "Company detail sheet" put manual mode here You can Enter his/her Basic-Hra and all detail of salary manually.
6- Enter Amount of OT/Hr if Employee do OT
7- Enter leave detail,Previous Year Leave-This Year Leaves.
8-Enter Rentpaid by Employee for exemption under section 10&17
9-Enter Amount for section 80c and 80D for U/S VIA deduction.

Thrid open "Attendance sheet according to perticular Month"

1- Enter Attendance/Leave/Holiday of Employee
2- enter Overtime of The Employee.

Forth open "Payroll sheet according to perticular Month"

1- All salary detail and attendance will automatically carry forward. You have to enter only reimberance detail and other deduction detail only
2- Salry will generate as per your data.
3- Enter Salary Amount Which You have Paid.
4-Select Type of Payment.

Most of remaning sheet are monitoring or summary sheet.

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...

Download:Free File Hosting & Video Downloads, Free File Sharing, Online Friends Network - Ziddu

Please chase 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 discriptions: By default I gave some categories for Fixed earning/Reimberancement/Other deductions. Change the Names of This Categories as per your reqirements.

4- As you enter detail mentions in step 3 name of the categories will appear in auto generation salary just below the Salary discription.

Enter percentage as per your company requirements to generate 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 Name of Departments/Designation of Employees of your Orgenizations.

8-Enter Tax Slab for man and Woman.

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-Here after If You choose Auto mode than Salary slip will be generated autonatically as per (%wise detail) data given by you in "Company detail sheet"(nomally for Regular Employees put Auto mode).But if You don't want to follow the rules enter by You in "Company detail sheet" put manual mode here You can Enter his/her Basic-Hra and all detail of salary manually.

6- Enter Amount of OT/Hr if Employee do OT

7- Enter leave detail,Previous Year Leave-This Year Leaves.

8-Enter Rentpaid by Employee for exemption under section 10&17

9-Enter Amount for section 80c and 80D for U/S VIA deduction.

Thrid open "Attendance sheet according to perticular Month"

1- Enter Attendance/Leave/Holiday of Employee

2- enter Overtime of The Employee.

Forth open "Payroll sheet according to perticular Month"

1- All salary detail and attendance will automatically carry forward. You have to enter only reimberance detail and other deduction detail only

2- Salry will generate as per your data.

3- Enter Salary Amount Which You have Paid.

4-Select Type of Payment.

Most of remaning sheet are monitoring or summary sheet.

Hello Mr.Jiguparmar,
I felt very much happy to see your software quoted above.
It is very exhaustive and user friendly also. I wonder there are such members on this site that they do so much labor in preparing a software like the above, share it alongwith other fellow members and in return just seek their advice or comments.
Thanks once again for sharing your salary software with all of us.
YRRao
Miyapur,Hyderabad.

Hi Amber,
Thanks a lot for providing the attendance excel. It is of great help for a fresher like me. Could you please help me further . I need to understand as to how to present this data in a PPT, providing all the necessary details.
Hoping for a positive response.
Regards,
Lopamudra

Dear Ambersaleem,
thank You so much for this attendancesheet ,i am facing too much problem while preparing attence data as i am handling 5 different location this is very much helping to me .
thank you once again...........
Warm Regards,
Ashwini Shailesh

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™