banner_ad

26AS Reconciliation format

Others 3112 views 5 replies
Can anyone help me with 26AS reconciliation in excel format?
Replies (5)
1)Log in to Traces
2) Taxpayer need to need to open text file by giving password date of birth of deductee
in DD/ MM/ YY format .
3) Zip file will be downloaded
4) Extract the text file
5) Select the complete text and copy the data in to MS Excell .
Otherwise just check out on YouTube , detail videos are available .
Make list of invoices and Tds deduction and compare it with 26AS
Used Subtotal option in excel and then compare both sheet
First download 26as report from traces site. then check and compare 26 report and your deduction details each
26ASshows only tds sent by clients and if few have not done tds filing then it may not come to 26AS.

So do the reconciliation invoice wise


CCI Pro

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
26 May 2026
CA / MBA (Finance) / CMA / M.Com (Finance)

Sri Aurobindo Gnostic Centre of Education

New Delhi

CA

View Details
Company
24 May 2026
Accounts & Tax Executive

PARAS KHURANA AND CO

New Delhi

B.Com

View Details
Company
19 May 2026
Fundraising Expert

MentorsWorld Ventures Private Limited

Ahmedabad

Others

View Details
Company
ARTICLESHIP 31 May 2026
Article Assistant

KPRS And Associates

New Delhi

CA Inter

View Details
Company
19 May 2026
Accountant

ca kunjan

Mumbai

CA Inter

View Details
Company
29 May 2026
Accounts assistant

Shubh Consultancy

Mumbai

Graduate (Any)

View Details
Company
16 May 2026
Audit clerk

mgirt & co

Bengaluru

CA Inter

View Details
Company
23 May 2026
Account Executive

SMJ global advisors pvt ltd

New Delhi

B.Com

View Details