TDS Payable Report
TDS Payable Report
The TDS (Tax Deducted at Source) Payable Report in the ERP application provides a consolidated view of all TDS amounts deducted by the business but not yet remitted to the government. This report is essential for tracking outstanding TDS liabilities, ensuring timely compliance with statutory requirements, and avoiding penalties for late payments.
Purpose
-
To monitor pending TDS payments that need to be deposited to the tax authorities.
-
To maintain accurate records for statutory audits and compliance.
-
To ensure timely remittance of TDS as per applicable tax laws.
Key Features
-
Displays party-wise TDS payable amounts.
-
Shows TDS deduction date and due date for payment.
-
Categorizes TDS by section and rate (e.g., 194C, 194J, etc.).
-
Provides filters for financial year, month, section, and vendor/customer.
-
Shows the status of payment (Paid / Unpaid / Partially Paid).
-
Supports export to Excel/PDF for submission or internal review.
Typical Data Fields
| Field Name | Description |
|---|---|
| Party Name | Name of the vendor/customer from whom TDS was deducted. |
| PAN / Tax ID | Tax identification number of the party. |
| Invoice / Payment Ref No | Reference number of the transaction on which TDS was deducted. |
| Date of Deduction | The date when TDS was deducted. |
| Section | Applicable TDS section as per income tax law. |
| TDS Rate (%) | Percentage of TDS deduction. |
| TDS Amount | Total amount of TDS deducted. |
| Due Date for Payment | Last date for depositing the TDS to the government. |
| Payment Status | Paid, Unpaid, or Partially Paid. |
| Remarks | Additional notes (if any). |
Example
| Party Name | PAN Number | Invoice No | Date of Deduction | Section | TDS Rate | TDS Amount | Due Date | Status |
|---|---|---|---|---|---|---|---|---|
| ABC Suppliers | AAAAA1234A | INV-00125 | 05-Jan-2025 | 194C | 1% | ₹1,200.00 | 07-Feb-2025 | Unpaid |
| XYZ Consultants | BBBBB5678B | INV-00130 | 12-Jan-2025 | 194J | 10% | ₹5,000.00 | 07-Feb-2025 | Paid |
Usage in ERP
-
Accounts Department can review the report before every TDS due date to ensure no payment is missed.
-
Compliance Officers can cross-check deductions and payments for accuracy.
-
Auditors can verify TDS liabilities during statutory audits.