ERROR MESSAGE FORM 27C
This query is : Resolved
03 August 2024
SIR,
I COULD NOT ABLE TO UPLOAD FORM 27C AS IT SHOWS DATE FORMAT ERROR. IN CSV FORMAT WHEN TRY TO FORMAT AS DD MMM YYYY . IT IS NOT WORKING. WHEN I RE-OPEN IT IS GOING BACK TO OLD FORMAT.
PLEASE HELP THANKS
I COULD NOT ABLE TO UPLOAD FORM 27C AS IT SHOWS DATE FORMAT ERROR. IN CSV FORMAT WHEN TRY TO FORMAT AS DD MMM YYYY . IT IS NOT WORKING. WHEN I RE-OPEN IT IS GOING BACK TO OLD FORMAT.
PLEASE HELP THANKS
13 August 2025
You're facing a common error while uploading Form 27C (Declaration under Section 206C(1A)), usually caused by incorrect date formatting in the CSV file.
Let me explain why this happens and how to fix it step-by-step.
🧾 Problem:
When uploading Form 27C CSV to the Income Tax TIN website, you get:
❌ “Date Format Error”
🔍 Why This Happens:
Excel often reverts the date format when saving CSV files.
The TIN system expects specific formats, like DD-MMM-YYYY (e.g., 13-Aug-2025)
But Excel might auto-convert to MM/DD/YYYY or other regional formats, causing rejection.
✅ Solution (Step-by-Step): Use Notepad Instead of Excel
🔧 Step 1: Fill Form in Excel, But Don't Save As CSV Yet
Open the .csv template from the TIN-NSDL site.
Enter data in Excel as usual.
For the Date fields (like Date of Declaration, Date of Receipt), use this format:
13-Aug-2025 (exactly like this — Day-MonthAbbr-Year)
Make sure the column is formatted as Text, not Date.
🧰 Step 2: Save Properly Using Notepad
After completing the form in Excel, copy all data (Ctrl+A, then Ctrl+C)
Open Notepad
Paste the data into Notepad (Ctrl+V)
Carefully verify the date fields still look like 13-Aug-2025
Save the file with .csv extension:
File > Save As
File name: "form27c.csv" (with quotes to force CSV extension)
Encoding: ANSI
Save as type: All Files
✅ Step 3: Upload the CSV File
Go to the TIN-NSDL site
Upload the newly saved CSV file
It should now accept the date fields and pass validation
💡 Tips:
Always use hyphen (-) as the separator (not slashes or dots)
Format = DD-MMM-YYYY (e.g., 04-Aug-2024)
Don't open the file again in Excel after saving from Notepad — it might auto-format again
Let me explain why this happens and how to fix it step-by-step.
🧾 Problem:
When uploading Form 27C CSV to the Income Tax TIN website, you get:
❌ “Date Format Error”
🔍 Why This Happens:
Excel often reverts the date format when saving CSV files.
The TIN system expects specific formats, like DD-MMM-YYYY (e.g., 13-Aug-2025)
But Excel might auto-convert to MM/DD/YYYY or other regional formats, causing rejection.
✅ Solution (Step-by-Step): Use Notepad Instead of Excel
🔧 Step 1: Fill Form in Excel, But Don't Save As CSV Yet
Open the .csv template from the TIN-NSDL site.
Enter data in Excel as usual.
For the Date fields (like Date of Declaration, Date of Receipt), use this format:
13-Aug-2025 (exactly like this — Day-MonthAbbr-Year)
Make sure the column is formatted as Text, not Date.
🧰 Step 2: Save Properly Using Notepad
After completing the form in Excel, copy all data (Ctrl+A, then Ctrl+C)
Open Notepad
Paste the data into Notepad (Ctrl+V)
Carefully verify the date fields still look like 13-Aug-2025
Save the file with .csv extension:
File > Save As
File name: "form27c.csv" (with quotes to force CSV extension)
Encoding: ANSI
Save as type: All Files
✅ Step 3: Upload the CSV File
Go to the TIN-NSDL site
Upload the newly saved CSV file
It should now accept the date fields and pass validation
💡 Tips:
Always use hyphen (-) as the separator (not slashes or dots)
Format = DD-MMM-YYYY (e.g., 04-Aug-2024)
Don't open the file again in Excel after saving from Notepad — it might auto-format again
You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now
Click here to login now
Similar Resolved Queries
Unanswered Queries
- CG Tax On residential property
- Post Office RD Interest
- Applicable TDS for Purchase of Flat from NRI
- Eway bill for machinery reparing
- Claiming exemption of perquisite for employee-owned car under New Tax Regime in ITR-2
- Building and other construction workers welfare cess act 1996
- ITR 3 FILING OF AN INDIVIDUAL (PARTNER IN A PARTNERSHIP fIRM)
- Bank Accounts in Balance Sheet for ITR 3
- Gift of mutual fund units to daughter
- Annual return of gst limit
- Delisted shares sold in off market/ Rebate u/s87A
- In Exports Sales HSN details where to fill
- Opting out" of regime provided under subsection (1A) of Section 115BAC but Form 10IEA is not filed.
- Difference in tax comparison report
- Gst invoice numbering and delivery challan numbering
- Sales amount in Gstr1
- E Commerce GSTR1 & 3B how to file
- GST Cancellation without jurisdiction
- Legal Opinion on Registrar's Refusal to Investigate a Society for Non-Renewal and Non-Compliance
- GST Refund_RFD-01
Trending Online Classes
-
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English
CA Bhanwar Borana & CA Shubham Keswani
Subscribe to Pro
Join an elite circle of professionals
CAclubindia
