Gst Hsn Code List In Excel Free Download

admin
Every business entity is required to obtain a unique number under GST registration. This enables the business to collect GST from the recipient and avail input credit. Therefore, CGST Act 2017 makes it mandatory for the following persons to get registered under GST and obtain GSTIN.
  1. Generate GST Invoice Format in Word & Excel. Export Invoice Under GST. Advantages of GST. GST Audit Checklist. Depreciation Methods. Check GST – HSN Code. GST Exemption List. Partnership Firm Registration.
  2. Download free accounting software with an intuitive interface, full stock support and unit of measurement plus multiple advanced invoicing features. Sleek Bill is one of the best accounting solutions πŸ†.
  3. HSN and GST Rate in Stock Summary Free TDL Code 2021 Pooja Singh February 12, 2021 With this free TDL code we can add Item HSN code and Item GST Rate in Stock summary detail.
  4. GST rules specify that each invoice of a business should contain certain fields like HSN/SAC code, tax split between IGST, CGST, SGST and UGST, vendor/purchaser GSTIN etc. With KDK GST software, generate GST compliant invoices customised with your business logo, for each place of business within 60 seconds.

SAC Code List, Download SAC Code for GST in Excel, PDF Format. SAC Code means Services Accounting Code. SAC code is used to classify services unlike goods which follows HSN code. For each type of service provided, there is an unified code for recognition, measurement an.

/pokken-tournament-download-for-ppsspp.html. Pes 17 Iso File For Ppsspp Download Pokken Tournament Dx Download For Ppsspp Psp Games For Ppsspp App Dragon Ball Ppsspp Games For Android Ppsspp Latest Version For Iphone Naruto Shippuden Game For Ppsspp Free Download Is An S5 Good For Ppsspp Def Jam Fight For Ny The Takeover Ppsspp. Pokken Tournament Dx Download For Ppsspp Psp Games For Ppsspp App Dragon Ball Ppsspp Games For Android Ppsspp Latest Version For Iphone Naruto Shippuden Game For Ppsspp Free Download Is An S5 Good For Ppsspp Def Jam Fight For Ny The Takeover Ppsspp Max Payne For Ppsspp.

  • individuals or entities having an aggregate turnover of more than 40 lakh rupees in case of goods
  • entities or individuals having an aggregate turnover of more than 20 lakh rupees in case of services
  • individuals or entities having an aggregate turnover of more than Rs. 20 lakhs for the supply of goods in case of hilly or north-eastern states.

Try QuickBooks Invoicing & Accounting Software – 30 Days Free Trial.


As per the GSTIN format, the first two digits represent the state code in which the business entity is registered under GST law. The state indicates the state in which a business entity is located, carries its business and thus is registered from that state under GST.

Each state in India is allotted a state code so as to make it convenient to identify the business entity. Accordingly, the GST state codes, along with the alphabetical codes, for various states are as follows:

State NameState CodeAlphabetical Code
Jammu and Kashmir01JK
Himachal Pradesh02HP
Punjab03PB
Chandigarh04CH
Uttarakhand05UT
Haryana06HR
Delhi07DL
Rajasthan08RJ
UttarPradesh09UP
Bihar10BH
Sikkim11SK
ArunachalPradesh12AR
Nagaland13NL
Manipur14MN
Mizoram15MI
Tripura16TR
Meghalaya17ME
Assam18AS
West Bengal19WB
Jharkhand20JH
Odisha21OR
Chattisgarh22CT
Madhya Pradesh23MP
Gujarat24GJ
Daman and Diu25DD
Dadra and Nagar Haveli26DN
Maharashtra27MH
Andhra Pradesh28AP
Karnataka29KA
Goa30GA
Lakshadweep Islands31LD
Kerala32KL
Tamil Nadu33TN
Pondicherry34PY
Andaman and Nicobar Islands35AN
Telangana36TS
Andhra Pradesh (New)37AD

GST State Code List in PDF

How to Know Your Jurisdiction?

Central Board of Indirect Taxes and Customs (CBIC) provides the facility of checking your jurisdiction. Knowing the jurisdiction in which you fall helps the taxpayer to locate the jurisdictional officer.

Furthermore, the taxpayer needs to provide his jurisdictional details when filling the form for GST registration.

Steps involved in finding your jurisdiction are as follows:

  • Visit the CBIC website. Click the β€˜Services’ tab and select β€˜Know your jurisdiction from the drop down menu.
  • Select the state in the left column on the screen.
  • Then, select the zone, commissionerate, division and range details to your jurisdiction.

Goods and Services Tax Identification Number (GSTIN) is a 15 digit number that is given in a certificate of registration to an applicant once his application for the grant of GST registration is approved. This number is made available to the applicant on the common portal once GST registration gets completed.

The GSTIN is an alpha – numeric number consisting of 15 digits. It is a PAN based number and is state specific. The GSTIN ca be decoded as follows:

  • First Two Digits – Represent the State Code
  • Next Ten Digits – Indicate PAN or TAN
  • Thirteenth Digit – Represents the number of registration under single PAN
  • Fourteenth Digit – Indicates the nature of business (this is kept as β€˜Z’ by default. It is kept blank for future use)
  • Fifteenth Digit – Alphanumeric character that indicates the check code

Suppose a business entity has GSTIN 06BBBBB1111B1ZE. Let’s decode the components of the given GSTIN:

06 BBBBB1111B 1 Z E

Gst Hsn Code List In Excel Free Download Free

  • First Two Digits – State Code (Haryana)
  • Next Ten Digits – PAN or TAN
  • Thirteenth Digit – Represents the number of registration under single PAN (1)
  • Fourteenth Digit – Indicates the nature of business (this is kept as β€˜Z’ by default. It is kept blank for future use)
  • Fifteenth Digit – Alphanumeric character that indicates the check code (E)
[/vc_column][/vc_row]


You May Also Read:

How Many Types of Invoice in GST?

Gst hsn code list in excel free downloads

There will be 2 types of Invoices in GST

  1. Tax Invoice
    It is to be used for all types of taxable Sales
  2. Bill of Supply
    It is to be used for exempt sales + Sales by Composition Dealer

Note:-

For both Goods and Services, It will be Same Series (bill book)

Also for both local and central sales which are taxable, same bill book

Only for exempt goods, there will be separate bill book called Bill of Supply

How will Tax be Charged on Bills

On Local Sales,CGST + SGST will be Charged

On Central Sales,IGST will be Charged

Example

Gst Hsn Code List In Excel Free Downloads

Similarly on Services, Also Same tax will be charged

Current Layer Selector: Users now have a quick way to change the layer on the fly without having to open the Layers panel. Autodesk Drive support: Users can add Autodesk Drive as a storage location to access DWG files stored there. Command Line Enhancements: Now the number of displayed of command line can be adjusted or set to automatically fade away. Download autocad portable free.

Example

Compulsory Items Required in Tax invoice in GST

  1. Name, Address, GSTIN No of Supplier
  2. Unique Serial Number of Each Invoice in one or multiple series (Can have Dash (– )or Slash (/).But it should be different series for each year
  3. Date of Issue of Invoice
  4. Name , Address ,GSTIN of Buyer if Registered
  5. In Case of Unregistered Buyer, Name, Address, State, Place of Delivery is compulsorily required if Invoice Value before taxes is more than 50000
  6. HSN Code of Goods
  7. Description of Goods
  8. Quantity as well as Quantity Code or Units
  9. Total Value
  10. Discount if any and Taxable Value (Total Value-Discount)
  11. Rate of Tax (Separately show CGST, SGST, without IGST, UTGST, Cess if any)
  12. Place of Supply (It is required For Interstate Sales)
  13. Address for Delivery
  14. Whether Tax is Payable Under Reverse Charge
  15. Signature/Digital Signature of Authorized Signatory

Sample Format of Tax Invoice in GST

TAX INVOICE ON GOODS LOCAL

TAX INVOICE ON GOODS CENTRAL

Download in Excel Format

TAX INVOICE ON GOODS LOCAL 2

Download in Excel Format

TAX INVOICE ON SERVICES LOCAL

TAX INVOICE ON SERVICES CENTRAL

Gst Hsn Code List In Excel Free Download Version

Download in Excel Format

QUESTIONS

Can Cash Sales InvoIce Be issued without Mentioning Buyer Name?

Yes

This can be done only if

Sale is to Unregistered

Gst Hsn Code List In Excel Free Download

Taxable Value (Amount before taxes) is upto 50000

For Different Cash Sales during the day, Can One Bill to be issued or Separate?

If taxable value (amount before taxes) is upto 200

And

Buyer Does not ask for bill

Gst Hsn Code List In Excel Free Download 64-bit

Single invoice can be issued for one day sales

What is HSN Code of Item

Full form of HSN Code is

  • Harmonized System Nomenclature
  • In easy language , it means Serial number of Goods
  • In GST,Each goods has a unique Serial Number OF 8 Digits

You can search HSN Code for your goods here

For Services,You can Download Service Accounting Code Excel Sheet

Is Mentioning HSN Code Compulsory on Invoice?

It Depends upon Turnover of Tax Payer

TURNOVER OF TAX PAYER IN LAST YEAR

REQUIREMENT OF HSN CODE

UPTO 150 LAKHS(1.5 CRORE)

NOT REQUIRED

1.5-5 CRORES

FIRST 2 DIGITS

MORE THAN 5 CRORES

FIRST 4 DIGITS

(Notificatiion 12/2017)

How Many Copies of Invoice to be Issued?

As per Rule 3 of GST Revised Invoice Rules:

  1. The invoice shall be prepared in triplicate, in case of supply of goods, in the following manner:–
    1. the original copy being marked as ORIGINAL FOR RECIPIENT;
    2. the duplicate copy being marked as DUPLICATE FOR TRANSPORTER; and
    3. the triplicate copy being marked as TRIPLICATE FOR SUPPLIER.
  2. The invoice shall be prepared in duplicate, in case of supply of services, in the following manner:-
    1. the original copy being marked as ORIGINAL FOR RECIPIENT; and
    2. the duplicate copy being marked as DUPLICATE FOR SUPPLIER.
  3. The serial number of invoices issued during a tax period shall be furnished electronically through the Common Portal in FORM GSTR-1.

How to check Tax Rate on Services to be charged on Bill?

Normal Tax Rate on Service is 18%

However on some services,tax rate is different

Get Complete list here

Download in PDF FORMAT

Real Bill Example for Restaurant Business

Hi, you can learn Accounts, Tax, GST, Tally from our website Teachoo (ΰ€Ÿΰ₯€ΰ€šΰ₯‚)

Click to learn

Tax

(TDS , Payroll , ITR-Income Tax Return , GST)

Excel

(Basic Excel , Shortcuts , Vlookup , Hlookup , Pivot Table , Macros)

Accounts

(Debit-Credit Rules, Entries , Balance Sheet , Fund Flow , Cash Flow , Ratios)

GST

(Basics , Computation , Returns , Registration , Challans)

Tally

(Basics , Ledger creation , Passing Entries , Tally Shortcuts)

You can also attend our Practical Training Classes. Click here to Register