SwilERP (RetailGraph) GSTR1 Excel and CSV Export and Upload

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 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)

  1. Composition Dealer

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

  1. Non-resident taxable person

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

  1. 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)

  1. Tick-Mark on the "Export Debit note in CDNR" to export all debit notes in excel format.

  1. Next, press OK.

  1. While clicking ok, a new window for selecting a path will appear.

  1. 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.

  1. In the Excel file you'll see B2B, B2CS, HSN CODE and Documents details.

  1. 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)

  1. Tick-Mark on the "Export Debit note in CDNR" to export all debit notes in CSV format.

  1. Next, press OK.

  1. While clicking ok, a new window for selecting a location will appear.

  1. 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.

  1. 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:



 3. After that, you have to submit the details according to the fields. Click the proceed button.

Reference image:




4. 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.

  1. Click on the Import Excel or Import CSV to import the file in offline tool.

  1. In the "Select Section" select the file name from the drop-down list, which you want to import.

  1. Then click on the Import CSV or Excel to upload it.

  1. 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.

  1. 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:


 

 

 




      • 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 ...
      • 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 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 ...
      • 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 JSON File

        How to Export GSTR-1 JSON file in SwilERP Software In this article, we discuss how to export JSON file of GSTR-1 data for uploading in GST Portal. What is GSTR-1? Form GSTR-1 is a return statement in which a regular dealer needs to capture all the ...