Export GSTR 1 in Excel

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     ...
    • XML Tally Data Import - Tally Prime

      To import Trial Balance using XML Tally through Tally Prime, you are requested to please export the Trial Balance and List of account from Tally Prime application and then import the same in Zen IT Software. To Export Trial Balance using Tally Prime ...
    • 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 ...
    • EXCEL EXPORT / IMPORT || Error in Loading DLL in excel export / Automation error - Library not registered

      Error in Loading DLL in excel export / Automation error - Library not registered in Excel export Solution : NOTE : This is not Software Related issue. Usually error in loading dll Excel arise when due to the installation of any software the new DLL ...
    • 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 ...