TDS Reconciliation
Books Data vs Form 26AS
0 matched
0 review
Standard Upload Format
Upload Books Data and Form 26AS using the standardized templates below. This avoids format errors from raw text, PDF, and unstructured Excel exports.
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.
Quarter values: use `Q1`, `Q2`, `Q3`, or `Q4`
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
Form 26AS
Upload format needs review
Matched Entries
| Party | PAN/TAN | Quarter | Books TDS | 26AS TDS | Variance |
|---|---|---|---|---|---|
| No matches yet. | |||||
Mismatches
| Reason | Party | PAN/TAN | Quarter | Books TDS | 26AS TDS | Likely cause | Action |
|---|---|---|---|---|---|---|---|
| No issues yet. | |||||||