Excel for Chartered Accountants
ABCAUS Excel Application for Tax Deduction Account Number Form 49B
As per section 203A of Income Tax Act, 1961, every person deducting or collecting tax , who has not been allotted a Tax Deduction Account Number (TAN) /Tax Collection Account Number (TCN) shall apply for the allotment of TAN or TCS as the case may be. It enables the Income Tax Department to link tax deducted and deposited by a deductor.
Tax Deducted at Source by assessees has to be deposited using challan ITNS 281 by quoting the TAN/TCN of the deductor.
TAN/TCN is a ten digit alphanumeric number. A typical TAN structure is like "ABCD12345E"
- first four character are letters,
- next five numerals and
- last character letter.
The first three letters represents the city name (eg, "LKN" for Lucknow , "ALD" for Allahabad. The fourth letter represents the initial letter of the deductor.
Application for acquiring Tax Deduction Account Number should be made in Form No. 49B to Tax Information Network Facilitation Center (TIN-FC) of NSDL. TAN can also be applied online through NSDL website. The link for making online application is as under:
Tracking Status of Application:
https://tin.tin.nsdl.com/tan/StatusTrack.html
Also the status of the TAN application can also be tracked by sending a text message (SMS) "NSDLTAN space 14 digit acknowledgement number" to 57575
After NSDL receives the TAN application along with required documents (either through TIN FC / Online), the details are verified and then forwarded to Income Tax Department. After that it is the Income Tax Department that issues a unique TAN/TCN.
ABCAUS Excel Auto Form 49B Download
ABCAUS Excel format Tax Deduction / Collection Account Number application is simplest and fully automated to save your time and energy.
The whole application has been divided into various sections so that only the applicable part can be filled. However the whole application can also be filled in one go if required. Userforms have been provided for each section.
These user forms have many inbuilt properties to safeguard any error, like it automatically convert text entered into uppercase, no space is required while filling forms, the text is automatically distributed into boxes in excel forms, inbuilt structure check has been provided for existing TAN or PAN.
