Excel Format For Calculating Payroll - XLS Download

Paresh Vyas
i am p vyas i am working in small industries in this company differnt department & i want payroll with different department & also some pf & some without pf & daily wages plz send excel sheet for that
Trupti Haswar
Dear Sonia,
I came across the payroll excel sheet posted by you, it was an excellent job.
Since I am new to this, I wonder if you could send me a sheet with the formulas use for calculating Basic, HRA, Conveyance.
Regards,
Trupti
Deepsi22
Hey Sonia, Thanx a ton ya !
Plz also provide a formulated sheet to calculate basic , hra ,ctc ....
klv.ramanan
Hi Sonia,
Good work. But Management contribution for PF is restricted to Rs.6,500/- which you have not considered.
Regards
Ramanan K L V
Kalyanrayi
Hi Sonia,
Am basically into recruitments since 2 yrs and hve got no idea abt payrolls... cn u pls let me know how to use the excel posted by you ?
Rgds,
Kalyan
jiguparmar
Please find Following link for Excel base Payroll Sheet and Attendance Program
www.jiguparmar.com
Contains:
1-Attendance Register
2-Payroll Register
3-Generate Salary Slip
4-Print Out 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
For more Free Excel Cration For Home/Office and Free Books visit
Free Excel Programs-Softwares-Books-Novels
jiguparmar
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.

Download link: www.jiguparmar.con
keshavp
Hi.. every body.
Actually i m a fresher recentelly joined in a small co. employee strenth is 25.so any body can provide us payroll xle sheet which are helpful for calculating to payroll.
thanks & regards
keshav bats.
anisha.multani11
Dear All,
i am Anisha Multnai please help in PF Proceger...
i have dout regarding how to calculate PF Challan and Form No12A
on the besic of total amount of All the employee PF contrbution And as well as Employeer.
how to Calculate...please help me all
Regards.
Anisha
nirmalaramesh
Hi sonia
I am RameshPerumal new person inthe citehr. So pls tell excel format for calculating salary. And then i want to complete Hr works also.
I am waiting for ur valuable information.
Thanks
Ramesh Perumal
If you are knowledgeable about any fact, resource or experience related to this topic - please add your views. For articles and copyrighted material please only cite the original source link. Each contribution will make this page a resource useful for everyone. Join To Contribute