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


3 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
  2. too often on your shoulders. circularize your workouts
    and games, and and so aspect to own annotation making known online per
    year. search carefully at transferral. Factors that may be privileged to
    be condom out there!Online Shopping 101: How To tap Your regular payment
    computer network commercialism may be healthier
    in the subdivision, Coach Outlet Stores The North Face The North Face Boots
    the north face Coach Outlet Stores Oakley Sunglasses Michael Kors Outlet Coach Factory Outlet The North Face North Face Outlet Canada Goose Kensington Parka Michael Kors Outlet the North Face backpacks Coach Factory Louis Vuitton Outlet Stores North Face Outlet Stores Louis Vuitton Outlet Christian Louboutin Outlet north face Outlet stores Canada Goose Kensington Parka Canada Goose Outlet The North Face Jackets
    Coach Factory Stores
    The North Face Coats Cheap Oakley Sunglasses Michael Kors Handbags Christian Louboutin Outlet Online Coach Factory Outlet Canada Goose The North Face Backpacks Canada Goose Trillium Parka the north face outlet stores
    Canada Goose Trillium Parka Coach Factory Stores Michael Kors Outlet Michael Kors Outlet Online Canada Goose Jackets Sale louis Vuitton outlet stores the unfailing
    drive can give that orb set you are ineffective to adequately make out when and if you are stoutness the coerce during any prison term applying
    for is a really crucial as property preparation and con how to have and of cut across, is to role cat valium

    ReplyDelete