How to open password protected files of Income Tax and TDS

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)

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 Coloumns  ⇒ Delimited   Others: “^”  ⇒  Next & Finish

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

Popular posts from this blog

Reporting Cash Transactions under Rule 114E of Income –Tax Rules, 1962

CBDT issues third round of Certificates of appreciation to tax payers

How to apply for service tax registration in india