• Apr
  • 05
  • 2012

Form-16 in Excel Format AY 2012-2013

Article ID 44086 | Posted In Income Tax | , | 69 Comments » Print Friendly and PDF

Download Automated Form-16 for Financial Year 2011-2012 and Assessment Year 2012-2013

This Excel utility is fully automated. Just put the data in Data input sheet and it will prepare the Form-16 automatically. User can also take printout of Form 16 prepared through this utility. Format if form 16 is latest and applicable from A.Y. 2012-13 and F.Y. 2011-12.

Download

Developed by– Pranab Banerjee

 


  • godbole ramesh upasrao

    plase send form 16 of financial year 2012-13

  • vijay

    Plz send me form 16 in excel for fy 2012 2013

  • VARUNDEEP SINGH

    Sir

    Please i want to know that in books of a firm there is partners account and as well as unsecured depositer accounts , the name of partner and depositer is same just like suresh kumar partner and suresh kumar huf as unsecured depositer, but a problem occured a cheque was trfd to huf a/c but it punched into partners a/c . and also final return has been filed (AY 13-14) , NOW CAN WE RECTIFY THESE ENTRIES , One problem is that unsecured depositer also avail the interest and partner also availed the intt

  • Venkat

    Hi Sir,

    can you please send me the form 16 for the year 2012- 2013 ASAP. Also i came to know that it is protected so can you please send me the unprotected form 16 with access to all the columns.

    Thanks,
    Venkat

  • N.K.Patel

    Dear Sir, Please send the automated Form 16 excel fomat FY 2013-14 & AY 2014-15

  • GOBINATH

    MANY COLUMNS PROVIDED BY YOU ARE DISABLED. SIR ONLY U CAN OPERATE. THANKS AND REGARDS FOR YOUR SOFTWARE,MOREOVER THIS SOFTWARE DO NOT MEET OUT MY REQUIREMENTS OF TAMILNADU GOVT TEACHERS FORM 16 IN EXCEL FORMAT
    THANKS SIR

  • GOBINATH

    Sir
    I wanted to have proper Form 16 in Excel format for our Tamil Nadu Govt Service Employees to be filed in for fy 2012-2013.
    Regards
    Gobinath

  • vojay

    Sent form16FY12-13 AY-14 in my mail mr.vijaydabral@gmail.com

  • Arun

    Dear Sir,
    Please send the automated Form 16 excel fomat FY 2012-13 & AY 2013-14

  • Robert S

    How Do I correct my name on Form-16?

  • VINAYAGAMOORTHI

    Sir,
    I missed my last year form 16 (2011-2012). But I need this form 16 for my bank loan purpose. How I get this form 16.

  • Pooja Rao

    In form 16 i should enter the period as date of joining to date of resignation of the employee or what????Pls guide on this matter

  • Ramesh Kumar

    Send me Form 16 in excel format for the FY 2012 – 2013
    Thanks

  • Ramchandra bahuguna

    Form 6 application id is 2834637

  • abhijeet ghase

    sir i wanted the form 16 for the year 2011-2012 so pl send it on my e mail id

  • anku

    Sir,
    As usual kindly upload an automated Form 16 for FY 2012-13 AY 2013-14 in excel format. I have to prepare TDS for more than 60 staff. Please Sir. Thank you.

  • dhasarathan

    sir, i am dhasarathan.i want a sample filled form16 an year on 2013-14, 2012-13. It was most urjent sir. My id dhasaa222@gmail.com.pls help me sir

  • suraj

    Dear Sir,
    Please send the automated Form 16 excel fomat FY 2012-13 & AY 2013-14

  • Banke bihari pandey

    Send me form 16 excel formet form fy 2012 -13

  • PIYUSH VADHAR

    Sir,
    Your form no 16 for financial year 2012-13 is chargeable ? Please send the detail of your form. Thanks.

  • sushil mishra

    Dear Sir,
    Please send the automated Form 16 excel fomat FY 2012-13 & AY 2013-14

  • OM PRAKASH DAIYA

    sir, Form no 16 exle financial year 2012-13 a.y 2013-14 send me

  • sushil mishra

    Dear Sir
    Send me Form 16 example for distribute of my rly employees in excel format for the FY 2012 – 2013
    Thanks

  • K. MANOJ KUMAR

    Hi, Sir send to New form 16 (2012-2013) in Excel

  • mohd junaid ansari

    Pls. Send me my. Form. 16 for current. Year

  • Binu V.N

    PLS send Form 16 F/Year 2012-13 A/YEAR 2013-14

  • geetanjali

    Dear Sir,
    Please send the automated Form 16 excel fomat FY 2012-13 & AY 2013-14

  • Prabhakar

    Please send Form 16 for excel format for F.Y.2010-11 & F.Y. 2011-12

  • JAINKAMAL

    PLS SEND FILLED SAMPLE FORMAT OF FORM 16 FOR THE FINANCIAL YEAR 2012-13 MY ID jain.kamal@email.com

  • RAJSHREE MUKUND

    PLS SEND FILLED SAMPLE FORMAT OF FORM 16 FOR THE FINANCIAL YEAR 2012-13 MY ID OS rajshreemukund@gmail.com

  • ashu sharma

    My name is ashu sharma please Send me New rules For TDs Deduction on my email iD it’s very urgent i m new HR executive in my company and company would start TDS deduction so please give me reply what should i do for deduct TDS From First step/.Email ADDRESS: ashus6601@gmail.com….. and please tel me TAN number is must ? for Tds deduction . and give me a right format to deduct TDS please Help me

  • http://www.taxguru.in Manoj Patil

    Dear sir Pls send filled sample format 2012-2013 of form no 16 with value.my mail id is manojapatil.10@gmail.com

    Regards
    Manoj Patil

  • Haranadharao

    Dear Sir,
    please send format of form 16 for A.y 2012-13

  • himanshu

    Please send Form 16 for excel format for F.Y.2010-11 & F.Y. 2011-12

  • anand

    good one
    reduced lot of work

  • rajendra singh

    please
    send me form 16 for excel formate 2012-13

  • kalidass

    Hum ko farm nammer kush sallo se nahi mila hai p farm post kar dijiy

  • Naresh

    Dear Sir

    Send me Form 16 in excel format for the FY 2012 – 2013
    Thanks
    Naresh

  • venkat

    Dear Sir ,

    You have done wonderful job and very kind of you

    Thanks & Regards

    venkat

  • Gunasekaran V

    Dear Sir

    Send me Form 16 in excel format for the FY 2011 – 2012

    Thanks

  • suchith

    Mr. pranab’

    It is an excellent form 16 generation in macros. good one.it is very clear about form 16.

    Thanks for your excellency

  • Sanjiv Jain

    Dear Pradeep

    In the form 16 made by you you have give deduction of education allowance fo rs 100 per month for two children i.e Rs 2400 a year , but I am not able to get any confirmation from any site for its applicability for the FY 11-12 and AY 12-13

    Please confirm can we avail the same for FY11-12

  • sameer

    i am accountant

  • GRIFAN GILL

    form 16 is very easy to calculate tax for all employees.Please send G,P.Fund deduction format in excel.

  • Elumalai

    Can you clarify:
    One of our Employee got his salary 23k * 8 months(upto), after he got 35 k *4
    How much tds i have to deduct from his salary (he is around 65 yrs).
    And also can you send sample form 16 certificate

    With Thanks & Regards
    7Hills
    Chennai

  • Arpit

    Sir,

    Your automated Form-16 format is good. In my Office FY Start from Mar to Feb.. Accordingly i want to change TDS details which is start from Mar. 11 to Feb. 12.

    Please change as above.

    Thanking you,

    Arpit Tak

  • naresh

    some coloums are not changeble

  • Pankaj Kuamr Singh

    Why we can’t modify figure of professional tax in Deduction under section 16 current value is Rs.1,000 we require to modify in Rs.2,500
    Same as above in Deduction under section 80c current value of GPF is 40,000 but we require it to modify as per applicable amount

    Pankaj Kumar Singh
    Viraj Impex Pvt Ltd

  • Pankaj Kuamr Singh

    please calcluate Leav Travel Allowence for empolyee. calculate HRA Allowence for Empolyee

    Pankaj Kumar Singh
    Viraj Impex Pvt. Ltd

  • Ramesh Gandhi

    Dear Pranb,

    Is it possible to have Form 16 A in Excell format instead of utility, i just edit any prepared form by changing data at that place and prepare for my requirement of issuing form to my customer whose tax i have deducted by editing this basic template.

    Hopeto get soon same. ramesh gandhi

  • Pranab Banerjee

    If have any discrepancy in this Automated Form 16, like as the P.Tax Column is unable to change as quoted Mr.Tushar, I hope in the unfortunately locked, sorry for this. 

  • Tushar

    Dear Pranab
    Why we can’t modify figure of professional tax in Deduction under section 16 current value is Rs.1,000 we require to modify in Rs.2,500
    Same as above in Deduction under section 80c current value of GPF  is 40,000 but we require it to modify as per applicable amount 

  • Umesh

    Your tax utility is not calculating the tax . for example my income is 1303209 then your format calculate tax 182963 instead of 242963

  • Amey Mulay

    Hi pranab,

    Can you shre the password for the file to be unlocked ?

  • virender pal

    we required form 16 format with formula

  • RAJEEV SINGH

    Resp. sir,
    may ne aapka formate dekha lekin usme ek asuvidha mejhe samajha me aati hai ki may isme kewal eka hi adami ka data filap kar sakata hu aap se nivedan rahega ki aap mujhe multiple employee ki filling kar shaku esha taraha ka data mujhae pradan kare. Thank you,

  • Narayanan R

    Sir,

    If we give the office name and address it is not flowing in the Form 16 page.pls. check

  • Ravi Shankar Chaubey

    Pls send to me TDS chart of current date

  • Pranab Banerjee

    To Mr.Ramesh, as you quoted about the Automated Form 16, for your kind information that , this Calculation prepared by me only for individual use not for any professional person. I have already got information from various corner that this Excel Utility has been utilized by the some person for their business purpose. Although the most of people are utilized their creation for business purpose. I have only the motive that this any of my Excel Utility share to all who are not in professional. Your comments about this Excel Utility is hurt to me. You have says that I have charged by this Form 16, But for your kind information that U have offered to me to purchase this Excel Utility as a Tax Consultant. If you are a Tax Consultant, then you are a professional and get some money from your client against this any Tax Preparation. Can U share your knowledge about Income Tax with free of cost ? I have no motive to wasting your time, if you have need this Excel Utility or not, this is your personal matter, I could not bound to use this. Also you are informed that many of Tax Consultant already requested this Excel Utility and I have already shared to them without any cost, plz don’t put any comments so any one can hurt to others. Thanks for your valuable comments ?

  • yogesh

    NO DATA ENTERED IN DEDUCTORS DETAILS ( AS PER FORM 16 )
    NAME OF DEDUCTOR
    TAN NO OF DEDUCTOR

  • parvinder srao

    brilliant auto generated form 16

  • S R SHUKLA

    there is no attachement to Download Automated Form-16 for Financial Year 2011-2012 and Assessment Year 2012-2013

  • Ramesh

    please don’t give business motive .  your form 16 some where not able to edit. while we called and as per your request we send mail where the problem we are facing? after that we received mail says that this is chargable? if you are charging you can show your rate also here itself,  you are wasting our time and how mr. Nitish also sent earlier

  • jagdish

    professional tax and pf contribution cells are protected since you have put the password. we can not use this at all

  • farhat

    i have admitted in pgdfqsf of ignou can i take rebate with my sons

  • Hitesh

    Profession Tax field not editible

  • ANMOL KHURANA

    but now form 16a is to be developed from income tax site???

    • http://www.taxguru.in Pranab Banerjee

      Sir, I is Pranab Banerjee from West Bengal.For your kind information that this Excel Utility is only Form-16 not in Form 16A as U mentioned.The Form-16 & Form 16A is different from each other.Another question by U the Form 16A will be change or not ? No any article by the Tax Expert or any Web Site or by the Tax Department given advance to any others. But U must know it by the Taxguru.in
      Pranab Banerjee