24th May 2016 From India, Chennai
Before asking people for passwords etc, you might need to brush up on your Excel skills.
There is no problem with the spreadsheet. I have just downloaded it and had a play with it.
All the data entry is done on Sheet 1 and that is NOT protected.
The remaining sheets take the data that you enter on Sheet 1 and create the reports and salary slips.
So replace the data on Sheet 1 with your data, and your problem is solved.
25th May 2016 From Australia, Melbourne
I have modified the sheet according to some suggestion received.
- Enabled Selection in the protected sheets.
- PF Rate input
- OT Rate input
26th May 2016 From India, Delhi
You can refer to this salary calculator in the article - What should you consider for the perfect performance appraisal?
It also explains the ideal structure as well with all the complaince guidelines .
27th May 2016 From India, Mumbai
26th May 2018 From India, Noida
I working as Accounts Assistant in a small startup Company. Ten employees are working in my company, company functioning from June 2018. I am coming from Computer Science background so don't know accounts in details. Company asked me to create a template for Salary slip.
I searched in the web and found your file(Salary Calculation Sheet_Revised.xls) in it. According to my company salary data, I want to customize some fields in Salary sheet in Gross salary and deductions. So kindly request you to mail the password for that file. I attached the same file in the attachment. My E-mail id :
31st December 2018 From India, Chennai