Download GST Payment Voucher Excel Template


Popular Categories in Excel Template
Trednding in Excel Template

Time To Fill Calculator

Time To Fill Calculator is simple and ready-to-use excel template to calculate Time To Fill …

Read More

Bill Paying

Bill pay is a handy service offered by many banks and credit unions. This service …

Read More

Bullet Journal

We recently discovered the world of bullet journaling and we are excited to see that …

Read More

Control Chart

Although there are many Statistical Process Control (SPC) software tools available, many engineers still often …

Read More
Generic filters

A recipient liable to pay tax under reverse charge is required to issue a GST Payment Voucher at the time of making payment to supplier.

Rules of GST Payment Voucher

A payment voucher referred to in clause (g) of sub-section (3) of section 31 shall contain the following particulars:

  1. Name, address and GSTIN of supplier if registered.
  2. Consecutive serial number not exceeding sixteen characters, in one or multiple series.
  3. Date of issue.
  4. Name, address, and GSTIN of recipient.
  5. Description of goods and services.
  6. The amount to be paid.
  7. The rate of tax
  8. The amount of tax payable in respect of taxable goods and services.
  9. Place of supply with the name of State and its code.
  10. Signature or digital signature of the supplier, authorized representative.

GST Payment Voucher Excel Template

We have created a GST Payment Voucher Excel Template in compliance the above-mentioned rules. You just need to enter a few details and the template will compute all rest items for you.

This template helps you to efficiently and easily issue voucher for payment under Reverse charge to supplier of goods or services.

It is useful for Accounts Assistant, Accountants, Audit Assistants.

Contents of the Payment Voucher Template

This consists of 4 sections

  1. Firstly, Header Section.
  2. The, Customer Details.
  3. The, Product Details.
  4. The, Signature Section.

1. Header Section

Header section consists of company name, company address, company logo, invoice number, GSTIN and the heading of the sheet “GST Payment Voucher Excel Template”.

2. Customer Details

Customer Detail consists of details of customer such as a date, the name of the customer, address, customer GSTIN, Place of Supply, Invoice Number, Invoice date against which the payment is made.

3. Product Details

This section consist of multiple subheadings:

Sr. No.: Serial number of products.

Product Description: Description of the Product.

Payment Amount: The amount of payment to be paid.

CGST: The Rate and the Amount. The rate is applicable rate of CGST which is to be enter manually. The template calculates the amount of CGST automatically when Payment amount X Rate of CGST.

SGST: The rate is the applicable rate of SGST which is to be enter manually. SGST amount calculates automatically when Payment amount X Rate of SGST.

IGST: The rate is the applicable rate of IGST which is to enter manually. The Amount is the Payment amount X Rate of IGST.

5. Signature and Summary Section

Signature Section consists of remarks, Signatures of receiver and the name of the signatory.

The amount in words: The grand total of Payment Voucher.

The summary consists of total of Payment voucher by customer.

Thus, Grand Total = Total Payment Amount + CGST + SGST + IGST.

To use this free Excel Template, you should have Microsoft Office/ Microsoft Excel. You can only use this template if you have these applications in your system. or Use, Google Sheets. 

After installing Excel or Spreadsheet, download the xlsx file of this template to use it

Once extracted, you can open the file using Excel and start entering data or customizing the template.

Click The Button Below To Download GST Payment Voucher Excel Template

Instruction :

All Excel templates and tools are sole property of User can only download and use the excel templates for their Personal use only. All templates provided by XLSX templates are free and no payment is asked. However, you are not allowed to distribute or share in any other website for sole purpose of generating revenue from it.

 You can also download and use our 1000 Best PowerPoint Presentation Templates and 500 Resume Samples from  Completely Free. All our templates are designed by Professionals

Popular Excel Templates: