ITC reversal for suppliers unpaid after 180 days
“show every purchase invoice with its payment status; say Agrees when it’s fully paid or still within 180 days, otherwise Reverse ITC, and show the unpaid balance and itc to reverse on the unpaid share”
Show every purchase invoice from Tally Purchase Register with its payment status from Tally Supplier Payments; say Agrees when it’s fully paid or still within 180 days, otherwise Reverse ITC, and show the unpaid balance and itc to reverse on the unpaid share.
What the agent built
4 steps, each one an ordinary Mammoth step you can open and change.
- FileTally Purchase RegisterCSV export · 30 rows
- FileTally Supplier PaymentsCSV export · 30 rows
- StepPrepare invoice matching keysStep 1
- StepTotal payments by invoiceStep 2
- JoinBring in payments29 of 30 paired
- StepWork out status and ITCStep 4
- ResultPurchase Invoice ITC Status30 rows
- ScheduleRuns when you sayProposed
Checked on the sample files: every step ran, 30 rows came out, and the join paired 29 of 30 rows.
- Download Tally Purchase Register sample (30 rows)Tally Prime: Purchase Register > Display > Excel
- Download Tally Supplier Payments sample (30 rows)Tally Prime: Accounting Vouchers > Payment Register > Export
What you get back
The result of that run, the rows to look at first.
| Supplier | Invoice number | Payment status | Unpaid balance | ITC to reverse | Invoice date | Taxable value | IGST | CGST | SGST | Invoice total | Paid amount |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Bharat Lab Supplies | BLS/NS/774 | Reverse ITC | 2,216 | 338.03 | 2026-02-25 | 61,200 | 0 | 5,508 | 5,508 | 72,216 | 70,000 |
| Chandra Packaging | CP/261 | Reverse ITC | 1,684 | 256.88 | 2026-03-04 | 43,800 | 0 | 3,942 | 3,942 | 51,684 | 50,000 |
| Aaradhya Office Systems | AOS/2425/118 | Agrees | 0 | 0 | 2026-02-12 | 84,500 | 15,210 | 0 | 0 | 99,710 | 100,000 |
| Delta Industrial Tools | DIT/0891 | Agrees | 0 | 0 | 2026-03-18 | 97,500 | 17,550 | 0 | 0 | 115,050 | 115,050 |
| Everest Safety Gear | ESG/4407 | Agrees | 0 | 0 | 2026-04-02 | 28,400 | 0 | 2,556 | 2,556 | 33,512 | 33,512 |
| Futura Electricals | FE/661 | Agrees | 0 | 0 | 2026-04-15 | 52,250 | 9,405 | 0 | 0 | 61,655 | 61,855 |
| Ganga Stationers | GS/1552 | Agrees | 0 | 0 | 2026-04-28 | 19,600 | 0 | 1,764 | 1,764 | 23,128 | 23,128 |
| Harita Components | HC/337 | Agrees | 0 | 0 | 2026-05-06 | 76,800 | 13,824 | 0 | 0 | 90,624 | 90,724 |
| Indus Fasteners | IF/908 | Agrees | 0 | 0 | 2026-05-19 | 33,150 | 0 | 2,983.50 | 2,983.50 | 39,117 | 39,117 |
| Jai Logistics Parts | JLP/204 | Agrees | 144 | 21.97 | 2026-05-29 | 40,800 | 7,344 | 0 | 0 | 48,144 | 48,000 |
| Aaradhya Office Systems | AOS/2425/147 | Agrees | 0 | 0 | 2026-06-03 | 15,700 | 2,826 | 0 | 0 | 18,526 | 28,260 |
| Bharat Lab Supplies | BLS/NS/811 | Agrees | 0 | 0 | 2026-06-14 | 49,950 | 0 | 4,495.50 | 4,495.50 | 58,941 | 59,441 |
How it works
How to use the Purchase Invoice ITC Status 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.
Purchase Invoice ITC Status: questions
How do you find purchase invoices with ITC to reverse after 180 days?
Which export from Tally should you use?
What happens to invoices that do not match any payment?
How do you change the rules in words?
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
Age what is open, and get the list of who to chase, sorted by how late it is.
- DPO by monthDays payable outstanding for every month, with bills received and what was unpaid at month endSee the workflow Template
- AR agingWhat each customer owes, split into 1-30, 31-60, 61-90 and over 90 days overdueSee the workflow Template
- DSO by monthDays sales outstanding for every month, with credit sales and what was owed at month endSee the workflow Template
- Inventory agingEach product's stock split by how long ago it arrived: 0-30, 31-60, 61-90 and over 90 daysSee the workflow Template
- AP agingWhat you owe each supplier, split by how overdue it isSee the workflow Template
- Bad debt reserve from agingCalculate each customer’s bad debt reserve from QuickBooks AR aging exports and loss rates for each bucket.See the workflow Built by the agent