How to Make Petty Cash Payment Voucher Format in Excel

Get FREE Advanced Excel Exercises with Solutions!

A cash payment voucher is a document containing the cash flow disbursement and the cause of the transaction. When you handle a small amount of cash, you need to make a petty cash payment voucher. Microsoft Excel provides us with enormous features to make petty cash payment vouchers. Following some straightforward steps, you can make a petty cash payment voucher format in Excel. In this article, we will show you the simple steps to make it. So, let’s get started.


What Is a Petty Cash Payment Voucher?

Petty means little. Whenever you deal with a small amount of cash payment voucher, it is called a petty cash payment voucher. It is a very boring and ineffective way to make a payment for a small amount with a cheque. So, this little amount of money is always dealt with in cash. For this reason, we have to make a petty cash payment voucher. It is the cash disbursement form with the payment and the cause of the payment.


How to Make Petty Cash Payment Voucher Format in Excel: 5 Easy Steps

To create a petty cash payment voucher, simply follow the steps outlined below. It will provide a clearer concept of the petty cash payment voucher. Here, we attach the basic outlook of a voucher.

Petty Cash Payment Voucher Format

Not to mention, we have used the Microsoft 365 version. You can use any other version at your convenience.


Step 1: Create Headers with Company Name

  • Firstly, from cell B2 to F2 apply the Merge & Center command and then create a header for the payment voucher.
  • After that, from cell B2 to F2 write down your Company Name and merged the cells with Merge & Center.

Create Headers with Company Name to make petty cash payment voucher in Excel


Step 2: Enter Date and Voucher Number

  • For making a payment voucher you need to enter the date and voucher number. In our case, we have used the TODAY function to apply the current date.
  • Initially, go to cell C6 and enter the function.
=TODAY()

It will dynamically change the date according to the present date.

Enter Date and Voucher Number to make petty cash payment voucher in Excel

  • Then, put the voucher number in cell F6.

Eventually, you will make your voucher format just like the image below.

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


Step 3: Input Necessary Data to Set up Voucher Format

  • In this step, insert your necessary data for creating the voucher format. You need to enter the cause of disbursement as a Description and create a Serial Number.

Input Necessary Data to Set up Voucher Format

  • Then, input the cash flow of your transactions.

Finally, your voucher format will look like the image below.


Step 4: Calculate the Total Amount

  • Now, we will calculate the “Total” for our transaction. We use the SUM function for doing this.
  • Firstly, go to cell F15 and insert the formula
=SUM(F9:F14)

Here, F9:F14 cells represent the “Amount” of cash. And the SUM function adds the value of F9:F14.

Calculate the Total Amount to make petty cash payment voucher in Excel

  • Then, press ENTER, and you will get the result.

Read More: How to Create a Salary Payment Voucher Format in Excel


Step 5: Evaluate Authorized Signature

  • Lastly, you need to enter the signature of the cashier who approved the vouch and the receiver’s signature for the proof of your payment slip. See the image below to get a basic idea.

Evaluate Authorized Signature to make petty cash payment voucher in Excel

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


Practice Section

We have provided a practice section on each sheet on the right side for your practice. Please do it by yourself.

Practice Section


Download Practice Workbook

Download the following practice workbook. It will help you to realize the topic more clearly.


Conclusion

That’s all about today’s session. And these are some easy steps to make a petty cash payment voucher format in Excel. Please let us know in the comments section if you have any questions or suggestions. For a better understanding please download the practice sheet. Thanks for your patience in reading this article.


Related Articles

<< Go Back to Payment VoucherFinance TemplateExcel Templates

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Fahim Shahriyar Dipto
Fahim Shahriyar Dipto

Fahim Shahriyar Dipto is a graduate of Mechanical Engineering at BUET. With over 1.5 years of experience at Exceldemy, he authored 70+ articles on ExcelDemy. He has expertise in designing worksheets at You’ve Got This Math. Currently, He is a Team Leader at Brainor. Dipto's passion extends to exploring various aspects of Excel. Beyond tech, he enjoys creating engaging kids' worksheets using Illustrator. A dedicated employee and innovative content developer, He incorporates a commitment to academic excellence and... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo