Account TDS Deduction

Account TDS Deduction allows businesses using Odoo to deduct TDS (Tax Deducted at Source) directly on vendor bills and payments. The module addresses the need for tracking TDS thresholds against specific expense accounts and alerting accounting staff when a bill, either individually or in aggregate, crosses the configured limit. This helps accounting teams apply TDS deduction rules consistently without manually tracking vendor-wise transaction totals outside the system.

Key Features

• Setup TDS deduction control at the Chart of Accounts level.
• Set a threshold for both individual and aggregated transactions to trigger alerts on the Bill page.
• Configure more than one TDS setup for each expense account, if required.
• Reusable alert mechanism that displays a summary of the amount at the time of posting.
• Set a Start Date and End Date in Accounting Settings for calculating TDS amounts for a specific period.
• Automatic alert and TDS summary logging in the Chatter when a bill's individual or aggregated sum exceeds the configured threshold.
• TDS Entry creation option available on the Bill after confirmation, shown by default via a TDS button.
• TDS Entry creation option available on the Payment after confirmation, shown by default via a TDS button.
• Automatic reconciliation of the TDS entry with the related Bill once the TDS entry is created and confirmed from the Bill page.

How It Works

After installing the Account TDS Deduction module, new fields are added to the Accounting Settings, where users provide the TDS journal, TDS withholding account, Start Date, and End Date. TDS Configuration records and TDS Slabs are created and managed under Accounting -> Configuration -> TDS Configuration. The relevant tax is then created in the Tax master and linked to the corresponding TDS Slabs, with the percentage entered as a negative value in the Tax master.

A new field, PAN Card No, is added to the vendor master. This field is used to calculate the aggregated transaction amount across all vendors who share the same PAN number, supporting TDS deduction on an aggregated basis.

Within the Chart of Accounts, the relevant account is opened and the TDS setup is applied for accounts where TDS deduction is required. When a bill is created and an account with a linked TDS configuration is selected at the line level, confirming the bill triggers an alert if the configured threshold is exceeded. At the same time, a message is logged in the Chatter indicating which TDS was applied, the configuration used for individual and aggregated thresholds, and the aggregated total amount calculated at the vendor PAN level.

Business Use Cases

Businesses that need to apply TDS deduction on vendor bills and payments can use this module to set up thresholds directly on relevant expense accounts, rather than tracking limits manually. Companies working with multiple TDS slabs for different expense categories can configure separate TDS setups for each expense account as needed.

Organizations dealing with vendors who may have multiple vendor records but share a single PAN number can rely on the PAN-based aggregation to ensure that TDS thresholds are evaluated across all related transactions, not just a single vendor record. Accounting teams that need to calculate TDS for a defined financial period can use the Start Date and End Date settings to keep TDS calculations aligned with that period. The Chatter logging of TDS summaries also gives accounting staff a traceable record of which TDS configuration and threshold applied to a given bill.

Frequently Asked Questions

Does this module support TDS deduction on both bills and payments?
Yes, the module provides a TDS Entry creation option on both the Bill and the Payment after they are confirmed.

How are TDS thresholds configured?
Thresholds for individual and aggregated transactions are set as part of the TDS setup on the Chart of Accounts, with configuration completed through TDS Configuration records and TDS Slabs.

How is the aggregated TDS amount calculated across multiple vendor records?
The module uses a PAN Card No field added to the vendor master to calculate the aggregated amount across all vendors sharing the same PAN number.

Does the TDS entry reconcile automatically with the bill?
Yes, once a TDS entry is created and confirmed from the Bill page, it reconciles automatically with the related bill.

Is there a record of which TDS configuration was applied to a bill?
Yes, when a bill is posted and the threshold is exceeded, a message is logged in the Chatter noting the applied TDS configuration and the aggregated total by vendor PAN.