# TDS on Supplier Payment Calculator for Indian Accountants > Source: https://netray.co/tools/tds-on-supplier-payment-calculator > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer Calculate TDS to deduct on a supplier bill by section rate, with the higher no-PAN rate and the net amount to pay. ## Category regional ## Erp Tally Prime ## Region India ## Audience - Accountant - Accounts payable - Finance controller ## Tool **Kind:** calculator **Currency:** Rs **Inputs:** #### Bill amount excluding GST **Key:** base **Type:** number **Default:** 250000 **Min:** 0 **Step:** 1000 **Unit:** Rs #### GST charged on bill **Key:** gst_pct **Type:** number **Default:** 18 **Min:** 0 **Max:** 40 **Step:** 1 **Unit:** % #### GST shown separately on invoice **Key:** gst_separate **Type:** select **Default:** 1 **Options:** ##### Yes, TDS on amount excluding GST **Value:** 1 ##### No, GST included in amount **Value:** 0 **Help:** Under CBDT guidance, if GST is shown separately in the invoice, TDS is on the amount excluding GST. #### TDS rate for the section **Key:** rate **Type:** select **Default:** 2 **Options:** ##### 0.1% (goods purchase, 194Q) **Value:** 0.1 ##### 1% (194C individual/HUF) **Value:** 1 ##### 2% (194C others, 194J technical, 194H, 194-I machinery) **Value:** 2 ##### 10% (194J professional, 194-I land/building) **Value:** 10 **Help:** Confirm the current rate and threshold for the section in the Income-tax Act and your tax advisor. #### Supplier PAN available **Key:** pan **Type:** select **Default:** 1 **Options:** ##### Yes **Value:** 1 ##### No (higher rate applies) **Value:** 0 **Outputs:** #### GST on bill **Key:** gst **Expr:** base * gst_pct / 100 **Format:** currency #### Total invoice amount **Key:** gross **Expr:** base + gst **Format:** currency #### Amount on which TDS applies **Key:** tds_base **Expr:** if(eq(gst_separate,1), base, gross) **Format:** currency #### Effective TDS rate **Key:** eff_rate **Expr:** if(eq(pan,1), rate, max(rate, 20)) **Format:** decimal **Description:** Section 206AA applies the higher of the normal rate or 20% when no PAN is available. #### TDS to deduct **Key:** tds **Expr:** round(tds_base * eff_rate / 100) **Format:** currency **Primary:** true #### Net payable to supplier **Key:** net **Expr:** gross - tds **Format:** currency **Primary:** true **Chart:** #### TDS and net payable vs bill amount **Type:** line **X:** base **From:** 50000 **To:** 1000000 **Steps:** 20 **Series:** - tds - net **Disclaimer:** Rates and thresholds change with each Finance Act. Verify the section, rate and threshold before deducting. Not tax advice. ## Content **Intro:** Accounts payable teams deduct TDS on every contractor, professional and goods bill that crosses a threshold. This calculator takes the invoice, treats GST the way the CBDT circular requires, applies the no-PAN penalty rate and gives the net amount to release. **Sections:** #### How to use it **Body:** Enter the bill amount before GST and the GST rate printed on the invoice. Say whether GST is shown separately, because that decides the TDS base. Pick the rate that matches the section you are deducting under, and tell the tool whether you hold the supplier PAN. Read the TDS to deduct and the net payable. Then book the deduction in Tally Prime, Busy or your ERP with the right TDS nature of payment so the 26Q return pulls the correct section. #### Method and formula **Body:** TDS equals the TDS base times the effective rate. The base is the invoice value excluding GST when GST is shown as a separate line, otherwise the full invoice value. The effective rate is the section rate, or 20% if that is higher and the supplier has not given a PAN. Net payable is the total invoice amount less TDS. The tool rounds TDS to the nearest rupee, which matches the rounding of challan payments. **Bullets:** - Check the annual and single-bill thresholds for the section first. - Deduct at the earlier of credit or payment. - Lower deduction certificates under section 197 override the table rate. #### Common mistakes **Body:** Frequent errors are deducting TDS on the GST component when it was billed separately, using the 194J professional rate for a pure technical-services contract, missing the cumulative threshold across bills in the year, and depositing late. Interest on late deduction and late deposit runs by the month, and a disallowance under section 40(a)(ia) can hit the expense claim. Keep PAN validation in the vendor master to avoid the 20% rate. **Cta:** Netray can build a read-only exception report over your payables that finds bills with the wrong TDS section, missing PAN or a cumulative threshold crossed. **Faq:** #### Is TDS deducted on GST? **Answer:** If GST is shown separately in the invoice, TDS is on the amount excluding GST. If the invoice shows one amount with GST included, TDS applies to the whole amount. Use the toggle in the tool to see both. #### What if the supplier has no PAN? **Answer:** The higher of the normal rate or 20% applies under section 206AA. The tool applies that automatically. Collect PAN in the vendor master to avoid the penalty rate and reconciliation problems in Form 26AS. #### Which rate for a machine repair contract? **Answer:** A works contract or labour for repair is generally 194C. Technical services can be 194J at 2%. The classification depends on the contract, so confirm with your tax advisor and keep it consistent. #### Does the tool check thresholds? **Answer:** No. Thresholds differ by section and change over time. Check them before using the result, and track the cumulative amount paid to each supplier through the year. ## Search terms tds calculator, tds on contractor payment, tds on professional fees, tds 194c 194j calculator, tds on gst invoice, tds net payable calculator, tally tds calculation --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json