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 be furnished by all normal and casual registered taxpayers making outward supplies of goods and services or both. It contains details of outward supplies of goods and services. Every registered taxable person, other than an input service distributor/ composition taxpayer/ persons liable to deduct tax u/s 51/ persons liable to collect tax u/s 52 is required to file Form GSTR-1, the details of outward supplies of goods and services during a tax period, electronically on the GST Portal.

Who is liable to file 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, a Nil return has to be filed by taxpayers. The following are exempted from filing the return:

1. An Input Service Distributor (ISD)

2. Composition Dealer

3. Suppliers of online information and database access or retrieval services (OIDAR)

4. Non-resident taxable person

5. E-commerce operator liable for collecting tax at source (TCS)

6. A taxpayer liable for deducting tax at source (TDS)

Kindly 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 the SwilERP dashboard to initiate the process:

1. Go to the GST > GST Forms (For Offline Tool)> Export GSTR-1(Excel)

Reference image:

SwilERP Dashboard Window

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.

Note: These details export as per Offline tool v 3.1.3

Reference image:

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:

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)

Reference image:

SwilERP Dashboard Window

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:

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:

Reference image:

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: