With the implementation of the GST Act 2017 from 1st July 2017, it is mandatory for every registered business entity to issue a GST Invoice. Under the GST regime, the Government has defined rules pertaining to GST Invoice format for Retailers.
We have created a ready to use Excel Template for GST Invoice for Retailers, simply by changing very few details like the Company name, Company address and GSTIN etc.
With this help of this template, you can efficiently and easily issue the invoices to your customers.
It is useful for Retailers, Cashiers, Accounts Assistant, Accountants etc.
To get a full view of the invoice please download the pdf version from the link below:
This invoice is developed according to Rules mentioned on www.cbec.gov.in the website of Central Board of Excise and Customs.
Rules of GST Invoice Format for Retailers
According to clause (c) of sub-section (3) of section 31 A bill of supply shall be issued by the supplier containing the following details:-
- Name, the address and GSTIN of the supplier.
- 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.
- Date of its issue.
- Name, the address and GSTIN or UIN, if registered, of the recipient.
- The HSN/SAC Code of goods or Accounting Code for services.
- Description of goods or services or both.
- The value of supply of goods or services or both taking into account discount or abatement, if any.
- 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.
Let us discuss the contents of the template in detail.
Contents of the GST Invoice Template for Retailers
This template consists of 4 sections:
- Header Section.
- Customer Details Section.
- Product Details.
- Summary and Signature Section.
1. Header Section
The Header section consists of the following Headings
Company Name: Enter your Company Name at the top.
Company Address: Enter your Business Address.
Company logo: If you have a business logo enter it or merge the cells.
Company GSTIN: Here you need to enter the GSTIN Number provided by the government.
Heading: Heading of the sheet will be entered as “Retail Invoice”.
2. Customer Details Section
Customer Detail section consists of details of a customer such as the name of the customer, address if applicable, Invoice Number and Invoice Date.
POS is not applicable here as no inter-state transaction is taking place.
3. Product Details Section
This section consist of multiple subheadings which are as below:
Sr. No.: Serial number of items/products.
Product Description: Description of the Product.
HSE/SAC Codes: HSN code of goods or Accounting Code of services.
To know the HSN code for your product, download the pdf file from the below link:
Qty: Quantity of goods supplied.
Units: Unit of the product like meters, pieces, kgs etc.
Rate: Rate/unit of Product.
Total Sale: Total amount of sales done. The formula applied here is Quantity X Rate.
Disc.: Discount if applicable.
Net Sale: Formula applied here is Total Sale – Discount = Net Sale.
Under the Composition Scheme, the retailer is not liable to collect the CGST, SGST or IGST. Hence no computation of taxes is shown in the invoice.
If the retailer is registered under the normal scheme, he has to show all the relevant tax columns and its computations.
For such sales, you need to issue a Tax Invoice. You can download excel format of such invoice from the link below:
4. Summary and Signature Section
Summary section consists of the total of billing amount payable by the customer.
Payable Amount = Invoice Value with tax – Discounts
Signature Section contains miscellaneous items like remarks, the business greetings and the signatures box for the authorized signatory.
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.