How to Export GSTR1 Data Via Excel & CSV Files in SwilERP

Export Consolidated GSTR1 Data in Excel & CSV Files

How to Export GSTR1 Data in Excel & CSV Files in SwilERP


If you are running a business with multiple locations and want to view data in one place, you can use a feature called Consolidated GSTR1 Data, which allows you to see all location data in one report.

Start with Login in the SwilERP to Initiate the Process

  1. Go to Menu > Consolidated Data > GST Form (Offline Tool) > Export GSTR1 (Excel).
  2. A new window of Export GSTR1 (Excel) will appear in next slide.
Reference image:
​

How to Export GSTR1 Data

  1. Select the Date Range "From" to "To" in the respective columns. For example, you selected 1st November to 30th November date range.
  2. Tick mark on the Export Debit Note in CDNR, if you want to export it.
  3. Press OK button.
Note: This report export as per Offline Tool v2.4

Reference image:
​
  1. A new window to Save the file will appear in next slide.
  2. Select the Path and enter the file name to save it.
  3. Save the excel file in your selected path.
Reference image:
​
  1. After saving the window, an Excel file will open.
  2. Here you can view all the details of GSTR1 in excel file i.e., b2b, b2cs, hsn, docs, etc.
  3. Review the details on the Excel sheet to ensure accuracy before proceeding with the upload into the Offline Utility.
Reference image:

Excel File Window
NotesNote: You can use the same procedure to export the GSTR-1 CSV file.

      • 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 Consolidated Data of GSTR2 in Excel Format

        How to Export Consolidated Data of GSTR2 in SwilERP GSTR-2 is a form that businesses use to report their purchases. It includes details about the goods and services they bought and the related invoices. This helps the government check and confirm ...

      • Consolidated GSTR3B Data Export to Excel in SwilERP Enterprise

        How to Export GSTR-3B to Excel in SwilERP The GSTR-3B is a summary return that businesses registered under GST need to file monthly. It is a self-declaration form where taxpayers provide summarized details of their outward and inward supplies, along ...

      • Consolidated Report of Trading Account

        A Quick Guide to View SwilERP Enterprise Consolidated Trading Reports Unlock insights into your business's profit/loss trends with SwilERP Enterprise's Consolidated Trading Accounts. Easily assess trading activities, compare annual sales and ...

      • Offline Setup for SwilERP (RetailGraph)

        How SwilERP Offline Setup Works for Branches What does mean by offline setup? Offline setup of SwilERP, you can set up your SwilERP's database according to the branches. You can do this work offline, but the internet is required for exporting and ...