Paperwork

5 Steps to Calculate Income Tax in Excel for India

5 Steps to Calculate Income Tax in Excel for India
How To Calculate Income Tax In Excel Sheet India

Step 1: Understand Your Taxable Income

2021 Tax Brackets Calculator Sapphobucci

In India, your taxable income is the amount you earn minus the deductions and exemptions allowed by the Income Tax Department. This includes income from salary, house property, capital gains, and other sources. Begin by summing up all your earnings for the financial year.

Here’s how to calculate:

  • Salary: Sum total of basic salary, allowances, and bonuses.
  • House Property: If you own a property, include rental income after deductions like interest on home loan and standard deduction.
  • Capital Gains: Profits from the sale of investments or property.
  • Other Income: Includes interest on savings, dividends, and more.
Understanding Taxable Income

Step 2: Apply Deductions

Income Tax Calculator Ay 2023 24 Excel Free Download India 2023 Printable Calendar

Deductions help reduce your taxable income. Here are some common deductions you might claim:

  • Section 80C: Investment in PPF, ELSS, EPF, life insurance premiums, and more (up to INR 1.5 lakh).
  • Section 80D: Medical insurance premiums.
  • Section 24(b): Interest on home loan for self-occupied property.

Calculate these deductions and subtract them from your gross income to get your net taxable income.

📝 Note: Keep your proofs of investments and expenditures for deductions; these are vital for verification during an audit.

Step 3: Choose the Right Tax Regime

How To Calculate Ta Da Income Tax Grand Total In Excel Part 1 Youtube

India offers two tax regimes for individuals: the old regime with numerous deductions and exemptions, and the new regime with reduced tax rates but fewer deductions. Here’s how to decide:

Parameter Old Tax Regime New Tax Regime
Exemptions/Deductions Many Fewer
Tax Rates Higher but with deductions Lower but less flexible
Income Tax Calculation For Fy 2023 24 Examples Fincalc Blog

Evaluate which regime benefits you more based on your income and available deductions.

Step 4: Calculate Tax Liability

Tds Tax India Income Tax Excel Based Income Tax Calculation For The

Using the appropriate tax slabs, calculate your tax based on your net taxable income. Here are the steps:

  • Apply the tax rates to each slab of your income.
  • Add cess and surcharge, if applicable. Currently, a 4% health and education cess is added to the total tax payable.
  • If applicable, subtract any tax rebate, like Section 87A.

Example: Suppose your taxable income under the old regime is INR 9 lakh.

  • Tax up to INR 5 lakh: INR 12,500 (including 4% cess).
  • Tax from INR 5 lakh to INR 7.5 lakh: INR 12,500 (20% x INR 2.5 lakh)
  • Tax from INR 7.5 lakh to INR 9 lakh: INR 5,000 (25% x INR 1.5 lakh)
  • Total tax before cess: INR 30,000. After adding cess: INR 31,200.

💡 Note: Tax rates change periodically, so always refer to the latest tax slabs for the most accurate calculation.

Step 5: Fill Out Form 26AS and Schedule Other Information in ITR

How To Calculate Income Tax On Salary With Example In Excel

Before filing your tax return, reconcile your tax payment details with Form 26AS, which is the Annual Tax Statement.

  • Download Form 26AS from the income tax e-filing portal.
  • Ensure the TDS, advance tax, and self-assessment tax paid are correctly reflected.
  • Input all the figures into your ITR form accurately.

The 'Schedule Other Information' in your ITR helps in reporting income not accounted for in your TDS certificates or if there are discrepancies.

To wrap up, calculating income tax in India involves a series of steps from understanding your income sources to choosing the right tax regime and finally ensuring all tax payments are correctly recorded. This comprehensive guide should help you navigate through the tax calculations efficiently, ensuring you comply with Indian tax laws while optimizing your tax savings.

The entire process, when done correctly, not only helps in reducing your tax liability but also in managing your finances better. By employing the above steps, you will gain insights into your financial health, allowing for better planning for the future, and ensuring compliance with the tax regulations set by the government.

What if I switch between the old and new tax regimes?

Income Tax 2021 Calculator
+

You can switch between the regimes annually, but remember that once you opt for the new regime, you can switch back to the old one only if you have no business income.

Are there any tax-saving investments I can make?

Video How To Calculate Income Tax In Fy 2021 22 On Salary Examples New Slab Rates Amp Rebate
+

Yes, consider investments like ELSS, PPF, EPF, and Sukanya Samriddhi Yojana under Section 80C, which can save up to INR 1.5 lakh annually on your tax.

How do I handle discrepancies in Form 26AS?

Calculating Income Tax Using Excel Easy Method Youtube
+

Report the discrepancies in your ITR form under ‘Schedule Other Information’, providing details of unreflected or incorrect TDS, ensuring accurate tax assessment.

Related Articles

Back to top button