LIVE GST Certification Course by CA Arun Chhajer begins 27th April. Register Now!!

Easy Office

26AS Reconciliation format

Manish M Nair (Student) (90 Points)

14 March 2022

Can anyone help me with 26AS reconciliation in excel format?

Reply
Follow
Share

5 Replies

prasad Nilugal ( GST Practitioner & Accounts ) (14165 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 .

1 Like

Eswar Reddy S (CFO- at NHTF) (58213 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) (83 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) (58213 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

Join CCI Pro

Recent Topics

More recent discussions | Post

Related Threads

Popular Discussion

Start a New Discussion

Easy Office

Trending Online Classes

Live class on Bonus & Gratuity(with recording)

Mr.Balamurugan Ranganathan

Enroll Now

25 April 2024
GST Live Certification Course (39th Batch) - April 2024 (Weekend Batch) (With Certificate)

CA Arun Chhajer

Enroll Now

21 April 2024
"Live class on Python for Financial Analysis: Unlocking Efficiency in Accounting and Finance"

CA Vishal Zawar

Enroll Now

01 May 2024

view all classess

CCI Pro

Subscribe to the latest topics :

Search Forum:

Forum Home

Popular Threads

Recent Posts

Unreplied Threads

Settings