How to Export and Upload GSTR-1 Data from SwilERP Pharmacy Software

Export and Upload GSTR-1 Data in Excel and CSV from SwilERP

How to Export and Upload GSTR-1 Data from SwilERP


In this Article, we will discuss how we can export GSTR-1 data in excel or CSV format. 

Introduction of GSTR-1

Form GSTR-1 is a return statement in which a regular dealer needs to capture all the outward supplies made during the month or quarter. In simple words, GSTR-1 is a return in which details of sales and other outward supplies need to be captured.

GSTR-1 is a monthly or quarterly return that should be filed by every registered GST taxpayer, except for a few, as given in further sections. It contains details of all outward supplies i.e. sales. The return has a total of 13 sections.

Eligibility of filing GSTR-1

Every GST registered dealer, irrespective of the sales amount, must file the return monthly or quarterly, depending on their annual turnover. It is mandatory to file the return even if there were no sales, and a Nil return has to be filed by taxpayers. The following are exempted from filing the return:
  1. Input Service Distributor: They will have to file GSTR 6.
  2. Non-Resident Taxable Person: They will be filing GSTR 5.
  3. Composition Scheme Taxpayer under section 10: The person opting for Composition Scheme has to file a return in GSTR 4.
  4. Tax Deducted at source under Section 51: They have to file a return under GSTR 7.
  5. A tax collector at Source under Section 52: They have to file a return in GSTR 8.
  6. Suppliers of online information and database access or retrieval services (OIDAR) have to file GSTR-5A. 
Note: 

1) Before starting the process, ensure you have downloaded the latest version of SwilERP(For this, you can contact your local service provider or make a ticket on Support.swildesk.com.

2) To download government offline tool please click the link given below:
Reference link: https://www.gst.gov.in/

Here is the process for exporting GSTR1 into Excel Format: 

Start with Login in SwilERP dashboard to initiate the process:
  1. Go to the GST> GST Forms (For Offline Tool)> Export GSTR-1(Excel)
GST Forms

After that, a new pop-up window will appear in the next slide. Follow the below-given steps to convert data into excel format:
  1. Select the Date Range "From" to "To" which data you want to convert into excel. (For example, you selected the 1st of August to 31st August date range)
  2. Tick-Mark on the "Export Debit note in CDNR" to export all debit notes in excel format. 
  3. Next, press OK. 
  4. While clicking ok, a new window for selecting a path will appear. 
  5. Select the File Path and Save it. 
Reference image: 

File Path


  1. After saving the file destination a excel file will open in your system. 
  2. In the Excel file you'll see B2B, B2CS, HSN CODE, and Documents details. 
  3. You can check the details on the Excel sheet before uploading into Offline Utility. 
Reference image:

Offline Utility


Here is the process for exporting GSTR1 into CSV Format:

Start with Login in SwilERP dashboard to initiate the process:
  1. Go to the GST > GST Forms (For Offline Tool)> Export GSTR-1(CSV)
exporting GSTR1 into CSV Format


  1. Select the Date Range "From" to "To" which data you want to convert into CSV. (For example, you selected the 1st of August to 31st August date range)
  2. Tick-Mark on the "Export Debit note in CDNR" to export all debit notes in CSV format. 
  3. Next, press OK. 
  4. While clicking ok, a new window for selecting a location will appear. 
  5. Select the File location and Save it.
Reference image:

File location

How to upload these files in Government GST Offline Tool 

In case if you don’t have the tool you can go on this link and download it.

Reference Link: https://www.gst.gov.in/
  1. After this process we have to open the downloaded offline tool. 
  2. Now, you have to Click on the “upload new invoice/other data for return” in the New option.
As shown in the below-given image:

Government GST Offline Tool
 
  1. After that, you have to submit the details according to the fields. And click the proceed button.
Reference image: 

Government GST Offline Tool

  1. A new window will appear in the next slide, where you have to click on the import files option. 


  1. After this process, you will see a new form with an option to import CSV/Excel.
  2. Click on the Import Excel or Import CSV to import the file in offline tool. 
  3. In the "Select Section" select the file name from the drop-down list, which you want to import.
  4. Then click on the Import CSV or Excel to upload it. 
  5. It will ask you the CSV path in the system, and you have to select the bsb.csv file to import. And then, click on the view summary button.
  6. This process will upload the CSV or Excel file in the tool, and you can see your summary by clicking the option view summary.
The below-given image for your reference:

Government GST Offline Tool


      • Related Articles

      • Export GSTR-3B Data in Excel Layout

        What is the process of exporting GSTR 3B data into excel in SwilERP (RetailGraph) What is GSTR-3B? The GSTR-3B is a consolidated summary return of inward and outward suppliers that the government of India has introduced to relax the requirements for ...

      • SwilERP (RetailGraph) GSTR1 Excel and CSV Export and Upload

        How to Export GSTR-1 Data From SwilERP (RetailGraph) Please Click the following link to see through the video how to Export "GSTR1 through Excel and CSV in SwilERP" Watch Now What is GSTR-1? GSTR-1 form is a monthly Statement of Outward Supplies to ...

      • Export GSTR-2 Excel File

        How to Export GSTR2 Excel File Through SwilERP Software What is GSTR-2? The GSTR-2 is a monthly tax return showing the purchases you’ve made for that month. When you make purchases from registered vendors, the information from their sales returns ...

      • Export GSTR9 Data In Excel File

        How to Export GSTR-9 Data in Excel File Through SwilERP Software What is GSTR 9? GSTR-9 is the annual return that all registered, taxable people must file. Businesses are required to file this return annually by 31st December of the coming financial ...

      • Export GSTR-1(Excel) Data

        How to Export GSTR-1(Excel) Data in SwilERP Software What is GSTR-1 Data ? Form GSTR-1 is a return statement in which a regular dealer needs to capture all the outward supplies made during the month or quarter. In simple words, GSTR-1 is a return in ...