To download Excel files (returns, 2B, 2A) from the GST portal, log in and navigate to Services > Returns > Returns Dashboard, select the financial year/period, and click the Download button on the specific form tile (e.g., GSTR-2B or GSTR-4A). Select "Download Summary (Excel)" or "Generate Excel File" to download a zip file.
Export GSTR-1 in Excel format
Click on the 'Download' tab appearing in the 'Auto Drafted details' box. Step 4: On the screen that appears, click on the button- 'Generate excel file to download' to download the file in excel format. Alternatively, click on the button “Generate JSON file to download” to download the file in JSON format.
Manual > View/ Download Certificates
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.
How to Download GSTR-3B from the GST Portal
To view and download Form GSTR-2B on GST Portal, perform following steps:
Step 1: Visit the GST Portal and go to the 'Downloads' section, click on 'Offline Tools' and then click on 'GST New Return Offline Tool (Beta)' under the options available. Step 2: An option to download the tool will be highlighted. Click on 'Download'. A confirmation box will open, click on 'Proceed'.
Steps to Create
Navigate to Services > Returns > Returns Dashboard option > Select the Financial Year & Return Filing Period > DOWNLOAD > GENERATE EXCEL FILE TO DOWNLOAD button to download Form GSTR-4A details in an Excel format, for any range of quarters, in the selected financial year.
To download the e-Invoices generated and received, visit the e-Invoice portal (https://einvoice.gst.gov.in) and log in using taxpayer GST portal credentials. After logging in, click on e-Invoice JSON download tile on e-Invoice dashboard.
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.
Apply the GST Formula Use a formula like = B2 - B2 / 1.15 for a 15% tax rate to calculate the GST amount. Adjust as needed for different tax rates. (This approach works similarly for other tax rates—just replace 1.15 with 1 + (GST Rate/100). For example, if the GST rate is 18%, use 1.18 instead.)
Our GSTR 1 JSON to Excel converter simplifies the process, allowing you to quickly and efficiently convert your files for easy analysis.
For downloading filed GST SRM -I follow these steps:
How can I download Gstr 1?
Click the Upload CSV button to upload the excel sheet. 3.1. 7 (b5) A warning message “Do you want to upload the csv file?” will appear on the screen. Click the YES button to proceed.
How can I as a taxpayer file the Letter of Undertaking (LUT) for export of goods or services at the GST Portal?
Penalties: In cases of non-generation of e-invoice, 100% of the tax or ₹10,000, whichever is higher, is the penalty for each invoice.
Go to Menu > Consolidated Data > GST Form (Offline Tool) > Export GSTR1 (Excel). A new window of Export GSTR1 (Excel) will appear in next slide.
Reconciling Books data with GSTR-1/1A, GSTR-2A/2B, and GSTR-3B is one of the most important GST compliance activities for every business. GSTR-1/1A reports outward supplies (sales). GSTR-2A/2B auto-populates inward supplies (purchases). GSTR-3B is the self-declared monthly summary return.
Pending GSTR-3B Filings: If a taxpayer has not filed their GSTR-3B for the previous period, GSTR-2B will not be generated. For instance, if September 2024's GSTR-3B is pending, October 2024's GSTR-2B will not be generated until the pending return is filed.