Income Tax Calculator Excel File For Year 2019-20 
Income Tax Calculator for the Financial Year 2019-20 for Salaried Individuals  in India in Excel.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.
Income Tax Calculator Excel File For Year 2019-20
I have considered the Interim Budget 2019 Proposals in this Excel Tool for Tax Calculation. 
Many Taxpayer in India see tax evasion as a mark of smartness. If the government allows you a tax break, you are free to take it. If there is a legal way you can save some of your hard-earned money from being taxed, you are free to save it. How is the Indian tax payers are doing their tax planning!. Can this be called as Smart Taxation or Tax Morality!!. Once Mr. Jaitley commented “Indians are generally conservative and God-fearing, but they do not see tax evasion as a moral problem”. May be this smartness is the reason the governments consider scrutiny is a better tool than moral persuasion to make the evaders pay up.

Income Tax Calculator Excel File For Year 2019-20 .Bible reminds us about this tax-morality in Romans 13:2 and 7, “Therefore, whoever resists authority, resists what God has appointed, and those who resist will incur judgment. Pay to all what is due them- taxes to whom taxes are due, revenue to whom revenue is due, respect to whom respect is due, honour to whom honour is due”.

Standard Deduction from taxable salary. Standard Deduction for salaried persons raised from 40,000 rupees to 50,000 rupees.
Rebate under section 87A has increased from 2500 to 12500 rupees up to the income of 5 lakh rupees, hence individual taxpayers with annual income up to 5 lakh rupees to get full tax rebate. Tax payers whose taxable income cross the limit of 5 Lakh need to have a smart way here!
Salient features of the Tax calculator.
Useful for the salaried employees of government and private sector, with all heads of Income including agricultural income.
  • Private sector employees can use to do their Flexi allocation and tax planning.
  • Tax and rebate calculation of agriculture income, to arrive the annual tax liability.
  • Marginal relief on surcharges where income crosses 50L and 1Cr.
  • Individual Form 16 Part B generation, useful for the small size firms.
  • Automated HRA exemption/Sec 80GG deduction calculation based on the salary and rent payments.
  • Validate and highlights the limits Chapter VI A deduction, Housing loan interest set off, and surcharge impacts.
Income tax Slabs & Rates FY 2019- 20, AY 2020-21
Income tax Slabs General Category Sr.Citizen Very Sr. Citizen
Upto Rs. 2. 5Lakh NIL NIL NIL
Rs.2.5 Lakh to 3.0 Lakh 5% NIL Nil
Rs.3.0 Lakh to Rs.5.0 lakh 5% 5% NIL
Rs.5.0 Lakh to Rs.10.0 Lakh 20% 20% 20%
Above 10.0 Lakh 30% 30% 30%

Surcharge:
If the total income between Rs 50 Lakhs and Rs 1 crore, a surcharge of 10% will be levied.
15% surcharge on income tax if the total income is over and above Rs 1 cr.

Income Tax Calculator Excel File For Year 2019-20.Income Tax Calculator for the Financial Year 2019-20 for Salaried Individuals  in India in Excel.
Income Tax Calculator Excel File For Year 2019-20.Income Tax Calculator for the Financial Year 2019-20 for Salaried Individuals  in India in Excel.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.