AIS reconciliation with books
“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”
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.
- FileAIS detail exportCSV export · 30 rows
- FileTally books ledger summaryCSV export · 28 rows
- StepTotal AIS by category and sourceStep 1
- StepTotal books by category and sourceStep 2
- JoinBring in books totals11 of 13 paired
- StepShow comparison and statusStep 4
- ResultAIS Books Reconciliation14 rows · 6 flagged
- ScheduleRuns when you sayProposed
On the sample files, every step runs and the result has 14 rows.
- Download AIS detail export sample (30 rows)Income Tax portal: AIS > Download > Detailed Information Statement
- Download Tally books ledger summary sample (28 rows)Tally: Reports > Ledger Summary > Export
What you get back
The result of that run, the rows to look at first.
| Category | Source TAN/PAN | AIS amount | Books amount | AIS TDS | Books TDS | Status |
|---|---|---|---|---|---|---|
| Interest from deposit | CNRB12345F | 30,000 | · | 0 | · | In AIS not in books |
| Interest from savings bank | UTIB12345C | 2,000 | · | 0 | · | In AIS not in books |
| Purchase of securities and units of mutual fund | UPST12345M | · | 2,800 | · | 0 | In books not in AIS |
| Dividend | INFY12345I | 7,500 | 7,520 | 0 | 0 | Amount differs |
| Interest from savings bank | HDFC12345A | 5,100 | 5,095 | 0 | 0 | Amount differs |
| Purchase of securities and units of mutual fund | ZRBK12345K | 4,000 | 7,000 | 0 | 0 | Amount differs |
| Dividend | BELL12345J | 5,500 | 5,500 | 0 | 0 | Matched |
| Dividend | TMLD12345H | 24,000 | 24,000 | 2,400 | 2,400 | Matched |
| Interest from deposit | ICIC12345E | 80,000 | 80,000 | 8,000 | 8,000 | Matched |
| Interest from deposit | YESB12345G | 35,000 | 35,000 | 0 | 0 | Matched |
| Interest from savings bank | KKBK12345D | 950 | 950 | 0 | 0 | Matched |
| Interest from savings bank | SBIN12345B | 2,400 | 2,400 | 0 | 0 | Matched |
How it works
How to use the AIS Books Reconciliation workflow
- 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and working on 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.
AIS Books Reconciliation: questions
How do you reconcile AIS with your books?
Which export should you use from the Income Tax portal?
What happens to rows that do not match?
How do you change the reconciliation rules?
Get early access to this workflow
It opens already built and working on sample files. Swap in your own exports to 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