salary slip format in excel with formula in india

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. No Designation Department Bank Name A/c No. 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.

It provides the detailed structure of the salary at a glance.

All elements of the salary breakup, including the deductions, are enlisted in a payslip or a salary slip. It is a monthly statement that consists of the details about all the components of the salary. If you live in the metro cities, then you will also get rent bill from the company. A Payslip or Salary Slip is a document provided by the employer to all the employees. 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.

Salary slip format in excel with formula in india