GST Invoice format in Excel and PDF

Last udpated: Nov. 4, 2017, 9:12 p.m.

The government notified rules for a tax invoice. A tax invoice issued by a registered person should contain details as required.

I have drafted an invoice in MS Excel and PDF format, which you can use for reference purpose. Alternatively, you can use online invoicing software for GST.

Download GST tax invoice format in excel or PDF

I have prepared a draft invoice in excel format. You can download this excel file and change the format or designing as per your requirements.

GST invoice format in excel and pdf

Download GST Tax Invoice format in excel

Download GST Tax invoice format in PDF

Free GST Billing software

Here is a video about KYG-Invoicing to explain you instead of Excel format you can use a free to use billing software created by me. It is being used by more than 6,000 users and they are happy.

It is free for life time.

Analysis of Invoice rules issued by government

Details of seller/supplier

  • Name,
  • Address and

Invoice details

  • Invoice number should be continuous containing alphabets or numerals or special characters, invoice number should be unique for a financial year
  • Date of invoice

Details of buyer/recipient if registered under GST

  • Name
  • Address
  • GSTIN or UIN
  • Place of supply along with state code if interstate sale

Details of buyer/recipient if not registered under GST and value of taxable supply is 50,000 or more

  • Name
  • Address of the recipient and the address of delivery
  • Name of State and its code

Details of products to be provided in invoice

  • Product description
  • HSN code of goods or Accounting Code of services
  • Quantity and unit of measurement
  • Total value
  • Taxable value
  • Rate of tax for CGST, SGST, or IGST
  • Amount of tax for CGST, SGST, or IGST

Invoice should be signed either digitally by a DSC (Digital signature certificate) or hand signature by the supplier or his authorised representative.

These are the basic details that an invoice should contain, export invoice, reverse charging invoices should contain the fact on invoice.

How many copies of the invoice should be prepared?

If invoice is for supply of goods, then 3 copies should be printed.

  • Original copy for Recipient/buyer
  • Duplicate copy for Transporter and
  • Triplicate copy for Supplier/seller

In case of service 2 copies should be prepared,

  • Original copy for recipient
  • Duplicate copy for supplier
Posted by Pulkit Sharma under GST

A Chartered Accountant by qualification. Love to code and share knowledge. On a mission to create the largest knowledge library for finance and taxation professionals. Check Profile


Comment by Pulkit Sharma

I have not uploaded the MS word format. You can copy the excel format and paste in word to use it in MS Word. Similarly there are many online website which can convert PDF into word.

Comment by Pulkit Sharma

Update: KYG invoice application is live. I suggest using this application for generating GST invoices.

Comment by Sachin Rastogi

Sir what are the terms in case of selling goods to unregistered person under gst and the value of goods is less than 50000.what are the details necessary to be shown in invoice?

Comment by Pulkit Sharma

Tax invoice formats provided in Excel are not scaled for printing. You have to adjust the margins before printing. It is only for sample purpose for those who need a format to give to their printers.
Alternatively I highly recommend using invoicing application which I have created.

Comment by Baba Dhd

Sir is there any charges to use your invoicing application?

Comment by Pulkit Sharma

No. It is free for small businesses.

Comment by Ganesh v

For invoice preparing which one necessity white sheet or printed stationery?

Comment by Pulkit Sharma

@ Ganesh
You can any. There is no rule on this.
You can have printed stationary but tax invoice should contain details as required under the law.

Comment by VINOD KUMAR


Comment by Johny dae

Thankyour for this very helpful information on gst invoice format.

Comment by Arun kumar

Dear sir, wonderful information about GST Bill format for goods,But, Please send me an excel bill format for Service bill under GST. and also clarify whether there is any strict rule for billing format under GST. Rgds Arun

Comment by Pulkit Sharma

There is no strict rule on format of invoice. You can design your bill in any format but should contain required details mentioned in article.

Comment by Guru murthy

Dear Sir,

We are service provider, interior designer, based bangalore, karnataka state.
if we do design service for Tamil Nadu state and billing to Karnataka state, what will be the place supply and tax components.

Comment by Ranjith Kumar

Comment by Abdus Sattar

Can I use this as pharmaceutical wholesaler

Comment by Pulkit Sharma

Yes you can use it. Why don't you try online invoicing software of knowyourgst?

You need to be logged in to comment.