Excel Payslip Template

As an employee, we all get salary receipts, the so-called “payslip,” from our employers, which is an acknowledgment of salary credited to the employee account. In the modern world, corporate companies use sophisticated software to prepare their employees’ payslips, but we can still rely on Excel to prepare them. This article will show you how to build a free payslip template in Excel.

Payslip or salary slip template in Excel is the receipt given by the employer to their employees every month upon payment of salary to the employee for the services rendered in the month. A payslip consists of all kinds of earnings and deductions under various heads as per the norms given by the government in the respective financial year.

You are free to use this image on you website, templates, etc., Please provide us with an attribution linkHow to Provide Attribution?Article Link to be HyperlinkedFor eg:Source: Payslip Template in Excel (wallstreetmojo.com)

Examples of Free Payslip Template in Excel

Let us follow the below steps to build a free payslip Excel template on your own.

Payslip for Not Registered Companies

For small industries not registered with the company, secretaries will not have any TDS, PF, or ESI deductions. For them, it is simple to make a payslip.

  • You first need to set up general information about the company. For example, we should include the company name, address, phone number, and logo. After that, you can have any other information regarding the company. Next, you need to specify which month your salary is paid for. Next, you have to include all the information related to employees. Employee information should consist of the following items. Employee name, ID, designation, department, gender, date of joining, and location. Once the employee information is provided, we need to show the employee’s bank account number, bank name, UAN number, ESI number, and PAN number. Next, you need to show the period of paid days, LOP days, and days in a month. Once employer and employee information is inserted, we need to insert salary details per the break-up. First, include gross salary as per break-up.The salary structure includes “basic salary,” “HRA,” and “special allowances.” These elements are common elements of a fixed salary. We need to include other earnings like incentives, bonuses, overtime, etc. Once the earning part is decided, we need to mention the deductions under various heads per the government’s rules. The deduction may include Provident Fund, ESI, Professional Tax, Income Tax (TDS), or salary advance (If any). Of course, you can also consist of any other deductions.When you include deductions, you must be careful about Professional Tax, Provident Fund, and income tax calculations.The Provident Fund will be 12% of basic pay. The Professional Tax will be ₹200 if the gross salary is more than ₹15,000 or ₹150.The income tax calculations should be as per the rules and regulations of the government. You need to calculate TDS after deducting exemptions, so maintain an individual working for this. It is always a good practice to hire a good professional or consultant who is an expert in these matters. Next, we need to arrive at the net pay amount. To calculate this, apply the formula: Total Earnings – Total Deductions. So, once the net payment arrives, the payslip format is ready to use. It looks like this.

Employee name, ID, designation, department, gender, date of joining, and location.

First, include gross salary as per break-up.The salary structure includes “basic salary,” “HRA,” and “special allowances.” These elements are common elements of a fixed salary.

The deduction may include Provident Fund, ESI, Professional Tax, Income Tax (TDS), or salary advance (If any). Of course, you can also consist of any other deductions.When you include deductions, you must be careful about Professional Tax, Provident Fund, and income tax calculations.The Provident Fund will be 12% of basic pay. The Professional Tax will be ₹200 if the gross salary is more than ₹15,000 or ₹150.The income tax calculations should be as per the rules and regulations of the government. You need to calculate TDS after deducting exemptions, so maintain an individual working for this. It is always a good practice to hire a good professional or consultant who is an expert in these matters.

Keeping in mind those unorganized industries, we also provide a payslip templatePayslip TemplatePayslips or salary slips are issued by every organization to its employees whenever the employer clears the salary for the period. A payslip offers a breakdown of the earnings and deductions of an employee in detail.read more for them.

Small industries include basic salaries as part of their salary structure.

In small industries, employees work overtime most of the time. In such cases, factories pay overtime wages at 1.5 times of regular payment.

The overtime amount is calculated hourly, so it is important to mention OT hours, rate, and amount.

So, the basic and OT payment gives the total payment.

Next, in small industries, the deduction part includes only “salary advances,” so provide this column under deductions.

So, now arrives the final net pay.

Things to Remember

  • The payslip looks beautiful, but the payrollPayrollPayroll refers to the overall compensation payable by any organization to its employees on a certain date for a specific period of services they have provided in the entity. This total net pay comprises salary, wages, bonus, commission, deduction, perquisites, and other benefits.read more team must put much effort into arriving at the net payNet PayEmployees’ net pay, often known as take-home pay, is their salary after all deductions.read more amount.In today’s sophisticated software, we can design anything and everything. All the complicated calculations are automated in that.We must download the template and modify the contents; if the organization’s salary structure is different.The TDS calculations are complicated. So always keep yourself up to date with rules.

This article is a guide to the Payslip Template in Excel. We discuss building a free payslip template in Excel using formulas with a downloadable Excel sheet. You can also learn more about Excel from the following articles: –

  • Top 5 Accounting Templates in ExcelBreak-Even Point in ExcelCreate a Database Template in ExcelCreate a Blank Invoice Template in Excel