26 as reconcilation

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.