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:
First, login in SwilERP dashboard to initiate the process
- Go to the GST> GST Forms (For Offline Tool)> Export GSTR2 (Excel).
Reference image:
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:
- 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)
- Tick-Mark on the "Export Supplier Name" option to export supplier name in the excel file.
- Press "OK" to continue.
Reference image:
- While clicking on ok, a new window will appear to choose the path.
- Select the file path where you want to save the Exported File.
- Enter the File Name & click on the Save button.
Reference image:
- After saving the file destination a Excel File will open in your system.
- 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.
- You can check the details on the Excel sheet before uploading into Offline Utility.
Reference image:
Note: Now, users can easily import this excel file into the offline utility at their convenience.