Itc04 rorm date error

Dera all i have face a challange during submission my itc 04 return in gst portel, date format automatically change in json file and same error show me after downloading error report on portal, many time try for different different mathod to correct the date format but still I am facing same problem 

Replies (2)
Quick Summary
This discussion addresses a common issue where the date format in the ITC-04 return changes automatically, causing errors during GST portal submission. The advice provided includes formatting dates as 'Text' in Excel before generating the JSON file, ensuring dates adhere to the DD-MM-YYYY format required by the GST offline utility, and avoiding re-saving the JSON file. It's also recommended to compare error reports with the source file and consider using AI-powered tools for streamlining compliance workflows.

Convert Date to TEXT in Excel

Before importing into ITC-04 utility:

  1. Select date column

  2. Right-click → Format Cells

  3. Choose Text

  4. Re-enter dates manually in:

 
DD-MM-YYYY

📌 This prevents Excel from auto-changing format during JSON generation.

Please check the date values in the original ITC-04 Excel/JSON file against the format required by the current GST offline utility—typically DD-MM-YYYY—and ensure dates are valid and fall within the relevant reporting period. Avoid opening and resaving the JSON in Excel or another editor, as it may alter date values or separators. Generate a fresh JSON using the latest ITC-04 offline utility, then upload it and download the error report again.

If the error continues, compare the exact error descripttion and affected record in the portal report with the corresponding row in the source file; the issue may be a specific date field or record rather than the whole JSON. Share the exact error text and an anonymised example of the date as shown in both the source file and error report to narrow it down.

A reliable ITC-04 workflow depends on keeping source data, utility validation and portal error correction aligned. Manual checking across many records is difficult; automation can reduce repetitive work while leaving review and compliance judgment in professional hands. At Jir AI, our 2,000+ AI agents and 650+ integrations streamline GST, ITR, TDS, TCS and other compliance workflows, helping reduce manual workload by up to 70%. WhatsApp us to explore the workflow: https://wa.me/message/3HVOZ7HIY4ESC1

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
30 October 2026
Asst Manager Accounts

Goodwin Pumps India Pvt Ltd

Chengalpattu

CA Inter

View Details
Company
ARTICLESHIP 23 October 2026
CA Articleship / Article Assistant

M N Rao & Associates LLP

Vijayawada

CA Inter

View Details
Company
ARTICLESHIP 22 October 2026
Articleship intern

Srinath Manikanta

Hyderabad

CA Inter

View Details
Company
Featured ARTICLESHIP 31 October 2026
CA Articleship

apricus india

Navi Mumbai

CA Inter

View Details
Company
Featured 29 October 2026
Accounts Executive

Synergy Keystone

Chennai

B.Com

View Details
Company
Featured 07 November 2026
Paid Assisstant

DPV & Associates

Chennai

CA Inter

View Details
Company
10 November 2026
Direct Tax Manager

CAAQ CONSULTANCY PVT LTD

New Delhi

CA Final

View Details
Company
ARTICLESHIP 16 November 2026
Audit Executives

Loonker Godawat And Company

Bengaluru

B.Com

View Details