Learn How to Export GSTR2 Excel File Through SwilERP Software

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 (GSTR-1) will be available in the GSTN portal as GSTR-2A for you to use in your GSTR-2. Before you file your return, you can check this information, make changes if necessary, and add any details that were not auto-populated.

GSTR-2 is a return containing details of all inward supplies. Based on this return, the Input Tax Credit that a taxpayer is eligible to avail of is determined.

In SwilERP, users can export the GSTR-2 excel file and upload it into GST through offline utility. Do follow the below-given steps to learn the process:

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/

First, login in SwilERP dashboard to initiate the process

  1. Go to the GST> GST Forms (For Offline Tool)> Export GSTR2 (Excel).
Reference image:

Export GSTR2


How to Export the Excel File

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 Supplier Name" option to export supplier name in the excel file.
  3. Press "OK" to continue.
Reference image:

Export the Excel File


  1. While clicking on ok, a new window will appear to choose the path. 
  2. Select the file path where you want to save the Exported File.
  3. Enter the File Name & click on the Save button.
Reference image:

File Name


  1. After saving the file destination a Excel File will open in your system.
  2. In the Excel file, you'll see the details of B2B, B2BUR, IMPS, IMPG, CDNR, CDNUR, AT, ATADJ, EXEMP, ITCR, HSNSUM, SUMMARY FOR in the respective columns of excel.
  3. You can check the details on the Excel sheet before uploading into Offline Utility.
Reference image:

Offline Utility


Note: Now, users can easily import this excel file into the offline utility at their convenience.


      • 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-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 ...
      • 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) In New Format

        How to Export GSTR-1 (JSON) New Form in SwilERP 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 ...
      • 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 ...