CCI Online Learning
50% OFF in CA/CS/CMA Subjects

Share on Facebook

Share on Twitter

Share on LinkedIn

Share on Email

Share More

How to prepare form16a thru excel data

rajesh jain (profession)     20 August 2012

rajesh jain
 1 likes  66 points

| My Other Post


i am trying to prepare form 16A for number of deductees thru data store in excel sheets named 

as 1.deductor detail, 2.Challan detail, 3.Deductee detail

but unable to  prepare the form 16A

if anybody can help looking file and data in attached excel2007 file Surely I wil be obliged for the same.


Thanking You

Rajesh Jain. Kondagaon, Chattisgarh.

email id   rj68 @


Attached File : 136607 1040455 demo.xlsx downloaded: 181 times

Aditi Kaur (Practising CA)    21 August 2012

CCI Online Learning offers a library of courses for CA/CS/CMA Aspirants from the best faculties in India. Our top notch courses aim to make your journey from a student to a professional, a successful one. To promise a successful career as a professional CCI Online Learning also offers programs like Financial Modeling, MS Excel, IFRS/IND AS Certification Courses that will help you take your career to the next level. Check out the free demo videos here


CA SANDESH MAHIPAL (Practicing in GST and MSME )     24 August 2012

Practicing in GST and MSME  
 90 likes  1395 points

View Profile | My Other Post

Manully preparing of form 16A is some typical and lengthy process since each and every data will have to be found out and then type the same in the form.


You can download all the form 16A from

just login into your TAN and submit details of the quarter for which you want to download form 16A.

All form16A will be availabe to you within few seconds in PDF format.



CA Sunny Aggarwal

Tax Consultant

Leave a reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Related Threads


Popular Discussion

view more »

Trending Tags
GST Live Class    |    x