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
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
From India, Mumbai
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
From India, Mumbai
1
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
From India, Madras
From India, Madras
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
From India, Hyderabad
From India, Hyderabad
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
From India, New Delhi
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
From India, New Delhi
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
From India, New Delhi
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
From India, New Delhi
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
From India, Ahmadabad
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
From India, Ahmadabad
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.
Form 9 (Excel Format).xls
10 ways to format Excel data.pdf