Dear All,
We have an employee strength of around 200, and we have to prepare the salary in Excel. How will we maintain the employee database and leave records, and how will we compute the salary after adjusting the leaves with pay and without pay? Please demonstrate. It's very urgent.
Thanks,
Anisha Mittal
From India, Delhi
Acknowledge(0)
Amend(0)
11We have an employee strength of around 200, and we have to prepare the salary in Excel. How will we maintain the employee database and leave records, and how will we compute the salary after adjusting the leaves with pay and without pay? Please demonstrate. It's very urgent.
Thanks,
Anisha Mittal
From India, Delhi
Acknowledge(0)Amend(0)
Hi, If you will call me, so that we can understand exact requirement. And we have many type format for the same. Regards, Shyam +91 99115 27513
From India, Delhi
Acknowledge(0)Amend(0)
From India, Delhi
Acknowledge(0)Amend(0)
Dear Anisha,
Why don't you use a payroll software for the same which will not only calculate your salary within seconds but also automatically generate many reports like PF/ESI statements, salary register, salary slip, etc.
We are providing payroll software that meets all your requirements. It includes all the features required in the best payroll software such as salary calculation, salary register, salary slip, PF reports, ESI calculation, and attendance card. Its reports are customizable according to your needs. It is faster than any other payroll software available; for example, it calculates the salary of 1000 employees in less than 5 seconds. Its unique design makes it more reliable and easy to use for the end user. For your queries, contact the numbers provided below.
Thanks
From India, Chandigarh
Acknowledge(0)Amend(0)
Why don't you use a payroll software for the same which will not only calculate your salary within seconds but also automatically generate many reports like PF/ESI statements, salary register, salary slip, etc.
We are providing payroll software that meets all your requirements. It includes all the features required in the best payroll software such as salary calculation, salary register, salary slip, PF reports, ESI calculation, and attendance card. Its reports are customizable according to your needs. It is faster than any other payroll software available; for example, it calculates the salary of 1000 employees in less than 5 seconds. Its unique design makes it more reliable and easy to use for the end user. For your queries, contact the numbers provided below.
Thanks
From India, Chandigarh
Acknowledge(0)Amend(0)
Hello Anisha I would suggest you to maintain payroll in tally 9.1 ERP. In excel there is chance of mistake.
From India, Pune
Acknowledge(0)Amend(0)
From India, Pune
Acknowledge(0)Amend(0)
Actually, presently where I am working, we use an internal software to calculate the salary. I am looking for a job change and have applied to a couple of companies where they have a staff of over 200 employees. I don't even know if they have any software to compute the salary. That's why I posted a query: Is it possible to compute a salary in Excel if, in the attendance report, an employee takes a leave and they also have leave balance in their account? How would you keep a record of that and calculate the salary accordingly? I have not yet received a satisfactory answer. Please help me out.
Thanks & Regards,
Anisha Mittal
From India, Delhi
Acknowledge(0)Amend(0)
Thanks & Regards,
Anisha Mittal
From India, Delhi
Acknowledge(0)Amend(0)
Well, dear, it is very hard to manage all these details in Excel files regarding paid leave details, remaining paid leaves, and most of the time it leads to critical errors in salary calculations. If you join any company that does not have any payroll software, then you can suggest to them to buy a payroll software, which is also beneficial for them and saves a lot of your time.
From India, Chandigarh
Acknowledge(0)Amend(0)
From India, Chandigarh
Acknowledge(0)Amend(0)
Hi, It is very easy maintain on excel....can you please send me any roughly data, so that we can prepare and send it to you on excel sheet. With best regards, Shyam Sundar
From India, Delhi
Acknowledge(0)Amend(0)
From India, Delhi
Acknowledge(0)Amend(0)
Dear All, I need to maintain the salary of all employees in excel (year on year) from the date of joining till current . Can anyone suggest a format for the same. Regards Shailaja
From India, Mumbai
Acknowledge(0)Amend(0)
From India, Mumbai
Acknowledge(0)Amend(0)
Dear User,
I have been managing payroll in Excel. I have attached a format for your reference. Most of the Excel sheets are linked (formula-based). Anyone using this format only needs to maintain the Attendance sheet of the current month (Apr 2018). The rest of the sheets, including paysheet, payslip, PF, ESI, leaves, and advances, are all interconnected and automatically change without the need for manual inputs. The only column that requires input is the "working days" column in the paysheet where you need to enter the number of days in that month (e.g., Feb=28, Apr=30, May=31). In the Attendance sheet (Apr 2018), you need to add or delete columns based on the number of days in the month.
For those who wish to handle payroll in Excel, you can utilize this format for review by your superiors. However, please exercise caution when working on payroll in Excel as mistakes can occur if not approached with seriousness and attention to detail. Even a small error like a difference of 1 Rs. or mismanagement of leave could lead to serious consequences, including job loss. Therefore, be meticulous while handling payroll in Excel.
If any Excel sheet is not linked, ensure to connect it properly with the correct formulas.
Thanks & Regards,
Hari Kumar
From India, Hyderabad
Acknowledge(0)Amend(0)
I have been managing payroll in Excel. I have attached a format for your reference. Most of the Excel sheets are linked (formula-based). Anyone using this format only needs to maintain the Attendance sheet of the current month (Apr 2018). The rest of the sheets, including paysheet, payslip, PF, ESI, leaves, and advances, are all interconnected and automatically change without the need for manual inputs. The only column that requires input is the "working days" column in the paysheet where you need to enter the number of days in that month (e.g., Feb=28, Apr=30, May=31). In the Attendance sheet (Apr 2018), you need to add or delete columns based on the number of days in the month.
For those who wish to handle payroll in Excel, you can utilize this format for review by your superiors. However, please exercise caution when working on payroll in Excel as mistakes can occur if not approached with seriousness and attention to detail. Even a small error like a difference of 1 Rs. or mismanagement of leave could lead to serious consequences, including job loss. Therefore, be meticulous while handling payroll in Excel.
If any Excel sheet is not linked, ensure to connect it properly with the correct formulas.
Thanks & Regards,
Hari Kumar
From India, Hyderabad
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.