TDS Reconciliation - Books vs Form 26AS

Standard Upload Format

Upload Books Data and Form 26AS using the standardized templates below. Reconcile either quarter-wise or party-wise yearly, including partial matches where credit exists but the yearly or quarter value differs.

Books Data columns: `Party`, `PAN`, `Quarter`, `TDS Amount`, `Expense Amount`

26AS columns: `Deductor`, `TAN/PAN`, `Quarter`, `TDS Amount`, `Income Amount`

Supplier PAN: collect PAN details from the client before reconciliation; books entries without PAN will be flagged for review.

Period values: use `Q1`, `Q2`, `Q3`, `Q4`, or `Yearly`; yearly mode will combine all quarter rows party-wise

Amounts: keep only number values like `5000` or `5000.50`

Template rows: keep the header row unchanged and enter data below it

One sheet only: keep the reconciliation data in the first worksheet if using Excel

Books Data

Choose standardized Excel or CSV

Form 26AS

Choose standardized Excel or CSV

Basis Quarter-wise Party-wise yearly

Variance

Upload format needs review

Matched Entries

Party	PAN/TAN	Period	Books TDS	26AS TDS	Variance
No matches yet.

Partial Matches

Reason	Party	PAN/TAN	Period	Books TDS	26AS TDS	Variance	Action
No partial matches yet.

Mismatches

Reason	Party	PAN/TAN	Period	Books TDS	26AS TDS	Likely cause	Action
No issues yet.