Generation of excel sheet from the Justification report downloaded from TRACES

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 thoughts on “Generation of excel sheet from the Justification report downloaded from TRACES

  1. 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?

  2. 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?

  3. 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.

  4. 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

    1. 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

  5. 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?

  6. 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.

  7. 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.

    1. 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.

  8. 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?

Leave a Reply

Your email address will not be published. Required fields are marked *