NITESH VYAS asked 6 years ago
error in filling statement 3 of RFD 01A
I am facing error in filling refund application RFD-01A, when I filled all the data and click to proceed the error showing that kindly verify if the statement is submitted successfully, and thereafter I go for statement 3 and download the offline utility, the utility is not properly working, please provide the solution
Answer the question
Sachin Agrahari answered 6 years ago
Dear Nitesh JI,
You will get an answer very soon, please clarify that whether you are filing Refund for SEZ Unit or an Exporter.
In case of any query you can call or whatsapp me on 8574566807.
NITESH VYAS answered 6 years ago
Dear sir,
I am applying refund for an export firm and number of errors in statement 3 while opening of sheet , during filling and validation, please guide me
Sachin Agrahari answered 6 years ago
Dear Sir,
Please call or whatsapp on 8574566807 to brief the problem you are facing.
NAYANA MANDKE answered 6 years ago
I am also facing the same problem. I put grievance also. But no reply from GST. Since last 3 weeks , St,3 A is not getting uploaded and therefore RFD 01 could not be filed. Refund is stuck up
CA SHIJOY JAMES answered 5 years ago
Statement Number 3 for uploading and shows an error “Password Protected” . .
“The cell or chart that you are trying to change is proctected and therefore read only ” Please download the modified file and easily create the json file . This Excel file is unprotected for editing . The issues have been now resolved..
You can subscribe my Youtube Channel https://www.youtube.com/shijoykoratty for more videos. The link also provided at the bottom for downloading the modified file.
https://drive.google.com/file/d/1VhGf_fIdc-50C1CrPPbR-UPLOFHfMKn6/view?usp=sharing
Shijoy James
ASTO
SGST Department Kozhikode, Kerala
OFFLINE EXCEL FILE FOR EXPORTERS FOR UPLOADING STATEMENT 3 ERROR SOLVED
This file is recreated for generating statement 3 for GST Export / Zero rated supply refund. Kindly Recreated by clearing errors: Shijoy James ASTO, SGST Department, Kozhikode, Kerala
Procedure for creating the JSON file.
1. Open the Excel File. Enter the GSTIN and Month and year for refund in the respective column. Month and year in mmyyyy format. For eg. if the refund applied month is August 2017, it should be entered as 082017.
2. Enter the data from Sl. No. 1 onwards. Sample data has bSeen entered here for your reference. Date should be entered in dd-mm-yyyy format. If your date format is different, please change it through Control Panel> Regional and Language> Date Format> British Date Format. The “Port Code”, “EGM Reference Number” etc should be entered in correct format. Select Goods or Service from the dropdown (G/S).
3. Click “Validate and Calculate” button. If any error shows in the extreme right “Error” column, rectify the mistake.
4. Click “Create File to Upload” and select the directory of your PC to download the JSON file. Name may be like “ABCAugust.json” etc. Please RENAME the file extension of the JSON file created to JSO and Save as “All Files” For eg. “AbcAugust.json to “AbcAugust.jso”
5. The go online in GST CP, (gst.gov.in) and login.
6. Goto Services> Refund .. Select the application for the corresponding month for which statement created as JSO file.
7. Browse and upload the file. Click Back button after upload . Then verify whether it has been uploaded properly. The data will be auto filled from the uploaded JSO file.
Thanking you
Shijoy James
Jainish Desai answered 5 years ago
SHILOY JAMES sir I am facing same problem in offline utility for statement -4 for SEZ supplies, I cannot write any thing in the excel file , whenever i input anything there comes a message that its a protected sheet.. sir any solution for this.
divyaCA SHIJOY JAMES answered 4 years ago
Dear GST stakeholders
The refund offline utility as downloaded from GST portal showing errors as follows
Error 1: Either invalid date or Please enter the Invoice or Doc date in dd-mm-yyyy format
Error2: SI.No with Duplicate Entry in row Number
Error3 : The uploaded JSON file which was created via offline utility has invalid data format.
.
Even though the data entered is correct..Lot of complaints and request in this regard have been received .. I have made a little modification in the VBA program code and rectified the common errors ..
Requesting the stakeholders (tax payers, practitioners, accountants, professionals etc. )may use this modified tool..
Please use MS Office 2010/13/16 for using the Excel VBA based utility..
Links for MODIFIED refund utility
Download MODIFIED Inverted duty structure refund
https://drive.google.com/file/d/1_BfthuOcQzwm3bQAkOj8FCziHkVJEuL2/view?usp=sharing
Download MODIFIED Refund Export without payment of tax Mutltiple BRC
https://drive.google.com/file/d/1VhGf_fIdc-50C1CrPPbR-UPLOFHfMKn6/view?usp=sharing
Feedback and errors are welcome
Shijoy James
ASTO
Kozhikode Kerala
CA SHIJOY JAMES answered 4 years ago
Dear GST stakeholders
The refund offline utility as downloaded from GST portal showing errors as follows
Error 1: Either invalid date or Please enter the Invoice or Doc date in dd-mm-yyyy format
Error2: SI.No with Duplicate Entry in row Number
Error3 : The uploaded JSON file which was created via offline utility has invalid data format.
.
Even though the data entered is correct..Lot of complaints and request in this regard have been received .. I have made a little modification in the VBA program code and rectified the common errors ..
Requesting the stakeholders (tax payers, practitioners, accountants, professionals etc. )may use this modified tool..
Please use MS Office 2010/13/16 for using the Excel VBA based utility..
Links for MODIFIED refund utility
Download MODIFIED Inverted duty structure refund
https://drive.google.com/file/d/1_BfthuOcQzwm3bQAkOj8FCziHkVJEuL2/view?usp=sharing
Download MODIFIED Refund Export without payment of tax Mutltiple BRC
https://drive.google.com/file/d/1VhGf_fIdc-50C1CrPPbR-UPLOFHfMKn6/view?usp=sharing
Feedback and errors are welcome
Shijoy James
ASTO
Kozhikode Kerala
