Excel for
Chartered Accountants

Permanent Account Number (PAN) is a ten-digit alphanumeric number. PAN enables the Income Tax Department to link all affairs / transactions of a person like payment of income/wealth tax , Tax deducted at source, Income Tax/Wealth Tax Returns, Bank Tranzactions etc.

A typical PAN structure is like "ABCPL1234K" . First three characters i.e. "ABC" as in the above PAN are alphabetic series running from AAA to ZZZ. Fourth character of PAN i.e. "P" in the above PAN represents the status of the PAN holder. "P" stands for Individual, "F" stands for Firm, "C" stands for Company, "H" stands for HUF, "A" stands for AOP, "T" stands for TRUST etc. Fifth character i.e. "L" in the above PAN represents first character of the PAN holder's last name/surname. Next four characters i.e. "1234" are sequential number running from 0001 to 9999. Last character i.e. "K" in the above PAN is an alphabetic check digit.

Section 139A of Income Tax Act, lays down who is required to apply for PAN and Rule 114B of Income Tax Rules lays down the transactions where PAN is required to be quoted. As required by section 139A. A Penalty of Rs. 10,000/- has been prescribed under section 272B for violating the above sections and rules.

CBDT has recently revised the format of form 49A to include document of Date of Birth (DoB). Also the list of document to be attached has also been revised. The revised version of ABCAUS Form 49A incorporates these changes and is latest and uptodate format. See CBDT Notification Click Here >>

ABCAUS excel based application for Permanent Account Number is very simple and user friendly. The user is required to fill the data in a pop up form and PAN Form in excel is updated automatically.

Users are not required to give blank spaces while filling the pop up form. If CAP lock is not on, it gives an alert message immediately. Dropdown list for various prefilled options have been provided to save the time of the user. Inbuilt check boxes also helps in selecting the various options in a very swift manner.

Inbuilt options have been given for checking Assessing Officer Codes and Complete list of various Business Codes have been provided in a Pop up Box. List documents to be attached can also be seen.

Macro should be enabled to use this form. Users are advised to read help file first.

Download ABCAUS Exccel PAN Form 49A Click Here >>

Download Help File Click Here >>

Mothers Name Option in PAN Card

Revised New Excel Auto New PAN Application Form 49A