TDSMAN Blog

smart & easy software for eTDS & eTCS returns

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.

 

facebooktwittergoogle_plusredditpinterestlinkedinmail
  • V K Bajaj says:

    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?

    August 9, 2013 at 10:48 am
  • Shell says:

    Thanks for the utility, having problems downloading from tdscpc…

    August 16, 2013 at 11:52 am
  • Dharmistha says:

    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.

    September 30, 2013 at 11:31 am
    • TDSMAN says:

      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.

      October 3, 2013 at 1:16 pm
  • Nilakantan Gangadharan says:

    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.

    October 25, 2013 at 7:23 am
  • ISAAC P ZACHARIAH says:

    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?

    October 26, 2013 at 8:17 am
    • TDSMAN says:

      Dear Sir,

      We are not able to understand your query. Please contact us at (91 33) 64596006, 22623535.

      November 1, 2013 at 2:34 pm
  • Santhosh says:

    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

    November 26, 2013 at 6:07 pm
  • Malathy says:

    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.

    December 28, 2013 at 12:46 pm
  • purvesh says:

    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?

    January 9, 2014 at 12:08 pm
    • purvesh says:

      I have all ready dounload jastification report but error is err1000.
      What does it mean and how to resolve?

      January 9, 2014 at 12:11 pm
  • narendra says:

    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?

    January 24, 2014 at 12:51 pm

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

*


4 × = sixteen

  • RSS
  • Facebook