Export Consolidated Data of GSTR2 in Excel Format

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 claims for input tax credits, making sure taxes are recorded correctly.

If you want to view data from multiple locations in one place, export your GSTR-2 consolidated data. Authorized users can log in with their admin credentials and select the "Consolidate Data" option.


Start with login in SwilERP Dashboard to Initiate the Process

  1. Go to the Consolidated Data> GST Forms (Offline Tool)> GSTR2 (Excel).
  2. A new window of GSTR2 (Excel) will appear in next slide.
Reference image:
​
SwilERP Dashboard Window

How to Export GSTR2 File in Excel Format

  1. Select the Date Range "From" to "To" in the respective columns. For example, you selected from 1st November to 30th November.
  2. Tick mark on the Export Supplier Name, if you want to export it.
  3. Press OK to export it.
Reference image:
​
Export GSTR1 Window
  1. A new window to select the Path will appear in next slide.
  2. Enter the File Name and Save the excel in selected path.

Reference image:

Select Path Window

How to View Data in Excel File

  1. After saving the window, an Excel file will open.
  2. Here you can view all the Purchase details in their respective columns.
  3. Review the details on the Excel sheet to ensure accuracy before proceeding with the upload into the Offline Utility.
Reference images:
​
Excel File Window

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

      • GST Summary Data

        How to view GST Summary Data in SwilERP What is GST summary data? GST stands for Goods and Services Tax. It is an Indirect tax that replaced a host of other Indirect taxes such as value-added tax, service tax, purchase tax, excise duty, and so on. ...

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

      • GST Query

        How to View GST Query in SwilERP What is a GST Query? A GST Query Data is an option in SwilERP; if users want to view their GST Sales and Purchase transaction data in a report, they can view it from the GST section. SwilERP also featured an ...

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