How to download GSTR 1 in excel from Tally Prime

You can download your GSTR-1 data in Excel format from TallyPrime by following these steps:

1. Generate the GSTR-1 Report:

• Go to Gateway of Tally > Display More Reports > Statutory Reports > GST > GSTR-1.
• Ensure the correct period is selected.
• Press F12 (Configure) to set options like showing tax types in separate columns or including HSN summaries. Press Ctrl+A to save the configuration.

2. Export the GSTR-1 Data:

• Press Alt+E (Export) > GST Returns.
• The Export GSTR-1 screen will open. Select the period, company, and tax registration.
• Choose Excel format: In the Export screen, select Excel (Spreadsheet) as the File Format.¹
• Configure section-wise export and folder path if needed.²
• Press E (Send) to export the file.

This will generate an Excel file containing your GSTR-1 data for the selected period.

Important Notes:

• GST Offline Tool: While you can download the GSTR-1 data in Excel format, you may still need to use the GST Offline Tool to convert it to JSON format before uploading it to the GST portal.
• TallyHelp: For detailed instructions with screenshots, refer to the TallyHelp page:
  • How to Export GSTR-1 in MS Excel/CSV Formats & Update Rate-wise HSN/SAC Summary

By following these steps, you can easily download your GSTR-1 data in Excel format from TallyPrime. This allows you to view and analyze your data offline or use it with the GST Offline Tool for filing your returns.