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