Take This Quiz & Predict Your Score in the coming CA CS or CMA Exam!
  • How important it is for you to pass the exam in this attempt?
  • What percentage of course you have finished well so far roughly?
  • How many hours you study in a day?
  • How many times you have revised the topics you have finished
  • Have you taken online or pen drive or live class from a renowned faculty?
  • What percentage of the classes you have watched?
  • Have you attempted mock tests or practice tests yet?
  • Are you planning to attempt mock tests conducted by external bodies- ICAI, ICSI, ICMAI or other institute?
  • How many tests you have taken?
  • Did you manage to finish the test papers on time?
  • Are you strictly following study material provided by the exam conducting authority such as ICAI/ICSI/ICMAI/Other Body?
  • How is your health in general?
  • How is your food habit?
  • Any interest in yoga or exercise or play sports regularly?
  • Planning to sleep well nights before the exams?
  • Planning to have light food and water before exams?

GST HSN CODE in Excel Format free download

GST HSN CODE in Excel Format free download

GST HSN CODE in Excel Format

GST HSN CODE in Excel Format : HSN or HS (Harmonised Commodity Description and Coding System) is a multipurpose international product nomenclature developed by the World Customs Organisation (WCO).

GST HSN CODE in Excel Format

GST HSN CODE in Excel Format

WCO has 181 members, three-quarters of which are developing countries that are responsible for managing more than 98 percent of world trade. HSN standardizes the classification of merchandise under sections, chapters, headings, and subheadings. This results in a six-digit code for a commodity (two digits each representing the chapter, heading, and subheading).

India, a member of WCO since 1971, has been using HSN codes since 1986 to classify commodities for Customs and Central Excise. Customs and Central Excise added two more digits to make the codes more precise, resulting in an eight-digit classification.

To Know more details on Interest on late payment of GST , GST constitutional amendment read this article.

GST HSN CODE in Excel Format

Check here to know more on GST and to download GST Billing Rules :

1.Invoicing Under GST CHECK HERE
2.Invoicing Under GST RulesCHECK HERE

Check here to know more on GST HSN Code with Rate :

1.GST Rate ScheduleCHECK HERE
2.GST Rate by GST CouncilCHECK HERE
3.GST HSN Codes EnrollnmentCHECK HERE

Check here to know more on GST HSN CODE in Excel Format :

1.GST HSN Code list in Excel FormatCHECK HERE
2.GST Rate List with HSN Code – All Items ListCHECK HERE
3.GST Invoice Format PDFCHECK HERE
4.GST Invoice Format ExcelCHECK HERE

HSN Code List for GST in Word

6. Item Wise GST Rates Decided on 18th June 2017 on Certain ServicesCHECK HERE

GST HSN CODE in Excel Format

Under GST, the majority of dealers will need to adopt two-, four-, or eight-digit HSN codes for their commodities, depending on their turnover the year prior.

  • Dealers with turnover of less than Rs 1.5 crores will not be required to adopt HSN codes for their commodities.
  • Dealers with turnover between Rs 1.5 crores and Rs 5 crores shall be required to use two-digit HSN codes for their commodities.
  • Dealers with turnover equal to Rs 5 crores and above shall be required to use four-digit HSN codes for their commodities.
  • In the case of imports/exports, HSN codes of eight digits shall be compulsory, as GST has to be compatible with international standards and practices.

GST HSN CODE in Excel Format

HSN has 21 sections, 99 chapter, 1,244 headings, and 5,224 subheadings. Sections and chapters are arranged in order of a product’s degree of manufacture or in terms of its technological complexity. Natural products like animals and vegetables appear in the earlier sections; man-made or technologically advanced products like machinery appear later.

Chapters have a similar structure. Take cotton, for example – Chapter 52. Cotton that has not been carded or combed appears earlier in the chapter; cotton as a woven fabric appears later.

  • Each Section is a collection of various chapters. Sections represent a broader class of goods, and chapters represent a particular class of goods. For example, Section XV relates to base metals and articles of base metals, while Section XV, Chapter 72 is for iron and steel specifically.
  • Each chapter is further divided into various headings depending upon different types of goods belonging to the same class. For example, Chapter 72, Heading 02 deals with ferro-alloys, and Chapter 72, Heading 29 with wire of other alloys.
  • Each heading contains products, which are ultimately assigned an HSN code. Ferro-manganese under ferro-alloys, for example, bears the HSN code 72.02.01 – 01 being the product code under Heading 02 of Chapter 72. The HSN code for other products under ferro-alloys is 72.02.99.
  • For better identification of goods, India and a few other countries use eight-digit codes for deeper classification. For example, is the HSN code for ferro-phosphorus under other ferro-alloy products.
  • Some HSN codes also use dashes. A single dash (-) at the beginning of a description denotes an article that belongs to a group covered under a heading. A double dash (–) indicates that the article is a sub-classification of the preceding article that has a single dash. Similarly, a triple dash (—) or quadruple dash (—-) indicates the article is a sub-classification of the preceding article that has a double dash or triple dash.

GST HSN CODE in Excel Format

Classifying goods under HSN

In formatting a classification for a particular item, dealers must apply the General Interpretative Rules (GIR) in a sequential manner. Once a classification is complete, there’s no need to continue applying the remainder of the rules. Moving on to the next rule is only necessary if a complete classification does not result from applying the previous rule. Classification is final once there is no ambiguity or confusion.

For classification purposes, a word should be construed in its popular sense and not in the strict or technical sense. For example, “Dabur Lal Dant Manjan” is not understood as “ayurvedic medicine” in trade parlance but as “toilet preparation” and should be classified accordingly.

Rule 1

  • Titles of sections, chapters, and sub-chapters are provided for ease of reference only.
  • For legal purposes, refer to headings and sub-headings to drive classification.

Rule 2a

  • If the goods are incomplete/unfinished and have the characteristics of the finished product, classification is the same as that of the finished product (if the classification is known).
  • The heading shall also include removed/unassembled or disassembled parts (i.e., SKD/CKD).

Rule 2b

  • Any reference to a material or substance includes a reference to mixtures or combinations of that material or substance with other materials or substances.
  • The classification of goods consisting of more than one material or substance shall take place as per Rule 3.

Rule 3a

  • Choosing a specific heading is preferred over a general heading.
  • For example, 85.10 is the classification for “shavers, hair clippers and hair removing appliances, with self-contained electric motor.” This is a more specific classification for a handheld electric razor than either:
    • 67: “tools for working in the hand, pneumatic, hydraulic or with self-contained electric or non-electric motor,” or
    • 09: “electro-mechanical domestic appliances with self-contained electric motors, other than vacuum cleaners”

Rule 3b

  • Mixtures/composite goods should be classified per the material or substance that gives them their essential character.
  • For example, a grooming kit consisting of electric hair clippers (85.10), a comb (96.15), and a brush (96.03) inside a leather case (45.02), should be classified under the electric hair clippers heading (85.10).

Rule 3c

  • If two headings are equally suited to the item, choose the heading that appears last in numerical order.

Rule 4

  • If goods cannot be classified per the above rules, they are to be classified according to the goods to which they are most akin.

Rule 5

  • Containers specifically designed for the article and suitable for long-term use will be classified along with that article, if such articles are normally sold along with such cases. For example, a camera case would fall under cameras.
  • Packing materials and containers are also to be classified with the related goods except when the packing is for repetitive use.

Along with India’s move to GST come moves to an online taxation system and to HSN codes for classifying goods for taxation. It’s all designed to bring about more uniform taxation as well as more ease of doing business. HSN codes will now be used in filing returns, on invoices, etc., rather than written descriptions.

It will all require some prep work from professionals and taxpayers, but automated GST compliance solutions are available to help ease the transition.

GST HSN CODE in Excel Format

Before in India, there are many direct and indirect taxes imposed on goods/services, right from its manufacture to its sale and eventual consumption, both at central and state levels, thereby unrealistically increasing overall cost to the end user.

To mitigate this burden, the Central Government proposed the Goods and Services Tax (GST). GST combines central excise duty, additional excise duty, service tax, state VAT & entertainment taxes under one banner.

Goods and Services Tax (GST) was introduced as a Constitutional Amendment bill in the Lok Sabha on 19 th December 2014 and passed by the house on 6th May 2015. However, it took more than a year for the Rajya Sabha to pass this on 3rd August 2016. The bill after ratifications by the states received the Presidential assent on 9th September 2016. GST is expected to come into force by 1st July 2017.

Implementation of the Goods and Services Tax (GST) will have a significant impact on the real estate sector, where, a property under construction, is taxed under VAT and Service Tax. The Goods and Services Tax (GST) will replace all these with a single tax, which shall, in the long run, reduce the overall cost of home ownership. The stamp duty and registration fees, however, will be outside the purview of the Goods and Services Tax (GST).

GST HSN CODE in Excel Format

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

GST HSN CODE in Excel Format

GST HSN CODE in Excel Format

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.

GST HSN CODE in Excel Format

Number of copies of the invoice to 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

At CAKART ( you will get everything that you need to be successful in your CA CS CMA exam – India’s best faculty video classes (online or in pen drive), most popular books of best authors (ebooks, hard copies), best scanners and all exam related information and notifications. Visit and chat with our counsellors any time. We are happy to help you make successful in your exams.

For more on GST and GST HSN CODE in Excel Format log onto




Leave a comment

Your email address will not be published. Required fields are marked *