How is the late-deposit interest calculated?

Under Section 201(1A), late deposit attracts 1.5% per month or part, from the date of deduction to the date of deposit. The register counts both the deduction month and the deposit month, as TRACES does, and computes the interest automatically.

Do I need a password to use it?

No. The sheets are protected so the formulas are not overwritten, but the input cells are open. Use Review then Unprotect Sheet only if you need to edit a locked cell.

Home › Downloads › Monthly TDS Challan Register

Monthly TDS Challan Register (Excel)

Q: When must TDS be deposited?

By the 7th of the next month for each deduction. TDS deducted in March is due by 30 April. The register fills the due date automatically from the date of deduction.

Format

Excel (.xlsx)

Updated

FY 2026-27

Cost

Free

In short

Log every TDS deduction against its deposit challan. The register auto-fills the due date, flags any late deposit, and computes the Section 201(1A) interest — so you deposit on time and never overpay interest.

⬇ Download Excel (.xlsx)

Who it's for

Deductors and accountants tracking monthly TDS payments
CA firms managing challans across clients
Anyone who has faced a 201(1A) interest or short-payment default

What's inside

A Challan Register — date deducted, section, TDS amount, then the deposit details (date, amount, BSR code, serial no)
Auto due date — 7th of the next month, and 30 April for March deductions
Auto status — On time / Late—interest due / Pending deposit
Auto Section 201(1A) interest — 1.5% per month or part, from deduction to deposit
Short/(excess) check against the amount deposited
A Monthly Summary — 12-month rollup of deducted, deposited, interest and pending items
Input cells open; formula cells locked & password-protected

How to use it

Enter each deduction: date deducted, section and TDS amount
The due date appears automatically
On deposit, fill the date, amount and challan details
Watch the status and interest columns; clear anything marked Pending before the due date
Use the Monthly Summary to see what is still to be deposited

FAQs

When must TDS be deposited?
By the 7th of the next month; March deductions by 30 April.

How is the interest worked out?
Section 201(1A): 1.5% per month or part, from the date of deduction to the date of deposit (both months counted, as TRACES does).

Password?
None needed — input cells are open; only the formulas are locked.

Free · verified 30 June 2026 against the Income-tax Act 2025 / FA 2025. General information, not professional advice.