Skip to content
Workflow · Age and chase · Opening soon

ITC reversal for suppliers unpaid after 180 days

Export the purchase register and supplier payments from Tally, then upload them into the workflow. It matches each invoice to payments, checks whether it is fully paid or still within 180 days, and flags the rest as Reverse ITC.

Early access opens shortly. Check back soon.

Someone typed

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

The agent read it as

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.

  1. File
    Tally Purchase Register
    CSV export · 30 rows
  2. File
    Tally Supplier Payments
    CSV export · 30 rows
  3. Step
    Prepare invoice matching keys
    Step 1
  4. Step
    Total payments by invoice
    Step 2
  5. Join
    Bring in payments
    29 of 30 paired
  6. Step
    Work out status and ITC
    Step 4
  7. Result
    Purchase Invoice ITC Status
    30 rows
  8. Schedule
    Runs when you say
    Proposed

Checked on the sample files: every step ran, 30 rows came out, and the join paired 29 of 30 rows.

What you get back

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

Purchase Invoice ITC StatusSample data30 rows
SupplierInvoice numberPayment statusUnpaid balanceITC to reverseInvoice dateTaxable valueIGSTCGSTSGSTInvoice totalPaid amount
Bharat Lab SuppliesBLS/NS/774Reverse ITC2,216338.032026-02-2561,20005,5085,50872,21670,000
Chandra PackagingCP/261Reverse ITC1,684256.882026-03-0443,80003,9423,94251,68450,000
Aaradhya Office SystemsAOS/2425/118Agrees002026-02-1284,50015,2100099,710100,000
Delta Industrial ToolsDIT/0891Agrees002026-03-1897,50017,55000115,050115,050
Everest Safety GearESG/4407Agrees002026-04-0228,40002,5562,55633,51233,512
Futura ElectricalsFE/661Agrees002026-04-1552,2509,4050061,65561,855
Ganga StationersGS/1552Agrees002026-04-2819,60001,7641,76423,12823,128
Harita ComponentsHC/337Agrees002026-05-0676,80013,8240090,62490,724
Indus FastenersIF/908Agrees002026-05-1933,15002,983.502,983.5039,11739,117
Jai Logistics PartsJLP/204Agrees14421.972026-05-2940,8007,3440048,14448,000
Aaradhya Office SystemsAOS/2425/147Agrees002026-06-0315,7002,8260018,52628,260
Bharat Lab SuppliesBLS/NS/811Agrees002026-06-1449,95004,495.504,495.5058,94159,441
30 rows in the result · 12 shown, problems first. Sample data: illustrative figures, not business results.

How it works

How to use the Purchase Invoice ITC Status 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.

Purchase Invoice ITC Status: questions

How do you find purchase invoices with ITC to reverse after 180 days?
Export the purchase register and supplier payments from Tally, then upload them into the workflow. It matches each invoice to payments, checks whether it is fully paid or still within 180 days, and flags the rest as Reverse ITC. You also get the unpaid balance and the ITC to reverse on that unpaid share.
Which export from Tally should you use?
Use the purchase register export for invoices and the supplier payments export for payments. The workflow needs both files so it can match each invoice to its payment history.
What happens to invoices that do not match any payment?
They stay unpaid in the result. If they are past 180 days, they are flagged for ITC reversal, and the unpaid balance is shown.
How do you change the rules in words?
Edit the rule text to change the payment check, the 180 day limit, or the ITC reversal condition. Then rerun the workflow on the same exported files.

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.