How to export GSTR 1 from tally prime
1. Generate the GSTR-1 Report:
- Go to Gateway of Tally > Display More Reports > Statutory Reports > GST > GSTR-1.
- Make sure 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.
- Press F8 (Include Uploaded/Exclude Uploaded) to choose whether to include previously exported transactions.
- Ctrl+B (Basis of Values): Choose to include or exclude HSN Summary and Document Summary.
- F12 (Configure): Set additional options as needed.
- Select the transactions/summaries to export and press X (Export).
- Choose your format:
- JSON (Data Interchange): For direct upload to the GST portal.
- Excel (Spreadsheet) or CSV (Comma Delimited): For offline work or using the GST Offline Tool.
- Configure section-wise export and folder path if needed.2
- Press E (Send) to export the file.
Important Notes:
- Resolve Uncertain Transactions: Before exporting, ensure you’ve addressed any “uncertain transactions” flagged by TallyPrime. These might have errors or missing information.
- Digital Signature Certificate (DSC): If filing online, you’ll need a valid DSC to sign your return.
- GST Offline Tool: For Excel or CSV exports, you might need to use the GST Offline Tool to convert them to the JSON format required for uploading to the GST portal.
- TallyHelp: For detailed instructions with screenshots, refer to the TallyHelp pages:
By following these steps, you can successfully export your GSTR-1 data from TallyPrime for filing your GST returns.