October 23, 2020

Itax Software

Income Tax Software

Download and Prepare at a time your Income Tax Computed Sheet + Automated H.R.A. Calculation U/s 10(13A) + Automated Income Tax Form 16 Part A&B in Revised Format + Automated Revised Form 16 Part B + Automated Income Tax Form 12 BA for the F.Y. 2020-21 In Excel All in One for only Non-Govt Employees for F.Y. 2020-21 With Old & New Tax Regime as per Budget 2020

How to do Income Tax Calculation for FY 2020-21?
Which Tax Structure to Select?


As per budget 2020, you cannot claim any tax
deduction or exemption if you plan to opt new tax structure. So, as an
individual tax payer if you opt for the new tax regime with reduce tax rate you
need to forgo all tax breaks available today. Fortunately, you have option to
continue with old tax structure. Salaried person can switch between old and new
tax structure.


Firstly, we will talk about which tax deduction and
exemption you need to forgo in case you opt for new tax structure with reduce
tax rate. Secondly, we will take few test cases and do income tax calculation
for FY 2020-21 to know which tax structure to select?

Also Download Automated Income Tax Revised Form 16 Part B for F.Y. 2019-20 [ This Excel Utility can prepare at a time 50 employees Revised Form 16 Part B ]

List of Tax Deductions and Exemption not
allowed in new Tax Structure

1 Tax Deduction Under Section 80C
The most popular
tax deduction of 1.5 Lakh under section 80C is not applicable for new tax
structure. This means you cannot claim any benefit for investment made in the
instruments such as PF, PPF, Life insurance premium, school tuition fees of
children, ELSS, PPF, NPS etc.


You can claim
deduction under section 80CCD for the employer contribution on account of
employee for NPS.

Also Download Automated Master of Form 16 Part A&B for the Financial Year 2019-20 [ This Excel Utility can prepare at a
time 50 employees Form 16 Part A&B, who are not able to download the Form
16 Part A from the TRACED PORTAL, they can use this Utility]

 2 Tax Deduction Under Section 80D

No tax deduction is
allowed for the medical insurance premium and preventive health checkup under
section 80D for new tax structure.
3 No LTA Benefits
For new tax structure
LTA – Leave travel allowance exemption which is currently available to salaried
employee for twice in block of four years is not allowed.
4 HRA
HRA is house rent
allowance. HRA is paid to salaried individuals by employer as a part of salary.
Earlier taxpayer was able to claim HRA up to certain limit. In new tax
structure it is not permissible.
5 Standard Deduction
A standard
deduction benefit of Rs.50000 currently available to salaried tax payer is not
applicable in new tax slab.
6 Section 80TTA Benefits
Section 80TTA
provides deduction of Rs.10000 on interest income. On new tax regime this
benefit is not available.
7 Section 80DDB Benefits
Benefits for
disability under section 80DDB up to Rs.40000 not available in case you are
planning to opt for new reduced tax structure.
8 Section 80E Education Loan
Tax break
permissible on the interest paid on education loan will not be claimable under
section 80E.
9 Section 80G of Donation
You were able to
make donation under section 80G and claim income tax benefit of equivalent
amount. The said deduction is not available in reduced tax structure.
10 Section 24 Home Loan Interest
Under section 24 of
the Income tax act, an individual was able to claim tax deduction on the
interest payment on the housing loan up to a maximum amount of Rs.200000. This
benefit is not extended if you opt for new tax structure.
Other deduction applicable under chapter VIA like section 80C,
80CCC, 80CCD, 80D, 80DD, 80DDB, 80E, 80EE, 80EEA, 80EEB, 80G, 80GG, 80GGA,
80GGC, 80IA, 80-IAB, 80-IAC, 80-IB, 80-IBA, etc) These Tax Section  are not entitled for New Tax Regime – Only allow
to get relief who are Opt in Old Tax Regime.

Income Tax Calculation FY 2020-21 (AY 2021-2022)

Now let’s calculate
actual tax benefits by doing Income Tax Calculation and comparing both the tax
structures in various cases.

Case 1 –
Salaried Individual claiming common deduction (80C,80D) and Home Loan Benefits

In first case I
will take example of salaried individual with income of 20 Lakh & 10 Lakh.
Let’s consider in both the cases individual takes benefits of standard
deduction Rs.50000, deduction of Rs.1.5 Lakh under section 80C, Rs.25000 under
section 80D and Interest on home loan up to Rs.200000.
Now two options are
available to the salaried individual. First he/she can opt for old tax
structure with all above deduction or he/she can forgo all deduction and opt
for new reduced tax structure.
If individual has
annual income of 20 Lakh and old tax structure is opted with tax deductions.
Applicable tax is 2.85 Lakh. If new tax structure is adopted applicable tax
amount is 3.37 Lakh. Similarly, if annual income is 10 Lakh and old tax
structure is adopted applicable tax is Rs.27500. For new tax structure
applicable tax is Rs.75000. Calculation is given below.
Example Picture of
Calculation of Tax 1 and 2

Case 2 –
Salaried Individual claiming common deduction under section 80C, 80D and
Standard Deduction

In second case
let’s assume that salaried individual is taking full benefits of section 80C,
80D and standard deductions as of now. Under new tax regime these deductions
are not applicable. Suppose income level of individual is 10 Lakh. If old tax
regime is selected payable tax is Rs.70200 on the other hand if new tax regime
is selected payable tax is Rs.78000.
Gross
Income Rs/-
Tax
as per Old Tax Structure Rs/-
Tax
as per New Tax Structure Rs/-
Additional
Tax Saving Rs/- / Payable
7.5
Lakh
18200
39000
-20800
10
Lakh
70200
78000
-7800
12.5
Lakh
124800
130000
-5200
15
Lakh
202800
195000
7800
20
Lakh
358800
351000
7800

Case 3 –
Salaried Individual not claiming any deduction or exemptions

In third case let’s
assume that salaried individual is not claiming any deduction of exemptions as
of now. So, under new tax regime he/she will get benefit of reduced tax rates
and he/she needs to pay less taxes. Suppose income level of individual is 15
Lakh. If old tax regime is selected payable tax is Rs.257400 on the other hand
if new tax regime is selected payable tax is Rs.195000 only.
Gross
Income Rs/-
Tax
as per Old Tax Structure Rs/-
Tax
as per New Tax Structure Rs/-
Additional
Tax Saving Rs/-
7.5
Lakh
54600
39000
15600
10
Lakh
106600
78000
28600
12.5
Lakh
179400
130000
49400
15
Lakh
257400
195000
62400
20
Lakh
413400
351000
62400
Conclusion:-
 
From above
cases example it is obvious
that in most of
the cases old tax rate
with deduction offers higher tax benefits. New reduced
tax rate is helpful only
if you are not
claiming any deductions as of
now. (which is very rare)

If you have home loan
and higher income you will get
higher tax benefits in old
tax rate compared to new
tax rate.

Free
Download Automated Income Tax All in One Excel Based Software for only
Non-Govt ( Private ) Employees for the Financial Year 2020-21and
Assessment Year 2021-22 as per Budget 2020 with Option in Old Tax Regime
and New Tax Regime

Feature of This Excel Utility :-

1)    You can choose your option as Old or New Tax Regime as per
Budget 2020
2)    This Excel Utility Prepare at a time your Income Tax
Computed Sheet + Automated H.R.A. Calculation U/s 10(13A) + Automated Income
Tax Form 16 Part A&B in Revised Format + Automated Revised Form 16 Part B +
Automated Income Tax Form 12 BA for the F.Y. 2020-21.
3)    Automatic Convert the Amount in to the In-Words without any
Excel Formula
4)    All the Income Tax Section have in this Utility as per the
Budget 2020
5)    The Salary Structure have in this utility as per the all of
the Private Concern’s Salary Pattern.

You may have missed