Export GSTR-2 Excel File

Export GSTR-2 Excel File

How to Export GSTR-2 Excel File Through SwilERP Software


What is GSTR-2?  

GSTR-2 is a monthly tax return that contains details of all purchases (inward supplies) made during a particular month.

  • When you make purchases from registered vendors, their sales returns (GSTR-1) appear on the GSTN portal as GSTR-2A.

  • You can use this auto-populated data while filing GSTR-2, and also add or edit details as required.

  • Based on this return, the Input Tax Credit (ITC) you are eligible for is determined.

Exporting GSTR-2 From SwilERP  

SwilERP allows users to export the GSTR-2 Excel file, which can then be uploaded into GST using the government’s offline utility tool. Follow the steps below to complete the process.


Important Notes Before You Begin  

  1. Ensure you have the latest version of SwilERP installed.

  1. Download the Government GST Offline Tool from the GST portal.


Steps to Export GSTR-2 Excel File in SwilERP  

  1. Log in to your SwilERP Dashboard.

  2. Go to the GST menu.

  3. Navigate to GST Forms (For Offline Tool).

  4. Select Export GSTR-2 (Excel).


Reference Image:
SwilERP Dashboard Window

How to Export the Excel File  

When the pop-up window appears, follow these steps to export data into Excel format:

  1. Select the Date Range – Choose the period (From–To) for which you want to export data.

    Example: 1st August to 31st August.

  2. Enable Export Supplier Name – Tick the checkbox if you want to include the supplier’s name in the Excel file.

  3. Click OK – Press OK to generate and export the Excel file.


Reference Image:

Saving the Exported File  

  1. After clicking OK, a new window will appear prompting you to choose the file path.

  2. Select the folder/location where you want to save the exported Excel file.

  3. Enter a File Name of your choice.

  4. Click on the Save button to complete the export process.


Reference Image:

      • Related Articles

      • How to Export GSTR-3B Data in Excel Format

        What is the Process of Exporting GSTR 3B Data to Excel in SwilERP What is GSTR-3B? The GSTR-3B is a summary return that shows all the goods and services a business has bought and sold. It was introduced by the Indian government to make it easier for ...

      • Export GSTR 3B (JSON)

        How to Export GSTR-3B (JSON) File in SwilERP What is GSTR-3B? GSTR-3B is a monthly self-declaration return filed by registered GST taxpayers along with GSTR-1 and GSTR-2. It is a simplified return form used to declare summary GST liabilities such as ...

      • Export GSTR-1 JSON for GSTN Filing

        Exporting GSTR-1 JSON File in SwilERP SwilERP makes it easy to export your GSTR-1 data in JSON format for GST filing. Just select the date range, choose if you want to include Debit Notes in CDNR and separate HSN details for B2B and B2C. The file is ...

      • How to Export GSTR1 in CSV & Excel format

        Export GSTR-1 in Excel/CSV Format with Separate HSN Reporting for B2B and B2C In the latest version of SwilERP (3.2.17.13), a new update has been introduced for GSTR-1 reporting. Now, users can export GSTR-1 data in Excel or CSV format with an added ...

      • Export GSTR-1 (JSON) New

        How to Export GSTR-1 (JSON) New in SwilERP What is GSTR-1? Form GSTR-1 is a return statement where every regular GST-registered dealer reports all outward supplies (sales) made during a month or quarter. In simple words, it contains the details of ...