Learn! How to File GSTR-1 Through Tally Prime

Learn! How to File GSTR-1 Through Tally Prime

With TallyPrime, you can file GSTR-1 in three easy ways: by generating JSON from TallyPrime, by using the GST Offline tool, or by filing directly on the GST portal. GSTR-1 includes the details of all outward supplies made in a given period. TallyPrime exports GSTR-1 returns in the latest format compatible with latest version of validation APIs used in offline tool.

Prerequisites for filing GSTR-1

  • GSTR-3B filing: Ensure that GSTR-3B returns are filed regularly. If GSTR-3B is not filed for the previous two return periods, then GSTN will block the filing of GSTR-1 as well.
  • Internet connectivity: This is required for uploading the JSON file, downloading the offline tool, and filing returns.
  • Microsoft Office: For exporting data to MS Excel, GSTN recommends MS Excel 2007 or later (if you are using the GST Offline Tool and MS Excel for filing returns).
  • To comply with GST rules and file accurate returns, ensure that the tax values of sales are equal to or greater than the computed values.
  • As per Rule 59(6) and Advisory on HSN & GSTR 1-filing given by GSTN, HSN Summary is mandatory for filing returns, and no field of HSN Summary can be left blank. The provision of a complete HSN summary is handled in TallyPrime Rel. 2.0

Tax liability on advance receipts

  • For businesses with an annual turnover of up to Rs. 1.5 crores, there is no need to pay tax on advance receipts from customers. 
  • The values of tax liabilities on advance receipt from customers will not be included in the GSTR-1 returns by default. Such transactions will appear under Not relevant for returns in the GSTR-1 report.
  • For businesses with turnovers above Rs. 1.5 crores, you can enable the option Enable tax liability on advance receipts in the Company GST Details screen.

Generate the JSON file from TallyPrime

Generate GSTR-1 returns in the JSON format

  1. Gateway of Tally > Display More ReportsStatutory Reports > GST > GSTR-1.
    Alternatively, press Alt+G (Go To) > type or search GSTR-1 > press Enter.
  2. F2: Period: Select the period for which returns need to be filed.
  3. Press Alt+E and select E-Return from the menu.
  4. Select JSON (Data Interchange) as the File Format.
  5. Specify the folder path to save the e-return in the File path field.
  6. File Name is auto-filled retain the name and press Enter.
  7. Set the option Export Document Summary to Yes.
  8. Press Enter
  9. Click Send to export the e-return.

Upload the JSON file generated from TallyPrime to the portal for filing returns.

Upload of GSTR-1 JSON file fails when HSN summary has negative quantity

If the HSN summary of GSTR-1 has negative quantity, the upload of JSON generated from offline tool or from TallyPrime is failing. Until the issue is resolved by GSTN, you can do the following:

  1. Open the JSON generated from TallyPrime. You can open it in Notepad.
  2. Go to the section “hsn”.
  3. Go to the tag “qty” and remove the negative sign. Repeat this for each “qty” that has a negative sign for taxable value and tax amount.
  4. Save the JSON.
  5. Upload it to portal.
  6. In the portal, go the section HSN Summary.
  7. Add the negative sign against each of the quantities that has taxable value and tax amount (which was removed from JSON).

You can import the Excel or CSV files generated from Tally into the GST offline tool. For this, as mentioned in the prerequisites, you need to download GST offline tool, and then install the offline tool.

Learn! How to File GSTR-1 Through GST Offline Tool

To export GSTR-1 returns in the MS Excel or CSV

  1. Gateway of Tally > Display More ReportsStatutory Reports > GST > GSTR-1.
    Alternatively, press Alt+G (Go To) > type or search GSTR-1 > press Enter.
  2. F2: Period: Select the period for which returns need to be filed.
  3. Press Alt+E and select E-Return from the menu.
  4. Select Excel (Spreadsheet) or CSV (Comma Delimited) as the File Format.
  5. Specify the folder path to save the e-return in the File path field.
  6. Set the option Export Document Summary to Yes and press Enter.
  7. Click Send to export the e-return.

If you have selected the CSV format, TallyPrime will create separate CSV files for each table in GSTR-1. These files need to be imported into the GST Offline Tool.

Learn! How to File GSTR-1 Through GST Offline Tool

Note: If $ symbol appears in the data exported to MS Excel, generate your data in the CSV format. If you want to continue in the MS Excel format, go to the Trust Center Settings in MS Excel, and add the location where TallyPrime is installed on your computer.

For more details on the information captured in each column of the e-return template, click here.

Dhanraj Sharma

Dhanraj Sharma is CEO of Tax Concept. He is on a Mission to Educate and Empower 10,000+ Professionals across the Country.

    Leave a Reply

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

    Social profiles