GSTR-1 return can be exported in the required excel format for any given period. All the transactions that are displayed under Included in returns section in GSTR-1 report will be exported.
The MS excel file created on export of GSTR-1 is in line with the format prescribed by the department. The file can be imported to the offline utility tool. This tool then creates the .json file that can be uploaded on the GST portal.
To export GSTR-1
1. Go to Gateway of Tally > Display > Statutory Reports > GST > GSTR-1.
2. Press Ctrl+E.