Sheet 1 — Monthly TDS Tracker (main dashboard)
A 12-month grid (April–March) tracking 9 TDS sections simultaneously:
| Row | What it shows |
|---|---|
| Section rows (192, 194A, 194C, 194H, 194I, 194J, 194Q, 194IB, Other) | Monthly TDS deducted — blue input cells with sample data |
| Total TDS Deducted | Auto-sum per month across all sections |
| Total TDS Deposited | Enter actual challan amounts — green input cells |
| Shortfall / Excess | Auto: Deducted minus Deposited |
| Days of Delay | Enter manually if paid after due date |
| Interest u/s 201(1A) | Auto: 1.5% × shortfall × months (min 1 month) |
| Monthly Status | Auto: COMPLIANT / LATE PAID / PENDING / NIL |
Annual summary panel below shows total deducted, deposited, shortfall, interest, and count of compliant/late/pending months.
Sheet 2 — Challan 281 Payment Log 50-row challan register capturing: month covered, challan date, bank name, BSR code, CIN, minor head code, salary TDS, other TDS, interest paid, fees, and auto-computed total per challan — with annual totals and minor head code reference guide.
Sheet 3 — Quarterly Summary Section-wise quarterly aggregation (Q1–Q4) auto-linked from Sheet 1, with annual totals, TDS return due dates (Form 24Q / 26Q), penalties under Sec 234E and 271H, and filing notes.
