TDS on expenses by section
“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 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.
- FileTally expense ledgerCSV export · 43 rows
- FileVendor masterCSV export · 12 rows
- FileTDS section thresholdsCSV export · 3 rows
- StepTotal payments for FY 2025-26Step 1
- StepPrepare vendor matchStep 3
- StepPrepare section matchStep 2
- JoinAdd section threshold12 of 12 paired
- JoinAdd yearly payments12 of 12 paired
- StepCalculate TDS and label vendorsStep 6
- ResultVendor TDS Check12 rows · 5 flagged
- ScheduleRuns when you sayProposed
On the sample files, every step runs and the result has 12 rows.
- Download Tally expense ledger sample (43 rows)Tally: Display > Account Books > Ledger Voucher > F12 Configure > Export
- Download Vendor master sample (12 rows)Tally: Masters > Accounts Info. > Ledgers > Export
- Download TDS section thresholds sample (3 rows)Tally: Reference sheet maintained by accounts team for TDS review
What you get back
The result of that run, the rows to look at first.
| Vendor | Status | Payments in FY | TDS due | TDS deducted | TDS difference | Applied TDS rate (%) | Section threshold | Section | PAN |
|---|---|---|---|---|---|---|---|---|---|
| Blue Oak Consultants LLP | Not deducted | 65,000 | 6,500 | 0 | -6,500 | 10 | 50,000 | 194J | GHIFP6789E |
| Aditi Advisory Services | Short deducted | 70,000 | 7,000 | 2,000 | -5,000 | 10 | 50,000 | 194J | TUVPJ3456D |
| Orion Fabricators Pvt Ltd | Short deducted | 130,000 | 2,600 | 1,300 | -1,300 | 2 | 100,000 | 194C | WXYCP3456H |
| Lotus Legal Partners LLP | Short deducted | 80,000 | 16,000 | 8,000 | -8,000 | 20 | 50,000 | 194J | · |
| Priya Desai | Over deducted | 140,000 | 1,400 | 2,800 | 1,400 | 1 | 100,000 | 194C | ZABPP4567J |
| Ramesh Kumar | Agrees | 120,000 | 1,200 | 1,200 | 0 | 1 | 100,000 | 194C | ABCPK1234A |
| Saanvi Engineers Pvt Ltd | Agrees | 150,000 | 3,000 | 3,000 | 0 | 2 | 100,000 | 194C | PQRCP5678B |
| Nitin Steel Works | Agrees | 90,000 | 0 | 0 | 0 | 2 | 100,000 | 194C | LMNFQ2345C |
| Metro Media Ads | Agrees | 30,000 | 600 | 600 | 0 | 2 | 20,000 | 194H | KLMRF1234F |
| Green Leaf Promotions | Agrees | 15,000 | 0 | 0 | 0 | 2 | 20,000 | 194H | RSTUF2345G |
| Shakti Transport Co | Agrees | 110,000 | 22,000 | 22,000 | 0 | 20 | 100,000 | 194C | · |
| Zenith Tax Advisory | Agrees | 60,000 | 6,000 | 6,000 | 0 | 10 | 50,000 | 194J | CDEFF5678K |
How it works
How to use the Vendor TDS Check 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.
Vendor TDS Check: questions
How do you do a TDS applicability check by vendor?
What export should I use?
What happens to rows that do not match?
How do I change the 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
Schedules, commissions, costing and margins, worked out the same way from every new export.
- Pivot table from raw dataTurn a raw sales export into a pivot table of revenue by region and month.See the workflow Built by the agent
- Real estate commission splitWork out real estate commission on each closed sale and split it between the listing agent, buying agent and brokerage.See the workflow Built by the agent
- Loan amortization from statementsBuild a monthly loan amortization schedule from an Excel export, with interest, principal, and remaining balance for each loan.See the workflow Built by the agent
- Accrued expenses scheduleBuild an accrued expenses schedule from QuickBooks exports. Match purchase orders to vendor bills, calculate unbilled amounts, and flag items that need accrual.See the workflow Built by the agent
- RFM segmentsEvery customer scored 1-5 on recency, frequency and spend, with a segmentSee the workflow Template
- Sales velocityEach rep's open deals, win rate, deal size, sales cycle and velocity, and the team'sSee the workflow Template