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.
23rd July 2012 From India, Chandigarh
Thanks & Regards
23rd July 2012 From India, Delhi
24th July 2012 From India, Chandigarh
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,
28th April 2018 From India, Hyderabad