Search
Generic filters

GST Payment Voucher Excel Template

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.

Download GST Payment Voucher Excel Template
Share on facebook
Share on linkedin
Share on email
Share on whatsapp

Download Guide

Compatible with : Microsoft Office Excel, Libra Office, WPS Office, Google WorkSheet
  • Download The Template XLSX File Format
  • Use the Template

Download Instruction :

All Excel templates and tools are sole property of xlsxtemplates.com. 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 PPTXTemplates.com  Completely Free. All our templates are designed by Professionals

Recently Uploaded Excel Templates: