How To File Your GSTR-1 Yourself Step By Step - INVI India Blog

Blog

 

Here is complete procedure for how to file your GSTR-1 yourself step by step.

Please download GSTR-1 Excel template
  • Kindly extract the downloaded ZIP file and you will be using following 2 files from the extracted folder:

                                  a. GSTR1_Excel_Workbook_Template (Excel Sheet)

                                  b. GST Offline Tool (Application).

How to file GSTR 1 GST Return online

In the Excel Template named GSTR1_Excel_Workbook_Template. Please delete all the prefilled data.

  • Using the said Excel Template you can add your information for GSTR-1.

Understanding the Excel Template:

There will be 4 general cases

1. B2B Invoices: The Invoices made to Customers with GSTN

2. B2CL Invoices: The Invoices which are made to Customers without GSTN but the total invoice value (including GST is more than 2.50 Lacs)l

3. B2CS Invoices: The Invoices which are made to Customers without GST not covered in point 2 Less: Credit Notes

4. Export: This will be in case of Invoices made in Currency other than INR.

5. Credit Notes: All credit Notes made in the App will which contains GSTN.

Details are as follows:

1. B2B Invoices: Only those Invoices in which the sale has been made through Enter GSTN Tab will go in this: it will be exported in Sheet b2b:

Column A: GSTIN/UIN: This contains GSTN of Customers

Column B: Receiver Name: This contains Customers Trade Name

Column C and D will be Invoice Number and Invoice Date

Column E will be Total Invoice Value, (Total of Basic + GST)

Column F will be place of Supply: Customers GSTN 1st 2 digits will be used here

Column G: Reverse Charge if Applicable (generally its not)

Column H: Applicable % Rate: this will remain blank

Column I: Invoice Type: Regular in all cases

Column K: will have Tax rate of Invoice

Column L: This will have total Taxable value: i.e. Basic Amount of Invoice.

2. B2CL Invoices: All Invoices which does not contain GSTN of Customers and the total Invoice Value is more than 2.50 Lacs will come in this sheet (b2cl).

Column A&B: will have Invoice Number and date

Column C: Invoice Value (Basic + GST)

Column D: Place of Supply: Customers GSTN 1st 2 digits will be used here

Column F: Tax Rate

Column G: This will have total Taxable value: i.e. Basic Amount of Invoice.

3. B2CS Invoice:  The Invoices which are made to Customers without GST not covered in point 2 Less: Credit Notes

Column A: Type: Always OE

Column B: Place of Supply: Customers GSTN 1st 2 digits will be used here

Column D: Tax Rate

Column E: This will have total Taxable value: i.e. Basic Amount of Invoice.

In this case total of all invoices in One Place of Supply has to come one time only.

It will generally be the Place of Supply of the Person registered with us only. I.e. at the time of registration the GST number given to us, its first 2 digits.

Less: Credit Notes of Invoices which are made without GSTN and the original Invoice Value is less than 2.50 Lacs will be deducted here.

Only Net Value of Sale-Credit Notes has to come here and the same can be negative.

4. Export: This will be in case of Invoices made in Currency other than INR.

Sheet: exp:

Column A: Export Type: WOPAY will pe done

Column B &C: will be Invoice Number and Invoice Date

Column D will be Total Invoice Value, (Total of Basic + GST)

Column H: Rate of Tax

Column I: This will have total Taxable value: i.e. Basic Amount of Invoice.

5. Credit Notes: All credit Notes made in the App will which contains GSTN.

Sheet CDNR

Column A: GSTN

Column B: Trad Name of Customer

Column C: Credit Note No.

COlumn D: Date

Column E: Note Type: Generally, C

Column F: Place of Supply: Customers GSTN 1st 2 digits will be used here

Column G: Generally, N

Column H: Note Supply Type: Always Regular

Column I: Note Value: will be Total Invoice Value, (Total of Basic + GST)

Column K: Tax Rate

Column L: Taxable value: This will have total Taxable value: i.e. Basic Amount of Invoice.

– All credit Notes made in the App will which do not contain GSTN and whose original Invoice Value is more than 2.50 Lacs will come here:

Sheet CDNUR

Column A: UR Type: B2CL if the Note is in INR and EXPWOP if the Note is in any currency other than INR.

Column B and C: Note Number and Note date

Column D: Always C

Column E: Place of Supply

It will generally be the Place of Supply of the Person registered with us only. I.e. at the time of registration the GST number given to us, its first 2 digits.

Column F: Note Value: Basic+GST

Column H: GST Tax Rate

Column I: Taxable Value= Basic Value of Note

Special Cases: Where in an Invoice there are more than 1 rate of GST then:

The said Invoice will be split in the number of rates it has.

And a separate Invoices will be shown with same info as above just in cases of:

– Rate: Different Rates will be given

and in Case of Invoice Value: Basic Value for the said Rate will be given

Invoice value will remain the total of Invoice Value of the said Invoice Number.

Same will go for Credit Notes

Please note: that the columns not discussed above are generally not applicable in GSTR-1 Filing, if you have doubt regarding the same please contact at [email protected]. Don’t worry consultations are free of cost and we reply within 48 hours of your mail.

  • Further kindly add or delete the Information from the Template as per your requirements and you can use the Help section in the said template for the same.
  • After the Template is finalised, kindly open GST Offline Tool (Application), extracted above, and let it install on your Computer System).
  • Open the application and Select upload new Invoice/Other Data for Return (New).
  • In Column GST Statement/Returns- Select GSTR-1, Further Input your GST Number in Column 2, Select Financial Year in Column 3 and Period of Tax in Column 4 (For Quarterly Returns Select- Last Month of the Quarter for which return is being filed.) Further In SEZ and Quarterly return filer options, kindly select as applicable.
  • Kindly select the Import Files option and import the Excel Sheet made at point no. 3.
  • After Import is Completed, please click on View Summary and after checking the same create Jason for GSTR-1.
  • Save the Jason file and Log in to GST Portal and go to Return Dashboard-Select the Relevant period of Return, In file GSTR-1 option kindly click on Prepare Offline and then Upload this Jason file.
  • Once the file is uploaded, please go back and click on the GSTR-1 Column and at the end view Summary of GSTR-1.
  • Further if everything looks fine, please click on Submit, and then file Return by using EVC or DSC.

Congratulations You have Successfully filed Your GSTR-1 yourself.

INVI INVOICING: Our mission is to make invoicing and GST easy for small businesses who stress during the accounting process and waste a lot of their hard-earned money in hiring professionals, yet don’t get 100% transparency and satisfaction. Now stop running to your professional for Invoicing and GST, make it yourself in just few clicks with INVI (Unleash the Power of Simplicity), anywhere, anytime, (be digital)

Quick Features:

  • Digital INVOICING
  • Multiple Templates
  • GST Automated
  • GSTR-1 Filing
  • IMPORT and EXPORT of DATA in quick easy steps.
  • and much more for you at just Rs. 1 per day.
  • Visit us at: https://inviindia.com/
  • Download on app store: https://apps.apple.com/in/app/invi-invoicing/id1570035950
  • Download on android play store: https://play.google.com/store/apps/details?id=app.inviindia.invi

Leave a comment

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