Learn How to Export GSTR-9 Data in Excel File Through SwilERP Software

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: 

  1. Go to the GST tab.
  2. Select GST Forms( For Offline Tool) > Export GSTR9 (Excel).

Reference Window:
Export GSTR9 SwilERP Dashboard Window

After clicking on Export GSTR9 (Excel) option a pop-up window will open, next follow the below steps:

Follow the below-given steps to transform data into excel format:

  1. Select the  Date Range ' From to To'. (For instance, you selected the 1st April to 31st August date range)
  2. Next, click on " Ok".

Reference Window:

Date Range


  1. 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:    

Save


  1. After saving the file destination, an excel file will open on you system.
  2. You can check the details on the Excel sheet before uploading it into Offline Utility. 

    Reference Window:    
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 ...

      • How to Export/ Import Master data

        How do exporting/importing master data in SwilERP (RetailGraph)? In RetailGraph, you have the feature to export the master data to excel sheets. You can export blank template files for master data creation using the Export/Import Master Data option ...