How to Download GST Invoice Format in Excel | Word | PDF File

Goods and Services Tax (GST) is a new tax that will be imposed on the sale and purchase of goods and services within India. GST is a single Indirect Tax aimed at making the country a unified common market. India is adopted a dual GST, wherein the CGST and SGST. The launch of GST from 1st July in 2017, all business owners searching for GST invoice format. As a GST registered dealer, you are required to provide GST Invoices bill to your customers that are compliant with GST rules and regulations for all suppliers of goods and services. The frequency of the query has increased recently. Thus, we decided to create example templates for GST invoice format in excel, PDF, Word for the traders and wholesalers.

GST Invoice Format in Excel

Download GST Invoice Format in Excel, Word, PDF

Before we get down to the rules that govern GST invoices, we have to understand what is GST invoice. A GST invoice is a document which is supposed to contain all the relevant details of a business transaction and both the parties involved. It must comprise the product name, description, quantity, details of the supplier and the purchaser, terms of sale, Rate charged, discounts, etc.

The different types of invoices and supporting documents under GST are:

  • Sales invoices
  • Purchase invoices
  • Bill of supply
  • Delivery challans (for supply on approval, supply of liquid gas, job work and others)
  • Credit notes
  • Debit notes
  • Advance receipts
  • Refund vouchers

How many copies of Invoices should be issued?

For Goods For Services
Original for Recipient Original for Recipient
Duplicate for Transporter Duplicate for Supplier
Triplicate for Supplier

GST Invoice Format in Excel

Here you can learn how to design simple GST Invoice format in Excel file. Download GST Invoice Format in MS Excel. I created this GST invoice for educational purposes only. I hope this could be useful for small shopkeepers and businesses and this invoice format is valid in India.

Download Excel Format of GST for Services

Download Excel Format of GST for Goods

As a GSTIN registered dealer, you are required to provide invoices that are compliant with Good and Service Tax rules and regulations for all suppliers of goods and services.

GST Invoice Format in Word

Here you can learn how to design simple GST Invoice format in Word file. Download GST Invoice Format in MS Word. I created this GST invoice for educational purposes only. I hope this could be useful for small shopkeepers and businesses and this invoice format is valid in India.

GST Invoice Format in Word file Download for Goods

GST Invoice Format in Word file for Services

GST Invoice Format in PDF

Here you can learn how to design a simple GST Invoice format in PDF file. Download GST Invoice Format in PDF. I created this GST invoice for educational purposes only. I hope this could be useful for small shopkeepers and businesses and this invoice format is valid in India.

GST Invoice Format in PDF File Download for Goods

GST Invoice Format in PDF File Download for Services

Who should issue GST Invoice?

If you are a GST-registered business, you need to provide GST-compliant invoices to your clients for sale of goods and/or services.

Your GST-registered vendors will provide GST-compliant purchase invoices to you.

GST Invoice Format Fields

Mandatory fields of a GST Invoice

All tax invoices provided by GST registered suppliers need to contain the following fields:

  • Invoice number and date
  • Customer name
  • Shipping and billing address
  • Customer and taxpayer’s GSTIN (if registered)**
  • Place of supply
  • HSN code/SAC code
  • Item details i.e. description, quantity (number), unit (meter, kg etc.), total value
  • Taxable value and discounts
  • Rate and amount of taxes i.e. CGST/ SGST/ IGST
  • Whether GST is payable on reverse charge basis
  • Digital Signature (or regular) of the supplier

** If the recipient is not registered AND the value is more than Rs. 50,000 then the invoice should carry:

  1. Name and address of the recipient,
  2. Address of delivery

iii. State name and state code

By when should you issue invoices?

  • The GST Act has defined time limit to issue GST tax invoices, revised bills, debit notes, and credit note.
  • Following are the due dates for issuing an invoice to customers:
  • Goods (Normal Case) – On or before of removal/ delivery
  • Goods (Continuous Supply) – On or before the date of issue of account statement/payment
  • Services (General Case) – Within 30 days of supply of services
  • Services (Bank & NBFCs) – Within 45 days of supply of services

Goods and Services Tax (GST) is a new tax that will be imposed on the sale and purchase of goods and services within India. GST is a single indirect tax aimed at making the country a unified common market. India is adopted a dual GST, wherein the CGST and SGST.

The main motive of a GST tax invoice is to charge tax from the purchaser on the government’s behalf. However, there are some exceptions to this in GST, since a supplier cannot charge tax and thus, a normal tax invoice cannot be issued. In such cases, the document that is to be issued is called a Bill of Supply. A Bill of Supply is similar to a tax invoice, except that the Bill of Supply does not contain any tax amount, as the seller cannot charge GST to the buyer.

GST Calculator

You can use GST Calculator tool which can be helpful to calculate the cost of products and services. GST Calculator provided by different websites to help you determine the amount of tax applicable to certain goods or services. Here we present the formula for the addition of GST is as follows:

GST Amount = (Original Price x GST Rate) / 100

Net Price = Original Price + GST Amount

For example, if a commodity is sold from Chennai to Bangalore for Rs. 9000, and the rate of GST is 12%, the GST amount applicable to the product will be (9000 x 15) / 100 = Rs.1080; and the net price will be Rs.9000 + Rs.1050 = Rs.10,050.

The formula for the removal of GST is as follows:

GST Amount = Original Price – (Original Price x (100 / (100 + GST Rate)))

Net Price = Original Price – GST Amount

1 thought on “How to Download GST Invoice Format in Excel | Word | PDF File”

Leave a Comment