How to export GSTR-1 data?

Asked by: Christ Hill  |  Last update: May 29, 2026
Score: 4.6/5 (22 votes)

Export GSTR-1 data by navigating to the GSTR-1 report (Alt+G) in TallyPrime, selecting the period (F2), and pressing Alt+E (Export) > E-Return. Select JSON or Excel format, configure settings, and click Export. The generated file can be uploaded directly to the GST portal.

How to export GSTR-1?

Export GSTR-1 in CSV format

  1. Press Alt+E (Export) > E-Return.
  2. Select the File Format as CSV (Comma Delimited).
  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 CSV files into the GST Offline Tool.

How to download GSTR-1 filed data?

How to Download GSTR-1

  1. Follow Steps 1 to 4 mentioned above.
  2. Click on “GSTR-1” from the list of return forms.
  3. Click on “Prepare Online” or “Download.”
  4. If you choose “Prepare Online,” you can enter details and submit.
  5. If you choose “Download,” the form will be saved on your device.

How to generate a summary of GSTR-1?

Steps to file the GSTR-1 summary

  1. Download details from e-invoice (excel sheet) in case of generation of e-invoices.
  2. Add or amend the records in GSTR-1.
  3. Click 'generate summary' button to generate the summary.
  4. Click 'proceed to file, summary' button to view the final summary before filing.

How to extract GSTR-1 data from Tally?

Gateway of Tally > Display More Reports > Statutory Reports > GST > GSTR–1. The report displays the data for a month or quarter depending on the Periodicity of GSTR-1 set in the Company GST Details screen. Alternatively, Alt+G (Go To) > type or search GSTR-1 or Returns or GST > select and press Enter.

How to File GSTR -1 Using JSON File | Upload GSTR-1 JSON to GST Portal | Offline Tools

22 related questions found

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 do I export all data from Tally?

How to export all vouchers along with the associated masters?

  1. Gateway of Tally > Day Book. ...
  2. Press Alt+E (Export) > Current.
  3. Press C (Configure) > type or select Include dependent masters and press Enter to set it to Yes.
  4. Press Esc to return to the Export screen.
  5. Press E (Send) to export.

How to download GSTR in Excel?

Step-by-Step Process to Download GSTR-2A in Excel Format

  1. Step 1: Log in to the GST portal with your username and password.
  2. Step 2: After logging, select 'Returns Dashboard' as shown below.
  3. Step 3: Select the month & financial year for which you want to download GSTR-2A in excel.

How to file GSTR 1 in detail?

Manual> Filing Nil Form GSTR-1 Online by Normal Taxpayers

  1. Access the www.gst.gov.in URL. ...
  2. The File Returns page is displayed. ...
  3. Click the PREPARE ONLINE button in the GSTR1 tile.
  4. The GSTR-1 – Details of outward supplies of goods or services page is displayed. ...
  5. The Nil File GSTR-1 page will be displayed.

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

What is the summary of Gstr-1?

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

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

How to download GST R 1 filing from the GST Portal: Login: Access the GST Portal and log in with your valid GSTIN credentials. 2. Navigate: Go to Services > Returns > GSTR-1 > Download.

What are the 5 steps of the export process?

To start export business, the following steps may be followed:

  • Establishing an Organisation. ...
  • Opening a Bank Account. ...
  • Obtaining Permanent Account Number (PAN) ...
  • Obtaining Importer-Exporter Code (IEC) Number. ...
  • Registration cum membership certificate (RCMC) ...
  • Selection of product. ...
  • Selection of Markets.

What is Alt F8 used for in Tally ERP 9?

Ctrl + F8: This opens the Sales Order screen in order vouchers, where you can record sales orders before processing them into sales. iii). Alt + F8: Opens the Delivery Note screen in inventory for managing goods delivery.

How to generate summary for filing GSTR 1?

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 much does a CA charge for filing an ITR?

ITR Filing Charges:

Salaried ITR Filing: ₹1,000/- Capital Gain / Share Gain-Loss ITR: ₹1,500/- Business ITR – 44AD Return: ₹2,000/- All other ITR Filing: ₹3,000/-

How to file itr1 step by step?

Step 1: Log in to the e-Filing portal using your user ID and password. Step 2: On your Dashboard, click e-File > Income Tax Returns > File Income Tax Return. Step 4: In case you have already filled the Income Tax Return and it is pending for submission, click Resume Filing.

How to export GSTR-1 from tally to Excel?

Export GSTR-1

  1. Go to Gateway of Tally > Display > Statutory Reports > GST > GSTR-1.
  2. Select the period for which returns need to be filed.
  3. Press Ctrl+E. ...
  4. Specify the Export Location and Output File Name.

How to file GSTR-1 with CSV file?

How To Export and Upload GSTR1 Form In CSV Files

  1. Select Date Range. Step 4:- Select Folder for saving these six CSV files. Select folder. ...
  2. GST Portal. Step 6:- Please fill all Fields as asked for: GSTIN No. and Tax Period. ...
  3. Select CSV Files. Step 9:- Select Files and click on Import CSV Button to Upload CSV Files.

What is the data of Gstr-1?

Form GSTR-1 is a monthly Statement of Outward Supplies to be furnished by all normal and casual registered taxpayers making outward supplies of goods and services or both and contains details of outward supplies of goods and services.

What is the data export process?

Data export is the process of extracting and converting raw data from its existing format to that required by another application or software system.

How many formats are available while exporting?

In Microsoft Word, you can export or save documents in formats like DOCX, PDF, RTF, TXT, and more. In image editing software like Adobe Photoshop, you can export images in formats such as JPEG, PNG, TIFF, GIF, and others. In spreadsheet applications like Excel, you can export in XLSX, CSV, PDF, and other formats.

Can we export data from Excel to Tally?

If you are switching from another ERP or accounting system: Export the data from your current ERP in Excel, XML JSON format. Import the exported file into TallyPrime.