Form 26AS TDS reconciliation
“compare the tds my customers deducted in my books with the tds shown in form 26as for the year, by customer tan and section, and list tds missing from 26as, tds in 26as that is not in my books, and differences”
compare the tds my customers deducted in Tally TDS receivable ledger with the tds shown in TRACES Form 26AS Part A for the year, by customer tan and section, and list tds missing from 26as, tds in 26as that is not in my books, and differences, for FY 2025–26
What the agent built
4 steps, each one an ordinary Mammoth step you can open and change.
- FileTally TDS receivable ledgerCSV export · 31 rows
- FileTRACES Form 26AS Part ACSV export · 30 rows
- StepTotal book TDS by customer and sectionStep 2
- StepTotal 26AS TDS by customer and sectionStep 1
- JoinBring in 26AS totals14 of 16 paired
- StepCompare TDS totals and flag differencesStep 4
- ResultTDS Reconciliation17 rows · 4 flagged
- ScheduleRuns when you sayProposed
Checked on the sample files: every step ran, 17 rows came out, and the join paired 14 of 16 rows.
- Download Tally TDS receivable ledger sample (31 rows)Tally: Display > Account Books > Ledger > TDS Receivable > Export
- Download TRACES Form 26AS Part A sample (30 rows)TRACES: Form 26AS / Annual Tax Statement > Part A > Download / Export
What you get back
The result of that run, the rows to look at first.
| Customer | Customer TAN | Section | TDS in books | TDS in 26AS | Difference | Status |
|---|---|---|---|---|---|---|
| Bluepeak Retail Pvt Ltd | BLUP12345F | 194C | 1,800 | 0 | 1,800 | Missing in 26AS |
| Harborline Studios LLP | BLUH67890K | 194J | 3,600 | 0 | 3,600 | Missing in 26AS |
| Northstar Events LLP | MUMN54321D | 194H | 0 | 750 | -750 | Missing in books |
| Saffron Edge Media Pvt Ltd | MUMS11223A | 194J | 8,400 | 8,200 | 200 | Amount differs |
| Asterline Digital Pvt Ltd | MUMA12345F | 194J | 15,300 | 15,300 | 0 | Agrees |
| Delta Finserv Ltd | PAND34567Q | 194H | 980 | 980 | 0 | Agrees |
| Garnet Traders LLP | KOLG67890T | 194C | 3,120 | 3,120 | 0 | Agrees |
| Harborview Tech Pvt Ltd | HYDH78901U | 194J | 12,800 | 12,800 | 0 | Agrees |
| Indigo Healthcare Pvt Ltd | AHMI89012V | 194C | 4,340 | 4,340 | 0 | Agrees |
| Juniper Consulting LLP | PUNJ90123W | 194J | 9,500 | 9,500 | 0 | Agrees |
| Oakridge Services Pvt Ltd | HYDO11223Z | 194C | 4,000 | 4,000 | 0 | Agrees |
| Beacon Retail Chain Pvt Ltd | DELB54321K | 194C | 4,460 | 4,460 | 0 | Agrees |
How it works
How to use the TDS Reconciliation workflow
- 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and checked on the sample files.
- 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
- 3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.
TDS Reconciliation: questions
How do you do 26AS reconciliation?
Which export should you use for 26AS reconciliation?
What happens to rows that do not match?
How do you change the reconciliation rules?
Get early access to this workflow
It will open already built and checked on the sample files. Swap in your own exports and see your result.
Workflows like this
Bank to ledger, payouts to deposits, returns to books. Every row comes back matched, or flagged with the reason.
- Bank reconciliationEvery line matched, flagged for a date check, or missing from one sideSee the workflow Template
- Payment reconciliationEach payout matched to its bank deposit, flagged for a date check, or missingSee the workflow Template
- Match names to a master listEach record with its master name (and ID), and how it matchedSee the workflow Template
- Cash reconciliationEach day's takings matched to a bank deposit, or flagged as not bankedSee the workflow Template
- Match customer payments to open invoicesMatch bank payments to QuickBooks open invoices by customer and amount, and see what is still unapplied.See the workflow Built by the agent
- Compare two listsCompare two exported spreadsheet lists by email, see matches, and label rows where name and email agree or differ.See the workflow Built by the agent