Menu
26AS Reconciliation format
Can anyone help me with 26AS reconciliation in excel format?
Replies (5)
Quick Summary
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 .
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
So do the reconciliation invoice wise
Recent Topics :
- Does Parag gupta's booster batch good for CA Inter
- Police Bandobost and GST Invoice
- Understanding where manual effort goes in audit wo
- Scanned purchase bills to Tally XML with GST check
- TDS applicability of foreign remittance to Oracle
- GSTR 9 LATE FEE
- Best Online Mock Test Series for CA Inter January
- COST OF IMPROVEMENT
- Pillows and Mattresses
- GST Applicability for Reg. / Un-Reg. Indian custom
Related Topics :
CAclubindia
