Read How to Generate GSTR 1 in RetailGraph Software

How to Export GSTR1 in CSV & Excel format

Export GSTR-1 in Excel/CSV Format with Separate HSN Reporting for B2B and B2C


In the latest version of SwilERP (3.2.17.13), a new update has been introduced for GSTR-1 reporting. Now, users can export GSTR-1 data in Excel or CSV format with an added feature: separate HSN summaries for B2B and B2C transactions. This change helps businesses easily view and manage HSN details for each type of saleโ€”business-to-business (B2B) and business-to-consumer (B2C)โ€”in a more organized and clear manner. 

Export GSTR-1 in Excel format:

Start with Login in the SwilERP to Initiate the Process

  1. Go to GST > GST Forms (Offline Tool) > Export GSTR-1 (Excel)
  2. The Export GSTR-1 (Excel) window will appear, as shown in the next slide.
Reference Image:
SwilERP Dashboard Window

GSTR-1 Export with Separate HSN Summary for B2B and B2C:

  • Select the date range in the "From" and "To" fields.
    Example: 1st April 2024 to 31st March 2025

  • Tick the checkbox for Export Debit Note in CDNR to include debit note data.

  • Tick the checkbox for Export Separate HSN for B2B and B2C to generate HSN summaries separately for both.

  • Click the OK button to proceed with the export.

๐Ÿ“„ Note: The report is generated as per Offline Tool version 3.1.3

 

Reference Image:


  • A new window will appear to save the exported file (shown in the next slide).

  • Choose the location (path) where you want to save the file.

  • Enter a file name of your choice.

  • Click Save to download the Excel file to the selected location.

Reference Image:

  • The Excel file contains all GSTR-1 details, including HSN summaries.

  • Separate sheets are available for B2B and B2C supplies.

  • You can view HSN summaries in both the B2BSupplies and B2CSupplies sheets.

  • Review all details before uploading to the GST Offline Utility.

Reference Image:



Export GSTR-1 in CSV format:

  1. Go to GST > GST Forms (Offline Tool) > Export GSTR-1 (CSV)
  2. The Export GSTR-1 (CSV) window will appear, as shown in the next slide.
Reference Image:
SwilERP Dashboard Window
  1. Select the date range using the "From" and "To" fields to define the period for which you want to export data. (For example: 01/08/2024 to 31/08/2024)
  2. Tick the checkbox Export Debit Note in CDNR to include all debit notes in the exported CSV file.
  3. Tick Export Separate HSN for B2B and B2C if you want to separate HSN details.
  4. Click the OK button to proceed.
  5. A new window will appear asking you to select the destination folder.
  6. Browse and select the folder where you want to save the CSV file, then click OK.
๐Ÿ“„ Note: The exported file is compatible with the Offline Tool version 3.1.3.

Reference Image:

      • Related Articles

      • Export GSTR-1 JSON for GSTN Filing

        Exporting GSTR-1 JSON File in SwilERP SwilERP makes it easy to export your GSTR-1 data in JSON format for GST filing. Just select the date range, choose if you want to include Debit Notes in CDNR and separate HSN details for B2B and B2C. The file is ...

      • Export GSTR-2 Excel File

        How to Export GSTR-2 Excel File Through SwilERP Software What is GSTR-2? GSTR-2 is a monthly tax return that contains details of all purchases (inward supplies) made during a particular month. When you make purchases from registered vendors, their ...

      • How to Export GSTR-3B Data in Excel Format

        What is the Process of Exporting GSTR 3B Data to Excel in SwilERP What is GSTR-3B? The GSTR-3B is a summary return that shows all the goods and services a business has bought and sold. It was introduced by the Indian government to make it easier for ...

      • Export GSTR 3B (JSON)

        How to Export GSTR-3B (JSON) File in SwilERP What is GSTR-3B? GSTR-3B is a monthly self-declaration return filed by registered GST taxpayers along with GSTR-1 and GSTR-2. It is a simplified return form used to declare summary GST liabilities such as ...

      • GST Summary Data

        How to view GST Summary Data in SwilERP What is GST summary data? GST stands for Goods and Services Tax. It is an Indirect tax that replaced a host of other Indirect taxes such as value-added tax, service tax, purchase tax, excise duty, and so on. ...