HomeTallyPrimeTaxation ComplianceIndia GST - RegularGSTR-1Uploading to IFF for QRMP Dealers

 

Explore Categories

 

 PDF

File GSTR-1 Using IFF (for QRMP Dealers)

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.

However, if you have opted for the Quarterly Return Monthly Payment (QRMP) scheme, then you will have to upload the details of your B2B invoices and credit notes every month using the Invoice Furnishing Facility (IFF) provision on the GST portal. This might sound like a daunting task, but TallyPrime will make it very easy for you. The GSTR-1 report in TallyPrime provides you with the brilliant flexibility to export separate JSON files for each section of GSTR-1, which will help you upload the details in a systematic and timely manner.

Accordingly, you can easily export the following sections and upload them on the portal in the first two months of the quarter.

  • 4A, 4B, 4C, 6B, 6C – B2B Invoices
  • 9B – Credit/Debit Notes (Registered) – CDNR
  • 9A – Amended B2B Invoice – B2BA
  • 9C – Amended Credit/Debit Notes (Registered) – CDNRA

After you upload the details on the portal, your buyers can claim the Input Tax Credit in the first and second months. In the third month, you can file GSTR-3B and GSTR-1, as usual.

Export GSTR-1 Sections for Monthly and Quarterly Return Filing

As a QRMP dealer, you need to upload the JSON files of the B2B Invoices and Credit Note and Debit Note sections in all the three months of a quarter. Moreover, in the third month of a quarter, you will need to upload the JSON files of all other sections of the quarter along with the B2B Invoices and Credit Note and Debit Note sections of that particular month.

  1. Press F11 (Company Features) > Goods and Services Tax (GST) and press Enter.
  2. Periodicity: Quarterly.
    GSTR-1 for Quarterly Filing in TallyPrime
  3. Press Alt+G (Go To) > type or select GSTR-1 and press Enter.
    Alternatively, Gateway of Tally > Display More Reports > Statutory Reports > GST > GSTR-1 and press Enter.
    By default, the GSTR-1 report will be open for a quarter.
  4. Export B2B Invoices and Credit Notes sections for the first two months of the quarter.
    1. Press F2 (Period).
    2. Enter From and To dates, as per the dates of the month.
    3. Press Alt+E (Export) > GST Returns.
      The Export GSTR-1 screen appears.
    4. Press F12 and set Show Section as Yes.
    5. Select the B2B Invoices – 4A, 4B, 4C, 6B, 6C, Credit or Debit Notes (Registered), Credit or Debit Notes (Unregistered), and amendments sections, as applicable.
      Selecting Sections for the First Months of the Quarter While Exporting GSTR-1 from TallyPrime
    6. Press X (Export).
    7. Configure the export.
      1. Press C (Configure).
      2. File Format: JSON (Data Interchange).
      3. Set other configurations, as needed.
    8. Press E (Send). 
      The JSON files of the sections get exported.
  5. Similarly, in the third month of the quarter, export B2B Invoices – 4A, 4B, 4C, 6B, 6C, Credit or Debit Notes (Registered), and Credit or Debit Notes (Unregistered) sections, as applicable.
  6. Export other sections for the entire quarter for the third month.
    1. Press F2 (Period).
    2. Enter From and To dates, as per the dates of the quarter.
    3. Press Alt+E (Export) > GST Returns.
    4. Press Alt+E (Export) > GST Returns.
      The Export GSTR-1 screen appears.
    5. Press F12 and set Show Section as Yes.
    6. Select sections other than B2B Invoices – 4A, 4B, 4C, 6B, 6C, Credit or Debit Notes (Registered), and Credit or Debit Notes (Unregistered).
    7. Press X (Export).
    8. Configure the export.
      1. Press C (Configure).
      2. File Format: JSON (Data Interchange).
      3. Set other configurations, as needed.
    9. Press E (Send).
      The JSON files for the other relevant sections get exported.

Export Separate JSON files for Each Section of GSTR-1

Once you have verified your GSTR-1, you can easily share the details of specific sections with the tax department. You only have to export the required details in JSON files and upload them on the portal using the IFF provision. All your GST data from TallyPrime will appear seamlessly on the portal.

  1. From any screen in TallyPrime, press Alt+E (Export) > GST Returns.
    The Export GSTR-1 screen will open, where you can select the required period, company, or tax registration.
    Note: You can view the report for the required period by pressing F2 (Period). Accordingly, you can export the JSON files for the relevant month or quarter.
  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 enable the Export separate files for each Section option.
  6. Press E (Send) to export.
    The section-wise JSON files will be saved in the selected Folder Path, which will be automatically opened by TallyPrime.
    Section-wise JSON Files for a Month
    If you were exporting the details for a quarter, then the JSON files will appear as shown below.
    Section-wise JSON Files for the Quarter
    Now you can proceed to upload the relevant files on the GSTR-1 portal.

Here is an animated GIF to show you how you can easily generate different JSON files for the required sections:

File GSTR-1 on the Portal Under IFF

Upload B2B Invoices and Credit Notes for the first two months

After generating JSON files for the required sections of GSTR-1, you can upload them on the GST portal.

  1. Log in to the GST portal.
    1. In the GSTR-1 report in TallyPrime, press Alt+V to open the GST portal.
    2. Click Login on the portal screen.
    3. Enter the registered Username & Password, type the captcha characters shown in the image, and click LOGIN.
  2. Navigate to the IFF section on the portal.
    1. Click RETURN DASHBOARD.
      Return Dashboard on the GST Portal
    2. Select the Financial Year and Period, and click SEARCH.
      Select Financial Year and Period for IFF
      The IFF section will appear as shown below:
      Invoice Furnishing Facility on the GST Portal for the QRMP Dealers 
  3. Upload the JSON files of the B2B invoices section.
    1. Click PREPARE OFFLINE under Invoice Furnishing Facility (Optional) in the Details of outward supplies of goods or services section.
    2. Click Choose File.
      Choose Files to Upload for IFF on the GST Portal
    3. Select the JSON file of the relevant section and month, and press Enter.
      Selecting JSON Files Corresponding to the Month for IFF
      The Upload History screen with the details of transactions will appear.
      Similarly, you can upload the JSON files of the other sections.

File returns in the last month of the quarter

Under the QRMP scheme, you can file your quarterly returns in the following method.

  1. Navigate to the Quarterly GSTR-1 section on the portal.
    1. In the File Returns screen, select the last month of the quarter in the Period field, and click SEARCH.
      Select the Last Month of the Quarter for Filing E-Return on the GST Portal
    2. Click PREPARE OFFLINE, under GSTR-1 (Quarterly) in the Details of outward supplies of goods or services section. GSTR-1 - Prepare Offline to File Quarterly Return
  2. Upload the JSON files of the B2B invoices for the last month of the quarter.
    1. Click Choose File.
      Choose Files to File E-Return for the Quarter on the GST Portal
    2. Select the JSON files of the required B2B invoices for the last month of the quarter, and press Enter.Select JSON Files of Sections other than B2B for the Quarter Generated Using TallyPrime
      Similarly, you can upload the JSON files of the credit notes of the month.
  3. Upload the JSON files of the rest of the sections for the whole quarter.
    1. Click Choose File.
    2. Select JSON files of the sections other than B2B invoices and press Enter.

Export Separate CSV Files for Each Section of GSTR-1

In TallyPrime Release 1.1.3 and later versions, you can easily export JSON files for different sections under the IFF provision. However, if you are yet to update to the latest version of TallyPrime, you can export section-wise CSV files and then convert them into JSON files using the GST Offline Tool.

  1. From any screen in TallyPrime, press Alt+E (Export) > GST Returns. The Export GSTR-1 screen will open, where you can select the required period, company, or tax registration.
    Note: You can view the report for the required period by pressing F2 (Period). Accordingly, you can export the CSV files for the relevant month or quarter.
  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 CSV as the File Format, and enable the Export separate files for each Section option.
  6. Press E (Send) to export.
    The section-wise CSV files will be saved in the selected Folder Path, which will be automatically opened by TallyPrime. Now you can proceed to upload the files on the GSTR-1 portal.
    Section-Wise CSV Files Generated Using TallyPrime

Convert CSV files into JSON files using GST Offline Tool for IFF

  1. Open the Goods and Services Tax Offline Tool, and under Upload new invoice/other data for return, click NEW.
    GST Offline Tool
    The File Returns screen opens.
  2. Specify the required details.
    1. Under GST Statement/Returns, select GSTR-1/IFF.
    2. Enter the GSTIN of your business under GSTIN of Supplier.
    3. Select the Financial Year for which you are filing returns.
    4. Select the Tax Period. This will be the period or month for which you are going to upload the CSV files.
    5. Set Is SEZ Taxpayer? to No.
    6. Set Is taxpayer Quarterly filer? to Yes and click PROCEED.
      File Returns Screen
  3. Select the required section, for instance, B2B Invoices – 4A, 4B, 4C, 6B, 6C, and click IMPORT FILES.
    Import Files to the GST Offline Tool
  4. Import the CSV file for the required section.
    1. Click IMPORT CSV.
      Click Import CSV on GST Offline Tool
    2. Select the CSV file for B2B invoices and press Enter.
      Select CSV Files to be Converted into JSON Files Using GST Offline Tool
      Similarly, you can import the CSV files for credit notes.
      Select Section on GST Offline Tool
  5. Generate the JSON files corresponding to the uploaded CSV files.
    1. Click VIEW SUMMARY. The Summary screen will open.
    2. Click GENERATE FILE. The JSON files corresponding to the uploaded CSV files will be downloaded.
      Generate JSON Files Using GST Offline Tool

Once you generate the JSON files using the GST Offline Tool, you can upload the B2B invoices and credit notes in the first and second months of the quarter, and then file your returns in the last month of the quarter.

 

Related Topics

Post a Comment

Is this information useful?
YesNo
Helpful?