|
|
|
Change in data structure of eTDS Statement from 1st October 2009 
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
| ............................................................................ |
|
| . |
|
|
Change in data structure of eTDS Statement...
Data structure of quarterly e-TDS statements have been modified by the Directorate of Income Tax
The input screen of FVU has three fields viz; 'Input File','Challan Input File' and 'Error/Upload & Statistics Report File'. |
|
TDS / TCS Input File
-
Specify the name (with the .txt extension) of the input file (including the path) i.e. the name of the e-TDS/TCS statement prepared as per file format to be validated by the FVU.
-
Input filename should not be more than 12 characters (including the .txt extension) and should not contain any special characters eg. : , \ / etc.,. Extension of Input file should be in small case.
For example Filename can be FORM27EQ.txt
|
|
|
2. |
Challan Input File
-
Specify the name (with the .csi extension) of the input file (including the path) i.e. the name of the challan file downloaded from Challan Status Inquiry for the verification of challan in TDS/TCS statement
-
Input filename should not be more than 25 characters (including the .csi extension) and should not contain any special characters eg. : , \ / etc.,.
For example Filename can be MUMM11111A040909.csi
|
|
|
3. |
Error/Upload & Statistics Report File
|
In case the input file is valid, FVU will generate three files:
- FORM27EQ.html - 'TDS/TCS Statement Statistics Report'
- FORM27EQ_PAN_Statistics.html - PAN Statistics Report
- FORM27EQ.fvu - 'upload file' and
- FORM27EQ_Electronic_Statement_Warning_File.html (If any)
|
| |
 |
| |
In case of an 'invalid file', an 'error file' will be generated. This will be an html file with the same filename as the input file with err appended after the file name and html as extension. Example, if the input file name is FORM27EQ.txt the error filename will be 'FORM27EQerr.html' (a carat separated text file with .err as extension will also get generated with the same information, filename FORM27EQ.err). The error file will contain details of erroneous records like Line no, record type, batch no., challan no., deductee/salary detail no., along with the error code and the corresponding error description. |
| |
Warning file is generated by FVU if:
- The value in the Bank Branch Code (BSR code) field of challan in the e-TDS/TCS statements is not present in the authorized list of collecting Bank Branch Codes in the FVU and/or
- If the PAN of the deductor is same as that of any deductee in the e-TDS/TCS statement.
- If the challans details of the statement do not match with the details uploaded by the bank.
This file is generated to give an alert to the deductor about the records in which invalid values are mentioned.
In case of regular statements the upload file is to be submitted to a TIN-FC in a CD/floppy along with physical Form 27A or directly to NSDL through the online upload facility at www.tin-nsdl.com.
In case of correction statements the upload file is to be submitted to a TIN-FC in a CD/floppy along with following documents:
(1)Statement Statistics Report generated by FVU
(2)Form No.27A
(3)Copy of the provisional receipt of regular statement |
|
