Self Help Knowledgebase and Trouble Shooter

How to Export GSTR-1 Return in MS Excel?

To export GSTR-1 returns in the MS Excel follow the steps below :

Steps 1 :
Gateway of Tally > Display > Statutory Reports > GST > GSTR-1.
Alternatively, Press Alt+G (Go To) > Type Here or Search GSTR-1 > Press Enter.

Step 2 :
F2: Period: Select the period for which returns need to be filed.

Step 3 :
Press Alt+E and select E-Return from the menu.

Step 4:
Select Excel (Spreadsheet) as the File Format.

Step 5:
Specify the folder path to save the e-return in the File path field.

Step 6:
Set the option Export Document Summary to Yes and press Enter.

            
Step 7 :
Click Send to export the e-return.

Hope this helps.
    • Related Articles

    • How to Export GSTR-2 data in MS Excel?

      To export GSTR-2 returns Data in the MS Excel follow the steps below : Go to Gateway of Tally > Display > Statutory Reports > GST > GSTR-2 Make sure that there are no items under the section Not included in returns due to incomplete information     ...
    • Invoice & other data upload for creation of GSTR 1

      The table below provides the name, full form and detailed description for each field of the worksheets followed by a detailed instruction for filling the applicable worksheets. The fields marked with asterisk or star are mandatory. B2B B2B Supplies ...
    • How to enter different tax rate in single invoice (GSTR-1 > B2B Invoice) through excel sheet?

      Solution: Step 1: Login on GST Software Application. Step 2: Select Company, Financial Year, Filing Type as GSTR-1 and Tax Period and then Go to Proceed.              Step 3: Here Click on - Download Sample Template.              Step 4: Once the ...
    • Invoice & other data upload for creation of GSTR 2 in Express GST | GST Filing

      The table below provides the name, full form and detailed description for each field of the worksheets followed by a detailed instruction for filling the applicable worksheets. The fields marked with asterisk or star are mandatory. b2b B2B Supplies - ...
    • GSTR-2A Reconciliation

      GST reconciliation primarily involves matching the data uploaded by the suppliers with those of the recipient's purchase data. This basically includes comparing the GSTR-2A auto-populated from suppliers data and the purchase data recorded by the ...