Learn how to efficiently compute your Income Tax Return using Excel for FY 2025-26. This guide covers essential formats, calculations, and tips to ensure accurate filing.
Understanding ITR Computation
Excel Format for ITR
Tax Deductions and Savings
Worked Example
FAQs on ITR Computation
A foundational overview of ITR computation for FY 2025-26.
Key Components of ITR
Learn about the essential components involved in ITR computation.
Gross Total Income: Sum of all income heads before deductions.
Deductions: Reductions under sections like 80C, 80D.
Taxable Income: Gross Total Income minus deductions.
ITR Forms Applicable
Identify the correct ITR form based on your income sources.
ITR-1: For individuals with income up to ₹50 lakh from salary, one house property.
ITR-2: For individuals and HUFs not having income from business or profession.
ITR-3: For individuals and HUFs having income from business or profession.
Filing Deadlines
Important dates to remember for timely ITR filing.
Individual taxpayers: July 31, 2026.
Audit cases: October 31, 2026.
Revised/Belated returns: December 31, 2026.
New vs Old Tax Regime
Choose between the new and old tax regimes based on your financial situation.
Old Regime: Allows deductions like ₹1.5 lakh under Section 80C.
New Regime: Lower tax rates but fewer deductions.
Comparison: Evaluate which regime offers better tax savings.
How to set up and use Excel for ITR computation.
Setting Up Excel
Initial steps to prepare your Excel sheet for ITR computation.
Create separate sheets for income, deductions, and tax calculation.
Use formulas to automate calculations for accuracy.
Ensure data validation to minimize errors.
Income Calculation
Steps to accurately calculate income using Excel.
List all income sources under respective heads.
Use SUM function to calculate total income.
Cross-verify with Form 16 or other income proofs.
Deductions and Exemptions
Input and calculate deductions to reduce taxable income.
Enter eligible deductions under sections like 80C, 80D.
Use IF functions to apply conditional deductions.
Ensure total deductions do not exceed limits.
Final Tax Calculation
Compute final tax liability using Excel.
Apply tax rates as per chosen regime.
Calculate rebate under Section 87A if applicable.
Verify tax liability with online calculators for accuracy.
Maximize your tax savings with these deductions.
Section 80C Deductions
Utilize Section 80C to reduce taxable income.
Invest in PPF, ELSS, or NSC up to ₹1.5 lakh.
Include tuition fees for children.
Consider home loan principal repayment.
Health Insurance under Section 80D
Claim deductions for health insurance premiums.
Up to ₹25,000 for self and family.
Additional ₹25,000 for parents below 60 years.
₹50,000 for senior citizen parents.
Home Loan Interest under Section 24
Deduct interest paid on home loans.
Up to ₹2 lakh for self-occupied property.
No limit for let-out property.
Ensure interest certificate from lender.
Education Loan under Section 80E
Claim interest on education loans.
No upper limit on interest deduction.
Loan must be for higher education.
Available for 8 years from loan repayment start.
A practical example to illustrate ITR computation.
Scenario Overview
Assume an individual with specific income and deductions.
Annual salary: ₹10 lakh.
Deductions: ₹1.5 lakh under Section 80C.
Health insurance: ₹20,000 under Section 80D.
Income and Deductions Calculation
Calculate taxable income after deductions.
Gross Total Income: ₹10 lakh.
Total Deductions: ₹1.7 lakh.
Taxable Income: ₹8.3 lakh.
Tax Liability Calculation
Compute tax liability under both regimes.
Old Regime: ₹72,500 after deductions.
New Regime: ₹62,500 without deductions.
Choose regime with lower tax liability.
What is the deadline for filing ITR for FY 2025-26?
The deadline for filing ITR for individual taxpayers for FY 2025-26 is July 31, 2026. For audit cases, the deadline is October 31, 2026.
Which ITR form should I use if I have salary income and one house property?
If you have salary income and one house property, you should use ITR-1, provided your total income does not exceed ₹50 lakh.
Can I claim deductions under both old and new tax regimes?
No, under the new tax regime, you cannot claim most deductions like 80C, 80D. The old regime allows these deductions, but you must choose one regime per financial year.
How do I calculate tax under the new regime?
Under the new regime, calculate tax using the lower tax rates without claiming deductions. Compare with the old regime to see which is more beneficial.
What is the maximum deduction under Section 80C?
The maximum deduction under Section 80C is ₹1.5 lakh. This includes investments in PPF, ELSS, NSC, and other eligible instruments.
Are there any benefits for senior citizens in tax filing?
Yes, senior citizens can claim higher deductions on health insurance premiums under Section 80D and have a higher basic exemption limit of ₹3 lakh.
What documents are needed for ITR filing?
You need Form 16, investment proofs, bank statements, and any other relevant documents to support your income and deductions.
Can I revise my ITR after filing?
Yes, you can revise your ITR before December 31, 2026, if you discover any errors or omissions in your original return.
Is it mandatory to file ITR if my income is below the taxable limit?
Filing ITR is not mandatory if your income is below the taxable limit, but it is advisable for record-keeping and to claim refunds if applicable.
What are the penalties for late filing of ITR?
A penalty of ₹5,000 is levied for late filing of ITR if filed after the due date but before December 31, 2026. After this, the penalty increases to ₹10,000.