EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login
Home Excel Excel Resources Maths Function in Excel Calculate Income Tax in Excel
Secondary Sidebar
Excel Functions
  • Maths Function in Excel
    • Calculating Investment Return In Excel
    • Sumif Function Examples
    • MROUND in Excel
    • SUM Cells in Excel
    • MMULT in Excel
    • MINVERSE in Excel
    • Trunc in Excel
    • SUMIF with Text
    • COS Function in Excel
    • RANDBETWEEN in Excel
    • Excel SUMIF with OR
    • Excel DEGREES Function
    • Calculations in Excel
    • Sumif Between Two Dates
    • Calculate Income Tax in Excel
    • PRODUCT Function in Excel
    • How to Sum Multiple Rows in Excel
    • Matrix in Excel
    • ROUND Formula in Excel
    • How to SUM in Excel
    • SUMPRODUCT Formula in Excel
    • Excel Running Total
    • Excel Rounding
    • Excel Exponents
    • Excel SIN Function
    • Excel Square Root Function
    • Excel ROUNDUP Function
    • ROUND Excel Function
    • Excel ROUNDDOWN Function
    • ODD Excel Function
    • SUMPRODUCT Function in Excel
    • AGGREGATE Function in Excel
    • ABS Function in Excel
    • Excel TAN Function
    • COMBIN Function in Excel
    • CEILING Function in Excel
    • INT Excel Function
    • SUBTOTAL Function in Excel
    • LN Function in Excel
    • Excel RAND Function
    • TANH Function in Excel
    • SUMIF Function in Excel
    • SUM Function in Excel
    • POWER Function in Excel
    • EVEN Function in Excel
    • LOG Function in Excel
    • FLOOR Excel Function
  • Excel Functions (12+)
  • Excel Tools (114+)
  • Financial Functions in Excel (17+)
  • Logical Functions in Excel (14+)
  • Lookup and Reference Functions in Excel (36+)
  • TEXT and String Functions in Excel (26+)
  • Date and Time Function in Excel (24+)
  • Statistical Functions in Excel (59+)
  • Information Functions in Excel (4+)
  • Excel Charts (56+)
  • Excel Tips (220+)
  • Workplace Productivity (4+)
  • Microsoft Office Tools (15+)
  • Excel Formula and Functions (22+)
  • MS Excel Shortcuts (4+)
Excel Functions Courses
  • Online EXCEL ADVANCED Certification
  • Excel for HR Training

Calculate Income Tax in Excel

By Arun GuptaArun Gupta

Calculate Income Tax in Excel

Calculate Income Tax in Excel (Table Contents)

  • How to Calculate Income Tax in Excel?

Introduction to Income Tax in Excel

A user can calculate n number of things in MS Excel in a few steps; one of them is the calculation of the Income Tax. There are two ways of income tax deduction from the incomes if a user is working in some company, they will deduct all income-related taxes from the user’s salary where the user needs to declare the income tax himself.

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

How to Calculate Income Tax in Excel?

Let’s understand how to Calculate Income Tax in Excel with some examples.

You can download this Calculate Income Tax Excel Template here – Calculate Income Tax Excel Template

Example #1 – Calculate Simple Taxable Income and Income Tax of that Income

Let’s assume Ravi’s income details are given in sheet 1; his salary is 2.5 Lakhs, total exemptions are 75000, total deduction 20000, there will 5 % tax on income below 2.5 Lakhs which the government imposes. Now Ravi wants to calculate his taxable income, and he needs to pay the tax in the current financial year.

Let’s see how a user can calculate his taxable income and income tax.

Step 1: Open MS Excel; now go to Sheet1, where Ravi’s income details are available.

Example 1

Step 2: As the user wants to calculate the taxable income and tax on the income >> create two rows to calculate the taxable income and tax on the income.

Example 1-2

Step 3: First, a user needs to calculate the taxable income >> click on cell B6, subtract the exemptions and deduction amount from the total income >> write the formula in B6 =” B2-B3-B4”. Press the Enter key.

Calculate income tax in excel 1-3

Step 4: Now, Taxable income will come, which is 1.55 Lakh.

Calculate income tax in excel 1-4

Step 5: Now calculate the tax that needs to be paid on the taxable income >> Tax is 5% below 2.5 lakhs income >> Now calculate 5% of the taxable income. Write the formula in cell B7 >> “=B5*5/100”.

calculate the tax

Step 6: Press the Enter key.

Calculate income tax in excel 1-6

Summary of Example 1: As the user wants to calculate his taxable income and the tax need to be paid by him in the current financial year, it is calculated in the above example. Ravi’s taxable income is 1.55 Lakh, and he needs to pay 7750 Rupee as the income tax.

Example #2 – Calculate Taxable Income and Income Tax with Different Tax Slab

Let’s assume a user’s income details are given in sheet 2; his salary is 28 Lakhs, total exemptions are 5.5 Lakhs, total deduction 2.3 Lakhs, the government gives tax slab. Now the user wants to calculate his taxable income and the tax need to pay by him in the current financial year.

Let’s see how a user can calculate his taxable income and income tax needs to as Income tax to the Government.

Step 1: Now go to Sheet2, where the user’s income details and tax slab is given.

Example 2

Step 2: The user wants to calculate the taxable income and tax on the income >> So two rows were created to calculate the taxable income and tax on the income A column.

Step 3: First, a user needs to calculate the taxable income >> click on cell B6, subtract the exemptions and deduction amount from the total income >> write the formula in B6 =” B2-B3-B4”. >> click the enter button.

income Tax Slab 1

Step 4: Now, Taxable income will come, which is 20.20 Lakhs.

income Tax Slab 2

Step 5: Now calculate the tax which needs to be paid on the taxable income >> it is coming in the 4th slab, which is Rs. 20 – 30 Lakhs= 20% >> Now calculate 20% of the taxable income.

income Tax Slab 3

Step 6: Write the formula in cell B7 >> “=B5*20/100”.

Tax on Income

Step 7: Press the Enter key.

 Tax on Income 2

Summary of Example 2: As the user wants to calculate his taxable income and the tax need to be paid by him in the current financial year, it is calculated in the above example the user’s taxable income is 20.20 Lakhs, and he needs to pay 4.04 Lakhs Rupee as Tax as the income tax.

Example #3 – Calculate Taxable Income and Income Tax with Different Tax Slab and Tax Surcharge

Let’s assume a user’s income details are given in sheet3; his salary is 90 Lakhs, total exemptions are 15 Lakhs, total deduction 9.8 Lakhs, Tax slab and surcharge details are given by the government. Now the user wants to calculate his taxable income and the tax need to pay by him in the current financial year.

Let’s see how a user can calculate his taxable income and income tax need to as Income tax to the Government.

Step 1: Now go to Sheet3, where the user’s income details and tax slab is given.

Example 3

Step 2: The user wants to calculate the taxable income and tax on the income >> So two rows are created to calculate the taxable income and tax on the income A column.

Step 3: First, the user needs to calculate the taxable income >> click on B6 Cell subtract the exemptions and deduction amount from the total income >> write the formula in B6 =” B2-B3-B4”. >> click the enter button.

Calculate income tax in excel 3-2

Step 4: Now, Taxable income will come, which is 65.20 Lakhs.

Calculate income tax in excel 3-3

Step 5: Now calculate the tax which needs to pay on the taxable income >> it is coming in the 3rd slab, which is Rs. 10 – 30 Lakhs and above = 30% >> Now calculate 30% of the taxable income. Write the formula in B7 cell >> “=B6*30/100”.

Calculate income tax in excel 3-4

Step 6: Press the Enter key.

Calculate income tax in excel 3-5

Step 7: As the income is more than 50 Lakhs, there will be a 10% Surcharge for Income.

Calculate income tax in excel 3-6

Step 8: Now calculate the total tax need to pay by the user. So, add the tax on income and surcharge taxes.

Calculate income tax in excel 3-7

total tax

Total Tax 1

Summary of Example 3: As the user wanted to calculate his taxable income and the tax need to pay by him in the current financial year, it is calculated in the above example User’s taxable income is 65.20 Lakhs, and he needs to pay 21.516 Lakhs Rupee as Tax as the income tax.

Things to Remember About Calculate Income Tax in Excel

  • Gross total income comes from calculation income from all sources.
  • If a user doesn’t have any type of Exemptions and deduction, then Gross total income will be the same as taxable income.

Recommended Articles

This is a guide to Calculate Income Tax in Excel. Here we discuss How to Calculate Income Tax in Excel along with practical examples and a downloadable excel template. You can also go through our other suggested articles –

  1. NPER Function in Excel
  2. Calculate Compound Interest in Excel
  3. Calculate Percentage Increase in Excel
  4. Excel Calculate Age
Popular Course in this category
MS Excel Training Bundle
  13 Online Courses |  100+ Hours |  Verifiable Certificates |  Lifetime Validity
4.5
Price

View Course

Related Courses

Excel Advanced Training (16 Courses, 23+ Projects)4.9
Excel for HR Training (8 Courses, 10+ Projects)4.8
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

© 2023 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

Download Calculate Income Tax Excel Template

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

Download Calculate Income Tax Excel Template

EDUCBA

डाउनलोड Calculate Income Tax Excel Template

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more