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.

Description

Excel Format

1

Tax Invoice

Download

2

Export Invoice – With Tax

Download

3

Export Invoice – Without Tax

Download

3

Bill of Supply

Download

4

Advance Receipt Voucher

Download

5

Payment Voucher

Download

6

Refund Voucher

Download

7

Debit Note

Download

8

Credit Note

Download

10

Delivery Challan

Download

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 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?

When:

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

When should the Tax Invoice be issued?

GOODS

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.

SERVICES

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 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.

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 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 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