To download GSTR-1 invoice-wise details in Excel from the GST portal, log in and navigate to Services > Returns > GSTR-1 > Prepare Online. Select the period, then use the "Download Details from e-invoice (Excel)" button to export data. For over 500 records, generate a JSON/ZIP file first.
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.
To view the e-Invoice, simply select the link provided in the "Download File" column. 8. To view and download an e-Invoice list in Excel format for a specific period, utilize the "List of IRNs" tab. Select the desired Financial Year and Month, then click the "DOWNLOAD E-INVOICE (Excel)" button.
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.
Downloading GSTR-1
Export GSTR-1 in Excel format
For downloading filed GST SRM -I follow these steps:
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
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.
1. To download the e-Invoice, visit https://einvoice.gst.gov.in and login with valid GST credentials. Click on Download e-invoice JSONs tile on the dashboard. Alternatively, taxpayer can navigate download e-Invoice by clicking Dashboard tile > e-Invoice Download tab.
Steps to Create
For this, you can use 'Download details from e-invoice (Excel)' button on GSTR-1 dashboard. It may to be noted that the auto-populated details in this excel file are as reported on e-invoice portal Invoice Registration Portal (IRP).
Steps to Download e-Invoice in JSON Format
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.
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.
Step 1: Login to GST portal.
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).
Once you are done uploading all the data to your GST Offline Utility Tool, click on the 'View Summary' button as highlighted below: Here, just click on 'Generate File' to generate a JSON file that can be uploaded to the GST Portal. Click on the link to download the JSON file: That's it!
Directly from the GST Portal:
Step-by-step guide to download the GST summary
Click the Search Taxpayer menu available at the GST Portal homepage. 2.2.2 In the GSTIN/UIN of the Taxpayer field, enter the GSTIN or UIN of the taxpayer whose details has to be searched. Click the SEARCH button. 2.2.3 The details are displayed.
For this, you can go to GST Menu, Generate Tax Summary, then go to GST reports, select the GST Summary Data report. You have to enter dates here and click on Get Data. After this click on the Raw Data tab. You have the option to export this raw data to excel.
Step 1: Log in to the e-invoice portal https://einvoice.gst.gov.in with valid GST login credentials. Step 2: On the 'Download e-Invoice' page, there are two tabs 'Generated' (for IRNs generated by the user) and 'Received' (for IRNs received by the user). Click on whichever applies to you.
Steps to Download GST Return Forms