Match your TDS records against Form 26AS in minutes. Track deductions by section, identify mismatches, and keep compliance on track. Download a blank copy in Excel, Word, or PDF.
Enter TDS entries below and compare your books against Form 26AS. The live preview updates as you type.
Pick Excel, Word, or PDF. Each format has columns for deductee details, TDS section, amounts, and Form 26AS comparison.
Fill in each deductee's name, PAN, TDS section, amount paid, and TDS deducted from your accounting records.
Enter the corresponding TDS amount from Form 26AS for each deductee. Mismatches are flagged automatically.
Investigate every mismatch. File correction returns or deposit shortfalls before the quarterly due date.
Grab a blank template in the format that fits your workflow. Every version has the same column layout with fields pre-labeled.
Spreadsheet with formulas. Best for teams that reconcile TDS in Excel.
Pre-formatted document with tables. Best for sharing with auditors or management.
Print-ready layout. Best for filing records and compliance documentation.
Stop reconciling TDS manually across spreadsheets. Let automation match deductions, flag mismatches, and generate returns.
TDS reconciliation ensures that every rupee deducted at source is deposited to the government and correctly reflected in Form 26AS. The process runs quarterly, aligned with return filing deadlines.
Pull all TDS entries from your accounting system for the quarter: deductee name, PAN, section, amount paid, and TDS deducted.
Log into TRACES or the Income Tax portal and download Part A of Form 26AS for the same period. This shows what the government has on record.
Compare each deductee entry in your books against the 26AS record. Note differences in amount, section code, or challan details.
Common causes: late deposit, wrong PAN/TAN, incorrect section code, or missed entries. Trace each mismatch to its root cause.
Submit correction returns on TRACES for any errors. Deposit pending amounts with interest under section 201(1A) before the due date.
Most TDS compliance issues arise from delayed deposits, wrong PAN entries, or reconciliation done only at year-end. These practices prevent demand notices and credit mismatches.
TDS reconciliation is the process of matching the tax deducted at source recorded in your books against the amounts reflected in Form 26AS and the TDS returns filed on the TRACES portal. It ensures every deduction is deposited to the government and properly credited to the deductee's PAN.
Yes. There is no cost, no account creation, and no watermark on any format. The interactive tool runs entirely in your browser and the downloadable files are yours to keep and reuse.
Reconcile TDS quarterly, aligned with the TDS return filing deadlines (Q1: Jul 31, Q2: Oct 31, Q3: Jan 31, Q4: May 31). Monthly reconciliation is recommended for high-volume deductors to catch mismatches early.
Mismatches can result from incorrect PAN/TAN, wrong section codes, late deposits, or errors in the TDS return. Unresolved differences may lead to demand notices from the Income Tax department or the deductee being unable to claim credit.
The template supports all common sections including 194C (contractors), 194J (professional fees), 194H (commission), 194I (rent), 194A (interest other than securities), 192 (salary), and 195 (non-resident payments).
Yes. Use the deductor view to verify that all TDS you deducted has been deposited and reported correctly. Switch perspective to the deductee view to verify that TDS deducted on your income matches what appears in your Form 26AS.
Templates work for companies with a manageable number of deductees. Once you process hundreds of TDS entries per quarter, need automated challan matching, or want real-time Form 26AS sync, reconciliation software eliminates manual effort and reduces compliance risk.