PMC›💰 Contract & Billing›Tax 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.
← Price Escalation Calculation Sheet