How to Download GSTR-1 for whole year in Excel from GST portal?

Editorial team Published on

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.

How to download GSTR-1 for whole year from GST portal?

Follow these steps to download any GST return form from the GST portal.

  1. Step 1: Visit the GST Portal.
  2. Step 2: Log in to Your GST Account.
  3. Step 3: Navigate to the 'Returns Dashboard'
  4. Step 4: Select the Financial Year and Period.
  5. Step 5: Download the GST Return Form.

How to download GSTR-1 in bulk?

Downloading GSTR-1

  1. Step 1: Log In. Visit the official GST portal: https://www.gst.gov.in/. ...
  2. Step 2: Select 'Services' After logging in, you will find a menu bar. ...
  3. Step 3: Choose 'Returns' ...
  4. Step 4: Click on 'Returns Dashboard' ...
  5. Step 5: Select Applicable Return Period. ...
  6. Step 6: File and Download.

How to download Excel from GST portal?

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.

How to download annual return from 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 download GSTR 1 from GST portal in excel | download gstr-1 all data in excel | 2021

32 related questions found

How to export GSTR 1 from GST portal to Excel?

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 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 generate GSTR-1 summary in GST portal?

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.

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

To view and download Form GSTR-2B on GST Portal, perform following steps:

  1. Access the https://www.gst.gov.in/ URL. The GST Home page is displayed. ...
  2. The File Returns page is displayed. ...
  3. Download GSTR-2B.
  4. View GSTR-2B.

How to download GSTR-1 more than 500 invoices in GSTR-1?

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.

What is the date format for Gstr 1 in excel?

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.

How to view GSTR1 in portal?

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.

How to extract data from GST portal?

For downloading filed GST SRM -I follow these steps:

  1. Access the https://www.gst.gov.in/ URL. ...
  2. Login to the GST Portal with valid credentials.
  3. Navigate to Services > Returns > View Filed Returns option.
  4. View Filed Returns page will be displayed on the screen. ...
  5. Click on SEARCH button after selecting all details.

How do I convert Gstr 1 Excel to JSON?

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 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.

Where to show export return in GSTR 1?

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.

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.

How to download GST return for full year?

How to Download GSTR-3B from the GST Portal

  1. Step 2: Navigate to the Returns Dashboard.
  2. Step 3: Select Financial Year and Return Filing Period.
  3. Step 4: Locate Filed GSTR-3B.
  4. Step 5: Download the GSTR-3B PDF.
  5. Step 1: Download Monthly GSTR-3B Returns for all the months of the year one by one.
  6. Step 2: Export to Excel.

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 download GSTR 1 bill wise details from GST portal?

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.

What is the summary of GSTR1?

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 create a CSV file for GSTR 1?

How To Export and Upload GSTR1 Form In CSV Files

  1. Select Date Range. Step 4:- Select Folder for saving these six CSV files. ...
  2. GST Portal. Step 6:- Please fill all Fields as asked for: GSTIN No. ...
  3. Import CSV Files. Step 8:- Please Select all CSV files from you have saved folder one by one e.g. B2B.CSV.
  4. Select CSV Files.

How to download full year 2B from GST portal?

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 export GSTR-1 data?

From the GST Filing Module

  1. Go to GST Filing on the left sidebar.
  2. Select Unpushed Transactions under GSTR-1 and click the File your Return tab.
  3. In the File your Return page, click Export As at the top and select JSON.

How to download GSTR 2a full year from GST portal in excel?

How to do annual GSTR 2a download?

  1. On the right-hand side there is the option to log in so do it.
  2. Select Returns next.
  3. Next click on Returns Dashboard.
  4. Select the Financial year, Return filing period and GSTR 2A form.
  5. Click on Search.
  6. Click on download and the GSTR 2a download full year will get done.