Form-16 in Excel Format AY 2012-2013
- Thursday, April 5, 2012, 9:10
- Income Tax
- Featured, News
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
Related posts:
- ITR-I in Excel for A.Y. 2012-2013 + Form 16 with TDS Calculation
- Automated Form-16A for F.Y. 2011-2012 / A.Y. 2012-2013
- Income tax / TDS Calculator for AY 2013-14 / FY 2012-13
- Form 16 Excel Utility with Synopsis to fill Form 24Q
- Download Updated Form No. 49A in Excel Format
but now form 16a is to be developed from income tax site???
Profession Tax field not editible
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
i have admitted in pgdfqsf of ignou can i take rebate with my sons
professional tax and pf contribution cells are protected since you have put the password. we can not use this at all
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
there is no attachement to Download Automated Form-16 for Financial Year 2011-2012 and Assessment Year 2012-2013
brilliant auto generated form 16
NO DATA ENTERED IN DEDUCTORS DETAILS ( AS PER FORM 16 )
NAME OF DEDUCTOR
TAN NO OF DEDUCTOR
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 ?
Pls send to me TDS chart of current date
Sir,
If we give the office name and address it is not flowing in the Form 16 page.pls. check
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,
Visit this link to prepare form 16 for 50 Employees in one file http://taxguru.in/income-tax/form-16-preparation-excel-based-utility-alongwith-synopsis-fill-form-24q.html
we required form 16 format with formula
Hi pranab,
Can you shre the password for the file to be unlocked ?
Your tax utility is not calculating the tax . for example my income is 1303209 then your format calculate tax 182963 instead of 242963
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
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.
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