12 February 2014
Steps to convert the Justification Report text file into an 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_TAN_Form Type_Quarter_FY', 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 - "TRACES Justification Report Generation Utility V 1.0" • 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