Skip to content
Workflow · Calculate · Opening soon

TDS on expenses by section

Export your expense ledger and vendor master from Tally, then add the TDS section thresholds you want to use. Mammoth totals payments by vendor for the financial year, checks the section threshold, uses the vendor rate or 20% when PAN is blank, and compares that with TDS deducted.

Early access opens shortly. Check back soon.

Someone typed

“for every vendor, total my payments for the financial year; once the yearly total is above the section threshold, tds is due on the whole year total at the vendor's rate, or 20% when the pan is blank; compare it with the tds deducted and label each vendor agrees, not deducted, short deducted or over deducted, allowing one rupee”

The agent read it as

For every vendor, total my payments for the financial year; once the yearly total is above the section threshold, tds is due on the whole year total at the vendor's rate, or 20% when the pan is blank; compare it with the tds deducted and label each vendor agrees, not deducted, short deducted or over deducted, allowing one rupee, for FY 2025-26, using Tally expense ledger, Vendor master and TDS section thresholds.

What the agent built

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

  1. File
    Tally expense ledger
    CSV export · 43 rows
  2. File
    Vendor master
    CSV export · 12 rows
  3. File
    TDS section thresholds
    CSV export · 3 rows
  4. Step
    Total payments for FY 2025-26
    Step 1
  5. Step
    Prepare vendor match
    Step 3
  6. Step
    Prepare section match
    Step 2
  7. Join
    Add section threshold
    12 of 12 paired
  8. Join
    Add yearly payments
    12 of 12 paired
  9. Step
    Calculate TDS and label vendors
    Step 6
  10. Result
    Vendor TDS Check
    12 rows · 5 flagged
  11. Schedule
    Runs when you say
    Proposed

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

What you get back

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

Vendor TDS CheckSample data12 rows
7 agrees3 short deducted1 over deducted1 not deducted
VendorStatusPayments in FYTDS dueTDS deductedTDS differenceApplied TDS rate (%)Section thresholdSectionPAN
Blue Oak Consultants LLPNot deducted65,0006,5000-6,5001050,000194JGHIFP6789E
Aditi Advisory ServicesShort deducted70,0007,0002,000-5,0001050,000194JTUVPJ3456D
Orion Fabricators Pvt LtdShort deducted130,0002,6001,300-1,3002100,000194CWXYCP3456H
Lotus Legal Partners LLPShort deducted80,00016,0008,000-8,0002050,000194J·
Priya DesaiOver deducted140,0001,4002,8001,4001100,000194CZABPP4567J
Ramesh KumarAgrees120,0001,2001,20001100,000194CABCPK1234A
Saanvi Engineers Pvt LtdAgrees150,0003,0003,00002100,000194CPQRCP5678B
Nitin Steel WorksAgrees90,0000002100,000194CLMNFQ2345C
Metro Media AdsAgrees30,0006006000220,000194HKLMRF1234F
Green Leaf PromotionsAgrees15,000000220,000194HRSTUF2345G
Shakti Transport CoAgrees110,00022,00022,000020100,000194C·
Zenith Tax AdvisoryAgrees60,0006,0006,00001050,000194JCDEFF5678K
12 rows in the result. Sample data: illustrative figures, not business results.

How it works

How to use the Vendor TDS Check 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.

Vendor TDS Check: questions

How do you do a TDS applicability check by vendor?
Export your expense ledger and vendor master from Tally, then add the TDS section thresholds you want to use. Mammoth totals payments by vendor for the financial year, checks the section threshold, uses the vendor rate or 20% when PAN is blank, and compares that with TDS deducted. It then labels each vendor as agrees, not deducted, short deducted or over deducted, allowing for a one rupee difference.
What export should I use?
Use the exported expense ledger and vendor master from Tally. Add the TDS section threshold table you want to apply for the year.
What happens to rows that do not match?
Rows that do not match a vendor or section rule stay unmatched, so they do not get a final TDS label until you fix the missing or inconsistent values.
How do I change the rules?
Edit the rule words in the workflow, for example the financial year, the section threshold, the vendor rate, the PAN blank rule, or the one rupee allowance.

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.

Workflows like this

Schedules, commissions, costing and margins, worked out the same way from every new export.

All calculate workflows →