salary slip format in excel with formula free download

The Salary slip format in excel with formula is different for a different industry.

For example incentives, allowances, deductions, attendance and leave records, etc. As well as salary paid to any employee those include basic salary. What is the Monthly Salary Slip Format in Excel?Īll documents all about salary slip is the way of documents which contains all information about salary. The salary special allowances exempt in some cases like other allowances that include LTA (Leave Travel Allowance), travel allowance, and HRA (House Rent Allowance). Special allowances have appeared on the earning side of the salary statement. They are given to the employees to motivate and encourage them to work better. Net payment amount= total earnings- total deductionsĪs you find the net payment amount, your salary slip format is ready to use.Įmployers provide special allowances to their employees to meet certain needs over and above their salaries. You can calculate a net payment amount by the following formula

The last step is to reach the net payment amount.

These deductions involve provident fund, ESI, professional tax, income tax (TDS), and any other deductions as well (advance salary).

After done with the earning section, state all the deductions as per the rules of the government.

Now you can add additional earnings such as incentives, bonuses, overtime, etc.

These are the basic components of a fixed salary. The structure of salary contains “Basic Salary,” “HRA,” and “Special Allowances”. At first, add the gross salary as per break-up.

When the above steps are completed insert the salary details as per break-up.

Next, provide the information about the interval of paid days LOP days, and days in a month.

After entering an employees’ general information provide his/her bank account number, bank name, UAN number, ESI, and PAN number.It may include an employee’s name, number, gender, designation, department, ID, date of joining, and address. Then, include all the information about the employee.Next, state that which month salary you are going to pay for.It may include company name, address, phone number, company logo, and any other information that you want regarding the company. At first, add general information about the company.Below we are going to discuss step-by-step how to create a salary slip in MS Excel

Salary slip format in excel with formula free download