Download Automated Income Tax Form 16 Part B with Synopsis of 24Q & 26Q for the Financial Year 2015-16 & Assessment Year 2017-18 [This Excel utility can prepare at a time 50 employees Form 16 Part B with Synopsis of 24Q & 26Q which is required submit to the NSDL]
Feature of this Excel Utility :-
1) Automatic Calculate your Income Tax as per the Budget 2016
2) All modification have in this Excel Utility as per the Budget 2016
3) Automatic Prepare Form 16 Part B after filling the employee's Data
4) Automatic prepare the Quarter ended statement of each employee in separate sheet
5) Automatic prepare the Tax Deduction of each employees Quarterly/Monthly in Separate Sheet
6) Automatic Convert the Amount in to the In-Word ( Without any Excel Formula)
7) Prepare at a time 50 employees Form 16 Part B with 24Q & 26Q
Snapshot of Form 16 Part B :-
An individual resident of India
What is Section 87A?
To
help individual taxpayers in lowering the tax outflow from their pocket a new
section 87A was introduced. Section 87A provides for income tax rebate of Rs
2,000 for individual resident tax payers not having income more than 5
lakh. . The
salient features of Income Tax Rebate under Section 87A:
1. The amount of tax rebate under section 87A is restricted to
maximum of Rs 2,000. If the computed tax payable is less than Rs.2,000,
say Rs.1,500 the tax rebate shall be limited to that lower amount ie Rs 1,500. The
Income Tax Rebate has been increased from Rs. 2000 to Rs. 5000 in Budget 2016
and would be applicable from Financial Year 2016-17 onwards
2. Rebate under Section 87A is only available to Individuals. All
categories of Individuals whether Male or Female or Senior Citizens are
eligible to claim Income Tax Rebate under Section 87A. Other types of assesses
like HUF, Companies, Partnership Firms, LLP etc are not eligible to claim
Income Tax Rebate under Section 87A.
3. Income Tax Rebate under Section 87A is only available to
Resident Individuals and not to Non-Resident Individuals.
4.
Total taxable income should not be more than 5 lakhs.
5. Income Tax Rebate of Rs. 2000 is allowed before the levy of
Education Cess and Secondary and Higher Education Cess(SHEC). In other words,
Education Cess and SHEC would be levied on the tax payable after allowing for
Income Tax Rebate of Rs. 2000
6. There is no benefit of this Rebate to Super-Senior Citizens i.e.
Individuals above 80 years of age as their Income up to Rs 5 Lakh is already
exempted from the levy of Income Tax
Who gets the tax rebate under section
87A?
Benefit
under section 87A is available only to the individual Resident, aged less than
80 years, earning net income up to Rs 5 lakhs. All the other
assesses like HUF, AOP, BOI, Company, Trust, LLP, Partnership Firms etc.
including individual NRIs are not eligible
to claim tax rebate under section 87A.
Since when is the rebate provided under section 87A?
·
Rs 2000 under Section 87A was introduced from Financial Year
2013-14 (AY 2014-15) onwards.
·
The Income Tax Rebate has been increased from Rs. 2000 to Rs. 5000
in Budget 2016 and would be applicable from Financial Year 2016-17 onwards.
Following table shows
the rebate in various years. For filing the ITR before 31 Jul 2016 for FY
2015-16 or AY 2016-17 the rebate is Rs 2000 as shown highlighted in yellow.
Financial Year
|
Assessment Year
|
Rebate under section 87A
|
FY 2013-14
|
AY 2014-15
|
2000
|
FY 2014-15
|
AY 2015-16
|
2000
|
FY 2015-16
|
AY 2016-17
|
2000
|
FY 2016-17
|
AY 2017-18
|
5000
|
What does total net income
means?
Total Net Income
means the taxable Income less any tax deductions under 80C to
80U. Suppose your income comes to Rs. 5,70,000 and you do tax
saving of Rs 1,00,000 under section 80C. The total net income in your case
comes to Rs. 4,70,000 which makes you eligible to claim tax rebate under
section 87A.
How much Income Tax Rebate can one claim under section 87A?
The tax rebate is only
limited to the total tax payable subject to maximum of Rs 2,000. So if the
total tax payable comes to Rs 1,600 than the tax rebate would be
restricted Rs 1,600 with no tax refund of unused amount.
If I claim less than maximum limit under section 87A will I get
refund?
No, there will be no
such tax-refunds.
How is Income Tax Rebate under section 87A calculated?
The tax rebate under
section 87A is to be deducted from the total tax payable. You are first
required to
·
Sum all incomes i.e. salary, house income, capital
gains, business or profession income and income from other sources and
·
then deduct the eligible amount under 80C to 80U and under
section 24(b) (Home Loan Interest) to come up with the net taxable income.
Examples of calculation of rebate under section 87A
Rameswar has Salary
of Rs. 3,50,000 p.a. He has put Rs 50,000 in EPF and life
insurance policy paying premium. He is paying home loan of Rs 50,000 in a year.
His income from other sources is Rs 15,000. So lets Compute his tax
liability . As after the deductions, taxable income comes to 2,65,000 and tax
comes to 1500. So Rameswar can gets tax rebate of Rs 1500, not Rs 2000.
Description
|
Amount
|
Salary Income
|
3,50,000
|
Income from House
Property
|
-50,000
|
Income from Other
Sources
|
15,000
|
Total Income
|
3,15,000
|
Deductions under 80C
|
50,000
|
Total Taxable Income
|
2,65,000
|
Tax on Income(@10%)
|
1500(10% of 2,65,000-2,500,000)
|
Less Rebate
|
1500
|
Total Tax Payable
|
0
|
But if compute tax
liability of Madhumita who has income of Rs 4,00,000 and similar investments ie
50,000 in EPF and life insurance policy paying premium. She is paying home
loan of Rs 50,000 in a year. Her income from other sources is Rs 15,000. As her
taxable income comes less than 5 lakh she can claim rebate of Rs 2000. So her
tax reduces by 2000 Rs. But she has to pay balance tax of Rs 4500.
Description
|
Amount
|
Salary Income
|
4,00,000
|
Income from House
Property
|
-50,000
|
Income from Other
Sources
|
15,000
|
Total Income
|
3,65,000
|
Deductions under 80C
|
50,000
|
Total Taxable Income
|
3,15,000
|
Tax on Income(@10%)
|
6500(10% of 3,15,000-2,500,000)
|
Less Rebate
|
2000
|
Total Tax Payable
|
4500
|
Education Cess
|
135
|
Total Tax
|
4635
|
Lets compute tax
liability of Rameswar who has income of Rs 8,00,000 and
has investments i.e 1,50,000 in EPF and life insurance policy
paying premium and 15,000 in Medical Insurance. He is paying home loan of Rs
1,50,000 in a year. His income from other sources is Rs 15,000. After
deductions his Income comes to 5,00,000 hence he can also claim rebate of Rs
2,00,000
Description
|
Amount
|
Salary Income
|
8,00,000
|
Income from House
Property
|
-1,50,000
|
Income from Other
Sources
|
15,000
|
Total Income
|
6,65,000
|
Deductions under 80C
|
1,50,000
|
Deductions under 80D
|
15,000
|
Total Taxable Income
|
5,00,000
|
Tax on Income(@10%)
|
25000(10% of 5,00,000-2,500,000)
|
Less Rebate
|
2000
|
Total Tax Payable
|
23000
|
Education Cess
|
690
|
Total Tax
|
23,690
|
When to Claim rebate under Section 87A?
One can claim the
rebate under section 87A while filling the ITR. The rebate under section 87A,
i.e., deduction from the tax payable would be the amount of tax payable itself
or Rs, 2000, whichever is less and such rebate shall be claimed while filing the
return just before adding the Education Cess, Secondary & Higher Education
Cess. If you use the E-filing Excel Utility or Java Utility is it calculated
automatically. A sample of ITR with 87A deductions for example of Mr.Rameswar
is shown below
Is the rebate under section 87A also available in case
of belated return i.e after the due date has gone?
Yes you can claim
Rebate under section 87A while filing ITR also. Rebate has nothing to do with
time limit.
Can I claim Rebate if my Total income is more than 5 lakh?
As shown in example of
Srinivas above even if your total income is more than 5,00,00 and by claiming
deductions under various sections you can bring down the taxable income to
5,00,000 you can claim Rebate of Rs 2,000. The section use word
Total income not the word Gross total income.
Can a senior citizen also claim rebate under section 87A?
Yes Tax Rebate
under section 87A is also available to a senior citizen, if
the total income is Rs. 5 Lakh or less. Effectively, it means,
a senior citizen, both male and female, need not pay
any tax on total income of up to Rs. 2,70,000. However,
this benefit is not available to a super senior citizen (age 80 or
above) as his total income up to Rs. 5 Lakh is already fully exempted.
What is difference between Exemption, Rebate and Deduction?
Income Tax Rebate,
Income Tax Deduction and Income Tax Exemption all reduce taxable income, they
are similar terms but yet different.
Exemption means, your income is actually taxable but under some
Income Tax section you can claim portion of it as exemption ie not subject to
tax.
For example, an individual getting his salary from employer is eligible for
house rent allowance(HRA) exemption. This means, the HRA that he is
getting is taxable but a portion of it will be deducted because of the
exemption available. Similarly an individual can also claim other
exemptions like, LTA (Leave Travel
Allowance) exemption. Similarly, Income Tax Exemptions allowed to be claimed
under head Capital Gains under Section 54, 54EC, 54F etc. So Income
Tax Exemptions are those which are allowed to be claimed only from a specific
source of Income and not from the Total Income. If you don’t claim it you won’t
get it and whole amount would be taxable.
Deductions are allowed to be claimed in case the taxpayer has
incurred some specified expenditure or made specified investments. The best
example of Income Tax deduction is section 80C where you claim deduction for
your investment in LIC, PPF, ELSS etc. To get this deduction you have to
specifically make investments that are in section 80C irrespective of your
type of income, salary income or income from business and profession.
Difference between exemption and deduction is, while exemptions are deducted
from their respective source as mentioned in Income Tax Act 1961, deductions
are deducted from Gross Taxable Income i.e. after taking all taxable incomes
together. Examples of Income tax deductions allowed are as follows:
·
Deduction under Section 80C
·
Deduction under Section 80TTA for Interest on Savings Account
·
Deduction under Section 80D for Payment of Medical Insurance
Premium
·
Deduction under Section 80E for repayment of Interest on Education
Loan
·
Deduction under Section 80G for Donations
·
Deduction under section 24 section for house property
Rebate is claimed from the total tax payable. While Income
Tax Exemptions and Income Tax Deductions are claimed from the Income, Rebate is
claimed from the Tax payable.
