26AS reconciliation with books, party by party: FY 2025-26 with an AI agent

Short answer: Put the TDS receivable from Tally next to Form 26AS, customer by customer, and explain every difference: credits missing from 26AS, TDS you never booked, the wrong section or base, and bills that fall in next year's statement. Claim only entries with status F. Income in 26AS that isn't in your books needs an answer before you file. For FY 2025-26 the statement is still Form 26AS; from tax year 2026-27 it is Form 168.

The TDS receivable ledger and Form 26AS should agree, but at year end they rarely do. Each difference has its own fix: some need a journal, some need an email to the customer, and some only need to wait for next year's statement.

Here is the method from a recent tutorial, then an agent matching a year of TDS for a facility services company with nine customers. It found most of the gaps in its first reply and the rest when asked.

The tutorial this is based on

26AS Reconciliation Process Simple Steps by practical Base Accounting, published 18 September 2026 (in Hindi). Shows where to find 26AS, how to book TDS in Tally and how to match it by party. It works through a single sale, with the 26AS rows typed in by hand, and its example deducts 10%; the right rate depends on the section, so check each customer's. The matching is described rather than shown, so we added the steps.

How do you reconcile 26AS with the books?

  1. Download Form 26AS for the year: on the e-filing portal, e-File > Income Tax Returns > View Form 26AS, then export it.
  2. Export the TDS receivable from Tally: customer, invoice number and date, taxable value, GST, section and the TDS you booked. The video books TDS with a journal: Dr TDS Receivable, Cr the customer.
  3. Total both by customer (or by TAN), with the amount and the TDS, and put the difference next to each.
  4. For each customer with a difference, go down to the invoice: which entry is missing on which side, and which has a different amount.
  5. Give each difference a reason: the customer hasn't filed, you didn't book the TDS, a different section or rate, TDS on the value with GST, a bill that falls in next year's statement, or income in 26AS that isn't in your books. The video's rule: your books may show more income than 26AS, never less.
  6. Check the status of booking. Only F (final) entries give credit; U (unmatched), P (provisional) and O (overbooked) need the deductor to act.
  7. Walk from the books total to the 26AS total until the difference is zero. Then pass journals for what is yours to fix and write to customers about the rest.

Where it usually goes wrong

How an AI agent does it from Slack

We gave the agent two files for a made-up facility services company, Sarthi Facility Services, with nine customers: the TDS receivable working from Tally for FY 2025-26 (92 invoices) and Form 26AS (89 entries). 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 SlackMatch Sarthi Facility Services' TDS receivable in Tally against Form 26AS for FY 2025-26, party by party, and tell me what's missing or doesn't agree. Draft any emails to customers but don't send them, and don't post entries.
Slack request to match the TDS receivable in Tally against Form 26AS party by party, with two files
The request with the two files. It posted nothing and sent nothing.

What the agent did

  1. Matched 92 invoices in the books against 89 entries in 26AS by customer, wrote a workbook and five email drafts, and posted and sent nothing.
  2. Found Orbit Malls' Q4 missing from 26AS (₹14,388), Zenith's 194J deduction (₹11,592 more), Lotus deducting on the value with GST (₹780 more), Nirmal's TDS not booked (₹1,424) and ₹1,00,000 of income from Vedant with no invoice.
  3. Missed the status-U entry, showing Prime Auto as fully matched, and asked Harmony Towers to correct its return for a 31 March bill. It treated Vedant's ₹1,00,000 as an advance rather than asking whether a bill should be raised.
  4. When asked about the status column and the 31 March bill, it found the U entry (₹1,514), said ₹2,08,174 can be claimed now, said Harmony's bill is likely in next year's statement, and walked ₹2,08,938 to ₹2,09,688.
  5. It also said to claim Harmony's ₹658 next year. When asked again, it agreed the credit belongs to FY 2025-26 but pointed to section 155(14); the route for TDS deducted a year after the income was taxed is section 155(20), with Form 71 (Form 102 from 2026).
The agent's party-wise table of TDS in the books and in 26AS for nine customers
The party-wise table from its first reply. Prime Auto shows no difference, but one of its entries has status U; it found that only when asked.

What it found

What doesn't agree, books vs 26AS, after one follow-up
CustomerDifferenceWhat to do
Orbit MallsQ4 TDS ₹14,388 not in 26ASAsk them to file Q4 with your PAN
Zenith Pharma194J at 10%: ₹11,592 moreBook the extra TDS; tell them
Lotus RealtyTDS on GST too: ₹780 moreBook it; ask them to use the taxable value
Nirmal Hospitals₹1,424 deducted, not bookedDr TDS Receivable, Cr Nirmal
Vedant Warehousing₹1,00,000 income, no invoiceAsk; if it's yours, invoice it with GST
Prime Auto₹1,514 with status UAsk them to correct the challan
Harmony Towers31 March bill, ₹658Likely in next year's statement
The agent's findings: Zenith Pharma deducted under 194J at 10%, Lotus Realty deducted on the value with GST, and Nirmal Hospitals' TDS was never booked
194J instead of 194C, TDS on the value with GST, and TDS a customer deducted that the books left out.
The agent's draft email to Orbit Malls about the missing Q4 TDS credit
A draft for Orbit Malls, not sent. We cropped the To: line: the addresses in its drafts are made up, since the files have none.
John's follow-up about the status of booking, and the agent finding one entry with status U
Follow-up 1: one entry has status U, so ₹2,08,174 can be claimed now.
The agent explaining that Harmony Towers' 31 March invoice is likely in next year's statement
Follow-up 1: Harmony's 31 March bill is likely in next year's statement. It then said to claim that credit next year, which is wrong; see below.
The agent's walk from TDS in the books, ₹2,08,938, to TDS in 26AS, ₹2,09,688
The walk from the books to 26AS, opened in Slack's full-table view. It adds up.

What you still check

Questions accountants ask

Why doesn't my TDS receivable match 26AS?

Usually for one of a few reasons: a customer hasn't filed its TDS return or quoted the wrong PAN, you haven't booked TDS a customer deducted, the customer used a different section or rate or deducted on the value with GST, or the TDS falls in a different year. Match customer by customer and the reasons show up.

Can I claim TDS that has status U in 26AS?

No. U means the deductor's statement doesn't match its challan. Ask the deductor to correct it; the credit is given once the entry turns F.

Is it still called Form 26AS?

For FY 2025-26, yes. From tax year 2026-27, under the Income-tax Act 2025, the annual tax statement is Form 168.

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