Tax Withholding Category (TDS/TCS) in ERPNext
A Tax Withholding Category in ERPNext represents Tax Deducted at Source (TDS) or Tax Collected at Source (TCS) rules applied on supplier or customer transactions.
It ensures that tax is deducted or collected at the time of transaction and deposited to the government, instead of being paid later by the party.
Tax Withholding Categories automate statutory TDS/TCS compliance, threshold tracking, and tax deduction during financial transactions.
Access Path
You can access Tax Withholding Category in ERPNext at:
Home > Accounting > Taxes > Tax Withholding Category
1. Prerequisites
Before setting up Tax Withholding Category, ensure:
- Supplier master is created
- Customer master is created (for TCS use cases)
2. Creating a Tax Withholding Category
Follow these steps:
- Go to Tax Withholding Category list and click New.
- Enter a unique name (e.g., Section 194C Individual).
- Specify category type (e.g., Professional Fees, Dividends).
- Define tax rate for a specific Fiscal Year.
- Set single and cumulative threshold limits.
- Assign the company’s tax account for crediting TDS.
- Save the record.
3. Assigning to Supplier or Customer
After creation, the Tax Withholding Category can be assigned to:
- Supplier (for TDS)
- Customer (for TCS)
Once assigned, ERPNext automatically considers withholding rules during transactions.
4. How Threshold Works
Tax withholding is triggered based on threshold limits:
- Single Invoice Threshold: Applies when one invoice exceeds limit
- Cumulative Threshold: Applies when total invoices exceed limit
Example
- Rate: 5%
- Single threshold: ₹20,000
- Cumulative threshold: ₹30,000
If invoices collectively exceed thresholds, TDS is automatically applied even if a single invoice does not exceed the limit.
5. Using Tax Withholding in Purchase Invoice
When a supplier has a Tax Withholding Category:
- ERPNext shows “Apply Tax Withholding” option
- TDS is calculated automatically on submission
- GL entries are posted for tax deduction
6. TDS on Advances
Tax can also be deducted on advance payments:
- During Payment Entry (Pay Type)
- When applying withholding checkbox
- Adjusted later against invoices using FIFO allocation
7. TCS (Section 206C(1H)) Example
For eligible customers:
- Create TCS category
- Set cumulative threshold (e.g., ₹50 Lakhs)
- Assign to customer master
When threshold is exceeded, TCS is automatically calculated on sales invoices.
8. Advanced Options
8.1 Consider Entire Party Ledger Amount
Calculates threshold based on all transactions with party.
8.2 Only Deduct Tax on Excess Amount
Applies tax only on amount exceeding threshold.
8.3 Round Off Tax Amount
Rounds tax to nearest integer value.
9. Key Accounting Impact
On invoice submission:
- Expense/Revenue account is debited/credited
- Party account is updated
- TDS/TCS payable account is credited
10. Summary
Tax Withholding Categories in ERPNext automate TDS and TCS compliance by tracking thresholds, applying statutory rates, and generating accurate accounting entries during supplier and customer transactions.
