How to Create a Salary Payment Voucher Format in Excel

Get FREE Advanced Excel Exercises with Solutions!

Microsoft Excel is a powerful program. In addition to this, it is quite easy and handy to operate. Also, productivity and utilization are increasing day by day. Fortunately, it can be used in all government and private organizations for various purposes. However, we can also utilize this software in order to prepare a salary payment voucher format. In this article, I will show you a step by step procedure to create a salary payment voucher format in Excel. Go through it carefully and save your time.


What Is Salary Payment Voucher Format?

Usually, a salary payment voucher contains all the information regarding the payment due to an employee for various tasks completed by him during a specific time period. It contains information about employees’ base salary, allowances, health insurance,  deductions, overtime and many more. The Human Resource department creates this document to determine the compensation of its employees in a business. It is known as a salary sheet or salary payment voucher. It includes financial data for employees, including their salaries, earnings, leave time, deductions, bonuses, and other benefits.


How to Create a Salary Payment Voucher Format in Excel: Step-by-Step Procedures

Fortunately, you can create a salary payment voucher format in Excel easily. Just you have to follow the steps mentioned below in order to properly complete the operation. For the purpose of demonstration, I have selected an employee named Michael Scott from ABC Company. Now, I will create a salary payment voucher format for him.


Step 1: Enter Company Details

Initially, write down the name of the company, company location, and payment voucher month and year in the first rows of the file.

Enter Company Details to Create a Salary Payment Voucher Format in Excel


Step 2: Create Employee Details to Create Salary Payment Voucher Format

Secondly, provide the employee details such as name of the employee, ID, designation, department, joining date and many more. In addition to these, this part includes total working days, LOPs (Loss of Paydays), and bank details of the employee.

Create Employee Details to Form a Salary Payment Voucher Format in Excel

Read More: How to Make a Cash Payment Voucher Format in Excel


Step 3: Calculate Earnings

In this part, I will calculate the total earnings of the employee. For this reason, I have selected the Basic Salary as 45% of the Gross Salary. Write down the following formula in cell C14.

=(C12/E7)*E9*45%

Calculate Earnings to Create a Salary Payment Voucher Format in Excel

Similarly, I have chosen the House Rent Allowances as 40% of the Basic Salary and Conveyance Allowances as 1600$, Medical Allowances as 1250$ and some Special Allowances for a total of 30 working days.

Now, input the following formula in order to calculate the Net Salary. Here, I have used the SUM function.

=SUM(C14:C18)

Lastly, you will receive the Net Salary as shown in the below picture.

Read More: How to Create Payment Advice Format in Excel


Step 4: Calculate Deductions

Furthermore, I have calculated EPF, Health Insurance and other taxes to deduct from Net Salary. At first, enter the formula below to calculate EPF. In this case, I have utilized the IF function.

=IF(C14>=15000,15000*12%,C14*12%)

Calculate Deductions to Create a Salary Payment Voucher Format in Excel

Similarly, you can calculate Health Insurance and sum them in order to find the Total Deductions.

Read More: How to Make Petty Cash Payment Voucher Format in Excel


Step 5: Estimate Net Pay

Finally, insert the following formula in order to calculate the Net Pay of the employee.

=C19-E19

Estimate Net Pay to Create a Salary Payment Voucher Format in Excel

Lastly, the salary payment voucher is ready as shown in the image below.


💬 Things to Remember

  • You can change the employee details and gross salary according to your company.
  • Moreover, I have chosen Earnings and Deductions However, you can easily change them according to your company structure.

Download Practice Workbook

You can download the workbook used for the demonstration from the download link below.


Conclusion

These are all the steps you can follow to create a salary payment voucher format in Excel. Hopefully, you can now easily create the needed adjustments. I sincerely hope you learned something and enjoyed this guide. Please let us know in the comments section below if you have any queries or recommendations.


Related Articles

What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Mehedi Hasan
Mehedi Hasan

Hi, I am Mehedi. I have completed my B.Sc. from Bangladesh University of Engineering and Technology. I have a strong interest in innovation and research in the field of Data Science and Machine Learning. Gradually, I now understand the value of Data Analysis and I am trying to learn everyday.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo