I am P. Vyas. I am working in a small industries company in different departments. I want payroll with different departments, some with PF and some without PF, and daily wages. Please send an Excel sheet for that.
Acknowledge(0)
Amend(0)
Acknowledge(0)Amend(0)
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 used for calculating Basic, HRA, and Conveyance.
Regards, Trupti
From India, Mumbai
Acknowledge(0)Amend(0)
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 used for calculating Basic, HRA, and Conveyance.
Regards, Trupti
From India, Mumbai
Acknowledge(0)Amend(0)
Hey Sonia, Thanx a ton ya ! Plz also provide a formulated sheet to calculate basic , hra ,ctc ....
From India, New Delhi
Acknowledge(0)Amend(0)
1From India, New Delhi
Acknowledge(0)Amend(0)
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
Acknowledge(0)Amend(0)
From India, Madras
Acknowledge(0)Amend(0)
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
Acknowledge(0)Amend(0)
From India, Hyderabad
Acknowledge(0)Amend(0)
Please find the following link for an Excel-based Payroll Sheet and Attendance Program:
www.jiguparmar.com
Contains:
1. Attendance Register
2. Payroll Register
3. Generate Salary Slip
4. Print Out Salary Slip
5. Track Employees' Leave history
6. Track Income Tax of All Employees
7. Print out Leave History of Employee
8. Overtime Monitor
9. Master Data sheet of All Employees
10. Leave Calculation sheet
For more free Excel Creation for Home/Office and free books visit Free Excel Programs, Softwares, Books, Novels.
From India, New Delhi
Acknowledge(0)Amend(0)
www.jiguparmar.com
Contains:
1. Attendance Register
2. Payroll Register
3. Generate Salary Slip
4. Print Out Salary Slip
5. Track Employees' Leave history
6. Track Income Tax of All Employees
7. Print out Leave History of Employee
8. Overtime Monitor
9. Master Data sheet of All Employees
10. Leave Calculation sheet
For more free Excel Creation for Home/Office and free books visit Free Excel Programs, Softwares, Books, Novels.
From India, New Delhi
Acknowledge(0)Amend(0)
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 the 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 a Salary slip as per your predefined data (If Basic is 25% of Gross, then auto-calculate it). However, some employees are Temporary or We don't Follow Rules as per Regular employee. In such cases, this type of Employee should be put on Manual mode, and you need to 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 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 Leave of employees each month. When it goes minus, a red indication will glow on that cell, so you have to put it on LWP; otherwise, minus leave will affect salary slip generation.
Required Attention: Please be vigilant about Auto and Manual mode and P.F Selection.
Download link: www.jiguparmar.com
From India, New Delhi
Acknowledge(0)Amend(0)
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 the 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 a Salary slip as per your predefined data (If Basic is 25% of Gross, then auto-calculate it). However, some employees are Temporary or We don't Follow Rules as per Regular employee. In such cases, this type of Employee should be put on Manual mode, and you need to 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 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 Leave of employees each month. When it goes minus, a red indication will glow on that cell, so you have to put it on LWP; otherwise, minus leave will affect salary slip generation.
Required Attention: Please be vigilant about Auto and Manual mode and P.F Selection.
Download link: www.jiguparmar.com
From India, New Delhi
Acknowledge(0)Amend(0)
Hi everybody,
Actually, I am a fresher recently joined a small company with 25 employees. Could anyone provide us with a payroll Excel sheet that would be helpful for calculating payroll?
Thanks and regards,
Keshav Bats.
From India, Mumbai
Acknowledge(0)Amend(0)
Actually, I am a fresher recently joined a small company with 25 employees. Could anyone provide us with a payroll Excel sheet that would be helpful for calculating payroll?
Thanks and regards,
Keshav Bats.
From India, Mumbai
Acknowledge(0)Amend(0)
Dear All,
I am Anisha Multani. Please help me with the PF process. I have a doubt regarding how to calculate the PF Challan and Form No. 12A based on the total amount of all the employee PF contributions as well as the employer's. How do I calculate this? Please help me, all.
Regards,
Anisha
From India, Ahmadabad
Acknowledge(0)Amend(0)
I am Anisha Multani. Please help me with the PF process. I have a doubt regarding how to calculate the PF Challan and Form No. 12A based on the total amount of all the employee PF contributions as well as the employer's. How do I calculate this? Please help me, all.
Regards,
Anisha
From India, Ahmadabad
Acknowledge(0)Amend(0)
Hi Sonia,
I am Ramesh Perumal, a new member on the citehr platform. Could you please provide me with an Excel format for calculating salaries? Additionally, I am interested in learning more about completing HR tasks.
I am eagerly awaiting your valuable information.
Thank you,
Ramesh Perumal
From India, Madras
Acknowledge(0)Amend(0)
I am Ramesh Perumal, a new member on the citehr platform. Could you please provide me with an Excel format for calculating salaries? Additionally, I am interested in learning more about completing HR tasks.
I am eagerly awaiting your valuable information.
Thank you,
Ramesh Perumal
From India, Madras
Acknowledge(0)Amend(0)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.