# TDS Deduction Tracker Worksheet (Editable, Excel Export)

> Source: https://netray.co/tools/tds-deduction-tracker-worksheet-india
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Record vendor bills, apply a TDS section and rate, and see tax deducted and net payable per line and in total.

## Category

regional

## Region

India

## Audience

- Accountant
- Finance controller
- Indian SME owner

## Tool

**Kind:** worksheet

**Mode:** editable

**Currency:** Rs 

**Columns:**

#### Vendor

**Key:** vendor

**Type:** text

#### Bill no

**Key:** bill

**Type:** text

#### Bill date

**Key:** bill_date

**Type:** date

#### TDS section

**Key:** section

**Type:** select

**Options:**

- 194C
- 194J
- 194I
- 194H
- 194Q
- 194A
- Other

#### Amount for TDS (excl. GST)

**Key:** base

**Type:** number

**Format:** currency

#### TDS rate %

**Key:** rate

**Type:** number

**Unit:** %

**Help:** Enter the rate that applies to the deductee and section

#### TDS deducted

**Key:** tds

**Type:** number

**Expr:** round(base * rate / 100)

**Format:** currency

#### GST on bill

**Key:** gst

**Type:** number

**Format:** currency

#### Net payable to vendor

**Key:** net

**Type:** number

**Expr:** base + gst - tds

**Format:** currency

**Rows:**

**Vendor:** Rapid Logistics

**Bill:** RL/221

**Bill date:** 2026-10-03

**Section:** 194C

**Base:** 85000

**Rate:** 2

**Gst:** 4250

**Vendor:** A. Menon and Associates

**Bill:** AM/58

**Bill date:** 2026-10-07

**Section:** 194J

**Base:** 60000

**Rate:** 10

**Gst:** 10800

**Vendor:** City Estates

**Bill:** CE/14

**Bill date:** 2026-10-01

**Section:** 194I

**Base:** 120000

**Rate:** 10

**Gst:** 21600

**Vendor:** Omega Steels

**Bill:** OS/907

**Bill date:** 2026-10-12

**Section:** 194Q

**Base:** 450000

**Rate:** 0.1

**Gst:** 81000

**Totals:**

#### Total bill base

**Key:** base

**Agg:** sum

**Format:** currency

#### Total TDS deducted

**Key:** tds

**Agg:** sum

**Format:** currency

#### Total net payable

**Key:** net

**Agg:** sum

**Format:** currency

**Summary:**

#### Effective TDS rate

**Key:** eff_rate

**Expr:** if(gt(sum_base,0), sum_tds / sum_base * 100, 0)

**Format:** decimal

**Description:** Total TDS as a percentage of the base amount

**Notes:** Rates change by Finance Act, deductee type and PAN status, so type the rate you have confirmed rather than relying on the sample values. Where GST is shown separately on the invoice, TDS is generally computed on the amount excluding GST; confirm with your adviser. Not tax advice.

## Content

**Intro:** Every month, accountants in Indian companies work out TDS on contractor, professional, rent and purchase payments. This tracker keeps each bill, section, rate and deduction in one table so that TDS payable, vendor net payments and the monthly challan amount can be checked before you pay.

**Sections:**

#### How to use the tracker

**Body:** Enter one row per vendor bill. Choose the section, type the base amount excluding GST and the rate that applies to that vendor. The worksheet computes the TDS and the net payable after adding GST. Totals show the TDS to deposit and the overall effective rate, which is a quick sanity check for the month. Export to Excel and attach it to your TDS challan working.

**Bullets:**

- Check the deductee PAN and category before choosing a rate
- Look at threshold limits per bill and per year for the section
- Keep the deduction date, not only the bill date, for deposit due dates

#### Sections commonly used by manufacturers

**Body:** Section 194C covers payments to contractors and transporters, 194J covers professional and technical fees, 194I covers rent, 194H covers commission and brokerage, and 194Q applies to a buyer with prior-year turnover above the notified limit purchasing goods above a threshold in a year. Each has its own rate, threshold and exceptions, and tax deducted is deposited by the seventh of the next month, with March handled differently. Always confirm current thresholds before relying on them.

#### Common mistakes

**Body:** Frequent issues include computing TDS on the GST-inclusive amount when GST is shown separately, applying the wrong rate to individuals compared with companies, missing the higher rate where PAN is not available, and deducting under 194C when the service is professional. Reconcile the tracker with your TDS payable ledger in Tally Prime, Busy or Zoho Books each month and with Form 26AS or the annual information statement of the deductee.

**Cta:** If vendor bills sit in an ERP and TDS is calculated again outside it, we can discuss rules-based flags that appear at the time of booking.

**Faq:**

#### Does this calculate the correct rate for me?

**Answer:** No. You enter the rate, because it depends on the section, the deductee and PAN status and changes over time. The sheet applies your rate consistently and totals the result.

#### Is TDS computed on GST?

**Answer:** Where GST is shown separately in the invoice, TDS is generally deducted on the value excluding GST. If it is not separately shown, the whole amount is the base. Confirm with your tax adviser.

#### When is TDS deposited?

**Answer:** Generally by the seventh of the month following the deduction, with a different date for March. Your adviser can confirm exceptions and interest on late deduction or deposit.

#### Can I use it for 194Q?

**Answer:** You can record 194Q lines, but the threshold is cumulative over the year, so track purchases from each seller separately. This sheet does not accumulate across lines for threshold testing.

## Search terms

tds deduction tracker excel, tds calculation sheet in excel, tds on contractor payment format, tds working sheet 194c 194j, tds ledger format, vendor tds register, tds payable tracker, 194q tds calculation

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