Monthly TDS working and challan reconciliation, by hand and by an AI agent

Short answer: A monthly TDS working lists every payment liable to TDS, checks the PAN, deductee type, rate and yearly limit for each party, totals TDS by nature of payment, and matches it to the challans paid. Short deductions, short payments and late deposits carry interest. An AI agent can prepare the working and flag every exception for you.

TDS is small money with large consequences: a missed deduction or a challan paid a few days late becomes interest, and a wrong PAN becomes a default notice months later.

This walkthrough follows a recent TallyPrime tutorial on the full TDS cycle, then gives the month's working to an AI agent.

The tutorial this is based on

Complete TDS Working in Tally Prime 7.2 | Entry to Return Filing | Form 141 by FinBookPro by Vivek Awasthi with FinTaxPro, published 24 October 2026 (in Hindi). A long tutorial covering the whole cycle under the new Income-tax Act section codes. This post uses the working and the challan reconciliation.

How do you prepare the monthly TDS working?

  1. Make sure every party ledger has a PAN and the right deductee type. The fourth letter of the PAN tells you the type: P for an individual, C for a company, F for a firm.
  2. Verify PANs in bulk on the income-tax portal.
  3. For each expense, check the nature of payment, the rate and whether the party has crossed the yearly limit.
  4. At month-end, total TDS payable by nature of payment.
  5. Pay the challan, record it in Tally with the BSR code, challan serial number and date, and map it to the deductions.
  6. Work out interest for anything deducted late or deposited after the due date.

Where it usually goes wrong

How an AI agent does it from Slack

We gave the agent three files for a made-up contractor, Sahyog Infra Projects: October's expenses with TDS from Tally, the party master with PANs and amounts paid since April, and the challans paid in November. The files use the nature of payment rather than section numbers. Every company, name, tax number and amount in these files is made up. The agent works in Slack, where it shows up as Mnemio AI, because Accountant AI is built on Mnemio AI.

The message in SlackSahyog Infra: prepare the October TDS working from these Tally exports and match it to the challans we paid in November. Check PANs, rates and yearly limits, and tell me what's short and any interest. Don't change anything.
Slack request to prepare October's TDS working and match it to challans, with three Excel files attached, and the agent's summary of TDS deducted against challans paid
The request and the summary: TDS deducted against challans paid.

What the agent did

  1. Totalled TDS deducted in October by nature of payment and compared it with the two challans.
  2. Checked every PAN against the format and the deductee type in the master.
  3. Added the amounts paid since April to October's to check each party against the yearly limit.
  4. Worked out the shortfall for each exception and the interest on the late challan.
  5. Saved the working in a workbook, without changing anything in Tally.
  6. Its first reply quoted section numbers from the 1961 Act. When told the firm works under the Income-tax Act 2025, it redid the summary by party with no section numbers.
A follow-up in Slack asking for the summary without old section numbers, and the agent's table by party with nature of payment, TDS deducted, TDS due, shortfall, interest and the fix
A follow-up in the same chat: the summary by party, without the old Act's section numbers.

What it found

What the agent found in the October TDS working
ExceptionPartyAmount (₹)What to do
Challan short of TDS deductedChallan 004121,200.00Pay the difference
Yearly limit crossed, no TDS deductedPatel Shuttering Works1,500.00Deduct on the whole year's payments
No PAN, deducted at the normal rateOm Sai Tipper Services7,980.00Get the PAN, or deduct at the higher rate
PAN fails the format checkVastu Interiors17,424.00Get the correct PAN
Company set up as an individualArya Structural Consultants Pvt LtdFix the party master
Rent challan paid after the due dateChallan 00977180.00 interestPay the interest with the next challan

What you still check

Questions accountants ask

How is interest on late TDS payment worked out?

For tax deducted but deposited late, interest is charged per month or part of a month from the date of deduction to the date of payment, so even a few days late can count as a full extra month. Check the current rate for your case.

Can the agent verify PANs on the income-tax portal?

You sign in to the portal yourself, in the agent's browser window. It can then run the checks there. It asks before it submits anything.

Does it file the TDS return?

No. It prepares the working and the challan mapping for you to review. Filing stays with you.

Hand this job to an agent

Bring one of your own files to a 30-minute call and watch an agent do it.

Book a 30-min demo