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
I am facing the same issue, Kindly upload revised document to claim refund,
if any one find the solution pls let me know at balajiindustries666@gmail.com
“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 .
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
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 .
I am facing the same issue, Kindly upload revised document to claim refund,
if any one find the solution pls let me know at ca.krishan@hotmail.com
I am also getting the same error. I raised complaint on GST Helpdesk. After 15 days their Technical Team came with the resolution that Clear Cache / Cookies of the browser. I did the same but still the error did not resolve. Everyone is requested to raise the complaint, as I think it is their website’s technical issue which arose since last month.
any help from the department i am also facing same issue sandip.savalia908@gmail.com
Did anyone got the resolution for error: “Kindly upload revised document to claim refund” while filling refund for inverted structure application?
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.
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 .
Please let me know if you find out any solution for that. Jain.mehul05@gmail.com.its started from 26th November 2021.
I am also facing this issue. Have you got resolution of it ?
same issue
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 .
I am also facing this issue. Have you got resolution of it ?
Still Not..
Excel sheet is passworld protected.plz share password
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.
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.
which value comes in firc coloum
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 . email : ravisapkal.office@gmail.com
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
this utility can be used upto 30-09-2020 after that new version came. Please share new modified version if you have.
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
same problem with my file please contact me if your problem solved
ph no 8930954067
Did you find any solution, please let me know
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.
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.
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.
Very useful
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
Dear sir,
I m also facing the same problem while uploading the json file how to resolve this.
If u get the solution please let me know
Thanks a lot sir. Our long awaited issue resolved.
Any person facing issue in uploading jason file can contact through mail niteshmathur1997@gmail.com
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
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
can you share the FAQ where it is mentioned that for B2C consolidated figure is to be given
Have u been able to solve this older version error? Pls tell us the solution too. Thanks
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
I HAVE SAME ISSUE, HAVE YOU FOUND ANY SOLUTION REGARDING THAT ? IF YES PLEASE LET ME KNOW, IT WILL BE A BIG HELP
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
I HAVE SAME ISSUE, HAVE YOU FOUND ANY SOLUTION REGARDING THAT ? IF YES PLEASE LET ME KNOW, IT WILL BE A BIG HELP
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.
Getting same error.were you able to resolve it?
I HAVE SAME ISSUE, HAVE YOU FOUND ANY SOLUTION REGARDING THAT ? IF YES PLEASE LET ME KNOW, IT WILL BE A BIG HELP
Thank you very much sir for the timely help.
Your file was very useful
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
SIMPLY CONVERT DATE INTO TEXT FORMATE BY EXCEL FUNCTION =TEXT(A1,”DD-MM-YYYY”). THEN PEST SAME INTO STATEMENT 1A
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
Hi,
When i submitting Annual return authorized signatory details shown as undefined along with tax payers name. kindly help to clear it
I tried using your modified tool but the portal shows invalid data format. Please guide if any solution.. I tried So many times
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.
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
While filling data in Excel utility for refund on account of supplies made to sez without payment of tax, it is asking for password
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
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.
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.
did you got find your resolved error, because i got same error pls help out me.
Someone please share email id of tool developer for offline utility in case of inverted duty structure
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
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.
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..
did you got find your resolved error, because i got same error pls help out me.
Sir,
Your Modified Inverted duty structure refund utility was very useful
Thank you very much
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
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.
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
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
Iam getting invalid data format error even after using the modified format and I have no dupliaction in invoices.
Error in uploading refund 01A error is older version inspite of new version uploading
Sir, can you please share the modified form for Statement 05. Refund for SEZ supply without payment of tax
Sir
“Valid GSTIN is mandatory”.
This error shows when i proceed for generating the Json File.
Please suggest me the solution.
The link for the utilities are not working. Sir, can you re-share the link
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..
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..
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
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
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..