How to Make a Cash Payment Voucher Format in Excel: 4 Easy Steps

Step 1: Add Company Details

Add company details at the top of the payment voucher.

  • Type in the company name M3 Inc in the B4 cell.
  • Include the company Address and the Contact number in the B5 and the B6 cells respectively.

Add Company Details to cash payment voucher


Step 2:  Enter Recipient Details, Reference Number, and Date

  • Add the recipient’s Address in the C8 cell.
  • Type in the Reference Number in the F8 cell.
  • Insert today’s Date in the F9 cell.

Enter Recipient Details, Reference Number, and Date to cash payment voucher


Step 3: Insert Payment Method, Description, and Amount

Insert Payment Method, Description, and Amount to cash payment voucher

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


Step 4: Calculate the Total Amount and Incorporate Signatures

Utilize the COUNTA and SUM functions to obtain the Total Receipts and the Total Amount in USD. The COUNTA function returns the number of payments by counting the non-blank cells within the D11:D16 range. In contrast, the SUM function adds up all the payments in the F11:F16 range and outputs the Total Amount.

  • Navigate to the C18 cell >> enter the expression given below.

=COUNTA(D11:D16)

The D11:D16 range of cells represents the entries in the Payment Method column.

Calculate the Total Amount with COUNTA function

  • Move to the F18 cell and insert the following equation in the Formula Bar.

=SUM(F11:F16)

The F11:F16 cells refer to all the sales Amounts in USD.

Using SUM function

  • Add the signatures of the authorized personnel and your results should look like the image shown below.

Incorporate Signatures


 

Download Practice Workbook


 

Related Articles

<< Go Back to Payment VoucherFinance TemplateExcel Templates

Get FREE Advanced Excel Exercises with Solutions!
Eshrak Kader
Eshrak Kader

Eshrak Kader is a dedicated professional with a BSc. Degree in Naval Architecture and Marine Engineering from Bangladesh University of Engineering and Technology. He boasts a rich background in Microsoft Office Suite, and over the past year, he has authored over 120 insightful articles for the ExcelDemy. Currently, Eshrak leads a team of 5 in the ExcelDemy Video project and enjoys problem-solving and making videos on Excel. Eshrak’s passion for continuous learning underscores his commitment to excellence in... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo