Loading GST Billing Software
header image

Freely Downloadable, Easily Editable GST Excel Templates

Erachana Line

Free Easily Editable GST Excel Templates for Download

As per GSTIN many changes are suggested in accounting Transaction. Considering those, we have prepared some of the Excel Templates to help business to adapt to GST Related Changes Quickly. Please download following Excel Templates.

Download Free Excel Templates

Sl. No.


Excel Format





Order Confirmation



Proforma Invoice



Purchase Order



Tax Invoice



Export Invoice – With Tax



Export Invoice – Without Tax



Bill of Supply



Receipt Voucher



Advance Receipt Voucher



Payment Voucher



Advance Payment Voucher



Refund Voucher



Debit Note



Credit Note



Delivery Challan


FAQs related to these GST Excel Templates

Advantages of using these Vouchers

None of the Cells are merged and hence it will be easy for the user to edit these Excel Templates.

I am either selling goods or providing services or both. What document do I raise at the point of sale?

Depending on whether you are registered or not under the GST regime, you will have to issue a Tax Invoice or a Bill of Supply(BOS) respectively. Also, there are certain circumstances under which a registered person is required to issue a BOS instead of a Tax invoice.

What is a Quotation?

When a seller sends a quotation, it commits them to a certain price. A quotation is used to let customer know the cost of goods or services before they decide to purchase them.

What is Order Confirmation?

An order confirmation is a written confirmation of an order which is sent by the seller that accepts the order placed by a customer. It serves as a tool to avoid confusion and mistakes in case the order does not confirm to the original offer. When the product or service is rendered, then, an invoice confirms the agreement and initiates the payment according to the agreed conditions.The ordered product or service is formally recorded in an Order Management System as a purchase order.

What is Proforma Invoice

A pro forma invoiceis essentially a preliminary bill of sale. It summaries a seller’s intent to deliver products or services to customers, for a specific price. It isn’t an exact invoice, as the price hasn’t been fixed yet. When to use Proforma invoices Proforma invoices are used if you need to produce a document to a customer for goods or services that you have not yet delivered.

Difference between Proforma Invoice and Invoice




Proforma invoice is like a normal invoice, provides information to the buyerconcerning the goods yet to be delivered.

A commercial instrument delivered to the buyer containing the details of products or services provided by the seller is known as an invoice.

Document Type



When to issue

Beforeorder is made.

Before payment is made.


To help the buyerto decide, whether to place an order or not.

To inform the buyer, the actual amount for payment.

What is Purchase Order?

A purchase order is a document containing agreed prices for goods or services. It is a commercial and first official offered document issued by a purchaser to a seller. Suppliers use purchase orders for order completion and payment. On receipt, the purchase order is used to pull purchased inventory for packaging. Once the inventory is pulled, an invoice is prepared based on the items and prepared for shipment.

What is a Tax Invoice?

A Tax invoice is one of the most crucial documents under the GST regime. Taxable persons are given the leeway to maintain their desired formats, however the requirements of The Goods and Services Act,2017 and the Rules made there under have to be adhered to.

A registered person shall issue a Tax invoice containing the following particulars: -

  • •  Name, address and GSTIN of the Supplier; and the Recipient (if registered);
  • •  A consecutive serial number, unique for a financial year, along with date of invoice;
  • •  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;
  • •  Description of goods or services along with its HSN code, Quantity and Units(Unique Quantity Code) thereof;
  • •  Total value of supply of goods/services/both; its taxable value considering the discount or abatement, if any;
  • •  Rate of tax (Central tax, State tax, integrated tax, Union territory tax or Cess);
  • •  Amount of tax charged in respect of taxable goods or services (IGST, CGST, SGST, UTGST or Cess);
  • •  Place Of Supply along with the name of State (If an Inter-state supply), and the address of delivery, if different from Place Of Supply;
  • •  Whether the tax is payable on reverse charge basis; and
  • •  Signature or DSC of the supplier or his authorized representative.

What is a Bill of Supply?

A Bill of Supply is very similar to a Tax Invoice excepting the tax component in the latter document. Meaning, there is no Tax charged in a Bill Of Supply. It will arise in the case of supplies by a person who is not supposed to collect tax and/or when the supplies are such that there is no tax charged on it.  Accordingly, it is issued by an Un-registered dealer and under certain circumstances also by a Registered dealer.

The particulars are the same as has been already enlisted for a Tax Invoice, except Tax rates, Tax amounts and Tax charged.

What are the circumstances under which a Registered person is required to issue a Bill Of Supply?


  • •   Supply is of Exempted goods or services.
  • •   Supplier is paying tax under Composition scheme.

When should the Tax Invoice be issued?


Where the Supply includes:

Movement of goods- At the time of/ before removal

No movement of goods- At the time of Delivery

Sale or Return supplies- Before/at the time of Supply or Within 6 months from the removal, whichever is earlier.


Within 30 days from the supply of services. (45 days in case of Banking, Insurance, NBFCs etc).

The invoice shall be prepared in Triplicate (for goods), in the following manner:–

  • •  Original for the Recipient;
  • •  Duplicate for the Transporter; and
  • •  Triplicate for the Supplier.

The invoice shall be prepared in Duplicate (for services), in the following manner:-

  • •  Original for the Recipient; and
  • •  Duplicate for the Supplier.

Will the HSN code have to be mentioned in every Invoice?

Taxpayers whose turnover is below Rs. 1.5 crores are not required to mention HSN Code in their invoices.

Those with turnover above Rs. 1.5 crores but below Rs. 5 crores shall use 2-digit code.

And with turnover above Rs. 5 crores shall use 4-digit code

What is Reverse charge?

Under a Reverse charge, the liability to pay tax is on the Recipient of supply of goods/services instead of the Supplier in respect of notified categories of supply. Accordingly, it is to be noted that in case of receipt of supply from an Unregistered person, the Registered person who is receiving goods or services shall be liable to pay tax

What is Receipt Voucher?

A receipt voucher is a form of deal made by the seller and the buyer regarding the purchased goods or service. It is one kind of receipts used for business purposes. After completing the transaction of payment, receipt voucher is given to customers.

What is an Advance receipt voucher?

When an amount of Advance is received from a customer with respect to supply of goods or services or both, a registered person should issue an Advance receipt voucher evidencing such receipt. It should contain such particulars as has been prescribed, as GST is payable on Advances received. Subsequently, when an Invoice is raised for supply against such advances, proper references will enable reducing the Output tax liability, provided tax on advances has already been paid.

What if such Advance is returned or the transaction is cancelled?

Where on receipt of advance payment with respect to any supply of goods/services/both the registered person has issued an Advance receipt but subsequently no supply is made and no tax invoice is issued with respect to that transaction, the said registered person may issue to the person who had made the payment, a Refund Voucher against such payment.

This is to record that the said advance has been returned back.

How different is this from a Payment Voucher?

A Payment voucher is raised when the entity is making a payment towards its business expenditure.

Also, under GST, in case of categories of goods/services that are notified, on which tax is payable on Reverse Charge basis, the recipient of the goods/services would be required to issue a Payment Voucher at the time of making payment to the supplier.

What is Advance Payment Voucher?

Manufacturers ask for a certain amount of advance and even before any service is been given, service providers request for advance. This is why advance payment voucher needs to be issued.

What is Refund Voucher?

A bulk order is received by the customer. A receipt is issued by the seller to the customer while paying the amount. If the order is cancelled anytime then a refund voucher should be raised for the advance received.

When is a Debit note issued?

Where a tax invoice has been issued for supply of any goods/services and the taxable value and/or tax charged in that tax invoice is found to be less than the taxable value and/or tax payable in respect of such supply, the taxable person, who has supplied such goods/services shall issue to the recipient, a Debit note.

When is a Credit note issued?

Where a tax invoice has been issued for a supply of goods/services and the taxable value and/or tax charged in that tax invoice is found to exceed the taxable value and/or tax payable in respect of such supply, the taxable person, who has supplied such goods/services may issue to the recipient, a Credit note

In addition to the details covered above (under Tax invoice) a Debit/Credit note shall also include the Serial number and date of the corresponding Original Tax Invoice, or as the case may be, Bill Of Supply.

Under the following cases, a Tax Invoice or a Debit note or a Credit note issued shall contain the words “INPUT TAX CREDIT NOT ADMISSABLE”.

  • •  Section 74 – Determination of tax not paid or short paid or erroneously refunded or input tax credit wrongly availed or utilised by reason of fraud or any wilful misstatement or suppression of facts.
  • •  Section 129 – Detention, seizure and release of goods and conveyances in transit.
  • •  Section 130 – Confiscation of goods or conveyances and levy of penalty./li>

What is a Delivery challan?

Where the goods are transported for delivery but quantity to be supplied is not known at the time of removal, the goods may be removed on a Delivery Challan and invoice may be issued after delivery.

A Delivery challan is issued for purposes of:

  • •  Supply of liquid gas where the quantity at the time of removal from the place of business of the supplier is not known,
  • •  Transportation of goods for job work,
  • •  Transportation of goods for reasons other than by way of supply, or
  • •  such other supplies as may be notified by the Board(GST).

The Delivery challan shall also be prepared in Triplicate.