Sunday, 20 November 2011

TAN Application Form 49B in Excel with Auto Fill Function.

All those persons who are required to deduct tax at source or collect tax at source on behalf of Income Tax Department are required to apply for and obtain TAN.
The provisions of section 203A of the Income-tax Act require all persons who deduct or collect tax at source to apply for the allotment of a TAN. The section also makes it mandatory for TAN to be quoted in all TDS/TCS returns, all TDS/TCS payment challans and all TDS/TCS certificates to be issued. Failure to apply for TAN or comply with any of the other provisions of the section attracts a penalty of Rs. 10,000/-.

Application for allotment of Tax Deduction and Collection Account Number under Section 203A of the Income Tax Act, 1961should be made in Form No. 49B. and submitted at any of the TIN Facilitation Centres.


The excel file will help in generating the form 49B, application for allotment of TAN, when the details are updated in Data sheet. The file contains two sheets "Data" sheet and "Form 49B" sheet. The details to be updated in "Data" sheet by selecting correct category of the applicant.


When the details are updated in the "Data" sheet the form will be generated automatically in the "Form 49B" sheet.


 Form for Application for allotment of TAN 49B in excel Click here to Download


2 comments:

  1. i Have gone through all auto fill format, but 49B IS NOT UPTO THE MARK , CORRECTION 49A , COUNTRY -(PLACE ) IS ABSENT, ABOVE ALL EVEYTHING IS GOOD, INFORMATION PERTAINING TO RECENT iT.ACT IS PERFECTLY CORRECT.

    ReplyDelete