Aa_somani
Accounts & Finance
Viksat
Software Developer
+2 Others

Dear All,
We have an employee strength of around 200 and we have to prepare the salary in excel only then how we will maintain the employee database and leave record and how we will compute the salary after adjusted the leaves with pay and without pay. Please demonstrate it.Its very urgent...
Thanks
Anisha Mittal
22nd July 2012 From India, Delhi
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
22nd July 2012 From India, Delhi
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 requirement. It include all the features which are required in a best payroll software such as salary calculation, salary register, salary slip, PF reports, ESI calculation, attendance card. Its reports are customizable according to your requirements. Its fastest then any other payroll software available for example : It calculate salary of 1000 employees in less then 5 seconds. Its unique design make it more reliable & easy to use for end user. For your queries contact at below given contact numbers.
Thanks
23rd July 2012 From India, Chandigarh
Hello Anisha I would suggest you to maintain payroll in tally 9.1 ERP. In excel there is chance of mistake.
23rd July 2012 From India, Pune
Actually presently where i am working we uses an internal software to calculate the salary.I am looking for a job change and i have applied in couple of company where they have a strength of over 200 employees and don't know even they have any software to compute the salary.That's why i posted a query that is it possible to compute a salary in excel if in the attendence report any employee takes a leave and they have also leave balance in their a/c then how will you to keep a record of that and calculate the salary accordingly. Still not recieved satisfactorily answer.Please help me out.
Thanks & Regards
Anisha Mittal
23rd July 2012 From India, Delhi
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 your join any company which do not have any payroll software then you can suggest them to buy a payroll software which is also beneficial for them and save a lot of your time.
24th July 2012 From India, Chandigarh
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
27th July 2012 From India, Delhi
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
25th April 2018 From India, Mumbai
#Anonymous
Dear User,
I have been doing payroll in excel only I have attached a format for your reference. Most of the excel sheets are linked (formula based) . Any one using this format have to maintain only Attendance sheet of current month (Apr 2018), rest paysheet, payslip, pf, esi, leaves and advances all are interlinked and automatically changes no need to give inputs except in paysheet -working days column you have to give that month days (like Feb=28, Apr=30, May=31). In attendance sheet (Apr 2018) you have to add one more column in the middle for 31 days or delete one or two columns for 30 days or 28 days.
For those who want to do payroll in excel can use it and get appraised by your superiors.
One thing be careful while doing payroll in excel there will be lot of mistakes if you don't take it seriously and work. If an employee gets even 1 rs. less or 1 leave is wasted or if you give loss of pay then you will lose your job. Be careful while doing payroll in excel.
If any excel sheet is not linked then carefully link it with proper formula.
Thanks & Regards,
Hari Kumar
28th April 2018 From India, Hyderabad

Attached Files
Membership is required for download. Create An Account First
File Type: xls Payroll Data Format in Excel.xls (4.69 MB, 1060 views)

Hello,
This Data base was so helpfull but its coded,is there any way one would obtain the excel sheet password to be able to modify it accordingly.
thank you
my personal email is
30th July 2019 From Rwanda, Kigali
Add Reply Start A New Discussion

Cite.Co - is a repository of information created by your industry peers and experienced seniors. Register Here and help by adding your inputs to this topic/query page.
Prime Sponsor: TALENTEDGE - Certification Courses for career growth from top institutes like IIM / XLRI direct to device (online digital learning)





About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service



All rights reserved @ 2019 Cite.Co™