Gsoftnet

Free Download Justification Report Excel Generation Utility v2.1.

Recently, A new version(2.1) of Excel Generation utility for Justification report has been rolled out by TRACES.  This is updated Justification Report text file format to convert the same into readable Excel format.  This utility is used to convert from "TXT" to "XLS" format Justification report.

Why its need?

It is very useful to know about details of calculation of defaults.  The Deductors are receiving Default Notices from Income Tax department.  To know the calculation of default, Justification Report is provided by Income Tax Department and Traces provides report in Text format thus this utility converts Text file to Excel format.  In this way, separate sheets of Excel File details the calculation of defaults sent by Income Tax Department.

Steps to convert the Justification Report text file into excel:

  • Download the zip file from 'Requested Downloads' screen and save to your local machine
  • Unzip the file using Winzip. Password to unzip is 'JR__
    __', e.g., JR_AAAAA1235A_24Q_Q3_2010-11. This will save the Justification Report as a text file
  • Download the macro utility for Justification Report from this screen
  • Double-click the utility, excel sheet will open
  • Click on 'Enable Content' in the warning message to enable macros
  • Select the Justification Report text file and the folder to save the output excel file and click on button 'Generate TDS CPC Justification Report'
  • The text file will be converted into excel spreadsheet and saved in the selected folder
  • Open the Justification Report excel file from the folder in which it has been saved

Download Latest Justification Report Utility Ver. 2.1 (Click Here)