• Apr
  • 05
  • 2012

Form-16 in Excel Format AY 2012-2013

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

 

Sandeep Kanoi

68 Responses to “Form-16 in Excel Format AY 2012-2013”

  1. vijay says:

    Plz send me form 16 in excel for fy 2012 2013

  2. VARUNDEEP SINGH says:

    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

  3. Venkat says:

    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

  4. N.K.Patel says:

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

  5. GOBINATH says:

    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

  6. GOBINATH says:

    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

  7. vojay says:

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

  8. Arun says:

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

  9. Robert S says:

    How Do I correct my name on Form-16?

  10. VINAYAGAMOORTHI says:

    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.

  11. Pooja Rao says:

    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

  12. Ramesh Kumar says:

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

  13. Ramchandra bahuguna says:

    Form 6 application id is 2834637

  14. abhijeet ghase says:

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

  15. anku says:

    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.

  16. dhasarathan says:

    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

  17. suraj says:

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

  18. Banke bihari pandey says:

    Send me form 16 excel formet form fy 2012 -13

  19. PIYUSH VADHAR says:

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

  20. sushil mishra says:

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

  21. OM PRAKASH DAIYA says:

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

  22. sushil mishra says:

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

  23. K. MANOJ KUMAR says:

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

  24. mohd junaid ansari says:

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

  25. Binu V.N says:

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

  26. geetanjali says:

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

  27. Prabhakar says:

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

  28. JAINKAMAL says:

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

  29. RAJSHREE MUKUND says:

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

  30. ashu sharma says:

    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

  31. Manoj Patil says:

    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

  32. Haranadharao says:

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

  33. himanshu says:

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

  34. anand says:

    good one
    reduced lot of work

  35. rajendra singh says:

    please
    send me form 16 for excel formate 2012-13

  36. kalidass says:

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

  37. Naresh says:

    Dear Sir

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

  38. venkat says:

    Dear Sir ,

    You have done wonderful job and very kind of you

    Thanks & Regards

    venkat

  39. Gunasekaran V says:

    Dear Sir

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

    Thanks

  40. suchith says:

    Mr. pranab’

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

    Thanks for your excellency

  41. Sanjiv Jain says:

    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

  42. sameer says:

    i am accountant

  43. GRIFAN GILL says:

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

  44. Elumalai says:

    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

  45. Arpit says:

    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

  46. naresh says:

    some coloums are not changeble

  47. Pankaj Kuamr Singh says:

    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

  48. Pankaj Kuamr Singh says:

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

    Pankaj Kumar Singh
    Viraj Impex Pvt. Ltd

  49. Ramesh Gandhi says:

    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

  50. Pranab Banerjee says:

    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. 

  51. Tushar says:

    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 

  52. Umesh says:

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

  53. Amey Mulay says:

    Hi pranab,

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

  54. virender pal says:

    we required form 16 format with formula

  55. RAJEEV SINGH says:

    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,

  56. Narayanan R says:

    Sir,

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

  57. Ravi Shankar Chaubey says:

    Pls send to me TDS chart of current date

  58. Pranab Banerjee says:

    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 ?

  59. yogesh says:

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

  60. parvinder srao says:

    brilliant auto generated form 16

  61. S R SHUKLA says:

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

  62. Ramesh says:

    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

  63. jagdish says:

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

  64. farhat says:

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

  65. 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

  66. Hitesh says:

    Profession Tax field not editible

  67. ANMOL KHURANA says:

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

Leave a Reply

GET FREE TAX UPDATES VIA EMAIL