# How to Create a Salary Payment Voucher Format in Excel

### Step 1 – Enter Company Details

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

### Step 2 – Create Employee Details to Create Salary Payment Voucher Format

Add the employee details such as name of the employee, ID, designation, department, joining date, total working days, LOPs (Loss of Paydays), and bank details.

### Step 3 – Calculate Earnings

Let’s assume the Basic Salary is 45% of the Gross Salary.

Add the following formula in cell C14.

`=(C12/E7)*E9*45%`

We have taken the House Rent Allowances as 40% of the Basic Salary,Â Conveyance Allowances as \$1600, Medical Allowances as \$1250, and some Special Allowances for a total of 30 working days.

Input the following formula to calculate the Net Salary.

`=SUM(C14:C18)`

The Net Salary will be displayed as shown in the image.

### Step 4 – Calculate Deductions

Enter the formula below to calculate EPF.

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

Calculate Health Insurance and sum them to find the Total Deductions.

### Step 5 – Estimate Net Pay

Add the following formula to calculate the Net Pay of the employee.

`=C19-E19`

It will output the salary payment voucher.

## Related Articles

<< Go Back to Payment Voucher |Â Finance Template |Â Excel Templates

Get FREE Advanced Excel Exercises with Solutions!
Mehedi Hasan

Mehedi Hasan, a BSc graduate in Naval Architecture & Engineering from Bangladesh University of Engineering and Technology, plays a pivotal role as an Excel & VBA Content Developer at ExcelDemy. Fueled by a profound passion for research and innovation, he actively engages with Excel. In his capacity, Mehedi not only adeptly tackles intricate challenges but also showcases enthusiasm and expertise in navigating tough situations with finesse, underscoring his unwavering dedication to consistently delivering exceptional and high-quality content. He... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF