26AS Reconciliation format

3149 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

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
06 July 2026
Chartered Accountant (Indirect Taxation)

Gowra Ventures Pvt Ltd

Hyderabad

CA

View Details
Company
29 June 2026
ACCOUNTANT

SANDEEP AASHISH & CO

Araria

B.Com

View Details
Company
Featured 15 June 2026
Senior Auditor

N. Dhawan & Co

New Delhi

CA Inter

View Details
Company
ARTICLESHIP 07 July 2026
Articleship

Jawahar and Associates Chartered Accountants

Hyderabad

CA Inter

View Details
Company
22 June 2026
Accountant

Global Image Technologies Private Limited

New Delhi

MBA

View Details
Company
24 June 2026
Chartered Accountant

CA Darshita Shah & Co

Nadiad

CA

View Details
Company
12 June 2026
Accounts & Taxation Executive

Winshine Financial Services

Mumbai

CA Inter

View Details
Company
Featured 24 June 2026
HEAD - AUDIT AND TAXATION

A R JADHAV AND ASSOCIATES

Mumbai

CA Inter

View Details