Download 10 GST Invoice Templates in Excel

Download 10 GST <a href=Invoice Templates in Excel" width="800" height="418" />

With the implementation of Goods and Services Tax from 1st July 2017, as a registered business entity we need to issue a GST invoice whenever the supply of taxable goods or services is made.

There are two types of GST invoice under the GST regime. Those businesses registered under the general category will issue a GST Tax Invoice. Those businesses registered under the Composition Scheme will issue a Bill of Supply.

Table of Contents

Types of GST Compliance Invoices

Depending on the nature of the supply you can define 3 types of invoices:

  1. Intra-State Invoice
  2. Inter-State Invoice
  3. Export Invoice

A business has to issue an Intra-state invoice when the supply is done within the state in which the business is registered. The issuer of the invoice has to collect CGST and SGST on this invoice.

Example: Goods sold by a business registered in Gujarat State to another business in Gujarat State. The product is liable for the collection of 5% GST, then 2.5 % CGST and 2.5% SGST has to be deducted on the taxable value.

When a supply takes place between two different states the business needs to issue an Inter-state invoice. The business needs to collect IGST on this invoice.

Example: Goods sold by a business registered in Gujarat State to another business in Maharashtra State. The product is liable for the collection of 5% IGST has to be deducted on the taxable value.

When supply is made outside the country, an Export Invoice is issued.

Rules To Follow When Creating a GST Invoice

The government has defined some rules for issuance of GST Invoices. Subject to rule 7, a tax invoice referred to in section 31 shall be issued by the registered person containing the following particulars:-

  1. Name, address, and GSTIN of the supplier.
  2. A consecutive serial number not exceeding sixteen characters, in one or multiple series, containing alphabets or numerals or special characters hyphen or dash and slash symbolized as “-” and “/” respectively, and any combination thereof, unique for a financial year.
  3. Date of its issue.
  4. Name, address and GSTIN or UIN, if registered, of the recipient.
  5. Name and address of the recipient and the address of delivery, along with the name of State and its code, if such recipient is un-registered and where the value of taxable supply is fifty thousand rupees or more.
  6. HSN Code of goods or Accounting Code of services.
  7. Description of goods or services.
  8. Quantity in a case of goods and unit or Unique Quantity Code thereof.
  9. The total value of the supply of goods or services or both.
  10. The taxable value of supply of goods or services or both taking into account discount or abatement, if any.
  11. The rate of tax (central tax, State tax, integrated tax, Union Territory tax or cess).
  12. The amount of tax charged in respect of taxable goods or services (central tax, State tax, integrated tax, Union Territory tax or cess).
  13. Place of supply along with the name of State, in the case of a supply in the course of inter-State trade or commerce.
  14. Address of delivery where the same is different from the place of supply.
  15. Whether the tax is payable on the reverse charge basis and
  16. A signature or digital signature of the supplier or his authorized representative.

Different GST Invoice Format in Excel

Keeping in mind the rules we have created 10 different formats of invoice under the GST regime. All formats vary in terms of design, industry, calculation method, etc.

Just enter a few details and the template will compute all the rest items for you. It is useful for Accounts Assistant, Accountants, Audit Assistants, etc.

This template helps you to efficiently and easily issue the invoices to your clients with CGST, SGST, and IGST Computations.

Let us discuss the contents of each template in detail.

Simple GST Invoice

GST Invoice

GST Invoice Format template consists of 5 sections; Header Section, Customer Details Section, Product & Tax Details Section, Billing Summary Section and Signature Section.

Header section consists of the company name, company address, company logo, GSTIN and the heading of the sheet “GST Invoice Template”.

GST Invoice

Customer Detail section consists of details of a customer such as the name of the customer, address, GSTIN, Invoice Number, Place of Supply (POS) and Invoice Date.

GST Invoice

Product-wise tax deduction section consists of multiple subheadings. You need to enter Sr. No., Product Description, HSE/SAC Codes, Quantity, Units, Rate of Product, Discounts, CGST Rate, SGST Rate, and IGST Rate.

GST Invoice

These all amounts; Total Sale, Taxable Value, CGST Amount, SGST Amount, IGSTAmount and Final Invoice Total will be automatically calculated.

The Summary section consists of the total billing amount payable by the customer.

GST Invoice

Signature Section consists of miscellaneous items like remarks, business greeting and Signatures of the receiver of the invoice and the accountant.

GST Invoice

Selling Goods On MRP

GST Invoice Format For Selling Goods On MRP

A person selling branded goods or goods with predefined MRP (maximum retail price) that is inclusive of taxes will require this GST Invoice format for selling goods on MRP inclusive of taxes.

This template contains reverse calculations which will extract the tax amount from the MRP.

This template consists of 4 sections; Supplier Detail, Customer Detail, Product Detail, Billing Summary, and Remarks section.

The header section consists of supplier details such as company name, logo, address, GST number, etc.

GST Invoice Format For Selling Goods On MRP

Customer detail section contains fields such as customer name, address, GST number, Place of supply, State, State Code.

GST Invoice Format For Selling Goods On MRP

You need to enter Sr. No., Product Description, HSE/SAC Codes, Quantity, Units, Rate of Product, Discounts, CGST Rate, SGST Rate, and IGST Rate.

GST Invoice Format For Selling Goods On MRP

These all amounts; Total Sale, Taxable Value, CGST Amount, SGST Amount, IGSTAmount and Final Invoice Total will be automatically calculated.

Billing summary consists of fields like Amount in words, Remarks, business greetings, company seal, authorized signatory, Invoice value, discounts, total taxable value, the grand total of the invoice, etc.

GST Invoice Format For Selling Goods On MRP

Freight Charges

GST Tax Invoice

Since the rollout of GST in July, people are still confused about how to include freight, insurance and packing, etc charges in GST Tax Invoice.

Business needs to issue the invoice which carries such additional charges. So how will they be recorded?

If such charges are included in the tax invoice then:

  1. It should be added to the value of goods
  2. Tax applicable on goods will be charged on the amount including of such charges.

It should be kept in mind, GST applicable on GTA services is 5%. But when you include it in your invoice it will be taxed at the applicable GST rate of goods even if the tax rate is higher than 5%.

A simple way to avoid higher payment of tax, freight charges shall be borne by the recipient of the goods.

As usual, the header section consists of the supplier’s company name, address, logo, etc.

GST Tax Invoice

Supplier’s details include Vendor Code if applicable, GSTIN, Pan, State, State code, Invoice no, Invoice Date, mode of transport, E-transit pass, date, etc.

GST Tax Invoice

Receiver’s details include name, address, PAN No, GSTIN, State and State code. If the delivery is different from the receiver then you can mention them manually in consignee details.

GST Tax Invoice

Product details section consists Serial number, Description of goods, HSN code, Unit of measurement, Quantity, Rate, Amount, discount and the Taxable amount

GST Tax Invoice

Billing Summary consists of the gross value with taxes, other charges (freight, packing, insurance, etc), tax on these charges, and Net Payable Amount.

GST Tax Invoice

Gross Amount = Taxable Value + CGST + SGST +IGST

Total Other Charges = Insurance + Freight + Packing

Net Payable Amount = Gross Amount + Other Charges + Tax On Other Charges.

Apart from that, this section consists of Amount in Words, Term & Conditions, Signature, company seal and bank details.

Jewelers

GST Invoice format for Jewelers

Usually, a jeweler sales new gold and also takes old gold of the customer.

Keeping this process of the transaction in mind, we have designed a GST invoice format for Jewellers in Excel. Using this template you can issue the invoice to your retail customers.

This template consists of 5 sections: Jeweler’s Details, Customer Details, Sales Details, Exchange Details, and Taxation and Billing Summary.

Jeweler’s details include the company name, address, contact details, GSTIN and the heading of the invoice “Tax Invoice”.

GST Invoice format for Jewelers

Customer details include name, address, contact number and pan card number as per the GST rules.

GST Invoice format for Jewelers

As this is a retail transaction where the invoice is issued directly to the customer, it belongs to the B2C category. Hence, it doesn’t require GSTIN of the customer. Instead of GSTIN, PAN card details of the customer are obtained.

Sales details include the details sale of ornaments, making charges, etc.

GST Invoice format for Jewelers

Exchange details contain the same columns as Sales details. Only Discount is not applicable in exchange.

GST Invoice format for Jewelers

Taxation section consists of taxation details only on the sales made and not on exchange.

GST Invoice format for Jewelers

As per GST law when there is the exchange of precious material there is no GST applicable as the customer is non-registered.

Apart from the taxation, this section also consists of a billing summary, the amount in words, invoice terms & conditions, business greetings, and the signature section.

Job-Workers

GST Invoice Format For Job Workers

Manufacturers outsource a major portion of their activities to Job Workers. A job worker will then issue a tax invoice for that portion of activities which can be claimed by the manufacturer in Input Tax Credit (ITC).

This template will be helpful especially to the textile industry and other manufacturing industries that involve job work process.

To know more about the Job Work Process under GST click the link below:

This template contains 5 different sections: Job Worker’s Details, Customer Details, Job Work Details, Taxation Details, Remarks, Billing Summary, and Term & Conditions section.

Job Workers detail consists of the company name, address, and logo.

GST Invoice Format For Job Workers

Customer Details section consists of customer name, address, GST number, invoice number, place of supply, date and the delivery challan against which he has received the material for job work.

The manufacturer will issue a delivery challan to the job worker at the time of the movement of goods without tax to his location.

GST Invoice Format For Job Workers

Job work details section contains Sr. No., Product Description, SAC Codes, Quantity, Units, Rate of Product, Discounts, CGST Rate, SGST Rate, and IGST Rate.

GST Invoice Format For Job Workers

These all amounts; Total Sale, Taxable Value, CGST Amount, SGST Amount, IGSTAmount and Final Invoice Total will be automatically calculated.

GST Invoice Format For Job Workers

The last section consists of Terms & conditions along with the billing summary and business greetings.

GST Invoice Format For Job Workers

Service Providers

GST Invoice format for Service Providers

GST Invoice format for service providers is almost similar to the GST Invoice format issued for goods suppliers.

The major difference is the Services Accounting Code (SAC code) to mentioned instead of the Harmonised System of Nomenclature Code (HSN Code).

This template contains 5 sections: Service Provider Detail, Customer Detail, Product Detail, Taxation & Remarks Terms & Conditions, and Billing Summary.

Service provider detail consists of the service provider’s company name, address, logo, GSTIN(GST Number), etc

GST Invoice format for Service Providers

The customer details include customer name, customer address, and customer GSTIN. In addition to that, it contains the place of supply, invoice date, invoice number and applicability of reverse charge.

GST Invoice format for Service Providers

Services Detail consists details like serial number, description, SAC code, quantity if applicable, units, rate and Total Sale.

GST Invoice format for Service Providers

Taxation and remarks section consists of 3 columns with 2 sub column each for CGST, SGST, and IGST.

GST Invoice format for Service Providers

Additionally, it also has “Amount in words” and “Remark” areas.

Lastly, Terms and conditions along with the billing summary and business greetings are given.

GST Invoice format for Service Providers

Billing Summary can be either: Invoice Value + CGST + GST + IGST = Grand Total or Invoice Value + Total GST = Grand Total.

Textile Business

GST Invoice Format for Textile

A single tax of 5% is applicable to the Textile Industry. Thus, a single tax column invoice format will be applicable.

This template contains 4 different sections: Supplier Details, Receiver/Consignee Details, Product Details, Billing Summary, Tax, and Signature Section.

Usually, the supplier details section consists of the company logo, company name, address, GSTIN and contact details or you can take a print of invoice on your letterhead.

It also contains columns for the reverse charge, invoice number, invoice date, date of supply, place of supply, transport details, state and state code, etc.

GST Invoice Format for Textile

Receiver/Consignee details consist of the receiver and consignee name, address, GSTIN, state, state code, etc.

GST Invoice Format for Textile

Product details section consists of product descriptions, serial number, quantity, unit, rate, and taxable value. Gross value = Quantity X Rate

GST Invoice Format for Textile

The billing summary consists of the following calculation:

Total Amount -Discount = Taxable Value

Total GST = CGST + SGST + IGST

Taxable Value + Total GST = Nett Amount

A separate column for the rate of tax applicable for each tax is provided. You enter applicable tax and it will compute automatically.

GST Invoice Format for Textile

In addition to the above, it has the amount in words, remarks, business greetings, and space for the Authorized signatory.

Traders & Wholesalers

It consists following two types of GST Invoice templates:

1. With multiple tax columns, where different commodities on which different rate of GST is applicable.

GST Invoice Format for Traders and Wholesalers

2. With Single Tax columns, where one tax rate is applicable to all the items.

GST Invoice Format for Traders and Wholesalers

Similar to other invoices, Supplier detail section consists of the company logo, company name, address, GSTIN and contact details.

GST Invoice Format for Traders and Wholesalers

Receiver/Consignee details section contain the name, address, GSTIN, state and state code, etc of the receiver/consignee.

GST Invoice Format for Traders and Wholesalers

Product details include the product descriptions, serial number, quantity, unit, rate, and taxable value. Taxable value = Quantity X Rate

GST Invoice Format for Traders and Wholesalers

When single tax is applicable you get more space for products as the taxes are entered consolidated in billing summary section.

Tax section consists of rate and amount column for CGST, SGST, and IGST if applicable. If IGST is not applicable, then this column can be removed.

GST Invoice Format for Traders and Wholesalers

For single tax applicable, the tax applicable rate is to be mentioned in the billing summary as shown below:

GST Invoice Format for Traders and Wholesalers

Same as other invoices, Lastly, summary section consists of the billing summary, where: section consists of the calculation of the invoice.

In addition to the above, this section also consists of multiple cells for the amount in words, business greeting, terms & conditions, and the authorized signatory.

GST Invoice Format for Retailers/Composition Dealers – Bill Of Supply

GST Invoice format for Retailers

Retailers come under the rule of Composition scheme. Such registered taxable persons need to issue Bill of Supply.

Rules of GST Invoice Format for Retailers:

According to clause (c) of sub-section (3) of section 31/A for the bill of supply shall be issued by the supplier containing the following details:-

  1. Name, the address and GSTIN of the supplier.
  2. A consecutive serial number not exceeding sixteen characters, in one or more multiple series, containing alphabets or numerals or special characters. It should be unique for each financial year.
  3. Date of its issue.
  4. Name, the address and GSTIN or UIN, if registered, of the recipient.
  5. The HSN/SAC Code of goods or Accounting Code for services.
  6. Description of goods or services or both.
  7. The value of supply of goods or services or both taking into account discount or abatement, if any.
  8. The signature or digital signature of the supplier or his authorized representative.

Provided further that any tax invoice or any other similar document issued under any other Act for the time being in force in respect of any non-taxable supply shall be treated as the bill of supply for the purposes of the Act.

This template consists of 4 sections: Header Section, Customer Details Section, Product Details, Billing Summary, and Signature Section.

The header section includes company name, address, logo, GSTIN and the invoice title.

GST Invoice format for Retailers

Customer Detail section consists of details of a customer such as the name of the customer, address if applicable, Invoice Number and Invoice Date.

GST Invoice format for Retailers

Product details include the product descriptions, serial number, quantity, unit, rate, and taxable value.

GST Invoice format for Retailers

The summary section consists of the total billing amount payable by the customer.

Signature Section contains miscellaneous items like remarks, the business greetings and the signatures box for the authorized signatory.

GST Invoice Format for Export

GST Export Invoice

GST Export Invoice as per the rules that are given in GST Law 2017 by the Government.

Movement of goods for the purpose of export where IGST is leviable, it can be done in the following two ways:

  1. Paying IGST in advance and taking the refund of it after the goods are exported. Documentary proofs of exports are to be submitted for such claim of refund. Click here to learn more about The Refund Process Under GST.
  2. Executing the Bond against IGST leviable against such goods.

This template is useful for Exporters whose supply involve paying of IGST (Integrated Goods and Service Tax).

Rules For GST Export Invoice

Subject to rule 7, a tax invoice referred to in section 31 shall be issued by the registered person containing the following particulars:-

  1. Name, address, and GSTIN of the supplier.
  2. A consecutive serial number not exceeding sixteen characters, in one or multiple series, containing alphabets or numerals or special characters hyphen or dash and slash symbolized as “-” and “/” respectively, and any combination thereof, unique for a financial year.
  3. Date of its issue.
  4. HSN Code of goods or Accounting Code of services.
  5. Description of goods or services.
  6. Quantity in a case of goods and unit or Unique Quantity Code thereof.
  7. The total value of the supply of goods or services or both.
  8. The taxable value of supply of goods or services or both taking into account discount or abatement, if any.
  9. The rate of tax (central tax, State tax, integrated tax, Union Territory tax or cess).
  10. The amount of tax charged in respect of taxable goods or services (central tax, State tax, integrated tax, Union Territory tax or cess).
  11. Place of supply along with the name of State, in the case of a supply in the course of inter-State trade or commerce.
  12. Address of delivery where the same is different from the place of supply.
  13. The signature or digital signature of the supplier or his authorized representative.

Provided also that in case of export of goods or services, the invoice shall carry an endorsement “SUPPLY MEANT FOR EXPORT ON PAYMENT OF INTEGRATED TAX” or “SUPPLY MEANT FOR EXPORT UNDER BOND OR LETTER OF UNDERTAKING WITHOUT PAYMENT OF INTEGRATED TAX”, as the case may be, and shall, in lieu of the details specified in clause (e), contain the following details:

(i) name and address of the recipient;
(ii) address of delivery; and
(iii) name of the country of destination:

Export Invoice

This template contains the following 5 sections: Header, Supplier and Customer Details, Billing Details and Signatory Section.

As usual, the header section consists of the company name, company address, and the company logo.

GST Export Invoice

In addition to that, it consists of the conversion rate required which is required to input for the exchange rate of foreign currency.

This section consists of the following details:

Invoice heading
GSTIN
Invoice Page No
Exporter Details
Consignee Details
Invoice No and Date
Purchase Order Number
Import Export Code No (IEC)
Country of Origin of Goods
Country of Final Destination
Details of Buyer if it is other than the consignee
Pre Carriage by Sea or Air
Place of Receipt by Pre-Carrier
Vessel/Flight No
Port of Loading
Port of Discharge
Final Destination
Terms of Delivery and Payment
Payment Description
Point of Delivery (POD)
Shipment

At the end of this section, you need to mention an endorsement “SUPPLY MEANT FOR EXPORT ON PAYMENT OF INTEGRATED TAX” or “SUPPLY MEANT FOR EXPORT UNDER BOND OR LETTER OF UNDERTAKING WITHOUT PAYMENT OF INTEGRATED TAX”, as the case may be.

GST Export Invoice

Billing Details consists of the following columns:

Marks and Nos
Description of Goods
HSN Code
Quantity
UOM
Rate (USD) or other applicable currency
Rate (INR)
Taxable Value
IGST (INR) and IGST percentage
Amount After Tax (INR)
Final Totals
Total GR WT (Gross Weight)
Total Net WT (Net Weight)

GST Export Invoice

Signatory section consists of the final declaration and terms. In addition to that, it also consists of the signature box for the authorized signatory of the supplier.

GST Export Invoice

We thank our readers for liking, sharing and following us on different social media platforms.

If you have any queries please share in the comment section below. I will be more than happy to assist you.

You are Here: Home / Excel Templates / GST Templates in Excel / Download 10 GST Invoice Templates in Excel

About Shabbir Bhimani

I have worked in Excel and like to share functional excel templates at ExcelDataPro.