To generate the excel sheet from the Justification report downloaded from TRACES, follow the steps given below:
1. To generate the justification report excel sheet, download the TRACES-Justification-Report-Generation-Utility-V1.0 from the following link:
Download TRACES-Justification-Report-Generation-Utility-V1.0
2. Now, provide the path of unzipped report downloaded from TRACES website and the path of the output folder where you want this report to be generated.
3. Click on Generate Report button to generate the report.
Please note, to generate the report you have to enable the macros in the excel sheet.
18 replies on “Generation of excel sheet from the Justification report downloaded from TRACES”
Sir,
Iam Getting an error of Jr-ERR1000 While generate report.
Thanks in advance.
when i open the pan correction its nothing generating its blank page coming, pls help me out…
When I clicked on GENERATE REPORT then message JR-Err1000³ was there.
What does it mean and how to resolve?
When I clicked on GENERATE REPORT then message JR-Err1000³ was there.
What does it mean and how to resolve?
Do we need to revise our TDS Return by e-TDS filing for the concerned quarter or to put the position correctly by correspondence with TRACES?
When I clicked on GENERATE REPORT then message JR ERR1000³ was there.
File not selected. Please select downloaded text file. What does it mean and how to resolve?
I have all ready dounload jastification report but error is err1000.
What does it mean and how to resolve?
When i download and try to open this file, it gives the below message on a pop-up window:
“This workbook has lost its VBA project, ActiveX controls and any other programmability-related features.”
After this, none of the buttons are usable. In fact, the XL is not working at all. I clicked on browse button, but nothing happens. I have enabled macros, enabled activeX settings, but still the XL is not usable. How do i correct it? I am using Excel 2007.
Dear Sir/Madam,
We are revising the ETDS return for 2010-11. I have pulled out justification report.
How will I come to know that the line item is for correcting the PAN or for Short deduction.
Also please let me know in justification report what does the below expansion stand for.
PEA1
SDPE
SDPE
Dear Sir/Madam,
We are revising the ETDS return for 2012-13. I have pulled out justification report.
How will I come to know that the line item is for correcting the PAN or for Short deduction.
Also please let me know in justification report what does the below expansion stand for.
PEA1
SDPE
SDPE
When I clicked on GENERATE REPORT then message JR ERR001³ was there.
File not selected. Please select downloaded text file. What does it mean and how to resolve?
Dear Sir,
We are not able to understand your query. Please contact us at (91 33) 64596006, 22623535.
Instead of simplifying procedures, dept has complicated and most of the time we are required to approach professionals or be at the mercy of department.
Sometimes we feel that the earlier system was less exhausting.
Dear Sir,
I am finding difficulty while converting text file of Justification report into Excel. It shows an error reporting that “text file con not be loaded, as it doesn’t have a proper version/header to convert to excel. Please get the proper text file and load it.”
Kindly guide what to do as i have already contact to the TDSCPC department for this. and have not received a favorable response.
Dear Sir,
We understand your problem. All rights and solution regarding this can be provided by the department only as they are the ones who have created it.
Thanks for the utility, having problems downloading from tdscpc…
When I clicked on “GENERATE REPORT” then message “JR ERR004” was there.
What does it mean and how to resolve?
Do we need to revise our TDS Return by e-TDS filing for the concerned quarter or to put the position correctly by correspondence with TRACES?
Dear Sir,
Please contact TRACES for this issue.
Email: contactus@tdscpc.gov.in
Toll Free: 1800 103 0344
Phone: 0120 4814600
I have the same problem like V K Bajaj. Any solutions? I just deal extensively with EXCEL REPORT.
The tips and tricks I have acquired me here: http://www.excel-aid.com/excel-report-applying-report-layouts-and-styles.html