GST is Collected in four ways CGST, SGST, UGST(Union Territory), IGST. There are three types of dealers they are Regular Dealer, Composite Dealer, Specific Register Dealer. GST collected from the taxpayer by different rate of taxes they are 28,18,12 & 5 percents. Every taxpayer rises two types GST Invoice they are tax invoice and bill of supply. The tax invoice maintained by regular dealers (more than 1.5 crores) and the bill of supply invoice maintained by the composite dealer (less than 1.5 crores turnover) & supply of exempted goods and services. Here you can find the GST invoice in excel format with automatic calculations.
The regular dealer should enter the below details for preparing GST invoice in excel format :
- Name and address & GST number of supplier
- Tax invoice number
- If the buyer registered then enter buyer name and address & GST.No
- If the buyer unregistered person then enter the buyer name and address only
- HSN Code of services
– Between 1.5 to 5 crores turnover you have to enter 2 digits HSN code in the invoice
-For 5 crores and above turnover you have to enter 4 digits HSN code in the invoice
- Particular details of goods and services
- Quantity of goods
- The total value of goods & services
- Taxable value
- Payment mode (credit / cash)
- Applicable tax rate of GST
- Amount of tax
- Place of supply (Intra State or Inter-state, If the place supply to intrastate then you should calculate CGST & SGST Tax. If the place of supply is Intra-State then you should calculate IGST Tax)
- Signature of the supply and firm stamp
↓Download GST Invoice Automatic Calculation