- Govindaraj K
- | Income Tax - Downloads
- 07 Jan 2021
- 197,985 Views
- 57 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.

- TDS Rate Applicable for FY 2021-22 or AY 2022-23
- Time period to file an appeal starts only when order is uploaded on GST portal
- Rate Chart of TCS For FY 2021‑22 Or For AY 2022-23
- CGST Ghaziabad unearths GST Evasion of approx Rs 37 Cr.
- Bombay HC dismisses plea for GSTR9/9C due date extension (Read order)
- CBDT Extends Vivad se Vishwas Dates Yet Again. So Your Appeals may have to Wait Longer!!
- QRMP Scheme – Some Useful Information
- Hum do and Hamare do Tax Benefit under Income Tax Act, 1961
- Result of CS Examinations December, 2020- Toppers & Analysis
- GST registration Cancellation vide deficient SCN unsustainable

- Extend Due Date for Furnishing GSTR-9 & GSTR-9C for FY 2019-20
- Important Alert – Upcoming statutory Due Dates- You Must Know
- Request to grant Extension for GSTR 9 & GSTR 9C – FY 2019-20
- 16 details of Purchaser you can check on GST website
- Request to extend time to file FORM GSTR 9 & 9C for FY 2019-20

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

SIR P;LS SEND INCOME TAX CALCULATOR2020-2021 FINANCIAL YEAR CALCULATION

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

Link is there to download at the end of article, which you can download after login.

The download link is available at the end of the Article.

You need to register and login in taxguru website to download.

Please avoid sarcastic comments.

Neither a joke nor a marketing gimmick .

Regards

Govind

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

You can always save the excel file using ctrl+s shortcut. Don’t opt for XML saving option. When popsup click NO.

However, you download the latest file from my google drive link. The save button and clear all input data button are provided.

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]

Sent