Please check if this attachment would be of any help to you. You just have to enter the salary of the employee in the Gross Salary column and also input the number of working days in the Working Days column. The spreadsheet will automatically calculate the Net Salary for you.
Hi Saritha, the Excel sheet is good. Moreover, it depends upon the management as well. In that payroll, there is no calculation for PF contribution.
Hi Archana, kindly tell me the nature of the business and the approximate wage range. If wages are less, then there is no need for a complicated process.
I agree with you that it differs from company to company and also depends on the management. I actually forgot to add the formula in the PF column, where the calculation wasn't shown.
I apologize for bringing up the issue of PF calculation. I am a bit confused about the attendance allowance in both breakdowns and deductions. I believe the allowance should only be included in the breakdowns. If there is no attendance allowance, then there won't be any allowance; however, if there is, then we will provide the allowance.
Moreover, please note that the PT slabs vary from state to state. The PT slabs mentioned are accurate only for Karnataka.
The breakup of salary differs as per the company's discretion. The allowances also vary. Please refer to the salary breakup format provided by our dear friend Saritha and discuss it with the management.
Can anyone help me create a Salary Calculator for a startup? I only need calculations for Basic, HRA, Conv, Special, and PF. That's all. Please share immediately.
Is it important to deduct tax from the payslip? If yes, then how much do we need to deduct in Delhi?
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