Statement number 3 for uploading and shows an error "password protected" solution

8693 views 18 replies

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 been 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


Attached File : 1871537 20180719214423 refund03statement.zip downloaded: 559 times
Replies (18)
👍 Good....
Thanks for the update......

The above unprotected file helps for filing the refund for one month. Kindly provide the unprotected sheet for filing the return for multiple periods at a time.

Sir Can you share same modified file for Statement 1A for refund Under inverted tax Strucuture?

Problem not yet solved. when we put date in period field, error shows "SI.No with Duplicate Entry in row Number 13"

Thank You so much sir... this helps me a lot

Originally posted by : CA Ajay
Problem not yet solved. when we put date in period field, error shows "SI.No with Duplicate Entry in row Number 13"

I am facing the same error, any solutions to this?

SI.No with Duplicate Entry in row Number 13

 

 

when we put date in period field, error shows "SI.No with Duplicate Entry in row Number 13" I am facing the same error, any solutions to this? SI.No with Duplicate Entry in row Number 13

facing same problem. please provide solutions.

Did this error got solved...pls reply its urgent

 

I am not able to resolve this issue, when I insert all data & go to validation, I still

get the same error msg...."SI.No with Duplicate Entry in row Number 13"

It has been 6 months not able to submit GST Refund, even GST office have no clue how to resolve the issue.

has anybody found any solution?

 

Thanks in advance.
 

I have problem to create json file it shows sl no duplicate in row no13
☰ Toggle navigation Toggle navigation Toggle navigation Toggle navigation CAclubindia Home Forum GST Get 10% Discount & Revise your CA subjects with online video classes with PD option - Coupon code: RSLT10 Statement number 3 for uploading and shows an error "password protected" solution   Follow Thread  a year ago     10 Replies     Report Shijoy Commercial Tax Inspector 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 been 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 Attached File : 1871537 20180719214423 refund03statement.zip downloaded 430 times   Reply    Quote    Like   Send msg Online GST Certification Course CAclubindia Online Learning offers a wide variety of online classes and video lectures for various professional courses such as CA, CS, CMA, CISA as well as various certification courses on GST, Transfer Pricing, International Taxation, Excel, Tally, FM, Ind AS and more. know more »    a year ago    Vinod Babu 👍 Good.... Thanks for the update......   Reply    Quote    Like   Send msg    11 months ago    Asha Partner The above unprotected file helps for filing the refund for one month. Kindly provide the unprotected sheet for filing the return for multiple periods at a time.   Reply    Quote    Like   Send msg    6 months ago    ROHAN article Sir Can you share same modified file for Statement 1A for refund Under inverted tax Strucuture?   Reply    Quote    Like   Send msg    5 months ago    CA Ajay CA Problem not yet solved. when we put date in period field, error shows "SI.No with Duplicate Entry in row Number 13" Attached File : 41003 20190309143944 capture1.jpg downloaded 73 times   Reply    Quote    Like   Send msg    5 months ago    BIJOY KUNDU STUDENT Thank You so much sir... this helps me a lot   Reply    Quote    Like   Send msg    4 months ago    Rajesh Karia Originally posted by : CA Ajay Problem not yet solved. when we put date in period field, error shows "SI.No with Duplicate Entry in row Number 13" I am facing the same error, any solutions to this? SI.No with Duplicate Entry in row Number 13       Reply    Quote    Like   Send msg    3 months ago    aasmeen ali accounting when we put date in period field, error shows "SI.No with Duplicate Entry in row Number 13" I am facing the same error, any solutions to this? SI.No with Duplicate Entry in row Number 13 facing same problem. please provide solutions.   Reply    Quote    Like   Send msg    a month ago    Dharam Vinesh Shethia student Did this error got solved...pls reply its urgent   Reply    Quote    Like   Send msg    18 days ago    Rajesh Karia   I am not able to resolve this issue, when I insert all data & go to validation, I still get the same error msg...."SI.No with Duplicate Entry in row Number 13" It has been 6 months not able to submit GST Refund, even GST office have no clue how to resolve the issue. has anybody found any solution?   Thanks in advance.     Reply    Quote    Like   Send msg   Prev12 Next LEAVE A REPLY Attach File  Notify when someone replies (Email/Android/iOS) Recent Post Topic  Forum Home Popular Discussion Tax amount need to be mentioned in way bill where to show nil rated supply Invoice Format SUPPLIER REGISTERED CANCELLATION Last Year ITC Interest rate for Annaul Return Gstr9 Gst annual return view more » Browse by Category Income Tax Audit Students Accounts Custom VAT Career Service Tax Corporate Law Info Technology Excise Shares & Stock Exams LAW Professional Resource Others Taxpayers GST   Set Content Preference About We are Hiring Media Coverage Advertise Terms of Service Disclaimer Privacy Policy Contact Us Download CAclubindia App ×  Read more at: https://www.caclubindia.com/forum/statement-number-3-for-uploading-and-shows-an-error-quot-password-protected-quot-solution-473679.asp?offset=1
SI.No with Duplicate Entry in row Number 13 - To resolve this issue, just make sure you manually select G or S from the drop down menu for each entry, don't copy paste G or S for all.

Hello ,

I can help u to get out of this error here is my mail id:- niteshmathur1997 @ gmail.com u can share ur error screenshots & excel utility having data. I  already help many people facing this kind of issue.  I can solve it as soon as possible. This service is free of cost.

Thanks & Regards

Nitesh Mathur

Hello ,

I can help u to get out of this error here is my mail id:- niteshmathur1997 @ gmail.com u can share ur error screenshots & excel utility having data. I  already help many people facing this kind of issue.  I can solve it as soon as possible. This service is free of cost. Thanks & Regards Nitesh Mathur

 


CCI Pro

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register