Need Help with Excel Payroll Template: How to Calculate Salary, Deductions, and Taxes?

sgenius
Please, can anyone provide a sample of payroll in Excel that shows salary calculation, ESIC deduction salary-wise percentage, PF deduction salary-wise, and profession tax deduction salary-wise? Additionally, I would like it to display gross and net salary. If income tax deduction is also included in the salary details, that would be helpful.

Regards,
Rajiv
navneetha1
I am outlining the scenarios in which we do not pay ESI. Please refer to the attached file, where you can modify the basics to view different breakup options. If you require ESI deductions as well, I will do my best to assist you.

Regards,
Navneetha :) :)
1 Attachment(s) [Login To View]

If you are knowledgeable about any fact, resource or experience related to this topic - please add your views. For articles and copyrighted material please only cite the original source link. Each contribution will make this page a resource useful for everyone. Join To Contribute