To download GSTR-1 for a full year in Excel, log in to the GST portal, navigate to Services > Returns > Returns Dashboard, and select each month/quarter to "Prepare Offline" under GSTR-1. Click "Download" to generate a JSON file, then use the "Returns Offline Tool" to convert this JSON into Excel for each period.
Follow these steps to download any GST return form from the GST portal.
Downloading GSTR-1
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.
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.
Export GSTR-1 in Excel format
GST Offline Tool Download Guide
Scroll down to the bottom of the Form GSTR-1 – Details of outward supplies of goods or services page and click the GENERATE GSTR1 SUMMARY button. This will include the auto drafted details pending for action from recipients.
To view and download Form GSTR-2B on GST Portal, perform following steps:
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.
The date format should bedd- mmm-yyyy only(eg 01-Jul-2017). ii. Incorrectinvoice format entered in excel. Invoice number should be maximum 16 digit and alphanumeric.
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.
For downloading filed GST SRM -I follow these steps:
To convert GSTR-1 Excel to JSON, download the GST offline tool from the GST portal. Import your GSTR-1 Excel file into the tool, check the summary, and click “Generate File” to create a GSTR-1 JSON file. This JSON format is the only file type accepted for uploading GSTR-1 returns on the GST portal.
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.
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.
#Third Way- How to download gstr 1 filing from offline tools:
How to Download GSTR-3B from the GST Portal
Go to Menu > Consolidated Data > GST Form (Offline Tool) > Export GSTR1 (Excel). A new window of Export GSTR1 (Excel) will appear in next slide.
You can download the E-invoice details that get auto-populated in Form GSTR-1 in an excel by clicking the DOWNLOAD DETAILS FROM E-INVOICES (EXCEL) button available at the bottom of Form GSTR-1 page.
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.
How To Export and Upload GSTR1 Form In CSV Files
How can I view and download Form GSTR-2B statement of a tax period? Navigate to Services> Returns > Returns Dashboard > File Returns > GSTR 2B Tile to view and download Form GSTR-2B statement of a tax period.
From the GST Filing Module
How to do annual GSTR 2a download?