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 .