Offline Utility Tool for GST Refund Error solved

Dear GST stakeholders. Here is the solution for error !!!

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

Error 2: SI.No with Duplicate Entry in row Number 13

Error 3 : 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

a. Download MODIFIED Inverted duty structure refund

https://drive.google.com/file/d/1_BfthuOcQzwm3bQAkOj8FCziHkVJEuL2/view?usp=sharing

b. Download MODIFIED Refund Export without payment of tax Multiple BRC

https://drive.google.com/file/d/1VhGf_fIdc-50C1CrPPbR-UPLOFHfMKn6/view?usp=sharing

Feedback and comment on errors are welcome

Author Bio

Qualification: Graduate
Company: SGST DEPARTMENT
Location: Kozhikode, Kerala, IN
Member Since: 24 Feb 2020 | Total Posts: 1

Join Taxguru’s Network for Latest updates on Income Tax, GST, Company Law, Corporate Laws and other related subjects.

Join Taxguru Group on Whatsapp

taxguru on whatsapp WHATSAPP GROUP LINK

Join Taxguru Group on Whatsapp

taxguru on whatsapp WHATSAPP GROUP LINK

Join Taxguru Group on Whatsapp

taxguru on whatsapp WHATSAPP GROUP LINK

Join Taxguru Group on Whatsapp

taxguru on whatsapp WHATSAPP GROUP LINK

Join Taxguru Group on Whatsapp

taxguru on whatsapp WHATSAPP GROUP LINK

Join Taxguru Group on Whatsapp

taxguru on whatsapp WHATSAPP GROUP LINK

Join Taxguru Group on Whatsapp

taxguru on whatsapp WHATSAPP GROUP LINK

Join Taxguru Group on Whatsapp

taxguru on whatsapp WHATSAPP GROUP LINK

Join Taxguru Group on Whatsapp

taxguru on whatsapp WHATSAPP GROUP LINK

Join Taxguru Group on Whatsapp

taxguru on whatsapp WHATSAPP GROUP LINK

Join Taxguru Group on Telegram

taxguru on telegram TELEGRAM GROUP LINK

More Under Goods and Services Tax

91 Comments

  1. Ramavatar Agarwal says:

    “Kindly upload the revised document to claim refund”. I am facing this issue to upload JSON files in an Inverted duty structure refund. Please, give me solutions .

  2. CA JYOTI SANKHALA says:

    Kindly upload the revised document to claim refund. I am facing this issue to upload JSON files in an Inverted duty structure refund. Please, give me solutions .

  3. Sanjeev Sachdeva says:

    Kindly upload the revised document to claim refund. I am facing this issue to upload JSON files in an Inverted duty structure refund. Please, anybody, help me to resolve this issue.

    1. SWEETY BHANDARI says:

      Kindly upload the revised document to claim refund. I am facing this issue to upload JSON files in an Inverted duty structure refund. Please, give me solutions .

    2. Himanshu Gupta says:

      Kindly upload the revised document to claim refund. I am facing this issue to upload JSON files in an Inverted duty structure refund. Please, give me solutions .

    1. Padmaraj Dwivedi says:

      If you fill the data in exact column no password required. Just fill the data in exact white columns. If you copy paste from another excel sheet, just copy the column-wise data and paste it.

  4. Varsha Nagaraj says:

    Sir it worked out for me…..! Thanks a lot. Guys if anyone is having trouble kindly follow what sir has said above. It works wonders.I am completely satisfied.

  5. SRINIVASAN says:

    ERROR MESSAGE DURING THE VALIDATION “Refund has already been claimed for this document(outward document)” for the july 2020, but we have not received any refund for this month. but the above issue problem happened that previous year invoice number same i.e., july 2019, how to SOLVE THIS? PLS HELP, helpdesk ask json file and error file screenshot, but not solve till date

  6. Venkatesh Chitragar says:

    Dear Sir,
    we are getting the error of “REFUND ALREADY BEEN CLAIMED FOR THIS DOCUMENT”, whereas we have not received any refund against this invoice. Please resolve our issue, Thank you

  7. Venkatesh Chitragar says:

    Dear Sir,
    We have applied for GST refund “On Account of Refund by Supplier of Deemed Export”, on 20/11/2020. Subsequently we have received GST RFD-03 Deficiency Memo from the department asking us to file the refund application with more documents. Accordingly, we have tried to apply for the GST Refund for the same invoice, but we are getting the error of “REFUND ALREADY BEEN CLAIMED FOR THIS DOCUMENT”, whereas we have not received any refund against this invoice. Thank you.

  8. OKS says:

    dear Sir,
    while entering the data in statement on utility i have consolidated invoices for one FIRC Certificate, if i enter the same FIRC number it showing error like FIRC number is already available in so and so row, kindly guide me on this issue.

  9. Pushparaj says:

    dear Sir,
    while entering the data in utility i have consolidated invoices for one FIRC Certificate, if i enter the same FIRC number it showing error like FIRC number is already available in so and so row, kindly guide me on this issue.

  10. KRISHNA KORDAWALA says:

    Sir,

    I am used this modified sheet but my is is same ” The uploaded JSON file which was created via offline utility has invalid data format”

    Please solve the problem

  11. Rakesh Saini says:

    While uploading json file of refund, under inverted duty structure,, there is message “An older version of offline utility has been used to upload the statement. Kindly download the latest available offline utility from the refund application and upload the statement again” I tried it so many times with the recently downloaded offline utility.
    Please suggest

    1. Ak says:

      For B2C supplies, taxpayer need not to provide document level details, rather a consolidated value is to be provided, for all the documents covered in B2C category. In case such error message is shown on upload of any statement, you can rectify the errors details in excel, by providing a single consolidated detail for Type of Outward Supply as B2C. Just go through portal FAQs

  12. Jubin says:

    when i upolading gst refund form S01A go for validating that time inword document error shown as per below:- This document is not found in GSTR1 returns data i.e. it is not filed. Please upload filed documents(Inward document). i have checked inward supplie data in 2A is correct uploaded but gst refund form S01A validating error showing. so pls sugesset me how do solve this error

  13. YATIN RANE says:

    when i upolading gst refund form S01A go for validating that time inword document error shown as per below:- This document is not found in GSTR1 returns data i.e. it is not filed. Please upload filed documents(Inward document). i have checked inward supplie data in 2A is correct uploaded but gst refund form S01A validating error showing. so pls sugesset me how do solve this error

  14. G K VAISHNAV says:

    when i upolading gst refund form S01A go for validating that time inword document error shown as per below:- This document is not found in GSTR1 returns data i.e. it is not filed. Please upload filed documents(Inward document). i have checked inward supplie data in 2A is correct uploaded but gst refund form S01A validating error showing. so pls sugesset me how do solve this error.

  15. Praveen Gujrati says:

    when i validate & calculate statement 3 after filling all the coloums, date automatically changed e.i. 10.04.2019 convert as 04.10.2019. pls help me in solving this problem

  16. VINODINI says:

    Hi. i am trying to submit GST refund application through RFD 01 . after creaton of JSON file , while uploading, system says an empty file cannot be uploaded. pls help on this error

  17. ashu says:

    I am facing the problem while claiming a refund under inverted duty structure, when I am going to upload the JSON file it is showing the problem that “an older version of the offline utility has been used to generate the JSON file.
    Please advise in this regard. I tried so much time but it is showing the same problem, even I filled in a new offline utility that I downloaded from GST portal. It is showing the same status although there are previously three times the same problem and communication with GST department in this regard. Eventually please provide the final suggestion so, that we can overcome this problem.
    With regards
    For MSHP PVT. LTD.
    Account department
    FCA MD. MAINULLAH.

  18. Jayesh Mahendrabhai Shah says:

    I require Excel FORMAT for GST_REFUND_05BAF13
    I had download it and open in 2013 but it shows error :
    compile error:can’t find project or library

  19. sriganesha says:

    while entering the data in statement 3 i have consolidated invoices for one FIRC Certificate, if i enter the same FIRC number it showing error like FIRC number is already available…. kindly be advised how to proceed

  20. Jigisha says:

    Hello Sir,
    The version for GST Refund S01a i.e. RFD 01 has been changed as per the error on website, due to which after downloading the new form the data for GST number and period vanishes while validating. Please help for the same.

  21. vanaja says:

    dear Sir,
    while entering the data in statement 3 i have consolidated invoices for one FIRC Certificate, if i enter the same FIRC number it showing error like FIRC number is already available in so and so row, kindly guide me on this issue.

  22. Rishabh says:

    Hello ,

    i was trying to file GST refund for March’18 under inverted duty structure , but system was saying first to file refund from July’17 to Feb’18. But when we select July’17 from Drop down, It is starting from August’17.

    i checked the same for other GST ID Also , similar error is appearing
    Any idea

  23. CA Manjul Soni says:

    I had some errors in generating json such as duplicate entries and also issues in b2c transactions.

    The tool helped me a lot. Infact I contacted Mr. James for same.. He helped me resolve the issues and gave me solutions. Thank you Mr James.. A very nice initiative.

  24. Mahendra Kumawat says:

    I have feeded all detail as per guidelines for refund after validated no error showing and JSON file created but upload it in portal, it not upload and showing error : The uploaded JSON file which was created via offline utility has invalid data format.
    Pls advise..

  25. Nagaraju M says:

    Dear Sir, Even though we have almost all the errors fixed and uploaded , Always shows the same error message, We have generated json file to upload statement 1A annexure using modified utility but we are getting an following error message again and again .

    “an older version of offline uitility has been used to upload the statement. kindly downlaod the latest available offline utility from the refund application and upload the statement again ”

    Please suggest me the solution PH 9964550033

  26. Narayan M K says:

    Thanks to Mr. Shijoy James. I contacted a number of departmental officers, helpdesk and my client visted the departmental offices a number of times for getting the uploading errors resolved but without any luck. Also thanks to Mr. Satyendra Kumar Jain’s advice regarding single consolidated entry for B2C, I could file the claim. Thanks both.

  27. RAJESH PM says:

    While using this new utility entering B2C Small the error message showing the Invoice date cannot be before 01-07-2017 for outward supplies.
    The date automatically showing in the date column is 07-07-2017, This cell is write protected.
    What is the solution

  28. Nitin Chopra says:

    While uploading RFD01 hain file for refund under inverted tax structure the error is appearing – THE UPLOADED JSON WHICH WAS CREATED VIA OFFLINE UTILITY HAS INVALID DATA FORMAT

  29. Ram Singla says:

    Sir

    “Valid GSTIN is mandatory”.

    This error shows when i proceed for generating the Json File.
    Please suggest me the solution.

  30. Manohar Jaiswal says:

    If anybody has refund statement errors, please use the above tools first as in the above post.. I have got this link from google after long searching. I have uploaded my refund application smoothly.

    Earlier I have contacted gst help desk, grievance portal multiple times..Utter wastage of time..Nothing solved me..

  31. Karan Sharma says:

    I am trying to upload GST refund JSON file but it is showing an error of undefined error under invoice no.

    Please tell me the solution as soon as possible..

  32. Darshak says:

    Heartly Thanks to Mr. Shijoy James Sir, this worked for me, i stuck with refund application since many days, tried to change many things , every time use fresh application but i failed to file refund application , even gst help desk dont have any solution , Thank you for helping me out; I really appreciate your kindness and support. I will always remember your support , god bless you sir , Heartily thanks again respected mr. shijoy james sir

  33. Mukesh Dhiman says:

    Sir,

    I am used this modified sheet but my is is same ” The uploaded JSON file which was created via offline utility has invalid data format”

    Please solve the problem

  34. Prakash Khandala says:

    Lot of Thanks to Sri. Shijoy James.. I have file my clients refund application.. I was stucked with the error SI.No with Duplicate Entry in row Number 13 .. several times.. I have contacted the helpdesk..They advised me to use fresh copy of refund application, issue may with date format etc.. But it was not the reason.. Actual issue was with the tool.. I have searched the internet and got a number .. I have called the number.. They have demanded Rupees 5000 each for each refund file..However these tools worked for my refund applications..Thaks Sri. James..

Leave a Comment

Your email address will not be published. Required fields are marked *

Search Posts by Date

December 2021
M T W T F S S
 12345
6789101112
13141516171819
20212223242526
2728293031