All about Entering & validating Details in GSTR-4 (Annual Return) Offline Utility
All about Form GSTR-4 (Annual Return) Offline Utility. How to fill GSTR-4 Annual return form offline to online
How can I prepare details in Offline Utility?
- Download the GSTR-4 (Annual) Offline tool from GST Portal under Downloads section and open it on your system.
- Enter edit/view the details in table no. 4 and table 6 (row 12 to 16)
- Generate the JSON file for upload.
Can I generate the JSON file from the offline tool without first importing and opening the JSON file into the offline tool?
- Yes, you can generate the JSON file from the offline tool without first importing and opening the JSON file into the offline tool.
Can the offline utility populate name of the taxpayer based on GSTIN in “Home” Sheet?
- No, the offline utility cannot populate name of the taxpayer based on GSTIN, as details will not be there to fetch name of the taxpayer in Excel/offline utility. GSTIN is to be manually entered. However, it can validate structure of GSTIN when GSTIN is entered in “Home” sheet of Offline utility.
Can I enter negative or decimal amounts in the offline utility?
- Yes, you can enter any negative value and decimal values in the offline utility, wherever applicable.
What is meant by Add or Delete option under Action column?
- You need to select Add or Delete option for each row with data to be added or deleted on the GST Portal.
What is “Validate Sheet” button?
- After entering the data in each sheet, you must click on ‘Validate Sheet’ button to validate the records. If there are any errors, then those errors will be displayed in ‘Sheet validation errors’ column. You must correct these errors before you move to next sheet or generate JSON file to upload.
Can the offline utility validate all details entered in it?
- No, the offline utility will not be able to validate all the details as it would have no connection with GST portal at the time of data entry. Only limited validations would be available in the offline utility tool, namely: GSTIN structure, type of tax etc.
After clicking “Validate Sheet” button, I can see cells highlighted in red and “Sheet Validation” column only shows “Error in row”. How can I know details about the error?
- Point your mouse-cursor on each of the red-highlighted cells to read the error description of each cell. A yellow description box will appear. Correct the errors as mentioned in the description box. Alternatively, click Review > Show All Comments link in the ribbon-tab of the excel to view all the comments together.
When will I be able to validate all details entered in the offline utility?
- Most of the validations are made available in the offline tool itself on click of “validate sheet” button. The validations that have dependency of online connectivity like GSTIN validation, tax rates, POS etc. would be done at the time of upload of JSON File created using offline tool.
