For this reason, I have selected the Basic Salary as 45% of the Gross Salary. In this part, I will calculate the total earnings of the employee. Read More: How to Make a Cash Payment Voucher Format in Excel In addition to these, this part includes total working days, LOPs (Loss of Paydays), and bank details of the employee. Secondly, provide the employee details such as name of the employee, ID, designation, department, joining date and many more. Step 2: Create Employee Details to Create Salary Payment Voucher Format Initially, write down the name of the company, company location, and payment voucher month and year in the first rows of the file. Now, I will create a salary payment voucher format for him. For the purpose of demonstration, I have selected an employee named Michael Scott from ABC Company. Just you have to follow the steps mentioned below in order to properly complete the operation.

Step-by-Step Procedure to Create a Salary Payment Voucher Format in Excelįortunately, you can create a salary payment voucher format in Excel easily. It includes financial data for employees, including their salaries, earnings, leave time, deductions, bonuses, and other benefits. It is known as a salary sheet or salary payment voucher. The Human Resource department creates this document to determine the compensation of its employees in a business. It contains information about employees’ base salary, allowances, health insurance, deductions, overtime and many more. 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.

Cash salary slip format in excel