CONSULTEASE.COM

Sign In

All QuestionsCategory: GST Complianceserror in filling statement 3 of RFD 01A
Profile photo of NITESH VYASNITESH VYAS asked 4 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
9 Answers
Profile photo of Sachin AgrahariSachin Agrahari answered 4 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.

Profile photo of NITESH VYASNITESH VYAS answered 4 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

Profile photo of Sachin AgrahariSachin Agrahari answered 4 years ago

Dear Sir,
Please call or whatsapp on 8574566807 to brief the problem you are facing.

Profile photo of NAYANA MANDKENAYANA MANDKE answered 4 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

Profile photo of SHIJOY JAMESCA SHIJOY JAMES answered 3 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 

Profile photo of Jainish DesaiJainish Desai answered 2 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.

Profile photo of divyadivya answered 2 years ago

For any issue while applying for refund under GST,

Profile photo of SHIJOY JAMESCA SHIJOY JAMES answered 2 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
 

Profile photo of SHIJOY JAMESCA SHIJOY JAMES answered 2 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