Add to Favourites

GSTR-3B Excel Utility Template Does Not Exist

Error: The GSTR3B Excel utility given by the department does not exist. Copy the Excel utility to the export location.

Cause: This error occurs when you try to export the GSTR-3B report but the Excel template provided by the GST department is not available in the folder path. As a result of this, you will not be able to export the report into an Excel file.

Resolution: Update the excel template provided by the GST department, using the following steps.

1. In the GST portal, select Downloads > GSTR-3B Offline Utility > click Download.
2. Select Proceed to download the Utility.
3. Extract the Excel file from the zip folder and save it in a folder.
4. In TallyPrime, open GSTR-3B.
5. Press Alt+E (Export) and select GST Returns.
6. Press Alt+E (Export) and Alt+C (Configure).
7. Copy the path of the saved Excel file and, under Export Settings, paste it in the Template File Path.
8. Select the Template File Name.
9. Press Ctrl+A to save and Alt+E to export the details.

Now the GSTR-3B report will be exported in the Excel format. To know more, refer to File GSTR-3B Using the JSON File Generated from GST Offline Tool.