TDS Form 138 (Erstwhile Form 24Q) Software FY 2026-27 by Vijayakumar Kota Medakbadi (Q1, Q2, Q3)

TDS Form 138 (Erstwhile Form 24Q) Software FY 2026-27 by Vijayakumar Kota Medakbadi (Q1, Q2, Q3) (As per Income-tax Act 2025)   14.07.2026

I am pleased to announce the release of my TDS Excel Software, prepared in line with the Revised Income Tax Act 2025. This tool is designed specifically for Form 138 (previously known as Form 24Q) to simplify the filing of TDS for Q1 in FY 2026–27.

🔹 Key Highlights

• Fully compliant with Revised Act 2025 requirements.

• Supports Form 138 format for Q1 to Q3 filing.

• Automated calculations to reduce manual errors.

• User‑friendly Excel interface for quick data entry.

• Developed and tested for accuracy by Medakbadi Kota Vijayakumar.

📂 Auto Import Gross & Tax Deductions (Quarter‑wise)

This Excel utility is designed to automatically import Gross Income and Tax Deduction data from IFMIS reports into the master file, eliminating manual entry in the “SALARY DATA” sheet:

1. Log in to IFMIS Access your IFMIS portal with valid credentials.

2. Go to Bill Section Module Navigate to the Bill Section in the dashboard.

3. Click on Report Select the Report option from the menu.

4. Choose IT Deduction Reports In the report list, select IT Deduction Reports.

5. Select Month & Year Pick the required Month and Year for the quarter.

6. Click Get Report Generate the report for the selected period.

7. Download Report Download the report file for each month.

8. Repeat for 3 Months Download reports for all three months in the quarter.

9. Rename Files by Month Number Example:

   • May → 5

   • June → 6

   • July → 7

10. Open All 3 Excel Files Launch the downloaded Excel files.

11. Copy Yellow‑Colored Columns From each file, copy the Gross & Advance Tax columns (highlighted in yellow).

12. Paste into Master File In the SALARY DATA sheet of the master file:

    • Use Paste Special → Values Only

    • Paste all three months together.

✅ This process ensures automatic quarter‑wise import of Gross & Tax data from IFMIS into your Excel utility, eliminating manual entry errors.

🔹 Why This Software?
Filing TDS returns can be complex, especially with frequent updates in tax laws. This Excel‑based solution ensures:
Accuracy in deductions and reporting.
Time savings with automated formulas.
Ease of use for Government DDOs of Andhra Pradesh and Telangana.
🔹 Availability
The software is now available for Government Drawing and Disbursing Officers (DDOs) preparing TDS Q1 returns for FY 2026–27.
👉 Prepared by: Kota Vijayakumar (Medakbadi)
👉 Purpose: Simplifying TDS compliance under the Revised Act 2025

Mandatory Filing Timelines

Excel Utilities and Return Preparation Utilities (RPU) must structure your data according to specific quarterly deadlines to avoid penalty defaults.

Quarter	Period Covered	Filing Due Date
Q1	April – June	31st July of the Financial Year
Q2	July – September	31st October of the Financial Year
Q3	October –December	31st January of the Financial Year
Q4	January – March	31st May of the subsequent Financial Year

⚠️ Penalty for Late Filing

Failure to file TDS returns within the prescribed timelines can attract penalties under the Income Tax Act:

• Late Filing Fee (Section 234E): ₹200 per day until the return is filed, subject to the maximum of the TDS amount.

• Penalty (Section 271H): Ranging from ₹10,000 to ₹1,00,000 for:

  • Not filing the return within due date.

  • Furnishing incorrect details such as PAN, challan, or deduction amounts.

• Interest (Section 201A): Applicable if TDS is not deducted or not deposited on time.

👉 To avoid these penalties, ensure timely filing of Form 138 (previously Form 24Q) as per the revised deadlines.

💡 Note to Users: If you find any errors while using this software, please comment on this Blogger page. Your feedback will help me rectify issues and ensure an error‑free version for everyone.