Skip to content
Workflow · Match two lists · Opening soon

AIS reconciliation with books

Export the AIS detail file from the Income Tax portal and the books ledger summary from Tally. The workflow totals each source by category and TAN or PAN, then compares the AIS and books amounts and TDS for FY 2025-26.

Early access opens shortly. Check back soon.

Someone typed

“compare the ais detail export with our tally books for fy 2025-26 by category and source tan/pan, show ais and books amount and tds plus status: matched, in ais not in books, in books not in ais, amount differs”

The agent read it as

compare the AIS detail export with our Tally books ledger summary for fy 2025-26 by category and source tan/pan, show ais and books amount and tds plus status: matched, in ais not in books, in books not in ais, amount differs

What the agent built

4 steps, each one an ordinary Mammoth step you can open and change.

  1. File
    AIS detail export
    CSV export · 30 rows
  2. File
    Tally books ledger summary
    CSV export · 28 rows
  3. Step
    Total AIS by category and source
    Step 1
  4. Step
    Total books by category and source
    Step 2
  5. Join
    Bring in books totals
    11 of 13 paired
  6. Step
    Show comparison and status
    Step 4
  7. Result
    AIS Books Reconciliation
    14 rows · 6 flagged
  8. Schedule
    Runs when you say
    Proposed

On the sample files, every step runs and the result has 14 rows.

What you get back

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

AIS Books ReconciliationSample data14 rows
8 matched3 amount differs2 in AIS not in books1 in books not in AIS
CategorySource TAN/PANAIS amountBooks amountAIS TDSBooks TDSStatus
Interest from depositCNRB12345F30,000·0·In AIS not in books
Interest from savings bankUTIB12345C2,000·0·In AIS not in books
Purchase of securities and units of mutual fundUPST12345M·2,800·0In books not in AIS
DividendINFY12345I7,5007,52000Amount differs
Interest from savings bankHDFC12345A5,1005,09500Amount differs
Purchase of securities and units of mutual fundZRBK12345K4,0007,00000Amount differs
DividendBELL12345J5,5005,50000Matched
DividendTMLD12345H24,00024,0002,4002,400Matched
Interest from depositICIC12345E80,00080,0008,0008,000Matched
Interest from depositYESB12345G35,00035,00000Matched
Interest from savings bankKKBK12345D95095000Matched
Interest from savings bankSBIN12345B2,4002,40000Matched
14 rows in the result · 12 shown, problems first. Sample data: illustrative figures, not business results.

How it works

How to use the AIS Books Reconciliation workflow

  1. 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and working on 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.

AIS Books Reconciliation: questions

How do you reconcile AIS with your books?
Export the AIS detail file from the Income Tax portal and the books ledger summary from Tally. The workflow totals each source by category and TAN or PAN, then compares the AIS and books amounts and TDS for FY 2025-26. It labels each row as matched, in AIS not in books, in books not in AIS, or amount differs when the amount or TDS is more than one rupee apart.
Which export should you use from the Income Tax portal?
Use the AIS detail export, since it has the category, source, TAN or PAN, amount, and TDS needed for the comparison.
What happens to rows that do not match?
Rows that do not find a matching source in the other file are marked in AIS not in books or in books not in AIS. Rows where the amount or TDS differs by more than one rupee are marked amount differs.
How do you change the reconciliation rules?
You change the rules in words by telling the workflow what to total, what fields to match on, and what counts as a match or difference. For example, you can change the threshold, the grouping fields, or the status labels.

Get early access to this workflow

It opens already built and working on sample files. Swap in your own exports to see your result.

Early access opens shortly. Check back soon.