How to Create a Payment Advice Template in Excel With Easy Steps

A payment advice is a document buyers send to seller to confirm an invoice has been paid.


  • Add the name and address of the supplier and recipient.
  • The supplier is the business that is supplying products or workforce. The name and address of the supplier should be placed at the top middle position of the payment advice. The address should include the road number, city name, state name, country name, etc. In this example the supplier’s name is XYZ Company, and the supplier’s address is 60/A, Nelson Road, Adelanto, California, USA.
  • Add the name and address of the recipient to the left side just below the name and address of the supplier. Here the recipient’s name is William Handy, and the recipient’s address is 130/C, Obama Street, California, USA.

payment advice format in excel

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

  • Provide a Date on the right side of the payment advice just below the name and address of the supplier.
  • Enter the invoice number just below the date. In this case, the invoice number is RTEP 102022.

Giving an Invoice Number

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

  • Add the payment method. Here we chose Inter Bank Transfer.
  • Add the details of the bank through which payment was made, includingBank Account Number, Bank Name, and any specific regional bank information. In this case, the Bank Account Number is 96430336756 and the Bank Name is California Overseas Bank.
  • Add the Paid Amount Here it’s $30,000.

Adding Mode of Payment and Payment Amount

  • Add the data of issuance to the table under the column header Payment Details. In this example, the payment is Issued From HDFC Bank.
  • Add Instrument Details that we are delivering to the recipient. Every instrument has its own code number according to the company’s policy. In this case, the Instrument Details are LCGHTY564312.

payment advice format in excel

Things to Remember

  • We should add a brief letter body above the table.
  • The line spacing should be adjusted so there is a vertical gap between each component of the payment advice.

Download Practice Workbook

Related Articles

<< Go Back to Payment VoucherFinance TemplateExcel Templates

Get FREE Advanced Excel Exercises with Solutions!
Shajratul Alam Towhid
Shajratul Alam Towhid

Md Shajratul Alam Towhid, a BSc graduate in Naval Architecture & Engineering from Bangladesh University of Engineering and Technology, holds a pivotal role as an Excel & VBA Content Developer at ExcelDemy. Fueled by a deep passion for research and innovation, he actively engages with Excel. In his capacity, Towhid not only adeptly tackles complex challenges but also exhibits enthusiasm and expertise in gracefully navigating tough situations, emphasizing his unwavering commitment to consistently delivering exceptional, high-quality content that... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF