26AS Reconciliation format

Can anyone help me with 26AS reconciliation in excel format?
Replies (5)
Quick Summary
This discussion provides a guide on how to reconcile your 26AS statement using Microsoft Excel. It outlines the process of logging into TRACES, downloading and extracting the 26AS text file, and then copying this data into Excel. The aim is to compare your invoice and TDS deduction records against the 26AS statement to ensure accuracy, noting that 26AS only reflects TDS filed by clients.

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
19 September 2026
Finance Manager

Mugdha Art Studio

Hyderabad

CA

View Details
Company
05 October 2026
Senior Accountant

Vision IT Peripherals Pvt Ltd

Mumbai

B.Com

View Details
Company
12 October 2026
Chartered Accountant - Internal Audit

HKC | Chartered Accountants & Business Advisors

Ludhiana

CA

View Details
Company
20 September 2026
Semi Qualified CA

Navin & Associates

Mumbai

CA Inter

View Details
Company
30 September 2026
Senior Accountant

Codeboard Technology

Chennai

B.Com

View Details
Company
Featured 03 October 2026
Accountant

A P Lodha and Associates

Jalna

B.Com

View Details
Company
Featured ARTICLESHIP 06 October 2026
Semi Qualified

AJAY SINGH AND CO LLP

Thane

CA Final

View Details
Company
17 September 2026
Chartered Accountant

Dass Gupta & Associates

Gurgaon

CA

View Details