To download the GSTR-1 annual summary in Excel, login to the GST Portal, navigate to Services > Returns > GSTR-1 > Download, select the desired financial year/period, and choose to download data as a JSON file, which can then be converted to Excel using the GST Offline Tool.
Export GSTR-1 in Excel format
Directly from the GST Portal:
Steps to file the GSTR-1 summary
Downloading GSTR-1
From the GST Filing Module
Login to the GST Portal with valid credentials. 3.1 Click the Services > Returns > Annual Return command. 3.2. Alternatively, you can also click the Annual Return link on the Dashboard.
How To Export and Upload GSTR1 Form In CSV Files
Locate the service menu: just when you log in, a dashboard will appear. You can go to the option of services now. Choose returns: Go to the services menu, and from there, you can visit the option of returns. Select relevant return: Choose the return that gives you access to the sales data that you need.
If the number of sales invoices is more than 500, then the GST Offline Utility has to be downloaded and the return file needs to be generated from this offline utility. There is no option to perform bulk action on invoices.
All your GST data from TallyPrime will appear seamlessly on the portal. In the GSTR-1 report, press Alt + E (Export) > GST Returns. The Export GSTR-1 screen will open, where you can select the required period, company, or tax registration. You also have the option to switch to GSTR-3B, if needed.
FORM GSTR-1 is a statement of the details of outward supplies (i.e. sales of goods or provision of services) of goods or services or both. The details filed in table of this statement are to be communicated to the respective recipients of the said supplies.
GSTR 1A return can be generated after the 15th of every month by accessing the GST Portal. To view or download GSTR 1A, go to Services > Returns > Returns Dashboard. After selecting the financial year and tax period, GSTR-1A in the given period will be displayed.
GST Tool Compatible
GST Reports are generated in excel formats that GST Offline tool recognises.
The exporter must fill 'Tax amounts' as 'zero' while making the declaration in Table 6A and Table 6B of GSTR-1. Thereafter, on successful completion of export, the details of accumulated ITC shall be reported to GST portal by filing form RFD-01 to apply for its refund.
Log in to the GST portal, navigate to 'Services' > 'Returns' > 'Annual Return', select the financial year, prepare it either using offline tool or online and submit the return, then file it with DSC or EVC.
Here is a step by step guide to change invoice details
Under the 'Returns' section, look for GSTR-3B. Click on the relevant return period to view the details. In the GSTR-3B form, under '3.1 Details of Outward Supplies', you can see the taxable turnover, exempt turnover, and non-GST turnover. Add these figures to calculate your total turnover for the period.
Effective October 1st, 2025, a new set of rules for GST return filing will come into effect. This marks the first filing cycle under the GST 2.0 reforms, aimed at improving transparency, control, and accuracy in Input Tax Credit (ITC) management through the Invoice Management System (IMS).
Go to Menu > Consolidated Data > GST Form (Offline Tool) > Export GSTR1 (Excel).
Go to File > Save As. The Save As dialog box appears. In the Save as type box, choose the text file format for the worksheet. For example, click Text (Tab delimited) or CSV (Comma delimited).
GST Annual Computation: Press Alt+G (Go To) > type or select GST Annual Computation and press Enter. Alternatively, Gateway of Tally > Display More Reports > GST Reports > GST Annual Computation and press Enter.
Step 1: Log in to the GST portal with your username and password. Step 2: After logging, select 'Returns Dashboard' as shown below. Step 3: Select the month & financial year for which you want to download GSTR-2A in excel. Click on the 'Download' tab appearing in the 'Auto Drafted details' box.
How to Access Your check sales data from GST
Export GSTR-1