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

More Under Goods and Services Tax

44 Comments

  1. 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.

  2. 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

  3. 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

  4. 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.

  5. 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.

    1. Manohar Jaiswal says:

      If you have downloaded the tool, you may not have this doubt.. It is on the home page of the tool itself. Somebody has already given this reply for another query in the bottom of this thread.

  6. 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

    1. Dipankar Basu says:

      It is the common error started after 01-07-2020 as GSTN blocked data ( return, refund , ledger etc ) related to July 2017. The reason stated by GSTN is that it can hold data only for three years (Which rule??)..But now GSTN has been trying to rectify the mistake in programs .. But still not resolved. Howver August 2017 is available even after August 1st 2020.

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

  8. 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..

    1. Taj Hussain says:

      Please send to the Tool developer.. He may help you..I got the help from directly. Please send to the email address provided in the tool with your problem..

  9. 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

      1. JOE JAMES says:

        On August 18 2020, I filed an application successfully. While filing now, facing the same problem with the version of utility like everyone here. Gst helpdesk is yet to come up with a solution. We cannot submit the RFD application without getting the json file validated. Have you figured out any solution. Please share / contact me on :9539806629 .

  10. 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.

  11. 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

    1. Taj Hussain says:

      Please send to the Tool developer.. He may help you..I got the help from directly. Please send to the email address provided in the tool with your problem..

  12. 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

    1. Sanesh Guptha says:

      Sir
      Please check whether any SECOND entry in B2C supplies..If two entries exists ,it may show this error. If you have two b2c supply ,consolidate the values of the supply and enter as a single entry.,Then retry

  13. Ram Singla says:

    Sir

    “Valid GSTIN is mandatory”.

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

  14. 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..

  15. 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..

  16. 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

  17. 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

    1. Satyendra Kumar Jain says:

      Sri..Mukesh Dhiman
      Please check whether any duplicate invoice is (with same invoice number) in either Inward supplies or in Outward supplies..Also check whether any double entry for B2C supplies in outward supplies. System only allows a single consolidated entry for all of your B2C supplies

  18. 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..

Cancel reply

Leave a Comment to Rishad

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

Search Posts by Date

November 2020
M T W T F S S
 1
2345678
9101112131415
16171819202122
23242526272829
30