Updated on: 30-Jul-2019
|
Related topics |
GSTR-4 report includes the details of taxable outward supplies, and inward supplies under reverse charge, made by a GST composition dealer in a given period. With Tally.ERP 9, you can file GSTR-4 in three easy ways:
● By generating JSON from Tally.ERP 9
● By using the GST Offline tool
● By filing your returns directly on the GST portal
Prerequisites for filing GSTR-4
● Internet connectivity: This is required for uploading the JSON file, downloading the offline tool, and filing returns.
● Microsoft Office: For exporting data to the offline tool, GSTN recommends MS Excel 2007 or later (if you are using the offline tool for filing returns).
You can quickly generate JSON from Tally.ERP 9 and upload it to the portal.
1. Go to Gateway of Tally > Display > Statutory Reports > GST > GSTR-4 .
2. F2: Period: Select the period for which returns need to be filed.
3. You can export data by pressing Ctrl+E or Alt+E .
Note: If the company GSTIN/UIN is incorrect, you need to correct it to proceed with the export.
● If you press Ctrl+E :
o Select JSON (Data Interchange) as the Format .
o Set Open Exported File to Yes .
o Press Enter to export.
● If you press Alt+E :
o Select JSON GSTR-4 (Data Interchange) as the Format .
o Set Open Exported File to Yes .
o Press Enter to export.
Upload the JSON file generated from Tally.ERP 9 to the portal for filing returns.
The latest offline tool supports data export only until 31st March 2019. Hence, if you are exporting data from April 2019 onwards, a note appears at the bottom of the Export Report screen as shown below:
The data will be exported to JSON file for reference purposes only. You cannot use this to file returns, as the department does not have a provision to file quarterly returns from 1st April 2019.
1. Log in to the GST portal.
2. Click Services > Returns > Returns Dashboard .
3. Select the Return Filing Period , and click SEARCH .
4. Click GSTR4 .
5. Click PREPARE OFFLINE .
6. Click Choose File to import the JSON file generated from Tally.ERP 9 or the offline tool. Once your JSON file is uploaded successfully, you will be notified by a message.
7. Verify the uploaded details after the time specified in the GSTR screen.
8. Submit your returns and e-sign.
You can export data to the offline tool provided by the department, generate JSON and upload the same to the portal.
1. Go to the GST portal .
2. Click Downloads > Offline Tools > GSTR 4 Offline Tool > Download .
3. Click Proceed .
4. A .zip file containing the GSTR_4_Offline_Utility will be downloaded.
5. Extract the file GSTR_4_Offline_Utility_v3.3.xls from the .zip file and copy it to the location where Tally.ERP 9 is installed.
1. Go to Gateway of Tally > Display > Statutory Reports > GST > GSTR-4 .
Note: Ensure to use a fresh offline tool each time before exporting the GSTR-4 data.
2. F2: Period - Select the period for which returns need to be filed.
3. You can export data by pressing Ctrl+E or Alt+E . If the template GSTR_4_Offline_Utility_v3.3.xls is not available in the Export Location , the message appears as shown:
Note: If the company GSTIN/UIN is incorrect, you need to correct it to proceed with the export.
● If you press Ctrl+E :
o Select Excel (Spreadsheet) as the Format .
o Set the option Open Exported File to Yes .
o Press Enter to export.
● If you press Alt+E :
o Select Excel GSTR-4 (Spreadsheet) as the Format .
o Set Open Exported File to Yes .
o Press Enter to export the data.
The offline tool opens with the data updated in the relevant fields.
4. In the offline tool click Validate Sheet to view the status of each sheet.
5. In the Home tab:
o Click Get Summary .
o Click Generate JSON File to upload .
o On successful validation, the message appears as shown:
6. Save the file in the required location.
7. Upload this JSON file on the GST portal.
For more details on the information captured in each column of the offline tool, click here .
The latest offline tool supports data export only until 31st March 2019. Hence, if the report period is from 1st April 2019, a note appears at the bottom of the Export Report screen.
In Tally.ERP 9, even though there is a provision to select the period from April 2019, the data will not be exported to the tool for the following reasons:
● The tool accepts data only until March 2019.
● As per Notification No. 20/2019 – Central Tax, issued by GSTN, annual returns will be applicable for composition dealers from April 2019.
If you want to export the details for reference purposes, you can press Alt+E from GSTR-4 and select Excel (Spreadsheet) format. Do NOT select Excel GSTR-4 (Spreadsheet).
When your data volume is very low, you can directly file the returns on the portal.
1. Log in to the GST portal.
2. Select the Return Filing Period , and click SEARCH .
3. Click GSTR4 .
4. Click PREPARE ONLINE .
5. Open each GSTR-4 table, copy the data exported from Tally.ERP 9 to GSTR-4 offline tool, and fill the tables.
6. Submit your returns and e-sign.
