Income Tax Calculator AY 2023-24 Excel [DOWNLOAD]

Please fill below form to download Income Tax Calculator AY 2023-24 in Excel. Once you provide details, you will be provided with link to download excel via Email. Also, read the instructions to use this Income Tax Excel Calculator. This excel calculator helps you to calculate income tax if you are salaried employee or business man.

Check out More online Calculators here including Income Tax, PPF, SIP, Home Loan Calculator and many more..

Note: This calculator is applicable for AY 2023-24. There were no changes made in Budget 2022, so the income tax slab rates remain same for Old and New Tax Regime.

Income Tax Calculator FY 2021-22 Excel — Income Tax Calculator AY 2023-24 Excel

Instructions to use Income Tax Excel Calculator AY 2023-24:

Download the Income Tax Calculator AY 2023-24 Excel on your device
Provide Income as Gross Income for AY 2023-24
Provide Investments including Standard Deduction, Section 80C investments, Section 80CCD(1B) investments and other tax saving options you are eligible for. Total amount of investments need to be entered. Standard Deduction of Rs. 50,000 is applicable for Employees.
Enter TDS amount that is already deducted from your salary in financial year
After providing all these parameters, income tax will be calculated based on Old and New Tax Regime

You can find more income tax calculation examples here

Now since you got the idea about how this excel calculator works, let’s see How to calculate Income Tax AY 2023-24 with the help of a video.

Income Tax Calculation AY 2023-24 Excel Video

Watch more Excel Videos Here

Also in case you want to use Online income tax calculator use below link instead of using excel calculator:

How this Income Tax Calculator in Excel helps you?

This income tax calculator helps you to understand your income tax based on Old and New Tax Regime.
Based on the calculations, you can choose which Tax regime you should choose. You should select tax regime based on which you’ll be paying less income tax.
It is important to note that investment deductions are available only in Old Tax Regime.
New Tax Regime does not allow you to claim any investment deductions to save income tax. This is because new tax regime are reduced tax slab rates.
This means that Standard Deductions of Rs. 50,000 is only available in Old Tax Regime, and not in New Tax Regime
In this way, the calculator can help you to compare your tax outgo and by iteratively entering the investment amount, you can decide how much you can invest more to pay less income tax if selecting Old Tax Regime.

Old Tax Regime vs New Tax Regime Slab Rates

Below is the table showing Old and New Tax Slab Rates for AY 2023-24:

Income	Old Tax Regime	New Tax Regime
Rs. 0 to Rs. 2.5 Lacs	0%	0%
Rs. 2.5 Lacs to Rs. 5 Lacs	5%	5%
Rs. 5 Lacs to Rs. 7.5 Lacs	20%	10%
Rs. 7.5 Lacs to Rs. 10 Lacs	20%	15%
Rs. 10 Lacs to Rs. 12.5 Lacs	30%	20%
Rs. 12.5 Lacs to Rs. 15 Lacs	30%	25%
more than Rs. 15 Lacs	30%	30%

Tax Slab Rates to calculate Income Tax AY 2023-24

As seen above, New Tax regime has reduced tax slab rates which means you will be paying less income tax, if you are not opting for any investment deductions.

In case you want to claim various deductions to save income tax, you might have to check how much income tax can be saved using Old Tax Regime.

ALSO READ: Income Tax Brackets in India

Which Tax Regime you should choose?

To answer this question, it depends on person to person. Every individual is having different incomes in a Financial Year.

If your income is in the range of Rs. 5 Lacs to Rs. 12 Lacs, you can opt for Old Tax Regime, and make some Tax saving investments and Save Income Tax.

But if your income is above Rs. 12 Lacs, there is not much option to save maximum income tax. Even after making investments with maximum limits in different sections, you’ll still be paying more taxes with old tax regime compared to new tax regime.

Below is the graph showing the comparison of income vs income tax:

Income vs income tax graph with investments

As seen above, green line depicts income tax with new tax regime, which is low when your income moves greater than 12 Lacs. Blue line (old regime with investments) is still above green line which shows that even after investments you’ll more more income tax with old slab rates compared to new slab rates.

So you should make your investments according to your total income and based on the calculations of income tax in both regimes. Choose the one that helps you pay less income tax.

ALSO READ: Income Tax Calculation FY 2022-23 in Excel

What is the new income tax calculation formula in Excel?

In Budget 2020, new tax regime was introduced with no deductions to be claimed. But Old tax regime is also applicable since than and you have the option to choose between these 2 options of old and new tax regime to pay income tax.

Using tax calculation formula in Excel (provided above), you can calculate tax liability based on below steps:

5% tax calculation on income between 2.5 to 5 lakh in both regimes. Formula will be 5% * 2.5 lakh / 100
10% tax calculation on income between 5 lak to 7.5 lakh in new regime. Formula will be 10% * 2.5 lakh / 100
Similarly for various slab rates and incomes, the tax calculation will be done based on such formula
Finally cess of 4% will be applicable on the intermediate tax calculated

Are you eligible for Tax Rebate u/s 87A?

You will be eligible for Tax Rebate u/s 87A when your taxable income is below Rs. 5 lacs in AY 2023-24. This is achievable by making investments under various sections.

Tax Rebate u/s 87A will be allowed in both Old and New Tax Regime.

Example

Let’s say your Net Taxable Income equals Rs. 5 Lacs in AY 2023-24

Based on Old and New Tax Slab Rates, you are liable to pay Rs. 12,500 as Income Tax based on your Net Taxable Income.

But we also have Tax Rebate u/s 87A which provides us a maximum rebate of Rs. 12,500, thus making our Income Tax = Rs. 0.

Find more Income Tax Calculation examples here.

How to pay ZERO Income Tax?

Using above trick of getting your Taxable income to below Rs. 5 lacs in FY, you need not have to pay any income tax, and by making investments, you save for your future as well. So it’s a win-win situation.

This is possible only when your total income is up to 10-12 lacs in a financial year and you are able to use all available investment options present. If your income goes above this figure in FY, it becomes difficult to save maximum income tax. Again, you can check by yourself using the Income Tax Calculator in Excel I have provided above.

Watch below video to know various tax saving options:

Watch more Excel Videos Here

That’s it in this article about income tax calculator AY 2023-24 in excel. Comment your queries in case you have any. Make sure that you Subscribe to YouTube Channel for more Personal Finance Videos and Download Income Tax Calculator App “FinCalC” on your mobile.

Conclusion

You can easily download income tax calculator AY 2023-24 in excel using above form. Make sure that you watch the video at the start of this article to know how to use this tax calculator.

Some more Reading:

Get EARLY Retirement!

Use Retirement Excel Calculator that will help you to Retire Early.
Click below button to download Retirement Calculator in Excel:

Watch how Retirement Calculator in Excel Works

Income Tax Calculator App – FinCalC

For Income Tax Calculation on your mobile device, you can Download my Android App “FinCalC” which I have developed for you to make your income tax calculation easy.

What you can do with this mobile App?

Calculate Income Tax for new FY 2024-25 and previous FY 2023-24
Enter estimated Investments to check income tax with Old and New Tax Regime
Save income tax details and track regularly
Know how much to invest more to save income tax
More calculators including PPF, SIP returns, Savings account interest and lot more

Download Income Tax Calculator APP from play store

Use Popular Calculators:

I’d love to hear from you if you have any queries about Personal Finance and Money Management.

JOIN Telegram Group and stay updated with latest Personal Finance News and Topics.

Download our Free Android App – FinCalC to Calculate Income Tax and Interest on various small Saving Schemes in India including PPF, NSC, SIP and lot more.

Follow the Blog and Subscribe to YouTube Channel to stay updated about Personal Finance and Money Management topics.

2 thoughts on “Income Tax Calculator AY 2023-24 Excel [DOWNLOAD]”

Anand Miryala
February 1, 2023 at 2:06 pm
Where are you handling employee PF contribution, Standard deduction, Professional tax etc.
1. admin
  February 1, 2023 at 5:32 pm
  please provide all deductions under investment label

Comments are closed.