web analytics

How to Download Justification report from TRACES

In the recent scenario many TDS assessee are getting notice from the Income Tax Department for Short deduction of tax or other demand notices due to discrepancy in filling TDS return.

In such case Justification report needs to be downloaded from TRACES website to ascertain the exact reason for rejecting TDS return or understand the basis on which Income Tax Department had raised the queries. Here is the detailed steps for Downloading Justification report from TRACES website:

Log in to https://www.tdscpc.gov.in/

Enter User ID, Password and TAN

After Login, Under the tab of Defaults -> Request for Justification Report Download

Screen will appear with the option of Financial Year, Quarter and Form type selection. Select the appropriate option for which Justification report needs to be generated and hit “Go” Button

On the next coming screen few Information to be fed like :

  • Token Number (Provisional Receipt Number)
  • BCR Code / Challan Number of any of challan
  • Date on which tax deposited
  • Challan Serial Number
  • Challan Amount
  • Mean of Payment (Challan / Transfer)
  • Unique PAN and Amount Combination for the challan mentioned above

After feeding this information request for generating Justification report. Within 24 hours of this practise Justification report will be generated and available on TRACES website for download under the tab of Downloads -> Requested Downloads

 

Click View All

Select the desired Justification report and Click on HTTP Download

To generate Justification Report in excel format you will need excel generation utility. Here is the Excel utility for Justification Report Generation:
Justification report Utility
Justification report Utility
TRACES-Justification-Report-Generation-Utility-V1.0.zip
452.7 KiB
305 Downloads
Details

 

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

 

CA Corners.com

 

 

 

Justification report Utility
Justification report Utility
TRACES-Justification-Report-Generation-Utility-V1.0.zip
452.7 KiB
305 Downloads
Details

Leave a Reply