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. In addition, if you have taken advance salary, then your interest is calculated in the company after that, the Contribution Fund. Table of Contents What is CTC What is Salary Breakup How is Salary Structure Determined Components of Salary Breakup Structure 1. 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. Every employer needs to pay 13 of the employee’s basic salary towards the EPF account of the employee and 3.25 of the employee’s gross salary as ESIC contribution if applicable. The calculation for TDS on salary is done by reducing the amount of exemption from the total annual salaried income of the employee.

Salary slip format in excel with formula in india