New form 49A Pan application in Excel with auto fill function

The Central Board of Direct Taxes (‘CBDT’) has amended the Income-tax Rules, 1962 (‘the Rules’) by notifying Income-tax (7th Amendment) Rules, 2011 in respect of application for allotment of Permanent Account Number (‘PAN’) with effect from 1 November 2011.

As per the amended rules there will be two separate PAN application forms as under:

·Form 49A: To be used by Indian Citizen, Hindu Undivided Families (HUF), Companies, Firm [including Limited Liability Partnership (LLP)], Trust, Association of Person, Body of Individuals, formed or registered in India.

·Form 49AA: To be used by Individuals not being a Citizen of India, LLP, Companies, Firm, Trust, Association of Person, Body of Individuals, formed or registered outside India. ( to download 49AA click here )


The excel sheet will help in preparing the form 49A pan application automatically when the details are updated in data sheet.

These details will be updated in the form automatically and you need not have to fill any information in the form. This form is prepared as per the latest amendments made by the CBDT as mentioned above.

New form 49A Pan application in Excel- Click here to download