How to get GSTR-1 data in Excel from GST portal?

Editorial team Published on

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.

How to download GSTR-1 excel file from GST portal?

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 generate GSTR-1 summary on 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 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 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 GSTR 1 from GST portal in excel | download gstr-1 all data in excel | 2021

26 related questions found

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 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 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 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 convert Excel to JSON file for gstr 1?

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

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 check GST details in GST portal?

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.

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.

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.

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 download GSTR 1 in excel from GST portal for full year?

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.

How to generate GSTR 1 summary in GST portal?

A. Login and Navigate to Form GSTR-1

  1. Access the www.gst.gov.in URL. ...
  2. The File Returns page is displayed. ...
  3. In the GSTR1 tile, click the PREPARE ONLINE button if you want to prepare the return by making entries on the GST Portal. ...
  4. The GSTR-1 – Details of outward supplies of goods or services page is displayed.

How to download GST data?

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.

How to convert online data to Excel?

Import data from the web

  1. Open Excel, and on the home screen, select New. ...
  2. Open the Power Query tutorial and press Create.
  3. On the Import Data from Web worksheet, copy the URL, which is a Wikipedia page for the FIFA World Cup standings.
  4. Select Data > Get & Transform > From Web.

How to download JSON file for GSTR 1?

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!

How to make GST working in Excel?

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.

Can I claim ITC without filing GSTR1?

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.

How to view filed tran 1 in GST portal?

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.

How to file GSTR 1 in GST portal offline?

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.