Sponsored
    Follow Us:
  2. Income Tax
  3. Downloads

Income Tax Calculator for Financial Year 2020-21 for Individuals

Sponsored

Republished with revised Simple Version

Simple Income Tax Calculator for the Financial Year 2020-21 in Excel for Salaried Individuals.

Tax Planning in the beginning of the Financial Year is always better instead of doing that at the end of the year in hurry. This will help the Individual to plan their Investments in advance and submit necessary documents to their Employer in time.

I am a CA Inter Completed, Experience in Private Sector as a Head of Finance.

I have considered the Budget 2020 in this Excel Tool for Tax Calculation.

Features :

1. Mainly useful for the salaried Employees having income includes:

    a . Income from Salary / Pension

    b.  Income from Interest (Other Sources). (Bifurcation w.r.t. Interest from Savings Bank Account, FD Interest etc.)

    c. You can input Capital Gain on Shares, Dividend Income, TDS deducted by others etc

2. Separate sheet for each Source of Income

3. Calculate Taxable Income, Tax, etc for Old Regime.

4. Provision for Automatic calculation of deduction u/s 80 GG towards Rent Payment when HRA is not received.

5. Age is calculated (as per IT Act) automatically based on DOB.

6. Tax Provisions are considered where ever required w.r.t. Senior Citizen, Very Senior Citizen, Physically Handicapped, etc.

7. Detailed statements are provided for :

    a. Income Tax Slab

    b. Tab Rebate

    c. Exempted Income u/s 10 & Standard deduction u/s 16

    d. Deductions under Chapter VI A (Sec 80 C, 80 CCC, 80 CCD, 80 D, 80 U, 80 TTA , TTB etc.)

8. This File may be useful to the Employers having limited no. of employees to Calculate Monthly TDS for each Employee.

9. The Tables are structured in such a way that it will be easier to fill information in the Income Tax Return.

10. Print Preview by clicking a Button for commonly required statements.

11. Number Format, changed to Indian Number format,  instead of  Thousands, except for Negative Numbers.

12. Data Import facility is provided to import from the previous release of this Tax Calculator ie. So you don’t need to re enter all the data when the new version is released for Particular Financial Year Module.

You may contact me for any clarification in this Excel Tax Calculator at grajan_k@yahoo.com.

(Article was Originally Published on 29.05.2020 and republished with changes on 09th August 2021)

Download Income Tax Calculator for Financial Year 2020-21 for Individuals
Access Denied! Only Regstered Users Can Download The File "Income Tax Calculator for Financial Year 2020-21 for Individuals". Register Here or Login
Sponsored

Tags:

Kindly Refer to Privacy Policy & Complete Terms of Use and Disclaimer.

Author Bio

Name: Govindaraj K
Qualification: Post Graduate
Company: N/A
Location: Bangalore, Karnataka, India
Member Since: 23 Apr 2019 | Total Posts: 6
View Full Profile

My Published Posts

Income Tax Calculator for FY 2021-22 in Excel for Salaried Individuals Income Tax / TDS on Salary Calculator for Multiple Employees for FY 2019-20 Income Tax Calculator for FY 2019-20 in Excel for Salaried Individual in India Loan Amortisation Table, Find Rate of Interest & EMI Calculator in Excel Income Tax Calculator for FY 2018-19 in Excel for Salaried Individuals in India View More Published Posts

Join Taxguru’s Network for Latest updates on Income Tax, GST, Company Law, Corporate Laws and other related subjects.

102 Comments

  3. MANI says:

    Please advise, whether an employee of a private company residing & working at Bangalore claim HRA paid to his father for his house property in Surat (Gujarat).

    Thanks,

    MANI

      Reply
  26. K L NARASIMHA SWAMY says:

    Dear Sir,

    Can you publish similar calculation sheet for professionals who are not subject to audit. No books maintained.
    Regards,

      Reply
  31. Javid Bashir says:

    please share the excel sheet for income tax calculation for salaried employees for the financial year 2020-21.
    Thanks in Advance….

      Reply
  40. ABBAS says:

    nsc purchase on 12.01.20 for five years can u gv excel table which give the accrued int as year ending 31st mar 20 and onwards upto maturity ?

      Reply
  42. ramanath.remella says:

    Sir,
    I am unable to open excel sheet for income tax calculation for salaried employees for the financial year 2020-21. I got blank page

      Reply
  44. shimpysaxena93@gmail.com says:

    Hi, This is Shimpy, Can you please share the excel sheet for income tax calculation for salaried employees for the financial year 2020-21.
    Thanks in Advance….

      Reply

Leave a Comment

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

Sponsored

Latest Posts

View All Posts
Sponsored

Featured Posts

View All Featured Posts

Popular Posts

Search Post by Date
July 2024
M T W T F S S
1234567
891011121314
15161718192021
22232425262728
293031