Dear Sir, I am looking for an excel worksheet that comprise all the required formulas to make a monthly payment to approximately 600 contractual employees. It should be contained from starting (Enrollment of employees) to completion of their monthly compliance of EPF & ESI in only one excel file.
It is requested to all of you please help me out in this regard if anyone has this type of excel working sheet which contain complete payroll.
From India, Delhi
It is requested to all of you please help me out in this regard if anyone has this type of excel working sheet which contain complete payroll.
From India, Delhi
For a payroll that large, I think you would be taking a risk with using Excel. The problem is even more acute when it appears you do not know much about using Excel, hence asking others to provide a ready made solution. If you don't have high level Excel skills, then how are you going to ensure everything runs correctly and have the ability to make changes to the sheet when rates of pay, deductions, statutory requirements etc, are changed?
For a payroll of this type, you are better to invest in a proper payroll system from a specialist software company. It will be cheaper in the long run, if your Excel spreadsheet fouls up the payroll one day, and you have 600 workers baying for blood.
You would be well advised to rethink this properly before moving on it.
From Australia, Melbourne
662For a payroll of this type, you are better to invest in a proper payroll system from a specialist software company. It will be cheaper in the long run, if your Excel spreadsheet fouls up the payroll one day, and you have 600 workers baying for blood.
You would be well advised to rethink this properly before moving on it.
From Australia, Melbourne
Though I agree with Aussiejohn on the risks involved in using Excel for managing large payrolls and the need for a proper payroll system, I must also play the devils advocate here.
My organisation eats, sleeps, dreams EXCEL... just about everything we do, we do in EXCEL; including payroll.
Our payroll strength has gone up to as big as 800 (daily wagers) at one point in time; and we used excel sheets without any issues. We have a seperate excel for PMT Staff & Workers
The keys for using excel are
a) design the workbook and sheets as per your requirement.
b) minimise data entry requirements (believe me, it can be done)
c) design input sheets also to match your main data sheets and use excel functions to copy data from input sheet to main sheet
d) use formulae, conditional formatting, plethora of excel built-in functions etc to maintain data integrity, non-duplication, data validation etc
e) Use lock / unlock cells to restrict editing rights to selected cells / rows / columns to only those areas where data entry is required.
f) protect the sheet with passwords
g) maintain a change log and strictly control the mods to the sheet.
h) maintain the sheets.
My payroll EXCEL has
a) a master sheet capturing all data of employee
b) a salary calculation sheet
c) PF ECR Sheet
d) ESI Upload Sheet
e) Payslip
f) Bank upload Sheet
g) Forms B, C & D
h) A macro to bulk print Pay slips (2 payslips per A4 sheet for daily wagers)
i) In case of PMT Salary Sheet, there is a macro to print payslip to PDF and generate an email to his given email ID.
Excel is extremely powerful, all you need is some knowledge and lots of curiosity, know what you need, design it well as per your requirement, minimise data entry / typing requirement, restrict mods and access (our payroll excel is accessed by just 4 people in the organisation), teach them how to use it and one can live comfortably with excel.
Necessity, they say, is the mother of invention, so we have learnt to tap deep into excel and exploit it well; but as aussiejohn said, a proper payroll / HRMS is probably a better solution.
Thanks and Regards
Arun
From India, Kochi
My organisation eats, sleeps, dreams EXCEL... just about everything we do, we do in EXCEL; including payroll.
Our payroll strength has gone up to as big as 800 (daily wagers) at one point in time; and we used excel sheets without any issues. We have a seperate excel for PMT Staff & Workers
The keys for using excel are
a) design the workbook and sheets as per your requirement.
b) minimise data entry requirements (believe me, it can be done)
c) design input sheets also to match your main data sheets and use excel functions to copy data from input sheet to main sheet
d) use formulae, conditional formatting, plethora of excel built-in functions etc to maintain data integrity, non-duplication, data validation etc
e) Use lock / unlock cells to restrict editing rights to selected cells / rows / columns to only those areas where data entry is required.
f) protect the sheet with passwords
g) maintain a change log and strictly control the mods to the sheet.
h) maintain the sheets.
My payroll EXCEL has
a) a master sheet capturing all data of employee
b) a salary calculation sheet
c) PF ECR Sheet
d) ESI Upload Sheet
e) Payslip
f) Bank upload Sheet
g) Forms B, C & D
h) A macro to bulk print Pay slips (2 payslips per A4 sheet for daily wagers)
i) In case of PMT Salary Sheet, there is a macro to print payslip to PDF and generate an email to his given email ID.
Excel is extremely powerful, all you need is some knowledge and lots of curiosity, know what you need, design it well as per your requirement, minimise data entry / typing requirement, restrict mods and access (our payroll excel is accessed by just 4 people in the organisation), teach them how to use it and one can live comfortably with excel.
Necessity, they say, is the mother of invention, so we have learnt to tap deep into excel and exploit it well; but as aussiejohn said, a proper payroll / HRMS is probably a better solution.
Thanks and Regards
Arun
From India, Kochi
Arun,
Agree with what you say, I too eat, sleep and dream of Excel, it's my favourite software to play with. Beats silly games any day.
However, as you say, you can do this given the deep level of skill you have with Excel. The nature of the OP's enquiry leads me to believe that he has no deep level skill of Excel that he would need, or else he would have developed the spreadsheet and be using it. Even if someone supplied him with a sheet, he has no skills to update or test it when statutory requirements change.
Pay is a fundamental thing when it comes to workers. They may tolerate a lot of other things, but mess up their pay, and all hell breaks loose.
In recent years here in Australia we have had a lot of cases of chronic underpayment of salaries and wages. The companies so far exposed are complaining about software errors and of course staff not checking their work etc. Many of these companies are now liable for tens of millions of dollars to repay employees salary arrears. That doesn't include the cost of fixing the software errors, retraining payroll staff, or the fines imposed by the authorities. To be fair, those companies weren't using Excel, but large HR based software that manages most of their operations. But the problem is the same - whatever you use, it's got to be accurate.
From Australia, Melbourne
Agree with what you say, I too eat, sleep and dream of Excel, it's my favourite software to play with. Beats silly games any day.
However, as you say, you can do this given the deep level of skill you have with Excel. The nature of the OP's enquiry leads me to believe that he has no deep level skill of Excel that he would need, or else he would have developed the spreadsheet and be using it. Even if someone supplied him with a sheet, he has no skills to update or test it when statutory requirements change.
Pay is a fundamental thing when it comes to workers. They may tolerate a lot of other things, but mess up their pay, and all hell breaks loose.
In recent years here in Australia we have had a lot of cases of chronic underpayment of salaries and wages. The companies so far exposed are complaining about software errors and of course staff not checking their work etc. Many of these companies are now liable for tens of millions of dollars to repay employees salary arrears. That doesn't include the cost of fixing the software errors, retraining payroll staff, or the fines imposed by the authorities. To be fair, those companies weren't using Excel, but large HR based software that manages most of their operations. But the problem is the same - whatever you use, it's got to be accurate.
From Australia, Melbourne
John,
Agree with you 100%.
Yes, creating and maintaining Excel sheets does require some in-depth knowledge and an aptitude for "problem-solving".
Once created, whether it is a software or excel sheets, the final output will of course depend on the user, regular maintenance & updates.
The thing with Excel is that companies will require someone in-house to do it, unlike a software.
Otherwise t will always be Garbage in Garbage Out.
Regards.
From India, Kochi
Agree with you 100%.
Yes, creating and maintaining Excel sheets does require some in-depth knowledge and an aptitude for "problem-solving".
Once created, whether it is a software or excel sheets, the final output will of course depend on the user, regular maintenance & updates.
The thing with Excel is that companies will require someone in-house to do it, unlike a software.
Otherwise t will always be Garbage in Garbage Out.
Regards.
From India, Kochi
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.
PAYROLL SOLUTION IN SINGLE SHEET.zip
Payroll Solution in single Sheet.xls