Parag Kukreja

Parag Kukreja

Article explains the password combination for Opening ITR-V/Acknowledgement, Form 26AS, Any Intimation/Order and TDS Provisional Receipt/Acknowledgement and for extracting TDS Justification Report, Conso File, TDS Certificates ZIP File and 26AS ZIP File.

A. Income Tax

a. For Opening ITR-V/Acknowledgement: PAN NO. Along With Date Of Birth In Lower Case(EXAMPLE: abcp1234d08081997)

b. For Opening Form 26AS: Date Of Birth (Example: 08081997)

c.For Opening Any Intimation/Order: PAN NO. Along With Date Of Birth In Lower Case (Example: abcp1234d08081997)

Password

B. TDS

a. For Extracting Justification Report: JR_TAN_FORMTYPE_QUARTER_FINANCIALYEAR (EXAMPLE: JR_ABCD12345E_26Q_Q3_2016-17)

b. For Extracting Conso File: (Example: ABCD12345E_49103541)

c. For Extracting TDS Certificates ZIP File: TAN In Upper Case (Example: ABCD12345E)

d. For Extracting 26AS ZIP File: Date Of Birth (Example: 08081997)

e. For Opening TDS Provisional Receipt/Acknowledgement: TAN No. In Lower Case (Example: abcd12345e)

How To Convert 26AS Text File Into Excel File?

1. Open The Text File

2. Select CTRL+A & Copy All The Data

3. Create A New Excel File And Paste The Data On Excel File In First Coloumn.

4. Go To Data Tab ⇒ Click On Text To ColumnsDelimited  Others: “^”  Next & Finish

5. Form 26AS Will Be Available In Excel File.

  • Text file of justification report can be converted in excel through TRACES justification report generation utility which can be downloaded from traces from the requested downloads tab.
  • Similarly, text file of TDS certificates can be converted into PDF through TRACES PDF CONVERTER which can be downloaded from traces from the requested downloads tab.

(Republished with amendments)

Join Taxguru’s Network for Latest updates on Income Tax, GST, Company Law, Corporate Laws and other related subjects.

Join Taxguru Group on Whatsapp

taxguru on whatsapp WHATSAPP GROUP LINK

Join Taxguru Group on Whatsapp

taxguru on whatsapp WHATSAPP GROUP LINK

Join Taxguru Group on Whatsapp

taxguru on whatsapp WHATSAPP GROUP LINK

Join Taxguru Group on Whatsapp

taxguru on whatsapp WHATSAPP GROUP LINK

Join Taxguru Group on Whatsapp

taxguru on whatsapp WHATSAPP GROUP LINK

Join Taxguru Group on Whatsapp

taxguru on whatsapp WHATSAPP GROUP LINK

Join Taxguru Group on Whatsapp

taxguru on whatsapp WHATSAPP GROUP LINK

Join Taxguru Group on Whatsapp

taxguru on whatsapp WHATSAPP GROUP LINK

Join Taxguru Group on Whatsapp

taxguru on whatsapp WHATSAPP GROUP LINK

Join Taxguru Group on Whatsapp

taxguru on whatsapp WHATSAPP GROUP LINK

Join Taxguru Group on Telegram

taxguru on telegram TELEGRAM GROUP LINK

More Under Income Tax

18 Comments

  1. anji says:

    Hi

    I hav recieved TAN PDF from NSDL ,but pdf is protected and in mail it says
    “The password for opening the PDF file is “Six Digit PIN code” mentioned in the TAN Application Form. ”
    what to do ???

  2. anji says:

    Hi ,

    I hav recieved TAN PDF from NSDL ,but pdf is protected and in mail it says
    “The password for opening the PDF file is “Six Digit PIN code” mentioned in the TAN Application Form. ”
    what to do ???

  3. Shylesh says:

    Hi ,

    I hav recieved TAN PDF from NSDL ,but pdf is protected and in mail it says
    “The password for opening the PDF file is “Six Digit PIN code” mentioned in the TAN Application Form. ”
    what to do ???

Leave a Comment

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

Search Posts by Date

December 2021
M T W T F S S
 12345
6789101112
13141516171819
20212223242526
2728293031