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 year (FY).
The GSTR-9 return is a summary of a business’s monthly or quarterly returns, i.e., the total number of transactions in a particular financial year. It includes the amount of taxes paid (CGST, SGST, IGST) during the year and details of exports or imports.
In simple terms, the purpose of the GSTR-9 is to consolidate information previously furnished in the monthly or quarterly returns. GSTR-9 implies that all monthly and quarterly returns must be filed before filing the annual return. Moreover, the GSTR-9 is not a rectification return but a consolidation return, which requires that data provided in monthly and quarterly returns match the data on the GSTR-9 exactly.
Through the SwilERP Software users can export the
GSTR-9
data in excel format. This feature is available in the
'GST'
tab. Following the below steps to know the process of export GSTR-9 data in export format.
Who are eligible for GSTR-9?
All the regular taxpayers registered under GST and having an annual turnover of more than Rs.
2 crores
should file GSTR-9 or GST Annual Return. The only category of GST-registered entities not required to file GSTR-9 filing are input service distributors, casual taxable persons and non-resident taxable persons.
Things to be noted:
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 the offline government tool, please click the link given below:
Reference link:
https://www.gst.gov.in/
Start with Login SwilERP dashboard to initiate the process:
-
Go to the
GST
tab.
-
Select
GST Forms( For Offline Tool) > Export GSTR9 (Excel).
Reference Window:
SwilERP Dashboard Window
After clicking on Export GSTR9 (Excel) option a pop-up window will open, next follow the below steps:
-
Select the
Date Range '
From to To'. (For instance, you selected the 1st April to 31st August date range)
-
Next, click on "
Ok".
-
After clicking on the
"Ok"
button, a new window will appear. Please select the file path, enter the file name, and then
Save
it for reference given below image.
Reference Window:
-
After saving the file destination, an excel file will open on you system.
-
You can check the details on the Excel sheet before uploading it into Offline Utility.
GSTR-9 Data in Excel file
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-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 ...
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 ...
Generate and Export Tran-2 Data in Excel
How to Generate and Export Tran-2 Data in Excel in SwilERP What is Tran-2 Data? Form TRAN – 2 can be filed by a dealer/trader who has registered for GST but was unregistered under the old regime. Such a dealer who does not have a VAT or excise ...
Export GSTR-1(Excel) Data
How to Export GSTR-1(Excel) Data in SwilERP Software 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 ...