Dear Respected Seniors,
For my own learning, I have created sample payroll sheet that is similar to the payroll file used by payroll team in my office during payroll month. I had the chance to take a look at the file but I am not handling payroll matters as part of my KRA.
Request you to please check and correct columns S and T (PF Employee&Employer Contribution), Column V (TDS) as I am not sure regarding formula and calculation to be used. In addition, the payroll team would not bother to have a look at this sample file and I really want to improve my skills/domain knowledge in the HR industry in years to come.
I would really appreciate your kind feedback, if you suggest more columns then please do so. Basic Salary and HRA is kept at 50%.
Thanks and Regards,
Akash Sharma
For my own learning, I have created sample payroll sheet that is similar to the payroll file used by payroll team in my office during payroll month. I had the chance to take a look at the file but I am not handling payroll matters as part of my KRA.
Request you to please check and correct columns S and T (PF Employee&Employer Contribution), Column V (TDS) as I am not sure regarding formula and calculation to be used. In addition, the payroll team would not bother to have a look at this sample file and I really want to improve my skills/domain knowledge in the HR industry in years to come.
I would really appreciate your kind feedback, if you suggest more columns then please do so. Basic Salary and HRA is kept at 50%.
Thanks and Regards,
Akash Sharma
1 Attachment(s) [Login To View]