How do I download GSTR 2B full year from GST portal in Excel?

Asked by: Manuel Hammes  |  Last update: June 8, 2026
Score: 4.6/5 (39 votes)

To download the full year GSTR-2B in Excel from the GST portal, you must download it on a month-by-month basis. Log in, navigate to Services > Returns > Returns Dashboard, select the financial year and month, and click Download under the GSTR-2B section.

How to download GSTR 2B for whole year?

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.

How to download GSTR 1 in Excel from GST portal for full year?

Export GSTR-1 in Excel format

  1. Press Alt+E (Export) > E-Return.
  2. Select the File Format as Excel (Spreadsheet).
  3. Set Export document summary to Yes.
  4. Export the file.
  5. Open the GSTR-1 offline tool downloaded from the GST portal. Import the MS Excel file into the GST Offline Tool.

How to download GST return for full year?

How to Download GSTR-9 (Annual Return)

  1. Log in to the GST portal.
  2. Go to “Returns Dashboard.”
  3. Select the financial year.
  4. Click on “GSTR-9.”
  5. Click on “Download.”
  6. Save the form on your device.

Can we download GSTR 2A in Excel for full year?

The month and fiscal year for which you wish to download the GSTR-2A in Excel should be chosen. The 'Auto Drafted information' box will display a 'Download' tab. After this, you will need to click on the button- 'Generate Excel file to download' to download the file in Excel format.

GSTR-2B Reco: 10 Min में सीखें Excel का Secret Tip (No Paid Software Needed)

36 related questions found

How to download 2A data?

Step 1 – Click on the 'Download' button on the GSTR-2A tile. Step 2 – Click on the 'Generate JSON file to download' or 'Generate an Excel file to download' button to generate data in the JSON or Excel formatted file.

How to download GSTR 2B from GST portal in tally prime?

Directly Download GSTR-2B from TallyPrime

  1. Press Alt+Z (Exchange) > Download GST Returns. ...
  2. Press C (Configure) to set the required Return Type, that is GSTR-2B, and the Return Period. ...
  3. In the Download GST Returns screen, press D (Download).
  4. Log in to your GST profile, if you have not already done so.

How to download GST returns in bulk?

GST Offline Tool Download Guide

  1. Visit the official GST portal at www.GST.gov.in.
  2. Navigate to the “Downloads” section from the main menu.
  3. Select “Offline Tools” from the dropdown options.
  4. Choose your required return type (GSTR-1/GSTR-3B/GSTR-9, etc.).
  5. Download the corresponding ZIP file.

How to see annual return in GST portal?

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 data from GST offline tool to Excel?

Go to Menu > Consolidated Data > GST Form (Offline Tool) > Export GSTR1 (Excel). A new window of Export GSTR1 (Excel) will appear in next slide.

How to convert gstr 2A JSON to Excel?

Step-by-Step Procedure to Convert GSTR 2A JSON File to Excel

  1. Step 1: Access the GST Portal. ...
  2. Step 2: Navigate to the Returns Dashboard. ...
  3. Step 3: Download the GSTR 2A JSON File. ...
  4. Step 4: Convert JSON to CSV. ...
  5. Step 5: Download the CSV File. ...
  6. Step 6: Download the JSON to Excel Converter.

How to download yearly sales data from 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.

What is Gstr 2A in GST portal?

Form GSTR-2A is a system generated Statement of Inward Supplies for a recipient. Form GSTR-2A will be generated in below scenarios: When the supplier uploads the B2B transaction details in their Form GSTR-1 / 5/1A. ISD details will be auto-populated on submission of Form GSTR-6 by their Input Service Distributor.

Where can I download 2B?

How can I view and download Form GSTR-2B?

  • Access the https://www.gst.gov.in/ URL. The GST Home page is displayed. ...
  • The File Returns page is displayed. Select the Financial Year, Quarter and Period (Month) for which you want to view Form GSTR-2B from the drop-down list. ...
  • Download GSTR-2B.
  • View GSTR-2B.

How to download full year GSTR 1 in Excel?

#Third Way- How to download gstr 1 filing from offline tools:

  1. Login: Access the tool and log in with your valid GSTIN credentials.
  2. Navigate: Click > Returns > GSTR-1 > Download.
  3. Select Tax Period: Choose the specific tax period for which you want to download the GSTR-1 file.

On which date is GSTR 2B generated?

Further, GSTR-2B is a static statement and is made available for each month on the 14th day of the succeeding month.

How to download yearly 2B from GST portal pdf?

How to access GSTR-2B on the GST portal?

  1. Step 1: Log in to the GST portal. ...
  2. Step 2: Navigate to the 'Returns Dashboard'.
  3. Step 3: Select the relevant tax period. ...
  4. Step 4: On the 'GSTR-2B' tile, you may either click on 'View' or 'Download', as per the need.
  5. (a) Download:
  6. (b) View:

How to download GST return yearly?

Click the Services > Returns > View Filed Returns option.

  1. Select the Financial Year, Return Filing Period and Return Type from the drop-down list. ...
  2. Note: ...
  3. Download Filed Form CMP-08 page is displayed. ...
  4. Acknowledgement message will be displayed stating that the process may take upto 5 minutes to complete.

How to download GSTR-2A annually from GST portal?

Click the Services > Returns > Returns Dashboard option. 2. The File Returns page is displayed. Select the Financial Year & Return Filing Period for which you want to view Form GSTR-2A from the drop-down list.

How do I download JSON files from GST portal?

Manual > e-Invoice JSON Download

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.

How to download annual turnover in GST portal?

How to View Annual Turnover on GST Portal: A Step-by-Step Guide. Go to the GST Portal and log in using your login credentials. After logging in, you will see your dashboard with various tabs and options. Click on the 'Services' tab and then select 'Returns Dashboard' from the drop-down menu.

How to download b2b invoices in GST portal in Excel?

Select the desired Financial Year and Month, then click the "DOWNLOAD E-INVOICE (Excel)" button. Additionally, you can download a list of IRNs generated for the selected GSTIN, also for the chosen financial year and month, by using the "Recipient GSTIN" tab.

How to generate GSTR 2B?

Log in to the GST portal using your credentials. Navigate to the 'Returns Dashboard' after logging in. Select the relevant tax period by choosing the month and financial year. On the 'GSTR-2B' tile, you have two options: click on 'View' to check the details online or 'Download' to save the information offline.

How to export GSTR 2 from Tally to Excel?

Export GSTR-2 from Tally. ERP 9 in the Excel format. o Open GSTR-2 report, and press Ctrl+E ( Export Return ). o Select Excel (Spreadsheet) .

What is Alt +Z in tally prime?

Alt + Z opens the data exchange and synchronization menu in TallyPrime, used for syncing, sharing, or managing company data.