Explore Categories

 

 PDF

File GSTR-1

GSTR-1 is a tax return that has to be filed by a regular dealer on the GSTN portal. If you are a regular dealer, then you have to upload the details of all your outward supplies (or sales transactions) every month or quarter, as per the turnover from the previous Financial Year.

Filing your return might sound like a daunting task, but TallyPrime will make your journey as easy as possible, while taking care of your business practices and preferences. You can file your GSTR-1 using TallyPrime in the following three ways.

Generate JSON file using TallyPrime and upload on the portal

This method fits in perfectly with the regular course of your business. You only have to record your GST transactions in TallyPrime, as usual, and the relevant details will be reflected seamlessly in the GSTR-1 report in TallyPrime. After that, you can export the details to a JSON file and upload it to the portal. As easy as that! All your GST data from TallyPrime will appear seamlessly on the portal.

Generate JSON file using GST Offline Tool and upload on the portal

Instead of directly generating a JSON file from TallyPrime, you can also make use of the GST Offline Tool provided by the portal. In this method, you have to export your GSTR-1 details from TallyPrime in the MS Excel or CSV format, and then import the file into the GST Offline Tool. Then you can export the details to a JSON file and upload it to the portal.

File GSTR-1 directly on the portal

If you do not wish to file your return using a JSON file, then you can also file your GSTR-1 directly on the portal. In this method, you can easily copy the details from the GSTR-1 report in TallyPrime and paste it in the respective sections on the portal. Alternatively, you can also fill the details manually by referring to the values in TallyPrime.

Prerequisites for Filing GSTR-1

Before proceeding to file GSTR-1, you must take care of a few requirements to ensure that your filing goes as smoothly as possible.

System requirements

  • Internet connectivity: An active internet connection is required for uploading the JSON file, for downloading the GST Offline Tool, and for filing your returns.
  • Microsoft Office: If you are using the GST Offline Tool and MS Excel for filing returns, then GSTN recommends MS Excel 2007 or later for exporting data to MS Excel.

General GST requirements

  • 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. To know more, refer to our blog.
  • Tax calculation: To comply with GST rules and file accurate returns, ensure that the tax values of sales transactions are equal to or greater than the computed values.
  • HSN Summary: As per Rule 59(6) and Advisory on HSN & GSTR-1 filing shared by GSTN, it is mandatory to provide complete details of the HSN Summary for filing returns.

Requirements in tax liability on advance receipts

  • Advance receipt based on turnover: 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. On the other hand, tax on advance receipts is applicable for businesses with turnovers above Rs. 1.5 crores. In such cases, you will have to enable the option Enable tax liability on advance receipts in the Company GST Details screen.
  • Advance receipt 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 in the Not Relevant for This Return section of the GSTR-1 report.

Generate JSON File Using TallyPrime

Once you have verified your GSTR-1, you can easily share these details with the tax department. You only have to export the details in the required format and upload it on the portal. All your GST data from TallyPrime will appear seamlessly on the portal.

  1. In the GSTR-1 report, press Alt+E (Export) > GST Returns. The Export GSTR-1 screen will open, where you can select the required period and company or tax registration. 
  2. Explore and set the required options in Ctrl+B (Basis of Values). For example, based on your business needs, you can choose to either include or exclude the HSN Summary and Document Summary in your exported GSTR-1 data.
  3. Explore and set the required options in F12 (Configure).
  4. Select the transactions and/or summaries that you want to export to the portal for filing, and press X (Export).

    The Export screen will appear as shown below:
  5. Select JSON (Data Interchange) as the File Format, and configure the options for section-wise export and Folder Path, as needed.
  6. Press E (Send) to export.

The exported file will be saved in the selected Folder Path, which will be automatically opened by TallyPrime. Now you can proceed to upload the file on the GST portal.

Uploading GSTR-1 when HSN Summary has negative quantity

If the HSN Summary contains a negative quantity, then you might face problems in uploading the JSON file on the GST portal. Until this issue is resolved by GSTN, you can perform the following steps for a successful upload.

I. Update the details in the JSON file 

  1. Open the JSON file generated from TallyPrime in the Notepad format.
  2. Go to the “hsn” section.
  3. Go to the “qty” tag 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 file.

II. Update the details on the portal 

  1. Upload the JSON file on the portal.
  2. Go to the HSN Summary section.
  3. Add a negative sign against each of the quantities that has taxable value and tax amount, which were removed from the JSON file.

File GSTR-1 Return

  1. In the GSTR-1 report in TallyPrime, press Alt+V (Open GST Portal). The GST portal will open, where you can see the Login screen.
  2. Log in with your registered Username and Password.
  3. Click Services > Returns > Returns Dashboard.
  4. Select the Return Filing Period and click Search.
  5. Select Yes to file Quarterly return or No to file Monthly return, based on the annual turnover of your business.
  6. Click SUBMIT.
  7. Click PREPARE OFFLINE.
  8. Click Choose File to import the JSON file that has been generated from TallyPrime or from the GST Offline Tool.

    Once your JSON file is uploaded successfully, you will be notified by a message from the GST portal.

    If you have generated multiple JSON files for uploading your latest transactions and for deleting some of your previous transactions, then it is recommended that you first upload the JSON file for deleting the transactions, and then upload the JSON file for regular transactions. This will ensure that all your details are uploaded and processed seamlessly.

  9. Verify the uploaded details after the time specified in the GSTR screen.
  10. Go to Services > Returns > Returns Dashboard, and click PREPARE ONLINE.
  11. Submit your returns and e-sign.

Here is an animated GIF to show you how you can easily file GSTR-1 on the portal using the JSON files generated from TallyPrime:

Generate JSON File Using GST Offline Tool

Once you have downloaded and installed the GST Offline Tool, you can import the MS Excel or CSV files generated from TallyPrime. 

The department has released GST Offline Tool Version 3.1.6. To know about the changes needed to generate the JSON file in this version, refer to the Changes when using the GST Offline Tool Version 3.1.6 section. Before importing your MS Excel and CSV files to the GST Offline Tool, you have to make the following changes in the files:
1. In the B2B and CDNR sheets, update the invoice type from Regular to Regular B2B.
2. Update the HSN codes to include at least two digits, based on the annual turnover of your business

Export GSTR-1 to MS Excel or CSV files

  1. In the GSTR-1 report, press Alt+E (Export) > GST Returns. The Export GSTR-1 screen will open, where you can select the required period, company, or tax registration.
  2. Explore and set the required options in Ctrl+B (Basis of Values). For example, based on your business needs, you can choose to either include or exclude the HSN Summary and Document Summary in your exported GSTR-1 data.
  3. Explore and set the required options in F12 (Configure).
  4. Select the transactions and/or summaries that you want to export to the portal for filing, and press X (Export).

    The Export screen will appear as shown below:
  5. Select Excel (Spreadsheet) or CSV (Comma Delimited) as the File Format, and configure the options for section-wise export and Folder Path, as needed.
  6. Press E (Send) to export.

The exported file will be saved in the selected Folder Path, which will be automatically opened by TallyPrime. If you have selected the Excel (Spreadsheet) format, TallyPrime will create a single MS Excel file. For CSV format, TallyPrime will create separate CSV files for each table in GSTR-1. These files have to be imported into the GST Offline Tool.

If the $ symbol appears in the data exported to MS Excel, generate your data in the CSV format. However, if you want to continue in the MS Excel format, then you have to 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.

Import data and generate the JSON file

  1. Open the GST Offline Tool.

    Ensure that you download and install the latest version of the GST Offline Tool. The department has released GSTR Offline Tool Version 3.1.6. When using this version of the tool, complete these steps for importing data, and do a couple of simple changes as mentioned under Changes when using the GST Offline Tool Version 3.1.6.

  2. Click NEW.
  3. Provide the required details and click PROCEED.
  4. Click IMPORT FILES.
  5. Click IMPORT EXCEL and select your file, if the return details were exported from TallyPrime in the MS Excel format.

    If you are using Version 3.1.6 of the GST Offline Tool, all the sections, except B2B and CDNR, will get imported. To know how to import these sheets, refer to the Changes when using the GST Offline Tool Version 3.1.6 section.


    To import the return details in the CSV format, select the name of the table in Select Section under Import Returns – One section at a time, and click Import CSV. You have to individually import files for each section.

  6. Click YES on the warning message and click VIEW SUMMARY.
  7. Click GENERATE FILE.

If you get a warning that some invoices contain invalid input, you can ignore it and proceed to generate the file. This can happen when you do not have any transactions in a selected section.
The GST Offline Tool generates a JSON file that has to be uploaded on the GST portal. If you are using Version 3.1.6 of the GST Offline Tool, then you have to perform the following steps to generate the JSON file.

Updates needed while using Version 3.1.6 of the GST Offline Tool
  1. After exporting GSTR-1 data from TallyPrime to Excel, import the Excel file to the GST Offline Tool. All the sections, except B2B and CDNR, will get imported to the tool.
  2. Export GSTR-1 data from TallyPrime in the CSV format.
  3. Open the CSV files of B2B Invoices 4A_4B_4C_6B_6C and CDNR in the MS Excel format.
  4. In the Invoice Type column, change the value Regular to Regular B2B in both the files. No changes are needed in the other invoice types.
  5. Import the updated CSV files into the tool where you have imported the remaining sections of GSTR-1.
    Now the GST Offline Tool will contain the details of all the sections.
  6. Generate a JSON file from the GST Offline Tool and upload it on the portal.

Now you can log in to the GST portal and file your GSTR-1 returns.

Updates needed for e-commerce operators

The GST department has not issued any GSTIN/UIN for e-commerce operators. Thereby, when GST data is exported from TallyPrime to MS Excel or CSV files, the GSTIN/UIN entered in the e-commerce party ledger is captured as E-Commerce GSTIN in b2bb2cl, and b2cs worksheets.

You have to make the following updates after exporting data to MS Excel or CSV files:

  1. Delete the GSTIN/UIN captured in the column E-Commerce GSTIN.
  2. Set the Type as OE in the b2cs worksheet.
  3. Generate the JSON file.

File GSTR-1 Directly on GST Portal

  1. Log in to the GST portal.
  2. Select the Return Filing Period and click SEARCH.
  3. Select Yes to file Quarterly return or No to file Monthly return, based on the annual turnover of your business.
  4. Click SUBMIT.
  5. Click PREPARE ONLINE.
  6. Copy the data for each section from the GSTR-1 report in TallyPrime and paste it in the relevant table of GSTR-1. Alternatively, you can refer to the data in TallyPrime and manually enter the details on the portal.
  7. Submit your returns and e-sign.

Download and install the GST Offline Tool

  1. Go to the GST portal > Downloads.
  2. Click Returns Offline Tool. A zip file containing the GST Offline Tool will be downloaded. This zip file also contains a detailed document on using the tool. Some important information about the tool and the system requirements are available on the Downloads page.
  3. Extract the offline tool from the zip file and install it.

Uninstall the previous version of GST Offline Tool

If you are using an older version of the GST Offline Tool, then it is recommended that you uninstall it and use the latest version.

  1. On your computer, go to Control Panel > Programs and Features.
  2. Right-click GST Offline Tool, and click Uninstall and proceed.
  3. Similarly, uninstall the Node.js application.
  4. Delete the folder where the older version of the GST Offline Tool was installed.
  5. Restart your computer.

Now you can download and install the latest version of the GST Offline Tool.

Depending on your requirements, you can use the GST Offline Tool either on the same computer where TallyPrime is installed, or on a different computer.

Mapping the Unit of Measurement (UoM) when the UQC is not available

The list of Unit Quantity Codes (UQC) provided by the department does not have the representative code for units such as brass, carats, and running foot. However, you can resolve this issue in TallyPrime using the following steps.

  1. Map the UoM to the related UQC. For example, you can map carat to KGS-KILOGRAMS.
  2. Export GSTR-1 in the MS Excel or CSV format.
  3. Open the HSN worksheet of the MS Excel or CSV file, and convert the quantity as per the mapped UQC. 
    For example, if carat is mapped to KGS-KILOGRAMS, then multiply the quantity by 0.0002. Refer to the Conversion Factors table given below, for details about other UoMs.
  4. Upload the modified MS Excel template or CSV file to the GST Offline Tool.
  5. Generate the JSON file.
Conversion Factors
Conversion Factors

Unit of Measurement (UoM)

Nearest UQC

Conversion of Quantity

(Multiply by)

Carat

KGS-KILOGRAMS

0.0002

GMS-GRAMMES

0.2

Brass

SQF-SQUARE FEET

100

CBM-CUBIC METERS

2.835

Running foot

MTR-METERS

0.3048

Cubic inches

MLT-MILILITRE

16.3871

Hanks

YDS-YARDS

For cotton: 840

For woollen: 560

Inches

MTR-METERS

0.0254

CMS-CENTIMETERS

2.54

Pounds

TON-TONNES

0.000453592

KGS-KILOGRAMS

0.453592

GMS-GRAMMES

453.592

Lots

TON-TONNES

0.0000128

KGS-KILOGRAMS

0.0128

GMS-GRAMMES

12.8

Milligrams

GMS-GRAMMES

0.001

Decameter square

SQY-SQUARE YARDS

119.599

SQF-SQUARE FEET

1076.39

Square inches

SQM-SQUARE METERS

0.00064516

SQY-SQUARE YARDS

0.000771605

SQF-SQUARE FEET

0.00694444

Tola

GMS-GRAMMES

11.6638125

The e-Return file has the provision to capture the taxable value and tax rate but not the tax amount. Hence, the tax amount is not exported to the e-Return file. After the details are uploaded, the tax value is automatically calculated based on the rate, taxable value, and place of supply.
 

Filing GSTR-1 for QRMP Dealers

If you have opted for the QRMP scheme, then you will have to upload B2B invoices and credit notes every month using the Invoice Furnishing Facility (IFF) provision on the GST portal. Accordingly, TallyPrime provides you with the facility to export the JSON files of each section in GSTR-1. Refer to the Uploading to IFF for QRMP Dealers topic for more details.

Post a Comment

Is this information useful?
YesNo
Helpful?