Skip to content
Workflow · Match two lists · Opening soon

Form 26AS TDS reconciliation

Export your Tally TDS receivable ledger and your TRACES Form 26AS Part A for the year. The workflow totals TDS by customer and section, then compares the two files and flags rows that agree, rows with different amounts, rows missing in 26AS, and rows missing in your books.

Early access opens shortly. Check back soon.

Someone typed

“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”

The agent read it as

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.

  1. File
    Tally TDS receivable ledger
    CSV export · 31 rows
  2. File
    TRACES Form 26AS Part A
    CSV export · 30 rows
  3. Step
    Total book TDS by customer and section
    Step 2
  4. Step
    Total 26AS TDS by customer and section
    Step 1
  5. Join
    Bring in 26AS totals
    14 of 16 paired
  6. Step
    Compare TDS totals and flag differences
    Step 4
  7. Result
    TDS Reconciliation
    17 rows · 4 flagged
  8. Schedule
    Runs when you say
    Proposed

Checked on the sample files: every step ran, 17 rows came out, and the join paired 14 of 16 rows.

What you get back

The result of that run, the rows to look at first.

TDS ReconciliationSample data17 rows
13 agrees1 amount differs2 missing in 26AS1 missing in books
CustomerCustomer TANSectionTDS in booksTDS in 26ASDifferenceStatus
Bluepeak Retail Pvt LtdBLUP12345F194C1,80001,800Missing in 26AS
Harborline Studios LLPBLUH67890K194J3,60003,600Missing in 26AS
Northstar Events LLPMUMN54321D194H0750-750Missing in books
Saffron Edge Media Pvt LtdMUMS11223A194J8,4008,200200Amount differs
Asterline Digital Pvt LtdMUMA12345F194J15,30015,3000Agrees
Delta Finserv LtdPAND34567Q194H9809800Agrees
Garnet Traders LLPKOLG67890T194C3,1203,1200Agrees
Harborview Tech Pvt LtdHYDH78901U194J12,80012,8000Agrees
Indigo Healthcare Pvt LtdAHMI89012V194C4,3404,3400Agrees
Juniper Consulting LLPPUNJ90123W194J9,5009,5000Agrees
Oakridge Services Pvt LtdHYDO11223Z194C4,0004,0000Agrees
Beacon Retail Chain Pvt LtdDELB54321K194C4,4604,4600Agrees
17 rows in the result · 12 shown, problems first. Sample data: illustrative figures, not business results.

How it works

How to use the TDS Reconciliation workflow

  1. 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.
  2. 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
  3. 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?
Export your Tally TDS receivable ledger and your TRACES Form 26AS Part A for the year. The workflow totals TDS by customer and section, then compares the two files and flags rows that agree, rows with different amounts, rows missing in 26AS, and rows missing in your books.
Which export should you use for 26AS reconciliation?
Use the TRACES Form 26AS Part A export for the year, and your Tally TDS receivable ledger export for the same FY. Both files should include customer TAN, section, and TDS amount.
What happens to rows that do not match?
Rows that do not match are kept and flagged as differences. They can show as missing in 26AS, missing in your books, or amount differs.
How do you change the reconciliation rules?
Change the rules in words by telling the workflow what to group by, what fields to compare, and what counts as a match. For example, you can switch the grouping keys, add or remove a section, or compare at a different level of detail.

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.

Early access opens shortly. Check back soon.