You can calculate this with your salary slip. In the salary slip, you get all the information, So that you can easily calculate how much your income is and how much your deduction is and in what things your deduction has been done and in which things your income is increased. If you have taken any loans, then their deduction is in it. In addition, if you have taken advance salary, then your interest is calculated in the company after that, the Contribution Fund. Some of these are Professional tax, Income tax.

Many types of Deductions included inside the company. 50% of the minimum wage for those working in metro cities (40 percent of basic salary for non-metros).Īpart from this, you get many types of allowances which include Traveling, Medical and Children’s Education, this whole depends on company to company fix amount which is given to you. It depends on company to company, how much will that amount be. If you live in the metro cities, then you will also get rent bill from the company. Salary slip is very different, it differs from company to company and industry, but if we follow the general format, then the salary slip consists of basically two components, in which you have to earn your income in one component and deductions in the other component.Īccording to the value you have created in the company, you call them income. While every company has to provide you Pay Slips, few companies even offer a print of payslip to their employee or email salary slip in PDF format to their employees so that we can download the payslip anytime.Free Salary Slip format in excel In India

You dont need to be a designer to create a payroll template that will hold up through thousands of pay cycles but that can be adjusted to reflect changing needs such as costs, base pay and raises. That’s why according to law, it is your right to ask for the Pay Slip if your company is not issuing it. These Excel templates can be adjusted to reflect hourly rates and overtime, salaries, taxes and withholdings that apply to your business. The employee Salary Slip is a very important legal document proof for his earnings. are exempt from the tax deductionĪdditionally, Payslip is very important for applying credit card, loans, mortgage of houses and the government benefits such as tax benefits, subsidy and medical benefits.

Telephone bills reimbursement, Medical reimbursements etc.

Performance Bonus and Special Allowance.

Income(Gross Salary + Other Income) – DeductionsĬTC= Total salary package of the employeeīasic Salary + HRA + Allowances – Income Tax – Employer’s Provident Fund – Professional Tax It can help to calculate the Gross earnings and deductions. Here we prepared few Salary Slip Excel Formats with predefined formulas. The format of Payslip consists of all earnings (fixed and variable) and deductions (fixed and variable) along with the mandatory tax deductions like TDS and FBT.

Salary pay slip excel format