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

    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?

    Reply
  2. purvesh

    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?

    Reply
  3. Malathy

    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.

    Reply
  4. Santhosh

    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

    Reply
    1. Shashank Petkar

      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

      Reply
  5. ISAAC P ZACHARIAH

    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?

    Reply
  6. Nilakantan Gangadharan

    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.

    Reply
  7. Dharmistha

    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.

    Reply
    1. TDSMAN Post author

      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.

      Reply
  8. V K Bajaj

    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?

    Reply

Leave a Reply

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