Rfd 01 a excel utility error

This query is : Resolved

naveen krishnamurthy (Querist)
Follow

25 October 2018 M TRYING TO GENERATE JSON FILE FROM EXCEL UTILITY FOR RFD 01 A REFUND OF ITC WITHOUT PAYMENT OF IGST BUT ITS SHOWING ERROR IN RELATION TO DATE I.E
"EGM details date cannot be earlier than Shipping Date"
"Invoice Date cannot be before 01-Jul-2017"
"Invoice Date cannot be greater than To Return period"

all data i corrected manually one by one but file not generating
WAHT ALL ERRORS M GETTING ALL RELATED TO DATE ONLY PLS HELP ME OUT . DATE SETTINGS ALSO I CHANGED IN MY PC ACCORDING TO DATE FORMAT AS PER GST EXCEL

Asha Kanta Sharma

Asha Kanta Sharma (Expert)
Follow

22 July 2025 The errors you’re encountering while generating the JSON file from the RFD-01A Excel utility are typical date-validation issues built into the utility to ensure compliance with GST rules. Let’s break down each error and how to fix it:

Common Errors & Their Meaning
"EGM details date cannot be earlier than Shipping Date"
EGM (Export General Manifest) date must be on or after the Shipping Bill date. Check your EGM date fields and ensure they are not before the Shipping Bill date entered.
"Invoice Date cannot be before 01-Jul-2017"
GST was implemented from 1st July 2017, so any invoice date before this is invalid. Ensure no invoice date entered is before 01-Jul-2017.
"Invoice Date cannot be greater than To Return period"
Invoice date must fall within the return period you are filing for. If you are filing a refund for, say, July-September 2018, the invoice date must be within this range.
Steps to Fix:
Cross-check all date fields:
Shipping Bill date ≤ EGM date
Invoice date ≥ 01-Jul-2017
Invoice date ≤ Return period end date
Correct date formats:
The utility requires dates in dd-mm-yyyy format. Changing your PC date format does NOT affect this; you must enter dates correctly in the Excel file.
Bulk-check with filters:
Use Excel filters or conditional formatting to quickly find dates that violate these rules and fix them.
Check hidden sheets or rows:
Sometimes errors come from hidden or extra rows. Make sure only valid data rows are filled.
Clear cache and restart utility:
Sometimes, after fixing data, the utility may still throw errors due to cached data. Save your file, close the utility, restart, and try again.
Extra Tips:
Always keep backup copies before editing.
Try generating JSON with a smaller sample (like just a couple of rows) to confirm your fixes.
If using any date formulas, ensure they are outputting valid dates (no text strings).

You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now