| Sheet | What it does |
|---|---|
| Dashboard | Auto-populated KPI cards (total TDS books vs 26AS, net difference, matched/mismatched/under-review counts), quarter-wise reconciliation summary (Q1βQ4 + annual), and section-wise TDS comparison (194C/J/A/H/I/Q) |
| Books Register | Enter all TDS deductions from your accounting system β challan ref, deductee name, PAN, quarter, section, amount, BSR code |
| 26AS Data | Paste downloaded Form 26AS / AIS data from TRACES portal β structured to match Books Register columns for formula-driven comparison |
| Reconciliation | Transaction-level matching table β Difference column auto-calculates (Books β 26AS), rows auto-highlight green (matched) or red/orange (mismatch), Status auto-labels: Matched / Mismatch / Missing in Books / Missing in 26AS |
| Deductee-wise Recon | Annual aggregated view per vendor using SUMPRODUCT β no manual entry needed; shows which deductees have persistent differences |
| Difference Analysis | Root cause documentation for every open item β PAN mismatch, challan error, timing difference, short deduction, AY mismatch; includes reference guide of 8 common causes |
| Form 16A Register | Tracks certificate issuance per deductee per quarter with issue date vs due date, days early/late, and TRACES generation status |
| Instructions | 7-step reconciliation process flow + key statutory notes (Sec 200A, 154, 272A, 276B, TRACES portal link) |
Colour coding: green rows = matched, orange/red = investigate, blue text = user inputs, black = formulas throughout.