How to prepare form16a thru excel data

"HAPPY INDEPENDENCE DAY" 

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 @ in.com

Cell.9425243988,9993050409


Attached File : 136607 1040455 demo.xlsx downloaded: 258 times
Replies (1)

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.

Alternatively..

You can download all the form 16A from www.tin-nsdl.com

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.

 

Regards

CA Sunny Aggarwal

Tax Consultant

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
13 October 2026
Accountant

Zerdi & Co. Chartered Accountants

Pune

B.Com

View Details
Company
16 October 2026
CA article trainee

Zerdi & Co. Chartered Accountants

Pune

CA Inter

View Details
Company
19 October 2026
Accountants/Articles (Freshers/Experienced)

ADY & CO.

New Delhi

Graduate (Any)

View Details
Company
ARTICLESHIP 08 October 2026
ARTICLE TRAINEE

S.B.G. & CO. CHARTERED ACCOUNTANTS

New Delhi

CA Inter

View Details
Company
14 October 2026
GST & TDS ASSISTANT

AGGARWAL SANJAY & ASSOCIATES

New Delhi

B.Com

View Details
Company
ARTICLESHIP 30 September 2026
CA Article Assistant

CA Suraj Garg & Associates

New Delhi

CA Final

View Details
Company
ARTICLESHIP 07 October 2026
Article assistant

S.K.Bajpai & Co.

Noida

B.Com

View Details
Company
05 October 2026
Senior Accountant

Vision IT Peripherals Pvt Ltd

Mumbai

B.Com

View Details