26AS Reconciliation format
Manish M Nair (Student) (90 Points)
14 March 2022
Can anyone help me with 26AS reconciliation in excel format?
5 Replies
prasad Nilugal
( GST Practitioner & Accounts )
(14801 Points)
Replied 14 March 2022
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 .
Eswar Reddy S
(CFO- at NHTF)
(58270 Points)
Replied 14 March 2022
Make list of invoices and Tds deduction and compare it with 26AS
Mukesh Katara
(Account manager)
(533 Points)
Replied 21 March 2022
Used Subtotal option in excel and then compare both sheet
Nilesh
(Account Executive)
(85 Points)
Replied 03 April 2022
First download 26as report from traces site. then check and compare 26 report and your deduction details each
Eswar Reddy S
(CFO- at NHTF)
(58270 Points)
Replied 04 April 2022
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
- Relief for Delayed Filing of Tax Forms
- Expire stock
- INCOME TAX AY 25-26
- Experienced CA firm for accounting & auditing
- Regarding Perquisite Tax on ESOP - Unlisted Compan
- Casual Taxable Person under GST
- Extended Date of GSTR-1 for the month of July 2020
- NRO Interest - Taxed at source and in Foreign Coun
- Clarity needed on effective date
- Income Tax Refund Deadline Shortened to Five Years
Related Threads
CAclubindia
