How to Create and Manage TDS Ledger in TallyPrime

A TDS ledger in TallyPrime is a dedicated account that records tax deducted at source on purchases and professional services. Enable it under F11, create ledger accounts for each vendor or nature of payment, and reconcile with GSTR-2B to ensure accurate GST input credit and compliance.

What is a TDS Ledger and Why You Need It

A TDS ledger in TallyPrime is an accounting record that tracks tax deducted at source (TDS) by vendors, contractors, or service providers during purchase transactions. When you buy goods or services from registered suppliers, they may deduct a percentage of the invoice amount as TDS under Income Tax Act rules. This deducted amount is credited to your input tax credit (ITC) in your GST return, but only if it is properly recorded and reconciled.

TDS ledgers are essential for businesses that:

• Receive services from contractors, consultants, or professionals
• Purchase goods where TDS is applicable
• Need to claim input credit on GST returns
• Must reconcile GSTR-2B (inward supplies) with actual invoices received
• File TDS returns (Form 26Q) with income tax authorities

Without a proper TDS ledger, you risk losing input credit, facing GST mismatch penalties, and failing income tax compliance audits. TallyPrime automates TDS tracking when configured correctly.

Enabling TDS in TallyPrime

Before you create a TDS ledger, you must enable the TDS feature in TallyPrime. Follow these steps:

1. Open TallyPrime and go to Gateway of Tally
2. Press F11 (Features) or select Alter Features
3. Navigate to Tax section
4. Select TDS/TCS
5. Set Enable TDS to Yes
6. Set Enable TCS to Yes if applicable (Tax Collected at Source)
7. Press Ctrl+A to accept and save

Once enabled, TallyPrime will display TDS and TCS options across purchase invoices, payment vouchers, and GST reports. You can now proceed to create TDS ledger accounts.

Creating TDS Ledger Accounts in TallyPrime

A TDS ledger is a special type of ledger account that records deductions. Create it as follows:

1. Go to Gateway of Tally > Create or press Alt+C
2. Select Ledger
3. Enter a name, for example, "TDS on Contractor" or "TDS on Professional Fees"
4. Under Ledger Type, select TDS Receivable or TDS Payable based on your role
5. If you are liable to deduct TDS, use TDS Payable
6. If you receive services and TDS is deducted from your payment, use TDS Receivable
7. Set the opening balance if you have prior TDS records
8. Link it to a parent group such as "Current Assets" or "Current Liabilities" as appropriate
9. Press Ctrl+A to save

You can create multiple TDS ledgers for different vendors, contractors, or nature of payments. This segregation helps in tracking and reconciliation.

Understanding TDS Nature of Payment Codes

TDS is deducted on specific categories of payments defined by income tax rules. TallyPrime requires you to assign a nature of payment code to each TDS transaction. Common codes include:

Nature of Payment	TDS Rate	Applicable To
Contractor (194C)	1% to 2%	Construction, repair, fabrication services
Professional Fees (194J)	10%	Consultants, architects, doctors, lawyers
Commission (194H)	5%	Commission on sale of goods or services
Rent (194I)	10%	Rent paid for building or plant
Interest (194A)	10%	Interest on deposits or loans

Configure these rates in TallyPrime under F11 > Tax > TDS. TallyPrime will auto-calculate TDS based on the invoice amount and nature of payment selected during bill entry.

Recording TDS in Purchase Invoices

When you receive a purchase invoice with TDS deducted, record it correctly in TallyPrime:

1. Go to Gateway of Tally > Create > Voucher or press Alt+F7 (Purchase)
2. Select the vendor name and enter invoice details
3. In the item line, enter the item name, quantity, rate, and amount
4. Below the item, you will see a TDS field (if TDS is enabled)
5. Press Tab to navigate to the TDS field
6. Enter the Nature of Payment (e.g., Professional Fees, Contractor)
7. TallyPrime will auto-calculate TDS based on the rate and invoice amount
8. Verify the TDS amount matches the vendor's invoice
9. Press Ctrl+A to save

TallyPrime will automatically debit the TDS ledger and adjust the net payment amount. This ensures your accounts reflect the actual cash paid (invoice amount minus TDS).

Reconciling TDS Ledger with GSTR-2B

GSTR-2B is the GST return statement showing inward supplies (purchases) filed by your vendors. TDS ledger reconciliation ensures:

• All TDS deductions are properly recorded in your books
• Input credit claimed matches vendor invoices
• No mismatch penalties are levied by GST authorities
• TDS amounts are correctly reflected in GST returns

To reconcile in TallyPrime:

1. Go to Gateway of Tally > Display More Reports > GST Reports
2. Select GSTR-2B Reconciliation
3. Compare invoices received in GSTR-2B with your TDS ledger entries
4. Identify any missing or mismatched invoices
5. Correct invoice amounts or TDS rates in your TDS ledger if needed
6. Generate a reconciliation report for audit trail

Regular reconciliation, ideally monthly, prevents compliance issues and ensures your GST returns are accurate.

TDS Ledger Reports in TallyPrime

TallyPrime provides several reports to monitor TDS ledger activity:

• TDS Register: Shows all TDS transactions with vendor names, invoice amounts, and TDS deducted. Access via Alt+G > TDS Register.
• TDS Ledger: Displays opening balance, transactions, and closing balance for each TDS ledger account. Go to Gateway of Tally > Display More Reports > TDS > TDS Ledger.
• TDS Payable Report: Lists TDS amounts you must pay to the government. Use this to prepare TDS challan and Form 26Q.
• TDS Reconciliation: Compares TDS recorded in books with GSTR-2B and vendor TDS certificates.

These reports help you track TDS compliance, verify amounts, and prepare for GST and income tax filing deadlines.

Worked Example: Recording TDS on Professional Fees

Let us walk through a real scenario. Suppose your company, ABC Pvt Ltd, receives a professional services invoice from XYZ Consultants on 15 January 2026:

• Invoice Amount: Rs 10,000
• Nature of Payment: Professional Fees (10% TDS applicable)
• TDS Deducted: Rs 1,000 (10% of Rs 10,000)
• Net Amount Payable: Rs 9,000

In TallyPrime, you record this as:

1. Create a purchase voucher for XYZ Consultants
2. Item: Professional Services, Amount: Rs 10,000
3. Nature of Payment: Professional Fees
4. TDS auto-calculated: Rs 1,000
5. Payment made: Rs 9,000 (net)
6. TDS Ledger (TDS on Professional Fees) is credited with Rs 1,000

Your TDS ledger now shows Rs 1,000 as TDS receivable (input credit). When you file GSTR-2B and GST return, this TDS amount will be claimed as input credit, reducing your GST liability. At year-end, you will file Form 26Q with income tax authorities showing all TDS deducted.

Common TDS Ledger Issues and Fixes

Users often face challenges with TDS ledgers. Here are solutions:

• TDS Not Calculating: Ensure TDS is enabled under F11 and the correct nature of payment is selected on the invoice.
• Mismatch in GSTR-2B: Verify invoice dates, vendor GSTIN, and amounts match exactly. Reconcile monthly to catch discrepancies early.
• TDS Ledger Balance Incorrect: Check opening balance and all transactions. Use Alt+Y (Data) > Repair if ledger shows wrong balance.
• Unable to Link TDS to Purchase: Confirm the ledger type is set to TDS Receivable or TDS Payable, not a regular ledger.

If issues persist, contact your Tally support or certified partner for data repair and reconciliation assistance.

TDS Ledger and Form 26Q Filing

Form 26Q is the TDS return filed with income tax authorities. It reports all TDS deducted during the financial year. TallyPrime helps you prepare this form by:

• Tracking all TDS transactions in the TDS ledger
• Generating TDS registers by vendor and nature of payment
• Exporting data in a format compatible with income tax e-filing portals

Ensure your TDS ledger is complete and accurate before the Form 26Q deadline (typically 31 May for the prior financial year). For detailed guidance on TDS filing, refer to our article on TDS challan in Tally and TDS return 26Q in Tally.

Linking TDS Ledger to GST Returns

TDS claimed in your GST return must match your TDS ledger. TallyPrime integrates TDS with GSTR-3B (monthly GST return) as follows:

1. All TDS recorded in purchase invoices flows to GSTR-2B automatically
2. TDS appears as input credit in GSTR-3B under the relevant HSN/SAC codes
3. You can view TDS credit claimed in Gateway of Tally > Display More Reports > GST Reports > GSTR-3B
4. Verify TDS amounts in GSTR-3B match your TDS ledger balance

This integration reduces manual errors and ensures GST compliance. If you use e-invoicing, TDS details are automatically captured in IRN and transmitted to GST authorities.

Best Practices for TDS Ledger Management

To maintain an accurate and compliant TDS ledger:

• Segregate by Vendor or Nature of Payment: Create separate ledgers for contractors, professionals, and other categories. This simplifies reconciliation and reporting.
• Verify Vendor GSTIN: Ensure vendor details in invoices are correct. Mismatched GSTIN causes GSTR-2B mismatch.
• Reconcile Monthly: Compare TDS ledger with GSTR-2B and vendor TDS certificates monthly, not just at year-end.
• Maintain Supporting Documents: Keep invoices, TDS certificates, and payment receipts for audit trail.
• Enable TSS for Updates: Ensure your TallyPrime has an active Technical Support Service (TSS) subscription so you receive the latest TDS rates and GST rule updates.

TDS Ledger in TallyPrime Cloud

If you use TallyPrime on Cloud, TDS ledger functionality is identical to the desktop version. You can:

• Create and manage TDS ledgers from any device (Windows, Mac, Linux, Android, iOS)
• Record TDS in purchase invoices with real-time synchronization
• Generate TDS reports and reconcile with GSTR-2B
• Access daily backups to protect your TDS data

TallyPrime Cloud is available from approximately Rs 899 to Rs 1,299 per month (indicative 2026 pricing) with licence included, or from Rs 175 to Rs 290 per user per month if you bring your own licence. This makes it ideal for businesses needing remote access and secure TDS tracking.

Upgrading Your TallyPrime License for Advanced TDS Features

TDS ledger is available in both TallyPrime Silver and Gold editions. However, if you need multi-user access to TDS ledgers (for example, separate accountants managing TDS for different vendors), consider upgrading to TallyPrime Gold. Gold allows unlimited users on a LAN, each with full access to TDS ledgers and reports. TallyPrime Silver is priced at approximately Rs 22,500 plus 18% GST (single user, perpetual), while Gold is approximately Rs 67,500 plus 18% GST (unlimited users, perpetual). An upgrade from Silver to Gold costs about Rs 45,000 plus GST. Both include 1 year of TSS free. For more details, see our guide on TallyPrime price.

Next Steps: Get Expert Help with TDS Ledger Setup

Setting up and managing a TDS ledger in TallyPrime requires attention to detail and knowledge of income tax and GST rules. If you are new to TDS or face challenges with reconciliation, we recommend consulting a certified Tally partner. Global IT Care is a Tally 3 Star Certified Partner based in Purnea, Bihar, with over 15 years of experience helping businesses configure TDS ledgers, reconcile GSTR-2B, and file compliant GST and income tax returns. We offer on-site training, data migration, reconciliation support, and ongoing TSS to keep your TallyPrime updated. Contact us today at +91 75469 00951 to discuss your TDS ledger needs and schedule a free consultation. Let us help you stay compliant and confident in your tax accounting.