How to File TDS Return 26Q in TallyPrime: Step-by-Step Guide
Form 26Q is the quarterly TDS return filed by deductors in India. TallyPrime enables TDS tracking via F11 Features, auto-calculates deductions on contractor and professional payments, and generates TDS reports for 26Q compliance. Filing deadline is 15 days after quarter-end.
What is Form 26Q and Why It Matters
Form 26Q is a quarterly return of tax deducted at source (TDS) filed by deductors, employers, and other entities that deduct tax on payments made to contractors, professionals, rent, and other specified categories. Every deductor registered with the Income Tax Department must file 26Q within 15 days of the end of each financial quarter. Non-compliance attracts penalties under Section 272B of the Income Tax Act, 1961, ranging from Rs 100 to Rs 10,000 per day of default.
TallyPrime, India's homegrown accounting software used by over 35 million businesses, provides built-in TDS management features that help deductors track deductions, reconcile payments, and prepare data for 26Q filing. Understanding how to use TallyPrime for TDS return preparation is essential for compliance and audit readiness.
Understanding TDS Categories in Form 26Q
Form 26Q covers multiple TDS categories, each with its own rate and applicability rules. The main categories include:
- TDS on contractor payments (Section 194C) - typically 1% to 2% depending on contract value
- TDS on professional fees (Section 194J) - typically 10% for non-residents, 2% for residents above threshold
- TDS on rent (Section 194I) - 10% on rent of non-residential property, 5% on residential property above Rs 50,000/month
- TDS on commission (Section 194H) - 10% on commission to agents and brokers
- TDS on brokerage (Section 194H) - 10% on brokerage payments
- TDS on dividend (Section 194) - varies by resident/non-resident status
Each category must be tracked separately in TallyPrime so that the 26Q return reflects accurate deductions by category. This separation is critical for IT Department reconciliation and audit defense.
Enabling TDS in TallyPrime: Step-by-Step
Before you can file TDS returns or track deductions, you must enable TDS in TallyPrime. Follow these exact menu paths:
- Open TallyPrime and press Alt+G to go to Gateway of Tally
- Select F11 (Features) or click on Features
- Navigate to Statutory and Taxation > Tax Deduction at Source (TDS)
- Set TDS to Yes
- Press Ctrl+A to accept and save
- Close and restart TallyPrime
Once enabled, TallyPrime will display TDS-related ledgers, groups, and reports. You will see new options under Gateway of Tally > Display More Reports > TDS Reports. For more details on activation, refer to our guide on how to enable TDS in Tally.
Creating TDS Ledgers for Different Payment Categories
After enabling TDS, you must create TDS ledgers for each category of payment you make. TDS ledgers are special accounts that track the tax you deduct and deposit on behalf of the payee.
To create a TDS ledger for contractor payments:
- Press Alt+G > Gateway of Tally > Accounts Info > Ledgers > Create
- Enter Ledger Name: TDS on Contractor @ 1%
- Set Ledger Type: TDS Deductible
- Under TDS Details, select Category: Contractor (Section 194C)
- Set TDS Rate: 1%
- Set Applicable Above: Rs 30,000 (or your threshold)
- Press Ctrl+A to save
Repeat this process for each TDS category you use. For detailed instructions on contractor TDS, see TDS on contractor in Tally. For professional fees, visit TDS on professional fees in Tally.
Recording TDS Deductions in Payment Vouchers
When you make a payment to a contractor or professional, TallyPrime allows you to deduct TDS at the point of payment. Here is a worked example:
Scenario: You pay a contractor Rs 1,00,000 for construction work on 15 October 2024. TDS rate is 1%. You deduct Rs 1,000 and pay Rs 99,000 to the contractor.
| Particulars | Amount (Rs) |
|---|---|
| Gross Payment to Contractor | 1,00,000 |
| TDS Deducted @ 1% | -1,000 |
| Net Payment to Contractor | 99,000 |
| TDS Deposited to Government | 1,000 |
To record this in TallyPrime:
- Press Alt+J to create a Payment Voucher (or use Gateway of Tally > Vouchers > Payment)
- Select Payee: Contractor Name
- Enter Particulars row: Debit Contractor Expense A/c Rs 1,00,000
- In the same row, click on TDS column and select TDS on Contractor @ 1%
- TallyPrime auto-calculates TDS as Rs 1,000
- Enter Bank Payment row: Credit Bank A/c Rs 99,000
- TallyPrime auto-creates: Credit TDS Payable A/c Rs 1,000
- Press Ctrl+A to save
TallyPrime now tracks Rs 1,000 as TDS deducted in Q3 (Oct-Dec) and shows it in TDS reports. For more on this process, see TDS ledger in Tally.
Depositing TDS via Challan in TallyPrime
Once you deduct TDS, you must deposit it to the government within the due date. In India, TDS is deposited using Form 16A (Challan) through the NEFT/RTGS system to the Reserve Bank of India (RBI) or designated banks.
To record a TDS challan payment in TallyPrime:
- Press Alt+J > Payment Voucher
- Payee: RBI / Designated Bank (create if not exists)
- Particulars row: Debit TDS Payable A/c (the liability account) Rs 1,000
- Bank row: Credit Bank A/c Rs 1,000
- Add reference: Challan No., BSR Code, and date in the memo field
- Press Ctrl+A to save
For a detailed walkthrough, refer to TDS challan in Tally. Proper challan recording ensures your TDS reconciliation is accurate when filing 26Q.
Generating TDS Reports in TallyPrime
TallyPrime provides multiple TDS reports to help you verify deductions and prepare for 26Q filing. Access these reports via:
Method 1: Gateway of Tally > Display More Reports > TDS Reports
Method 2: Alt+G then search for TDS
Key TDS reports include:
- TDS Summary - shows total TDS deducted by category and quarter
- TDS Deduction Register - lists all deductions with payee names, dates, and amounts
- TDS Reconciliation - matches deducted TDS with deposited challan amounts
- TDS Payable - shows outstanding TDS liability
- Deductee-wise TDS - breaks down deductions by individual payee (useful for issuing Form 16A)
Run the TDS Summary report for your quarter (e.g., Oct-Dec for Q3) and cross-check it against your challan deposits. Any mismatch must be corrected before filing 26Q.
Understanding Form 26Q Filing Deadlines
Form 26Q is a quarterly return with strict deadlines. Missing the deadline invites penalties and interest. Here are the deadlines for FY 2024-25:
| Quarter | Period | Filing Deadline |
|---|---|---|
| Q1 | April 1 - June 30 | July 15 |
| Q2 | July 1 - September 30 | October 15 |
| Q3 | October 1 - December 31 | January 15 |
| Q4 | January 1 - March 31 | April 15 |
Plan your TDS reconciliation and data preparation at least one week before the deadline to allow time for corrections and file submission via the TRACES portal.
Reconciling TDS Data Before Filing 26Q
Before submitting Form 26Q, you must reconcile your TDS records in TallyPrime with your bank statements and IT Department records. Follow this checklist:
- Run TDS Summary report for the quarter from TallyPrime
- Compare total TDS deducted with total TDS challan deposits
- Check that all challan reference numbers and dates are recorded
- Verify payee names, PAN numbers, and deduction amounts match your records
- Ensure no TDS entry is duplicated or missing
- Cross-check bank statements to confirm all challan payments cleared
- Reconcile with Form 16A issued to payees (if applicable)
If you find discrepancies, use the TDS Reconciliation report in TallyPrime to identify and correct them. For data repair guidance, see TDS in TallyPrime.
Preparing 26Q Data for TRACES Portal Submission
TallyPrime does not directly file Form 26Q on the TRACES portal, but it provides all the data you need. Once your TDS records are reconciled, export or print the TDS reports and use them to prepare the 26Q XML file in TRACES or through certified TDS filing software.
Key data points to extract from TallyPrime for 26Q:
- Deductor PAN and registration details
- Quarter and financial year
- TDS category and rate for each deduction
- Payee name, PAN, and address
- Gross payment amount and TDS deducted
- Date of deduction and challan reference
- Total TDS deposited in the quarter
Many deductors use TallyPrime data as the source of truth and manually populate TRACES or hire a CA to file 26Q based on TallyPrime reports. This ensures accuracy and audit compliance.
Common TDS Mistakes and How TallyPrime Helps Avoid Them
Many deductors make costly TDS mistakes. TallyPrime's built-in controls help prevent them:
- Wrong TDS rate: TallyPrime enforces the rate you set in the TDS ledger, preventing manual errors
- Missed deduction threshold: TallyPrime shows the applicable threshold and warns if a payment falls below it
- Duplicate deduction: TallyPrime tracks each deduction by voucher, preventing double-counting
- Undeposited TDS: The TDS Reconciliation report immediately shows any deducted TDS not yet deposited
- Wrong payee details: Link payees to a master ledger in TallyPrime so names and PAN are consistent
- Late filing: Set a calendar reminder 7 days before the deadline to run TDS reports and prepare 26Q
TallyPrime Licensing and TDS Compliance Features
TallyPrime comes in two main editions: Silver and Gold. Both include full TDS features. Prices are indicative for 2026:
- TallyPrime Silver: Rs 22,500 + 18% GST (single user, perpetual license)
- TallyPrime Gold: Rs 67,500 + 18% GST (unlimited users on LAN, perpetual license)
- Technical Support Services (TSS): Silver Rs 4,500/year, Gold Rs 13,500/year (+GST) - includes updates and connected services like e-invoicing and TDS reconciliation
Every new TallyPrime license includes 1 year of TSS free. After TSS expiry, TallyPrime continues to work offline, but you won't receive updates or access connected services like live GSTR-1 reconciliation. For businesses filing 26Q regularly, TSS is highly recommended. For pricing details, see TallyPrime price.
TallyPrime on Cloud for Remote TDS Management
If your team works remotely, TallyPrime on Cloud allows secure access from any device. You can manage TDS deductions and generate 26Q reports from Windows, Mac, Linux, Android, or iOS. Pricing is approximately Rs 175-290 per user per month (bring-your-own-license) or Rs 899-1,299 per month (with license). The cloud version includes daily backups and ~99.9% uptime, ensuring your TDS data is always safe and accessible.
Next Steps: Get Expert Help with TDS and 26Q
Filing Form 26Q correctly is non-negotiable for tax compliance. If you are new to TDS or TallyPrime, or if you need help reconciling your TDS records and preparing 26Q, reach out to a Tally 3 Star Certified Partner who can guide you through the process and ensure error-free filing. Global IT Care, a Tally 3 Star Certified Partner in Purnea, Bihar since 2010, specializes in TDS setup, reconciliation, and 26Q compliance for businesses of all sizes. Contact us today at +91 75469 00951 to schedule a consultation and ensure your TDS returns are filed on time and accurately.
Frequently asked questions
What is Form 26Q in TDS filing?
Form 26Q is the quarterly TDS return filed by deductors of tax on payments made to contractors, professionals, and other specified categories. It reports TDS deducted and deposited during the quarter.
How do I enable TDS in TallyPrime?
Go to Gateway of Tally > F11 (Features) > Statutory and Taxation > Tax Deduction at Source (TDS) > Set to Yes. Save and restart TallyPrime to activate TDS ledgers and reports.
What is the filing deadline for 26Q?
Form 26Q must be filed within 15 days of the end of each quarter. For Q1 (Apr-Jun), deadline is 15 July; Q2 (Jul-Sep) is 15 Oct; Q3 (Oct-Dec) is 15 Jan; Q4 (Jan-Mar) is 15 Apr.
Can TallyPrime generate 26Q automatically?
TallyPrime generates TDS reports and reconciliation data, but the actual 26Q XML file must be prepared using the TRACES portal or certified software. TallyPrime provides the source data for compliance.
What ledgers do I need for TDS deduction on contractors?
Create a TDS ledger under TDS Deductible > Contractor (e.g., TDS on Contractor @ 1%). Link it to voucher entries when you pay contractors. TallyPrime will auto-calculate and track deductions.
How do I reconcile TDS in TallyPrime?
Use Gateway of Tally > Display More Reports > TDS Reports > TDS Reconciliation or Alt+G then TDS. Match deducted amounts with TDS challan payments and bank deposits to ensure accuracy before filing 26Q.