Convert any client's Tally TDS ledger into an RPU-ready Form 26Q workbook in under a minute — with deductee-wise PAN auto-fill, pending challan alerts and Section 201(1A) interest flags.
Step 1 · Quarter & Deductor Details
These appear on every output sheet and on the challan-281 summary.
Step 2 · Upload Tally TDS Ledger Excel Required
Tally path → Gateway → Display → Account Books → Group → Duties & Taxes → select each TDS ledger (TDS @ 194J, TDS on Contract 194C, TDS on Lease Rent, etc.) → Export as Excel. One Excel file with all TDS ledgers (one per sheet, or stacked) is ideal.
Step 3 · Upload Previous 26Q Optional
Upload the previous quarter's or last year's Form 26Q — Excel (.xlsx), Word (.docx), CSV or RPU (.txt) all work. We read every deductee row and auto-fill PAN, deductee status (Co / Ind / HUF) and section for every repeat vendor in the current ledger. Vendors not found will be flagged as "new vendor — confirm PAN" (without PAN, the engine applies 20% under Section 206AA).
Optional helpers
Review & Categorise
Each deductee row is auto-mapped to a section + rate. Edit any cell inline. PAN auto-filled from previous 26Q where matched.
One branded Excel with 5 sheets — 26Q Summary, Annexure I (Challans), Annexure II (Deductees), Pending Challan-281 and Dates to Confirm. Annexure II copy-pastes directly into the NSDL RPU utility.
Quarter
—
Deductor
—
TAN
—
Filing checklist
Pay any pending challan from Income Tax e-Pay Tax portal → Challan ITNS-281. Use the section-wise totals from the Pending Challan-281 sheet.
Open NSDL RPU utility → create / open Form 26Q for the quarter.
Paste Annexure I (Challans) into the Challan tab — one row per BSR + date.
Paste Annexure II (Deductees) into the Deductee tab — one row per deduction.
Validate via FVU and upload at incometax.gov.in → e-File → TDS → Upload TDS.
How this works
Export from Tally: Gateway → Display → Account Books → Group → Duties & Taxes → pick each TDS ledger → Alt+E to export Excel. Either export each ledger to its own sheet of one workbook, or paste them stacked in one sheet — we auto-detect.
Section detection: ledger names are matched to sections by keyword: "contract" → 194C, "professional / technical / consultancy / royalty" → 194J, "interest" → 194A, "rent · plant" → 194I-a, "rent" → 194I-b, "purchase of goods" → 194Q, "commission / brokerage" → 194H, "salary" → 192. Override any row inline.
Reconciliation: Opening Bal + Period Deductions − Challan Payments = Closing Bal. We compare against Tally's own closing figure on the bottom of the ledger; any mismatch is flagged.
Pending challan + interest: any TDS deducted but not deposited is highlighted; Section 201(1A) interest is computed @ 1.5% per month (part-month counts as a full month) from deduction date to today.
Section 206AA: deductees without PAN auto-tagged at 20% rate.
Previous 26Q in Word (.docx): upload the same kit you submitted last quarter — every <table> in the document is scanned, the row containing "PAN" becomes the header, and Name + PAN + Status + Section get cached for auto-fill. Free-text 26Q docs (no tables) are also handled by PAN-regex line scan.
Educational dates: if your Tally is in Education Mode (only 1, 2 or 31 of each month allowed), every "Educational" date row is captured in the Dates to Confirm sheet so you can fill the real date before submitting.
Filing calendar
Quarter
Period
TDS deposit due
26Q filing due
Q1
1 Apr – 30 Jun
7 Jul
31 Jul
Q2
1 Jul – 30 Sep
7 Oct
31 Oct
Q3
1 Oct – 31 Dec
7 Jan
31 Jan
Q4
1 Jan – 31 Mar
30 Apr
31 May
Late filing fee: ₹200 / day under Section 234E (capped at TDS amount).
Late deposit interest: 1.5% / month under Section 201(1A).
Disallowance: 30% of expense under Section 40(a)(ia) if TDS not deposited by ITR due date.