# TDS on Purchase of Goods (Section 194Q) Calculator for Indian Buyers

> Source: https://netray.co/tools/tds-on-purchase-section-194q-calculator-india
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Works out section 194Q TDS on a vendor invoice after the annual Rs 50 lakh threshold, excluding GST shown separately, and the net amount to pay.

## Category

regional

## Region

India

## Audience

- Finance controller
- Accounts payable
- Purchase manager
- Tax consultant

## Tool

**Kind:** calculator

**Currency:** Rs 

**Inputs:**

#### Purchases from this vendor earlier in the financial year (excl. GST)

**Key:** prior

**Type:** number

**Default:** 4200000

**Min:** 0

**Step:** 100000

**Unit:** Rs

**Help:** Total value of goods bought from the same resident seller from 1 April up to the previous invoice.

#### Current invoice value excluding GST

**Key:** invoice

**Type:** number

**Default:** 1800000

**Min:** 0

**Step:** 50000

**Unit:** Rs

**Help:** Taxable value of goods on the invoice.

#### GST shown separately on the invoice

**Key:** gst

**Type:** number

**Default:** 324000

**Min:** 0

**Step:** 5000

**Unit:** Rs

**Help:** Where GST is shown separately in the invoice, CBDT guidance excludes it from the TDS base.

#### Annual threshold per seller

**Key:** threshold

**Type:** number

**Default:** 5000000

**Min:** 0

**Step:** 100000

**Unit:** Rs

**Help:** Rs 50 lakh in the section as enacted. Change only if the law has changed.

#### TDS rate

**Key:** rate

**Type:** select

**Default:** 0.1

**Options:**

##### 0.1% (PAN available)

**Value:** 0.1

##### 5% (no PAN, section 206AA)

**Value:** 5

**Outputs:**

#### Cumulative purchases after this invoice

**Key:** cum_after

**Expr:** prior + invoice

**Format:** currency

#### Amount already above threshold

**Key:** excess_before

**Expr:** max(0, prior - threshold)

**Format:** currency

#### Amount above threshold after this invoice

**Key:** excess_after

**Expr:** max(0, cum_after - threshold)

**Format:** currency

#### TDS base for this invoice

**Key:** base

**Expr:** excess_after - excess_before

**Format:** currency

**Description:** Only the portion of purchases that crosses the Rs 50 lakh line is subject to TDS.

#### TDS to deduct

**Key:** tds

**Expr:** base * rate / 100

**Format:** currency

**Primary:** true

#### Net payable to vendor

**Key:** net

**Expr:** invoice + gst - tds

**Format:** currency

**Primary:** true

**Chart:**

#### TDS vs current invoice value

**Type:** line

**X:** invoice

**From:** 0

**To:** 20000000

**Steps:** 40

**Series:**

- tds

**Disclaimer:** Section 194Q has been amended several times and its applicability depends on the period and on the Income-tax Act in force. Confirm that 194Q applies to your transaction date and buyer turnover test with your tax advisor before deducting.

## Content

**Intro:** Section 194Q requires certain buyers to deduct a small TDS on purchases of goods from a resident seller once purchases from that seller cross Rs 50 lakh in a financial year. This calculator applies the threshold, the incremental base and the rate to each invoice so your accounts payable team deducts the right amount.

**Sections:**

#### How to use the calculator

**Body:** Enter the value of goods already purchased from the same vendor since 1 April, then the current invoice value excluding GST. The tool adds the two, checks how far the cumulative total sits above the threshold, and taxes only the incremental excess. Keep one run per vendor, because the threshold is tested vendor by vendor and not across all suppliers. Use the chart to see how TDS grows as a single invoice gets larger. Re-run after each invoice, carrying the cumulative figure forward.

**Bullets:**

- Use the vendor's PAN to pick the 0.1% rate
- Exclude GST if it is shown separately on the invoice
- Carry cumulative purchases forward invoice by invoice

#### The rule behind the numbers

**Body:** The section applies to a buyer whose turnover in the previous financial year exceeded Rs 10 crore. TDS is at 0.1% of the amount by which purchases from the seller exceed Rs 50 lakh, deducted at the time of credit to the seller or payment, whichever is earlier. It does not apply where the seller has TCS collected under section 206C(1H) for the same transaction, and it does not apply to goods covered by other TDS sections. Because the base is incremental, an invoice that stays below the threshold carries no TDS.

#### Worked example

**Body:** A plant has already bought Rs 42 lakh of castings from a vendor this year. The next invoice is Rs 18 lakh plus Rs 3.24 lakh GST. Cumulative purchases become Rs 60 lakh, which is Rs 10 lakh above the threshold. TDS at 0.1% is Rs 1,000 on that Rs 10 lakh. The net payable is Rs 21.24 lakh less Rs 1,000. The next invoice from the same vendor will be fully above the threshold, so TDS applies to its entire base.

#### Common mistakes and ERP notes

**Body:** Teams often test the threshold on a single invoice instead of cumulatively, or include GST in the base. Another miss is forgetting that advances and credit notes also move the position. In SAP, Oracle, Infor or Tally, set up a withholding tax code for 194Q with a cumulative threshold by vendor so the system deducts automatically, and reconcile it quarterly against Form 26Q before filing.

**Cta:** If threshold tracking by vendor is still done in spreadsheets, we can help automate withholding tax determination inside your ERP and reconcile it to Form 26Q.

**Faq:**

#### Is GST included in the 194Q TDS base?

**Answer:** Where GST is shown separately in the invoice, the CBDT clarified that TDS under 194Q is applied on the value excluding GST. If the invoice shows a single gross amount with no separate GST, the full amount forms the base. Keep the invoice format consistent so auditors can follow the logic.

#### Does the Rs 50 lakh threshold apply per invoice?

**Answer:** No. It applies to total purchases from one seller in the financial year. Once cumulative purchases cross Rs 50 lakh, TDS is calculated on the excess, and every later invoice from that seller is fully taxable at the rate.

#### What if the seller has already collected TCS?

**Answer:** If the seller collected TCS under section 206C(1H) on the same sale, the buyer is not required to deduct 194Q on that transaction. The two provisions are not meant to apply together, so record which one covered each invoice.

#### Which buyers must deduct 194Q?

**Answer:** Buyers whose total sales, gross receipts or turnover from business exceeded Rs 10 crore in the immediately preceding financial year. The test is on the buyer, not the seller. Confirm current applicability with your tax advisor each year.

## Search terms

194Q TDS calculator, TDS on purchase of goods, section 194Q calculation, 194Q threshold 50 lakh, TDS on purchase 0.1 percent, 194Q example, tds on purchase excel, 194Q GST included or excluded

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json