- Govindaraj K
- | Income Tax - Downloads
- 30 Mar 2021
- 293,307 Views
- 72 comments

**Income Tax Calculator for the Financial Year 2020-21 for Both Regimes in Excel for Salaried Individuals in India-Ver 20.01 **

This excel based simple and user friendly Income Tax calculator for Salaried Individuals is to compute the Income Tax for both Old and New Regime.

This will help you to decide which Regime to follow to minimize your Tax Burden.

**Please read the instructions given in the Excel file for better understanding.**

** ****The Salient Features :**

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

a . Income from Salary and Pension

2. Income from House Property (Self Occupied and Rented out)

3. Income from Capital Gain on (eligible) Sale of Shares and Equity oriented Mutual Funds where STT is paid.

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

5. Separate sheet for each Source of Income

6. Calculate Taxable Income, Tax, Rebate, Surcharge, Marginal Relief and Cess.

7. Salary Particulars can be given on monthly basis. Flexible Allowance and user defined heads of allowance are incorporated

8. Calculation of Accrued Interest on NSC in neat tabular form.

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

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

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

12. Section wise Tax Rules for Reference Purpose are provided;

13. Income Tax Slab

14. Rebate

15. Sur Charge, Marginal Relief and Cess on Tax

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

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

18. This File may be useful to the Employers having limited no. of employees to Calculate Monthly TDS for each Employee, Gross Salary / Amount Paid to be shown in Quarterly 24Q eTDS Purpose etc.

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

20. Print by clicking a Button for commonly required statements.

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

22. Included Notes and FAQ for better understanding. Like Gift to Minor Child and Spouse, Topics on Capital Gain, etc

You may contact me for any clarification in this Excel Tax Calculator at [email protected]

**(Republished with Improved Tax Calculator)**

Tags: Calculator, Income Tax Calculator

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

- AMP Expenses not qualifies as ‘international transaction’ under Section 92B
- No refund of excise duty paid under protest after expiry of limitation period under Section 11B
- Date of Sale for of Claiming Exemption under Section 54
- Difference between Shareholder & Director under Companies Act, 2013
- Income Heads – Some Issues – Income from other sources
- Key takeaways in transfer of Goodwill or share of profit in case of death of a CA
- HC explains scope of ‘intimation’ under section 143(1)(a) of Income Tax Act, 1961
- Explanation 2(c) to Section 147 is merely to explain the scope of re-assessment
- Appellate Authority can exercise Power under Rule 46A suo-motu without any application from any of contesting party
- Section 68 not applies when assessee explained nature & source of Income

- Join GST, Customs & Income Tax Courses at 40% Discount (Till 15th May)
- Right Time To File Income Tax Return For AY 2021-22
- LTC Exemption of Rs. 36000 per family member For FY 2020-21 also available to non-Government Employees
- Direct & Indirect Taxes Updates- April 2021
- Section 269ST relaxation on cash payment to hospitals

- Right Time To File Income Tax Return For AY 2021-22
- Waiver of interest & late fee under GST & Revised due dates
- 20 Suggestive Tax Relief Measures In Times of Covid 2.0
- GST: Chart of Waiver of interest & late fee for March & April, 2021
- Corporate Compliance Calendar for May 2021

am unable unprotect the worksheet, it is asking for password

ITD has published ITR 1 for AY 2021-22. But, for filing the tax return, it has not enabled the program. When we can expect enabling the software. Can you up date the same for my guidance.

sir,

income tax calculator financial year 2019-20 & 2020-21 excel for all heads

Pls share the TDS excel sheet

Plz share the Excel sheet

Please share your excel sheet

Please share the excel sheet for income tax calculation for salaried employees for the financial year 2020-21.

Thanks

Hello Sir,

income tax calculator financial year 2019-20 & 2020-21 excel for salaried email [email protected]

VERY USEFUL TAX CALCULATION SHEET IN EXCEL FOR FY 202 – 21 BUT ONE COLUMN THAT IS I CANT ABLE TO UNDERSTAND WHERE TO FILL THE PROFESSIONAL TAX COLUMN THAT ONLY I CANT ABLE TO FILL BUT EVERYTHING IS VERY USEFUL TAX WORKING CREATION TO COMPARE NEW AND OLD REGIME THANK YOU FOR YOUR PRESENTATION

plz forward excel sheet of income tax calculation for fy 2020-2021

Hi sir, please send Income Tax Calculator for Financial Year 2020-21 for Individuals to email id [email protected].

Can you please share the excel sheet for income tax calculation for salaried employees for the financial year 2020-21.

[email protected]

Can you please share the excel sheet for income tax calculation for salaried employees for the financial year 2020-21.

Got a message that it is protected with a password and cannot open

Unable to open the excel sheet link. Pl send correct link.

Can you please share the excel sheet for income tax calculation for salaried employees for the financial year 2020-21.

Thank you

Dear sir, Please send income tax calculation excel sheet for the below mail id

[email protected]

Thanking you sir

please send me income tax calculator excel for year 2020-21

Is this a joke or marketing gimmick, where is the excel sheet

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

EXCEL BASE INCOME TAX CALCULATOR FOR THE FINANCIAL YEAR 2020-21

Sir, where can I get the calculation sheet.?

income tax calculator with form 16 financial year 2019-20 & 2020-21 excel for salaried email [email protected]

How to get the tax calculator?!

Sir Can you enable the save option, we are unable to save this file after editing

Where is excel sheet of particular computation of income tax financial year 2020 21

Sir pls send it calculator FY 20-21

income tax calculator financial year 2020-21 excel for salaried email id.

pls send income tax calculator FY 201-20

sir Can you please share the excel sheet for income tax calculator for multiple employees for the financial year 2020-21.

plz send excel calculator sheet

pls send income tax calculator for multiple employees for fy 2020-21

pls send incometax/tds calculator for multiple employees for FY 2020-21

Sir, please send 24q excel sheet for income tax calculation for salaried employees for the financial year 2020-21.

Where is income tax calculator Excel sheet sir?

Please send the excel sheet it calculator

Sir, can you please send income tax calculator for the Assessment Year 2020-21 to my email ID?

Respected Sir

Please mail me income tax auto software password free at ID [email protected]

Thanks

Sir, please send 24q excel sheet for income tax calculation for salaried employees for the financial year 2020-21. email id: [email protected]

Please send excel sheet

Please send the excel sheet for salaried person & business income for fy 2020-21

thank u sir

Dear Sir,

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

Regards,

sir,

income tax calculator financial year 2019-20 & 2020-21 excel for salaried email id.

[email protected].

thanks

Good day sir, could u sent I tax calculation (Excel) sheet for the Assessment year 2021-22.

please send the tax calculation excel.

Good day sir, could u sent I tax calculation (Excel) sheet for the Assessment year 2021-22.

Regard

Girish T

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

Thanks in Advance….

sent

Pls send me income tax calculator in excell sheet

Please send the excel sheet for salaried person for fy 2020-21

Please send income tax calculator in excell format.

[email protected]

please send income tax calculator in excel format for fy 2020 – 2021

Please send the excel sheet it calculator

Please send the excel sheet it calculator

pls send the Tax calculator 2020-21 to [email protected]

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 ?

I want to like ur website

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

Sir, can you please send income tax calculator for the Assessment Year 2020-21 to my email ID?

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….

HI,

Can you please share excel utility of IT calculator on my mail ID as given below for AY 2020-21 & AY 2021-22.

Mail ID – [email protected]

Thanks in advance

Abhishek K

kindly send it to my EMail ID

[email protected]

Hello, Please share Investment declaration format and IT Calculator at [email protected]

Sir, please send 24q excel sheet for income tax calculation for salaried employees for the financial year 2020-21.

e-mail: [email protected]

Hi, Can you pls send the xl calculator to [email protected]. Thanx.

sir,

income tax calculator financial year 2019-20 & 2020-21 excel for salaried email id. [email protected]