BOQ Builder·Auto-BOQ from dimensions, DSR ratesNEWBidEasy·Government tenders, searchableLIVEInfraLens App·Free on Play Store, offline-readyNEW
PMC💰 Contract & BillingTax Deduction Tracker (Income Tax TDS, GST TCS/TDS)

Tax Deduction Tracker (Income Tax TDS, GST TCS/TDS)

log
PMC-BIL-LOG-005·v1.0-beta·⚠ Beta — review before use

Tracks all tax deductions on contractor payments + bill processing. Compliance + reconciliation tool for income tax + GST. Critical for closeout audit + statutory returns.

ReferencesIncome Tax Act 1961 — Section 194C (TDS on Contractors)GST Act 2017 — Section 51 (TDS by Government Deductors)GST Act 2017 — Section 52 (TCS by E-Commerce Operators)Finance Act + CBDT Notifications
Download
📍 When to use this template
  • Each RA bill processing.
  • Quarterly TDS return filing.
  • Monthly / quarterly GST return.
  • Year-end reconciliation + audit.
Sections & fields
Preview of the template structure. Download Excel to fill on site.
1Bill + Period4 fields
Bill Number + Date
_____________
Bill Value (Pre-Tax)
_____________
GST Component
_____________
Total Bill (Inc Tax)
_____________
2Income Tax TDS6 fields
TDS Section (194C / 194J / etc.)
_____________
TDS Rate (1 % individual / 2 % others)
_____________
TDS Amount
_____________
Cumulative TDS to Date
_____________
Form 16A Issuance Status
_____________
Tax Deposit Date (must be by 7th of next month)
_____________
3GST TDS / TCS6 fields
GST TDS Applicability (Section 51 — Govt. Deductors)
_____________
GST TDS Rate (1 % CGST + 1 % SGST or 2 % IGST)
_____________
GST TCS Applicability (Section 52 — E-Commerce)
_____________
GST TCS Rate (1 % typical)
_____________
TDS / TCS Amount
_____________
Deposit Reference (GSTR-7 / GSTR-8)
_____________
4Other Statutory5 fields
EPF Contribution Deducted
_____________
ESI Contribution Deducted
_____________
Professional Tax
_____________
Labour Cess (BOCW)
_____________
Other Tax (Cess / Surcharge)
_____________
5Reconciliation4 fields
TDS Certificate Issued (Y/N)
_____________
Form 26AS Updated (Y/N)
_____________
TRACES Portal Match
_____________
Vendor's Acknowledgement
_____________
💡 Sample filled excerpt
RA #15, ₹2.5 cr + ₹45 lakh GST = ₹2.95 cr. TDS (sec 194C, 1 %): ₹2.95 lakh. GST TDS (sec 51, 2 %): ₹5.9 lakh (since client is govt). Deposits made within 7 days. Form 16A issued to vendor. Form 26AS reflects.
⚖ Compliance notes
  • TDS deposit deadline: 7th of next month for non-government; quarter-end for some categories.
  • GST TDS @ 2 % only for government deductors (Section 51 GST Act); otherwise no TDS at source for B2B.
  • Penalty for non-deposit: 1.5 % per month interest + late fee.
  • TDS at higher rate (20 %) if vendor's PAN not provided.
  • Form 16A must be issued within prescribed time + match TRACES portal data.

Engineer's Notes — Tax Deduction Tracker (Income Tax TDS, GST TCS/TDS)

Why the TDS / TCS Tracker matters

Every construction RA bill triggers multiple statutory deductions: Income Tax TDS under Section 194C, GST TDS under Section 51 (for government deductors), labour cess under BOCW Act, PF / ESI contributions, professional tax. Missing any one creates a chain of consequences: - Interest @ 1.5% per month on late TDS deposits (compounds fast) - Disallowance under IT Act Section 40(a)(ia) — 30% of the contractor's payment becomes non-deductible expense for the deductor - GST audit findings — input tax credit denial - TRACES mismatch — vendor's Form 26AS doesn't reflect; vendor escalates; rectification headache - Penalty proceedings — under-deduction or non-deposit penalty up to TDS amount

The TDS Tracker is the per-bill, per-vendor ledger that prevents these failures by recording every deduction at point of payment, deposit reference, certificate issuance, and TRACES match status.

Standard TDS / TCS structure on a construction project

Per-bill deductions (typical mix):

Income Tax TDS (mandatory if turnover > limits): - Section 194C: contractors / sub-contractors - 1% if vendor is individual or HUF - 2% if vendor is firm / company - 20% if vendor's PAN not provided - Section 194J: professional fees (consultants, architects) — 10% (2% for technical services) - Section 194I: rent — 10% (plant + machinery hire) or 2% (land/building)

GST TDS (Section 51, only for govt + PSU + specified deductors): - 2% on payments to suppliers (CGST 1% + SGST 1%, or IGST 2% for inter-state) - Threshold: contract value > ₹2.5 lakh - Deposit via GSTR-7 by 10th of next month - TDS certificate (GSTR-7A) to vendor within 5 days

Labour cess (BOCW Act): - 1% of construction cost (1.4% in some states) - Deducted at source by govt employers from contractor bills - Deposited with state Labour Welfare Board

Deposit deadlines: - Income Tax TDS: by 7th of next month (March deduction = 30th April) - GST TDS: by 10th of next month (GSTR-7) - BOCW cess: per state rules, typically monthly - PF / ESI: by 15th of next month

Quarterly returns: - 24Q + 26Q (Income Tax TDS) by 31st of July, October, January, May - GSTR-7 (GST TDS) monthly - BOCW Cess return — annual

Common TDS / TCS errors

1. Wrong section applied — works contract treated as professional service (194J vs 194C); rate mismatch; demand notice on under-deduction.

2. PAN not collected — vendor's PAN not on file; should have deducted @ 20%; deducted @ 1-2%; difference recoverable from deductor.

3. GST TDS applied to private contracts — Section 51 only for government deductors; private contractors must NOT deduct GST TDS; vendor claims refund + escalation.

4. Late deposit — 7th deadline missed; 1.5% per month interest from due date till deposit date.

5. No certificate issued — Form 16A / GSTR-7A not issued to vendor; vendor can't claim credit; escalates.

6. TRACES mismatch — TDS deposited but quarterly return wrong PAN; vendor's Form 26AS doesn't reflect; vendor escalates.

7. Sub-contractor TDS confusion — main contractor deducting TDS from sub-contractor's bill; sub-contractor's deductee TAN compliance failure.

8. Mobilisation advance TDS — TDS applicable on advance; many forget; demand notice later.

9. Cumulative threshold not tracked — Section 194C @ ₹30,000 single payment / ₹1,00,000 aggregate; multiple small payments aggregate; cumulative not tracked.

10. GST on TDS treatment — TDS on GST-inclusive value vs GST-exclusive value confusion; rules clarify but practice varies.

Cross-references

Companion PMC formats: - Bill Register (PMC-BIL-REG-002) — master bill log - Subcontractor Bill (PMC-BIL-LOG-003) - Cost Control Report (PMC-BIL-LOG-004) - BOCW Return (PMC-LAB-FRM-008) — labour cess

Statutory references: - Income Tax Act 1961 — Sections 194C / 194J / 194I / 194IA / 194IB - GST Act 2017 — Sections 51 + 52 (TDS / TCS) + Rule 66 - BOCW Cess Act 1996 — labour cess @ 1% - Code on Social Security 2020 — under implementation (consolidates PF / ESI / gratuity) - TRACES portal — https://www.tdscpc.gov.in (TDS reconciliation) - GST portal — https://www.gst.gov.in (GSTR-7 / 7A)