Learn How to Export GSTR-1(Excel) Data in SwilERP Software

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 which sales details 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.
 
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 GSTR-1 into (Excel) new format:

Start with Login SwilERP dashboard to initiate the process:

  1. Go to the GST tab.
  2. Select GST Forms (For Offline Tool) >Export GSTR 1 (Excel) New.

Reference Window:
Export GSTR 1SwilERP Dashboard Window
  1. How to Export GSTR-1 (Excel) New:

  1. After clicking on export GSTR-1 (Excel) New option a pop-up window will open, select the Date-Range 'From to To' in it.
  2. Now, click on the Ok.
Reference Window:
Date RangeSwilERP Dashboard Window
  1. While clicking Ok, a new window for selecting a path will appear.
  2. Select the File Path and enter the file name to save it.
  3. Click on Save button.
Reference Window:

Save button



  1. After saving the file destination, an excel file will open in your system.
  2. The Excel file shows B2B, B2CS, Exp, SEZ, and Documents details.
  3. You can check the details on the Excel sheet before uploading it into Offline Utility.

Excel sheet


So it was the process of how you could export the GSTR-1 data in the new excel format. After exporting the data, you can also upload the data on the government portal.



      • 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 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-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 ...
      • Generate and Export Tran-2 Data in Excel

        How to Generate and Export Tran-2 Data in Excel in SwilERP What is Tran-2 Data? Form TRAN – 2 can be filed by a dealer/trader who has registered for GST but was unregistered under the old regime. Such a dealer who does not have a VAT or excise ...
      • How to Export/ Import Master data

        How do exporting/importing master data in SwilERP (RetailGraph)? In RetailGraph, you have the feature to export the master data to excel sheets. You can export blank template files for master data creation using the Export/Import Master Data option ...