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: Netaji, Vengeri, Kozhikode, Calicut, Kerala, India
Member Since: 24 Feb 2020 | Total Posts: 3
Working as Intelligence Officer in State GST Department Kerala India View Full Profile

My Published Posts

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

Join us on Whatsapp

taxguru on whatsapp GROUP LINK

Join us on Whatsapp

taxguru on whatsapp GROUP LINK

Join us on Whatsapp

taxguru on whatsapp GROUP LINK

Join us on Whatsapp

taxguru on whatsapp GROUP LINK

Join us on Whatsapp

taxguru on whatsapp GROUP LINK

Join us on Whatsapp

taxguru on whatsapp GROUP LINK

Join us on Whatsapp

taxguru on whatsapp GROUP LINK

Join us on Whatsapp

taxguru on whatsapp GROUP LINK

Join us on Whatsapp

taxguru on whatsapp GROUP LINK

Join us on Whatsapp

taxguru on whatsapp GROUP LINK

Join us on Telegram

taxguru on telegram GROUP LINK

Download our App

  

More Under Goods and Services Tax

108 Comments

  1. S RANJITH KUMAR says:

    I am supplier of deemed export while filing the refund application the system shows error ” the uploaded json file which was created via offline utility invalid data format” . i checked several times i am using excel 2016 but also it show same error.

  2. babu says:

    while preparing Json file for uploading for a refund of tax accumulated due to the inverted tax structure, the taxable turnover and tax details are disappearing and error reports are generated. How to rectify this defect

    1. Raghav says:

      The excel sheet given by you for Inverted Duty Structure refund 2.0 is uploading. Json file , after being uploaded showing that “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..”

          1. Mukesh says:

            I am also getting same error. Error : 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.
            Still no solution. Has anyone got the solution?

  3. Mahadevi says:

    Hii, Im getting this Error..
    Please enter either integrated tax or (central and state) tax value for outward supplies ” for Nil Rated supplies. What GSt amount do i need to fill in those column

  4. jinal mehta says:

    I am trying to file refund application (inverted duty), I have 9 purchase bills and 1 combined B2C bill. I uploaded that and it also got validated, but now when I enter even Re. 1 in column 1 (turnover of inverted rated goods), it is showing that such amount is greater than that uploaded in column 16 of the offline utility. Please help

  5. Muhamed Naseem says:

    I have the issue at the time of applying GST refund in inverted duty structure.Error message:”Kindly upload revised document to claim refund”

Leave a Comment

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

Search Posts by Date

November 2023
M T W T F S S
 12345
6789101112
13141516171819
20212223242526
27282930