TDS Reconciliation Sheet

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 […]

πŸ”„ Published Jul 2026

Trusted by 6,00,000+ CA professionals across India

⬇ Available Downloads

Excel Format (Editable) πŸ”’

XLSX Pro 28 KB ✏️ Editable
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.

Get Unlimited Access with Pro Membership

Download unlimited formats, get editable files, and access premium CA resources.

  • Unlimited downloads
  • Editable Word / Excel formats
  • Premium CA toolkit access
  • GST / ROC / Audit templates
  • Priority format updates
  • AI drafting tools (coming soon)
β‚Ή99
per month
β‚Ή1,499
lifetime
πŸ‘‘ Upgrade to Pro

What is Included in This Format?

This format includes a professionally structured template ready for immediate use. Fields are clearly labeled for easy customization.

Disclaimer: This format is provided for general information only. Please review applicable laws and professional requirements before use.