Master TDS Calculation and Quarterly Return Filing Form 26Q in Tally Prime

Tax Deducted at Source (TDS) is a fundamental statutory requirement for businesses operating in India. Managing non-salary vendor payments—such as professional fees, contractor payments, rent, and commission—demands strict compliance with Income Tax provisions. Executing tds calculation and quarterly return filing form 26q in tally prime allows accounting professionals, business owners, and tax consultants to automate tax deductions, reconcile challans, and generate error-free e-TDS return files within minutes.

At Accounting Sikho, we empower accounting learners and finance professionals with practical, job-ready accounting skills. This comprehensive guide walks you step-by-step through configuring masters, passing entries, resolving return exceptions, and exporting your e-TDS return file seamlessly in Tally Prime.

What is Form 26Q and Why is Tally Prime Essential for Filing?

Form 26Q is the mandatory quarterly return filed for all Tax Deducted at Source under Section 200(3) of the Income Tax Act for payments made to resident deductees (excluding salary payments).

Due Dates for Filing Quarterly Form 26Q

To protect your business or clients from late filing fees under Section 234E (₹200 per day of delay) and heavy interest penalties under Section 201(1A), Form 26Q must be filed within the statutory deadlines:

• Quarter 1 (April to June): 31st July

• Quarter 2 (July to September): 31st October

• Quarter 3 (October to December): 31st January

• Quarter 4 (January to March): 31st May

By utilizing Accounting Sikho techniques for tds calculation and quarterly return filing form 26q in tally prime, accountants eliminate manual calculations, automatically track threshold limits, prevent tax deduction errors, and maintain audit-ready financial ledgers.

Step 1: Enabling TDS and Configuring Masters in Tally Prime

Before automating tax calculations, you must activate the statutory features and create the required ledger structure in Tally Prime.

                    [ Press F11: Company Features ]
                                   │
                                   ▼
                   [ Enable "Tax Deducted at Source (TDS)" ]
                                   │
                                   ▼
              [ Configure TAN Details & Deductor Category ]
                                   │
                                   ▼
          ┌────────────────────────┴────────────────────────┐
          ▼                                                 ▼
[ Create TDS Nature of Payment ]              [ Create Party & Duty Ledgers ]
 (Set Section, Code & Rates)                   (Set PAN, Deductee Type & TDS)

1. Enable Statutory Features

1. Go to Gateway of Tally and press F11 (Company Features).

2. Under statutory options, set Enable Tax Deducted at Source (TDS) to Yes.

3. Enter your Tax Deduction Account Number (TAN), TAN Registration Number, Company Deductor Type (Company or Non-Company), and Responsible Person details.

4. Press Ctrl+A to save.

2. Create TDS Nature of Payments

Go to Gateway of Tally > Create > Statutory Masters > TDS Nature of Payments. Set up the applicable nature of payments (e.g., Fees for Professional Services – Sec 194J or Payments to Contractors – Sec 194C):

• Section: 194J

• Payment Code: 94J

• Rate for Individuals/HUF: 10% (or 2% depending on sub-clause)

• Rate for Other Deductee Types: 10%

• Threshold/Exemption Limit: ₹30,000

3. Create Required Ledgers

• Expense Ledger (e.g., Professional Fees Account): Group under Indirect Expenses. Set Is TDS Applicable to Applicable, and select the relevant TDS Nature of Payment.

• Party Ledger (e.g., Tech Solutions Pvt Ltd): Group under Sundry Creditors. Set Is TDS Deductible to Yes, choose Company-Resident under Deductee Type, and enter a valid PAN Number.

• TDS Duty Ledger (e.g., TDS on Professional Fees): Group under Duties & Taxes. Select TDS as Type of Duty/Tax and attach the corresponding TDS Nature of Payment.

Step 2: Recording TDS Expense Vouchers and Deductions

Once your configuration is complete, executing tds calculation and quarterly return filing form 26q in tally prime happens automatically during voucher entry.

Passing a Booking Entry with Auto-Deduction

1. Go to Gateway of Tally > Vouchers > Press F7 (Journal) or F9 (Purchase).

2. Debit your Expense Ledger (e.g., Professional Fees) with the total bill amount (e.g., ₹50,000).

3. Credit your Party Ledger (e.g., Tech Solutions Pvt Ltd). Tally Prime will automatically calculate TDS based on the defined rate (10% of ₹50,000 = ₹5,000) and display the net payable amount to the party (₹45,000).

4. Credit your TDS Duty Ledger (e.g., TDS on Professional Fees) for the deducted amount (₹5,000).

5. Accept the bill-wise allocation screen and press Ctrl+A to save.

Step 3: Paying TDS to the Government and Reconciling Challans

Deducted tax must be deposited with the Central Government using Tax Information Network (TIN) payment portals before the 7th of the following month (except for March deductions, which are due by 30th April).

1. Record the Statutory Payment Entry

1. Go to Gateway of Tally > Vouchers > Press F5 (Payment).

2. Press Auto Fill (Ctrl+F) and select Stat Payment.

3. Set Type of Duty/Tax to TDS, specify the period, section (e.g., 194J), and Deductee Status.

4. Select your Bank Account ledger to auto-populate the TDS duty liability. Save the voucher.

2. Perform TDS Challan Reconciliation

To ensure your tax payments are included in Form 26Q, you must reconcile the payment voucher with actual challan details:

1. Go to Gateway of Tally > Display More Reports > Statutory Reports > TDS Reports > Challan Reconciliation.

2. Select the statutory payment entries recorded for the quarter and press Alt+R (Reconcile).

3. Enter the BSR Code, Challan Number, Challan Date, and Cheque/DD Number.

4. Press Ctrl+A to save.

Step 4: Generating and Correcting Form 26Q in Tally Prime

After recording expenses and reconciling payment challans, you are ready to compute your return.

             ┌───────────────────────────────────────────┐
             │ Navigate: Alt+G (Go To) > Select Form 26Q │
             └─────────────────────┬─────────────────────┘
                                   │
                                   ▼
             ┌───────────────────────────────────────────┐
             │ Check "Uncertain Transactions" Exception  │
             └─────────────────────┬─────────────────────┘
                        ┌──────────┴──────────┐
                        ▼                     ▼
               [ Exceptions Found ]    [ Zero Exceptions ]
                        │                     │
                        ▼                     │
               [ Resolve PAN/Nature ]         │
                        │                     │
                        └──────────┬──────────┘
                                   │
                                   ▼
             ┌───────────────────────────────────────────┐
             │  Press Alt+B (Save Return) to Lock Report │
             └─────────────────────┬─────────────────────┘
                                   │
                                   ▼
             ┌───────────────────────────────────────────┐
             │ Press Alt+E > Export e-Return Text File   │
             └───────────────────────────────────────────┘

Viewing the Form 26Q Report

1. Press Alt+G (Go To), type Form 26Q, and press Enter.

2. Set the desired period using F2 (Period) (e.g., 1-Jul to 30-Sep for Q2).

Resolving Uncertain Transactions / Exceptions

Tally Prime categorizes transactions into three clear groups:

• Included in Return: Vouchers with complete information ready for return filing.

• Not Relevant in this Return: Non-TDS or salary entries.

• Uncertain Transactions (Corrections Needed): Vouchers missing mandatory fields (e.g., invalid PAN, unlinked duty ledgers, or unselected deductee types).

Drill down into Uncertain Transactions, correct missing details directly from the screen, and press Ctrl+A. Once the exception count drops to zero, your report is verified.

Step 5: Exporting the e-TDS File and Validating via NSDL FVU

After finalizing the report, you must generate the text file required for official submission.

1. In the Form 26Q screen, press Alt+B (Save Return) to lock your return statistics.

2. Press Alt+E (Export) and choose E-Return.

3. Select SDF (Fixed Width) as your file format, set the export destination path, and enter the responsible person details.

4. Export the file to generate your official .txt return file.

5. Download the latest File Validation Utility (FVU) software from the NSDL/Protean e-Gov website.

6. Load your exported .txt file along with the corresponding .csi (Challan Input File downloaded from the Income Tax Portal) into the FVU utility.

7. Click Validate. Upon successful validation, the utility generates the .fvu file and Form 27A. Submit the .fvu file via the Income Tax e-Filing portal.

Key Benefits of Using Tally Prime for Form 26Q Returns

Frequently Asked Questions (FAQs)

What happens if I export Form 26Q without resolving Uncertain Transactions?

If you export Form 26Q with unresolved exceptions, incomplete entries will be excluded from the e-TDS file. This can lead to short-deduction notices or uncredited TDS for deductees on Form 26AS/AIS. AccountingSikho recommends clearing all exceptions before saving and exporting.

How does Tally Prime handle higher TDS deduction for non-filers of income tax returns?

Tally Prime allows you to set customized tax deduction rates within the party master or override rates directly during voucher entry to comply with higher rates applicable under tax regulations.

Can I revise Form 26Q in Tally Prime after altering previous entries?

Yes. If you make ledger changes after saving a return, reopen the Form 26Q report in Tally Prime. The system will alert you to value shifts and allow you to press Alt+W (Recompute) and save the file as a revised return.

Why is my payment entry missing from Form 26Q in Tally Prime?

Payment entries will not populate in Form 26Q deductor details unless you complete the Challan Reconciliation step. Enter your BSR code, challan number, and date via the Challan Reconciliation screen to link statutory payments to deductee vouchers.

Mastering tds calculation and quarterly return filing form 26q in tally prime ensures error-free compliance and seamless tax management. Build your professional accounting expertise, gain practical software knowledge, and stay ahead in your career with interactive tutorials and expert courses at Accounting Sikho.