Exporting GSTR-1 from Tally.ERP9

You can export your GSTR-1 data either in MS Excel or CSV format. Before exporting GSTR-1, resolve the exceptions in your transactions by going to the Summary of Exceptions (GSTR-1)

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

Note : The Format is set to Excel (Spreadsheet by default. To Change the format, select CSV (Comma delimited on the Export Report screen.

4.    Specify the Export Location and Output File Name.

5.    Press Enter to export.

If you have selected the CSV format, Tally.ERP 9 will create separate CSV files for each table in GSTR-1. These files need to be imported into the offline tool.

Note: If the data exported to MS Excel has $ symbol, or if the values are not appearing, generate CSV file and import it into the offline tool,