Make two columns next to it and add the Actual salary of the employee and Earnings in another column. In one column, you can add the earning details such as Basic wage, HRA, Medical allowances, Conveyance, and other special allowances. You can also find many free versions available on the internet.ġ) Once you open MS Excel, create a file name and save it in a location from where you can access it easily.Ģ) Open a new Excel Sheet and write your company name, company address, month & year of the salary slip within the first three rows.ģ) Make two columns and enter the general details of the employee like Name, designation, ID, Department, Date of Joining (DOJ), Bank details, Attendance details, and any other information you feel is required.Ĥ) Leave a row and start by entering the employee's salary structure in the columns as shown in the image. Here are the steps you need to follow to create a salary slip format in Excel.įirst, make sure you have MS Excel working on your computer system. How do you make a Salary Slip Format in Excel? Salary Slip is also referred to as Payslip, as it contains payroll details of the employees.Įach organisation has its Salary Slip Format designed mainly by an HR or an Accountant to keep track of employees' salary details. Usually, a Salary Slip contains the Name of the Organisation, Employee Name, Employee ID, Date/Month, Attendance for that month, Employee Bank A/C details, Gross Salary, Provident Fund, Home Rent Allowance, Deductions, Bonus, and more. So, let's discuss all the topics related to the professional salary slip format in this blog.Ģ) How do you make a Salary Slip format in Excel?ģ) Examples of simple Salary Slip format in ExcelĤ) Why and where is a Salary Slip Needed?ĥ) What are the components of a Salary Slipħ) Advantages of Excel Spreadsheets to format Salary SlipĪ Salary Slip is a report generated by an organisation to keep employees' payroll, attendance, and other job-related information on record. Read this blog to create a Salary Slip Format in Excel with the right formula and components of salary slips to make functional payslips/monthly salary slips for the company.

According to research conducted by Statista, 86% of US companies use Microsoft Excel for various tasks. Moreover, you can also download from variety of Salary Slip Formats from the internet and use them in Excel.

Microsoft Excel is one of the widely used tools for creating Salary Slip Formats because it allows you to create own formats and use them forever. Companies use the Salary Slip Format to maintain a record of the monthly payroll of the employees.

Ctc salary slip format