26 as reconcilation

9711 views 5 replies

Hi, i recently joined a shipping company as accounts executive, and now we are going on with scrutiny for A.Y 2011-12. Now my management asks me to prepare for 26 AS reconcilation.

I am having 26 AS in excel format and having tally, actually our company used to pass the tds entry in tally whenever the debtor gives information of deducting TDS( no TDS certificates are issued by them), and in the end of the year depending upon the amount of tds deducted by debtors in 26 AS, our accountant passed entry for remaining amount by crediting the debtor.

Now due to scrutiny my management asks me to go on with 26AS reconcilation.

I am totally confused with what to do? So please guide me.

Replies (5)

You have two bases for reconciliation for now.

1) Your tally data- TDS receivable

2) Form 26 AS

Now, you can check party wise total TDS. If any difference then demand Form 16A from that party.

check the partywise ledger and ascertain how much amounts is recorded as TDS in one party account and compare it with 26as amount.record the difference and reverse as the case may be.In 26as the data is given vendor wise so you can easily compare it.

Prepare 26AS reconciliation in excel sheet.

1st column - name of the party

2nd column - bill raised amount

3rd column - tds deducted by party

4th column - as per 26AS

5th column - differences

6th column - remarks

pls share any excel formate

26 as is the document of tds deducted by the party during the payment made by them. we can find  the amount in tds receivable ledger.  

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
19 June 2026
Accounts Executive

Getfive Advisors Pvt. Ltd.

Ahmedabad

CA Inter

View Details
Company
ARTICLESHIP 30 June 2026
Article Assistant or Paid Assistant

VIKAS VERMA & CO

New Delhi

Others

View Details
Company
ARTICLESHIP 07 July 2026
Articleship

Jawahar and Associates Chartered Accountants

Hyderabad

CA Inter

View Details
Company
29 June 2026
Accountant (Finance & Compliance)

TRIEYEZ

Kolkata

CA

View Details
Company
ARTICLESHIP 27 June 2026
CA Articled Trainee And Paid Assistant

SKAA & Associates

New Delhi

CA Inter

View Details
Company
ARTICLESHIP 28 June 2026
Article Assistant

Sharma Chetan And Company

Gurgaon

CA Inter

View Details
Company
ARTICLESHIP 24 June 2026
ARTICLE ASSISTANT

BHUPINDER SHAH AND COMPANY

New Delhi

CA Inter

View Details
Company
ARTICLESHIP 24 June 2026
CA Article Trainee

Rahul Dang & Associates

Pune

CA Inter

View Details