How to Calculate Income Tax on Salary with Example in Excel

calculate tax on salary payslip example video

One of the most asked question on my YouTube channel is how to calculate income tax on salary in excel and how to calculate taxable income when someone is a salaried employee? It is very important to understand various factors while calculating taxable income which will help us to calculate income tax. Many other queries will be solved in this article – how to calculate income tax for salaried employee in excel, investment options available to save income tax, can you opt for new tax regime in next financial year, etc.

For salaried employees, we first calculate taxable income by segregating the various deductions such as EPF (Employee provident fund), NPS contribution from employer, HRA deduction and other investment options used by us from our income, in case we are opting for old tax regime. If we are opting for new tax regime, we won’t be able to claim deductions to save income tax so our entire gross income becomes our taxable income.

We will also see whether we should choose Old Tax regime or New Tax regime in case of salaried employee and which one will be beneficial.

Download Income Tax Excel Calculator

Please fill below details to DOWNLOAD Income Tax Calculator in Excel:

Enter Correct Email ID to receive Excel
If you opt in above, we use this information to send related content

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

Watch below video to know how to calculate income tax on salary payslip with examples

How to Calculate Income Tax on Salary Video

YouTube player

Watch more Excel Videos Here

Above video helps you to understand every point you should know while calculating your income tax if you are salaried. We have taken a payslip example to understand the process of calculating income tax and what are the different considerations while doing so.

instant calculator click here
Instant Income Tax Calculator

Old Tax Regime vs New Tax Regime

Let us first start with knowing the various Tax Slabs for Old Tax regime and New Tax regime.

Tax Slab Rates for people below 60 years:

Income Tax Slab Rates - Age below 60 years
Income Tax Slab Rates – Age below 60 years

As seen above, for FY 2024-25, there are 2 slab rates based on Old and New Tax Regime.

Old tax rates are greater compared to New Tax rates. But with New tax rates, you won’t be able to claim any deductions available to reduce your taxable income if you want to save income tax.

Further, New Tax rates have 7 slabs under it based on the income bracket you belong to, whereas, old tax rates have 4 slabs based on your income bracket.

In case you are calculating your income tax for the first time, let’s understand how these tax rates work. Let’s say your income is Rs. 11 Lakh in FY 2024-25. This does not mean you pay 30% on entire Rs. 11 Lacs of your income. Assuming that we are not considering any deductions in this case apart from Standard Deduction = Rs. 50,000 and your gross income is Rs. 11 Lakh:

Old Tax Regime
(with Standard deduction = Rs. 50,000, Taxable Income = Rs. 10.5 Lakh)

  • You won’t pay any tax on income up to Rs. 2.5 Lacs
  • Between Rs. 2.5 Lacs to Rs. 5 Lacs, 5% Tax is applicable = Rs. 12,500 (5% on Rs. 2.5 Lacs difference)
  • Between Rs. 5 Lacs to Rs. 10 Lacs, 20% Tax is applicable = Rs. 1,00,000 (20% on Rs. 5 Lacs difference)
  • Between Rs. 10 Lacs to Rs. 10.5 Lacs, 30% Tax is applicable = Rs. 15,000 (30% on Rs. 50,000 difference)
  • After adding above taxes = Rs. 1,27,500, 4% cess is applicable which is Rs. 5100
  • You total income tax = Rs. 1,32,600 considering taxable income of Rs. 10.5 Lacs after deducting standard deduction = Rs. 50,000

New Tax Regime
(with Standard Deduction = Rs. 75,000, Taxable Income = Rs. 10.25 Lacs)

  • In this case your taxable income = Rs. 10.25 Lacs
  • Standard deduction will be applicable in new tax regime for FY 2024-25
  • You won’t pay any tax on income up to Rs. 3 Lacs
  • Between Rs. 3 Lacs to Rs. 7 Lacs, 5% Tax is applicable = Rs. 20,000 (5% on Rs. 4 Lacs difference)
  • Between Rs. 7 Lacs to Rs. 10 Lacs, 10% Tax is applicable = Rs. 30,000 (10% on Rs. 3 Lacs difference)
  • Between Rs. 10 Lacs to Rs. 10.25 Lacs, 15% Tax is applicable = Rs. 3,750 (15% on Rs. 25,000 difference)
  • After adding above taxes = Rs. 53,750, 4% cess is applicable which is Rs. 2150
  • You total income tax = Rs. 55,900 considering taxable income of Rs. 10.25 Lacs

As seen above, you pay high income tax with income = Rs. 11 Lacs and if you opt for Old Tax Regime. This is because we have not considered any investment options for deductions to save our income tax. How much income tax can be saved with Old Tax Regime depends on the investments we can make. Read more about Tax Saving Options with Old Tax Regime.

Below is the screenshot of above calculations in Excel:

Income Tax Calculation on Salary in Excel Example
Income Tax Calculation on Salary in Excel Example

Note: Under investments, we have mentioned Rs. 50,000 as standard deduction. This amount is applicable in Old Tax Regime and and Rs. 75,000 standard deduction is available in New Tax Regime for FY 2024-25.

Love Reading Books? Here are some of the Best Books you can Read: (WITH LINKS)

More Recommended Books Here

How to calculate Taxable Income

Since now you have understood how income tax calculation works in both Tax regime, it is now time to understand how to calculate taxable income.

For Old Tax regime, as we saw above, the entire income you earn is not taxable, since you are allowed to make required investments to be claimed so that you can save income tax. These investment options can be claimed only in old tax regime and not in new tax regime.

Now what are these deductions? Below are some of them:

  • EPF – Every month, EPF (Employee Provident Fund) amount is deducted from salary. This amount can be claimed under section 80C and appropriate amount can be deducted from our total income to reach taxable income
  • NPS – In case your employer contributes in NPS on your behalf, you can claim this under Section 80CCD to reach your taxable income
  • Section 80C – This includes various options including Life insurance, 5 year fixed deposits, ELSS (Equity linked saving scheme), Home loan EMI payments, PPF (Public Provident Fund), etc.
  • HRAHouse Rent Allowance. If you notice your payslip is having an entry of HRA allowance. This is the allowance you get to pay for rented accommodation you stay in. So if you actually stay on rent, you can claim this HRA allowance to reduce taxable income so that your income tax is saved!

So these are some of the deduction options available to save income tax. Watch below video to know more:

YouTube player

Example Salary – Rs. 5 Lacs

Let us now understand how Old and New Tax regime calculates income tax on various income starting from Rs. 5 Lacs in a financial year. Below are the numbers in action with standard deduction applied in investments:

How to Calculate Income Tax on Salary Rs. 5 Lacs
How to Calculate Income Tax on Salary Rs. 5 Lacs

As seen above, you get tax rebate under section 87A, that cancels the income tax and makes your effective income tax = Rs. 0 in both old and new tax regime.

Note: Tax Rebate 87A is applicable when your taxable income is less than or equal to Rs. 5 Lacs. with Old Tax regime and less than Rs. 7 lacs with new tax regime.

Example Salary – Rs. 10 Lacs

Below is the screenshot if income – Rs. 10 Lacs with standard deduction applied in investments:

How to Calculate Income Tax on Salary Rs. 10 Lacs
How to Calculate Income Tax on Salary Rs. 10 Lacs

As seen above, you pay less income tax with New Tax regime. Here we have not considered any other deductions apart from standard deduction.

But what if we consider Rs. 1.5 Lacs deduction under section 80C, Rs. 50,000 under section 80CCD(1B) in NPS and Rs. 1 Lakh as HRA (House Rent Allowance), which makes total investments = Rs. 3.5 Lacs with standard deduction? Let’ see how the stats looks like:

How to Calculate Income Tax on Salary Rs. 10 Lacs with Investments
How to Calculate Income Tax on Salary Rs. 10 Lacs with Investments

As seen above, after making required investments, we pay same income tax with old tax regime and new tax regime. This proves that it is very important to check if after making investments, how much tax we will be paying with Old or New Tax regime. You can make more investments to save income tax under old tax regime

ALSO READ: Mutual Funds Return Calculator using Excel

Choose between Old or New Tax Regime

The most important question is whether to choose Old Tax regime or New Tax regime while calculating income tax?

The simple answer is to use the excel calculator I have provided in order to check income tax using Old and New regime based on your estimated yearly income and investments you are planning to make. This will help you to know which tax regime will help you to pay less income tax. You can also use this instant income tax calculator I have made for you to check your income tax

Conclusion

As seen in examples and videos above, it is very important to analyze your income tax based on old or new tax regime if you are a salaried employee. Based on your yearly income and investments, you can reach an estimate of income tax and choose whether you should opt for old tax regime or new tax regime.

Up to a certain limit, old tax regime is beneficial if you are making investments to save income tax. And after this cut off limit, new tax regime will be beneficial since it has reduced tax slab rates. It entirely depends on each individual’s income and investments that they make to choose between Old or new tax regime.

Some more Videos

YouTube player

YouTube player

YouTube player

Some more Reading:

SHOW your Support!

Found this Helpful? DONATE any amount to see more useful Content. Scan below QR code using any UPI App!

fincalc donate

UPI ID: abhilashgupta8149-1@okhdfcbank

Verify that you are “Paying Abhilash Gupta” before making the transaction so that it reaches me. It makes my Day 🙂

Thank you for Donating. Stay Tuned!

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 2023-24 and previous FY 2022-23
  • 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
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.


Leave a Comment

Your email address will not be published. Required fields are marked *