Скачать с ютуб GSTHero Excels for Outward and Inward Supply в хорошем качестве

GSTHero Excels for Outward and Inward Supply

GSTHero, Making your GST Filing Simple. This Video will guide you to enter your Outward and Inward supplies data into GSTHero Excel Templates. We have created two separated sets of Invoices based on the type of supply. 1. Outward Supply (Sales Invoices) 2. Inward Supply (Purchase Invoices) In Outward Supply we have provided three Excels to record the following type of Data: 1. Sales Register 2. Credit - Debit Register 3. Advance Received Register In Inward Supply we have provided Four Excels to record the following type of Data: 1. Purchase Register (All your Purchase, Expense and Fixed Asset Invoices will come under this register) 2. Imports Register (All your Import of Goods and Services Invoices will come in this Register) 3. Debit - Credit Register 4. Advance Paid Register Please Note: Every Excel has Document Type (First Column of Every Excel) which is very important column while entering the data in the excels. Watch this Video to understand the meaning of the Document Types: ======================= Outward Supply Documents Types: 1. Regular :- All Sale (Inter-State and Intra State) made to Registered Customer (B2B) or Unregistered Customer (B2C) only will have this Document Type. NOTE: SEZ and Deemed Exporter may have GSTIN number but they have a different Document Type. 2. Exports LUT/Bond :- All Exports made under LUT/Bond should be mentioned with this Document Type. 3. Exports :- All Exports not made under LUT/Bond should be mentioned with this Document Type. 4. SEZ Exports LUT/Bond :- All SEZ Exports made under LUT/Bond should be mentioned under this Document Type. 5. SEZ Exports : All SEZ Exports not made under LUT/Bond should be mentioned under this Document Type. 6. Deemed Exports: All sale made to a Deemed Exports (E.g. categorised as Merchant Exporter) should be mentioned with this Document Type. 7. NIL Rated : Any Invoice with all items categorised as NIL Rated as be GST law should be mentioned with this Document Type. 8. Exempt : Any Invoice with all items categorised as Exempt as per GST law should be mentioned with this Document Type. NOTE: Any Invoice having items mixed with NIL Rated items should be categorised as Exempt Document Type. NOTE: If any Invoice has Items mixed with Regular should be categorised as Regular Document Type. 9. NON GST: Any Invoice with all its item categorised as NON GST Item should be mentioned with this Document Type. NOTE: Any Mixture of items with NIL Rated and Exempt items should be Categorised as under NON GST only. 10. Credit Note / Debit Note: This Note is issued only against original Invoice from 1 to 9 mentioned above. 11. Advance Receipt : This Document type is used for all the advances received from customers before raising the invoice. We will have to report the vouchers to pay tax. ======================= Inward Supply Documents Types: 1. Regular :- All Purchase (Inter-State and Intra State) made from a Registered Supplier (B2B) or Unregistered Supplier (B2C) only will have this Document Type. NOTE: SEZ Supplier may have GSTIN number but they are treated as Imports and have different Document Type. 2. IMPG :- All Imports of Goods from outside the country or from SEZ should be mentioned with this Document Type. 3. IMPS :- All Imports of Services from outside the country or from SEZ should be mentioned with this Document Type. 4. NIL Rated :- Any Purchase Invoice where all the items are NIL Rated under GST law should be mentioned with this Document Type. 5. Exempt :- Any Purchase Invoice where all the items are Exempt under GST law should be mentioned with this Document Type. NOTE: Any Purchase Invoice mixed with NIL rated items should be mentioned under this Document Type. 6. NON GST :- Any Purchase Invoice where all the items are NON GST i.e. not covered under GST law should be mentioned with this Document Type. NOTE: Any Purchase Invoice mixed with NIL Rated or Exempt items should be mentioned under this Document Type. 7. Composition :- Any Purchase made from a composite Dealer should be mentioned with this Document Type. NOTE: Any Purchase Invoice mixed with NIL Rated, Exempt items should be mentioned under this Document Type. 8. Debit Note / Credit Note: This Note is issued only against original Invoice from 1 to 7 mentioned above. 9. Advance Paid: This Document type is used for all the advances paid to Supplier before raising the invoice.