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

Ensure you have the latest version of SwilERP installed.

For updates, contact your local service provider or raise a ticket at support.swildesk.com.

Download the Government GST Offline Tool from the GST portal.

Reference Link: https://www.gst.gov.in/

Steps to Export GSTR-2 Excel File in SwilERP

Log in to your SwilERP Dashboard.
Go to the GST menu.
Navigate to GST Forms (For Offline Tool).
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:

Select the Date Range – Choose the period (From–To) for which you want to export data.
Example: 1st August to 31st August.
Enable Export Supplier Name – Tick the checkbox if you want to include the supplier’s name in the Excel file.
Click OK – Press OK to generate and export the Excel file.

Reference Image:

Saving the Exported File

After clicking OK, a new window will appear prompting you to choose the file path.
Select the folder/location where you want to save the exported Excel file.
Enter a File Name of your choice.
Click on the Save button to complete the export process.

Reference Image: