TDS calculation on purchase and payment transactions

TDS can be deducted on expenses (GL Account) transactions. TDS can be deducted on purchase order, invoice received from vendor or advance payment made to vendor. TDS calculations can be done on following document types:

  • Purchase Order
  • Purchase Invoice
  • General Journal
  • Purchase Journal

The examples use illustrative rates, concessional rates, and exchange rates. They aren't guidance on current tax law. Use the rates and rounding setup that apply to your transactions.

These examples focus on expense accounts. For purchases of goods under section 194Q, see TDS calculation and transactions as per section 194Q.

Mandatory fields for TDS calculation on general journal, purchase journal, purchase invoice, purchase order

  • Create General Journal or Purchase Journal

    1. Select Search (Alt+Q) in the upper-right corner Enter General Journal or Purchase Journal, and then choose the related link.
    2. Select Vendor in Account Type and select relevant vendor code in Account No. field. Select G/L Account in Bal. Account Type and select relevant expense account in Bal. Account No. field.
    3. Select relevant TDS Section on journal line. Location Code and T.A.N No. fields shouldn't be blank.
  • Create Purchase Invoice or Purchase Order

    1. Select Search (Alt+Q) in the upper-right corner Enter Purchase Invoice or Purchase Order, and then choose the related link.
    2. Select Vendor, Location Code on Purchase Order or Purchase Invoice header
    3. Select G/L Account on Purchase Order or Purchase Invoice line.
    4. TDS Section, Location Code, and T.A.N No. fields shouldn't be blank.

TDS to be calculated on vendor invoice (through general journal, purchase journal, purchase invoice, or purchase order)

In the given scenario, vendor has issued an invoice for INR 50,000 on which 2% TDS is applicable under TDS Section 194C.

  • In this case TDS calculation is as following:

    ComponentValue
    TDS Base Amount50000
    TDS Amount1000 (50000*2%)
  • On posting of invoice, GL Entries are as following:

    ParticularsAmount
    Expense Account50000
    TDS Payable Account-1000
    Vendor Account-49000

TDS to be calculated on vendor advance payment (through general journal or payment journal)

In the given scenario, advance payment made to vendor for INR 50,000 on which 2% TDS is applicable under TDS Section 194C.

  • In this case TDS calculation is as following:

    ComponentValue
    TDS Base Amount50000
    TDS Amount1000 (50000*2%)
  • On posting of advance payment, GL Entries are as following:

    ParticularsAmount
    Vendor Account50000
    TDS Payable Account-1000
    Bank Account-49000

On receiving the invoice from the vendor, TDS is calculated on the differential amount. Suppose the vendor sends an invoice for INR 120,000. Because TDS was already calculated on the advance payment, the remaining taxable amount is INR 70,000 (120,000 - 50,000).

Note

Advance payment needs to be applied with the invoice before posting. Otherwise TDS is calculated on the whole invoice amount.

TDS to be calculated on nonresident vendor invoice in foreign currency

In the given scenario, vendor issued an invoice for USD 10,000 on which 2% TDS is applicable under TDS Section 195. All USD amounts get converted into INR based on currency exchange rates. For this example, exchange rate has been considered as USD 1 = INR 65.

  • In this case TDS calculation is as following:

    ComponentValue
    TDS Base AmountUSD 10,000 or INR 650,000
    TDS AmountINR 13,000 (INR 650000*2%)
  • On posting invoice, GL Entries are as following:

    ParticularsAmount
    Expense Account650000
    TDS Payable Account-13000
    Vendor Account-637000

Tip

Nature of Remittance and Act Applicable are mandatory for NRI Payments.

TDS calculation on higher rate if vendor isn't having PAN

If the vendor's PAN isn't available, the configured non-PAN rate is used. Complete the applicable P.A.N. Status and P.A.N. Reference No. so that posting can validate the vendor's details.

In the given scenario, vendor issued an invoice for INR 50,000 on which 2% TDS is applicable under TDS section 194C, but PAN isn't available for vendor. In such a case 20% TDS is charged as a higher rate.

  • In this case TDS calculation is as following:

    ComponentValue
    TDS Base Amount50000
    TDS Amount10000 (50000*20%)
  • On posting invoice, GL Entries are as following:

    ParticularsAmount
    Expense Account50000
    TDS Payable Account-10000
    Vendor Account-40000

Expenses partially subject to TDS

  • In the given scenario, vendor issued an invoice for INR 112,360, out of which INR 100,000 is for auditing service on which 10% TDS is applicable under Section 194J. INR 12,360 is for other charges on which TDS isn't applicable.

    In this case TDS calculation is as following:

    ComponentValue
    TDS Base Amount100000
    TDS Amount10000 (100000*10%)

On posting invoice, GL Entries are as following:

ParticularsAmount
Expense Account112360
TDS Payable Account-10000
Vendor Account-102360

TDS calculation on multiple expenses in a single invoice

A single invoice can be raised by the vendor for multiple expenses. For example, vendor issued a single invoice for INR 100000; INR 50,000 each towards two services under TDS Section 194C and 194J.

  • In this case TDS calculation is as following:

    ComponentValue
    TDS Base Amount100000
    TDS amount for 194C1000 (50,000x2%)
    TDS amount for 194J5000 (50,000x10%)
  • On posting invoice, GL Entries are as following:

    ParticularsAmount
    Expense Account (194C)50000
    Expense Account (194J)50000
    TDS Payable Account (194C)-1000
    TDS Payable Account (194J)-5000
    Vendor Account-94000

TDS on expenses at lower rate or zero rate

If a vendor has a certificate of concessional rate instead of normal rate, then to handle that scenario, concessional codes can be configured and attached to those vendors.

In the given scenario, vendor issued an invoice for INR 100000 towards professional services. Vendor has a certificate of income tax at Lower rate @ 5% on professional services instead of normal rate.

  • In this case TDS calculation is as following:

    ComponentValue
    TDS Base Amount100000
    TDS Amount5000 (100000*5%)
  • On posting invoice, GL Entries are as following:

    ParticularsAmount
    Expense Account100000
    TDS Payable Account-5000
    Vendor Account-95000

In this scenario, vendor issued an invoice for INR 100000 towards professional services. Vendor has a certificate of income tax at Zero rate @ 0% on professional services instead of normal rate.

  • In this case TDS calculation is as following:

    ComponentValue
    TDS Base Amount100000
    TDS Amount0 (100000*0%)
  • On posting invoice, GL Entries are as following:

    ParticularsAmount
    Expense Account100000
    Vendor Account-100000

Note

Concession Code must be selected on vendor master for lower or zero rated TDS transactions.

TDS Threshold

Find free e-learning modules for Business Central here