Error in GST Refund Offline Tool for Export and Inverted Duty Structure

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

Download MODIFIED Inverted duty structure refund https://drive.google.com/file/d/1_BfthuOcQzwm3bQAkOj8FCziHkVJEuL2/view?usp=sharing

Download MODIFIED Refund Export without payment of tax Mutltiple BRC

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

Feedback and errors are welcome

Shijoy James

ASTO

SGST Trivandrum Kerala

shijoy.james @ gmail.com