Hi Masters, I Ramesh, working for small company, employee strength around 30. I am new to payroll. Plz. send me excel format for calculating salary. Thanks&Regards Ramesh
From India, Bangalore
Acknowledge(0)
Amend(0)
7From India, Bangalore
Acknowledge(0)Amend(0)
Dear Ramesh Pls. find the payroll attachment as i maintain our company. May be it is useful to you. It contain formulas so dont change the sheet copy it and make new payroll. Regards Sonia
From India, Gurgaon
Acknowledge(0)Amend(0)
From India, Gurgaon
Acknowledge(0)Amend(0)
Hi Masters, I'm Ramesh, working for a small company with around 30 employees. I am new to payroll. Please send me an Excel format for calculating salary.
Thanks & Regards,
Ramesh
Hi Ramesh,
We are an outsourced consultancy firm catering to payroll and staffing services. If you are based in Mumbai, we can provide you with our best services, including statutory compliance management, at very affordable charges.
You can reach me at 99675 98731.
Regards,
Jatin.
From India, Mumbai
Acknowledge(0)Amend(0)
Thanks & Regards,
Ramesh
Hi Ramesh,
We are an outsourced consultancy firm catering to payroll and staffing services. If you are based in Mumbai, we can provide you with our best services, including statutory compliance management, at very affordable charges.
You can reach me at 99675 98731.
Regards,
Jatin.
From India, Mumbai
Acknowledge(0)Amend(0)
Hi ms. Sonia! Thanks for the information. But, in ur pay roll sheet there is no Professional Tax Column y so? as far as my knowledge the professional tax deduction is must. Thanks & Regards, Sujatha
From India, Bangalore
Acknowledge(0)Amend(0)
From India, Bangalore
Acknowledge(0)Amend(0)
Dear Sonia,
Thank you for your valuable information. The sheet that you have provided is to be taken as a base. We can modify it to some extent, taking into consideration the statutory compliance and other regulations.
Thanks and regards,
From India, Mumbai
Acknowledge(0)Amend(0)
Thank you for your valuable information. The sheet that you have provided is to be taken as a base. We can modify it to some extent, taking into consideration the statutory compliance and other regulations.
Thanks and regards,
From India, Mumbai
Acknowledge(0)Amend(0)
Hi Sonia,
I've checked the format; it's really well done. However, in the Ahmedabad region, associates have noticed that ESI has been deducted even when they are not in the band (the limit being Gross 10,000/-), as their gross was 18,000/-.
Please check this issue.
Regards,
Hari Krishna
From India, Hyderabad
Acknowledge(0)Amend(0)
I've checked the format; it's really well done. However, in the Ahmedabad region, associates have noticed that ESI has been deducted even when they are not in the band (the limit being Gross 10,000/-), as their gross was 18,000/-.
Please check this issue.
Regards,
Hari Krishna
From India, Hyderabad
Acknowledge(0)Amend(0)
Hello Sir/Madam,
This is Nagaraj M from Cosmosoft Technologies Ltd, Chennai. We are offering the "Payroll Package" at an affordable rate. Kindly go through the advantages of the "APPLECART" Payroll & TDS Solutions Package (PDF File Attached).
>>>Kindly call us for any details or a detailed Presentation of the Software....
Please call this number: 9884947801.
Regards,
Nagaraj M
Application Maintenance Engineer
H/P – 9884947801
COSMOSOFT TECHNOLOGIES LIMITED
#141, Arcot Road, Kodambakkam
Chennai, Tamil Nadu, India - 600 024
Phone: 91-44-23723206 / 07 / 08
Mail: [email protected]
Web: www.ctlindia.com / www.cosmosoft.in <link updated to site home> (Search On Cite | Search On Google)
From India, Madras
Acknowledge(0)Amend(0)
This is Nagaraj M from Cosmosoft Technologies Ltd, Chennai. We are offering the "Payroll Package" at an affordable rate. Kindly go through the advantages of the "APPLECART" Payroll & TDS Solutions Package (PDF File Attached).
>>>Kindly call us for any details or a detailed Presentation of the Software....
Please call this number: 9884947801.
Regards,
Nagaraj M
Application Maintenance Engineer
H/P – 9884947801
COSMOSOFT TECHNOLOGIES LIMITED
#141, Arcot Road, Kodambakkam
Chennai, Tamil Nadu, India - 600 024
Phone: 91-44-23723206 / 07 / 08
Mail: [email protected]
Web: www.ctlindia.com / www.cosmosoft.in <link updated to site home> (Search On Cite | Search On Google)
From India, Madras
Acknowledge(0)Amend(0)
Hi sonia, I hav checked ur excel sheet. I am new to this field, i want to confirm few things. Wot will happen if ur company is deducting PF & Gratuity also. Regards, Nidhi
From India, Delhi
Acknowledge(0)Amend(0)
From India, Delhi
Acknowledge(0)Amend(0)
Hi mastrs, i am julie ann,working in small company and i dont have knowledge yet about salary payroll.can you please send me a sample so that i can do it fast..??thank you..
From Qatar
Acknowledge(0)Amend(0)
From Qatar
Acknowledge(0)Amend(0)
Hi Jatin,
Do you have any of your centers in Pune? Also, how many days of time are needed to learn this, and what are the charges for the same?
Could you please email me the details at my ID, mhetar.namita@gmail.com?
Thank you.
From India, Pune
Acknowledge(0)Amend(0)
Do you have any of your centers in Pune? Also, how many days of time are needed to learn this, and what are the charges for the same?
Could you please email me the details at my ID, mhetar.namita@gmail.com?
Thank you.
From India, Pune
Acknowledge(0)Amend(0)
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)
From 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)
Dear sonia Thanks for your valuable information for me. And pls send me any information for the payroll and HR information also. And one second tell u Thanks Thanks Thanks Ramesh
From India, Madras
Acknowledge(0)Amend(0)
From India, Madras
Acknowledge(0)Amend(0)
i am new to payroll. man power of 5 pax only. please send me simple excell sheet for calculating payroll. the staff is still contract staff so they get fixed pay. the only deduction unpaid leave. TQ
From Malaysia, Kuala Lumpur
Acknowledge(0)Amend(0)
From Malaysia, Kuala Lumpur
Acknowledge(0)Amend(0)
Hi I want to start flexible staffing consultancy kindly provide me Terms & conditions between client & consultant. and share Contract Agreement. Regards Sachin Call:9368044499
From India, Bareilly
Acknowledge(0)Amend(0)
From India, Bareilly
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.
152120-very-use ful-hr-manageme nt-software-bui lt-excel-psa-hr -manager-mainta in-payrrol-exce l-soft.zip
Tangent HR Solutions.ppt