To get GSTR-1 data in Excel from the GST portal, log in and navigate to Services > Returns > Returns Dashboard, select the period, and use the "Download Details from E-invoices (Excel)" button. Alternatively, download the JSON file, then convert it using the GSTR-1 Offline Tool, or use third-party accounting software like Tally to export data.
Export GSTR-1 in Excel format
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.
For downloading filed GST SRM -I follow these steps:
Downloading GSTR-1
From the GST Filing Module
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.
Go to Menu > Consolidated Data > GST Form (Offline Tool) > Export GSTR1 (Excel). A new window of Export GSTR1 (Excel) will appear in next slide.
GST Offline Tool Download Guide
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.
How To Export and Upload GSTR1 Form In CSV Files
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.
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.
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 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.
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.
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.
A. Login and Navigate to Form GSTR-1
Step 1: Navigate to the GSTZen portal and click on the GSTIN for which you wish to download the GSTR-1A data. Step 2: Click on Download a Report, then select GSTR-1A and choose the relevant period (month and year). Step 3: Log in to the GST Portal using OTP authentication.
Import data from the web
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!
For example, if the total price is ₹118 with an 18% GST, the person would type =118 / 1.18' in Excel to find the original price of ₹100. Extract GST Amount: After finding the base price, they can calculate the GST amount by subtracting the base price from the total price. For example, ₹118 - ₹100 = ₹18.
Section 16(2)(aa) of the GST Act ensures that Input Tax Credit (ITC) can only be claimed if the supplier has uploaded the invoice in their GSTR-1 return and it reflects in the recipient's GSTR-2B. This rule was introduced to prevent fake claims, encourage supplier compliance, and maintain transparency.
Step 1: Login to GST Portal. Step 2: Go to the 'Services' > 'Returns' > 'Transition Forms'. Step 3: You will be able to see all the tiles w.r.t. TRAN-1. Based on whether you have filed a return for the past 6 months select 'Yes or 'No' from the drop-down.
file which is to be uploaded on GST Portal. Save this on your computer. 7) Uploading the file on Portal: Log on to the GST Portal: select "Prepare offline" on GSTR-1 section to upload Json file generated in the previous Step. Uploaded file would be subjected to data validations as per the business rules in GSTR-1.