Showing posts with label H.R.A.Calculator. Show all posts
Showing posts with label H.R.A.Calculator. Show all posts

Saturday, 28 October 2017

Rebate u/s 87A of the Income Tax as per Budget 2017, Plus Automated TDS on Salary for Govt & Non-Govt employees For F.Y 2017-18 and Automated Form 16 Part A and B and Part B for F.Y.2017-18 and A.Y.2018-19


Click to download All in One TDS on Salary for Govt & Non-Govt Employees for the Financial Year 2017-18 & Assessment Year 2018-19 with all amended Tax Section and Slab as per Budget 2017-18 [ This Excel Utility can prepare at a time Tax Compute Sheet + Individual Salary Sheet + Automatic Arrears Relief Calculation + Form 10E + HRA Calculation + Form 16 Part A&B and Part B for F.Y 2017-18 & A.Y. 2018-19]

Finance Act 2013, has introduced the new section, namely Section 87A. This newly inserted section gives rebate up to a maximum of Rs. 2500/- to the assessee having Net Total Income Less than Rs. 3,50,000/-(Rs. Three Lakes Fifty Thousand ). The rebate under this section is available to the resident Individuals for the  A.Y. 2018-19. ( As per the Finance Budget 2017-18)

“87A An assessee, being an individual resident in India, whose total income does not exceed Three Lacs & Fifty Thousand rupees(3.5 Lakh), shall be entitled to a deduction, from the amount of income-tax (as computed before allowing the deduction under this chapter i.e. Chapter VIA) on his total income with which he is chargeable for any assessment year, of an amount equal to hundred percent of income-tax or an amount of two thousand & Five Hundred (2.500/-) rupees, whichever is less.”

Conditions required to be fulfilled:
·                     The rebate is allowed only to the individual assesses (not to HUF/Firm/AOP/BOI)
·                     The individual should be resident in India
·                     Total income should be up to or less than Rs. 3,50,000/-. Total Income here means Income under all heads of Income (Salary, House property, Business & Profession, Capital Gain and Other sources) after deducting the deduction under Chapter VI i.e. deduction from 80C to 80U.
·                     No deduction is available to Super Senior Citizens whose age is more than 80 years.
Quantum of Rebate:
The rebate will be the lower of
·                     100% of the tax payable on Total Income; or
·                     Rs. 2,500/-

Click to download Automatic Master of Form 16 Part A&B and Part B for the Financial Year 2017-18 & A.Y. 2018-19[ This Excel utility can prepare One by One Form 16 Part A&B and Part B for F.Y.2017-18 & A.Y. 2018-19 ]


Thursday, 14 September 2017

Download Automated All in One TDS on Salary for Govt and Non-Govt employees for F.Y.2017-18 and A.Y.2018-19

After budget 2017, there are many doubts in respect of changes in individual taxation which affects the individual tax liability. In news & social media they are writing that there is no tax on annual income of Rs. 3.5 Lakh. People are taking that tax slab has changed from Rs. 3.5 Lakh to 5 Lakh.
Actually, there are only three new key changes for an individual in this Budget and new slabs are as follows.
1. Tax slab remains same but the rate for tax slab of 2,50,000 to 5,00,000 has Tax Rate @ 5%  and rest rates are same as the previous financial year.
New slabs for the F.Y.2017-18 & A.Y. 2018-19 is given below:-
2. Rebate under section-87A – has been Rs. 2,500 and eligibility for rebate of Sec 87A has reduced for individual of total income of Rs.3,50,000
3. Surcharge @ 10% will be charge from income above Rs.50 Lakh, & @ 15% for income above Rs. 1 Crore.
You all have to how much tax is payable in the financial year 2017-18. This Excel Based Utility can prepare at a time Tax Computed Sheet + Individual Salary Structure + Automated H.R.A. Calculation U/s 10(13A) + Automated Arrears Relief Calculation with Form 10E from F.Y.2000-01 to F.Y. 2017-18 + Automated Form 16 Part A&B and Form 16 Part B for FY 2017-18 with new income tax slab for F.Y.2017-18 & A.Y. 2018-19.
 This Excel Utility will help you to calculate the income tax in a very simple way with less time and fewer efforts. After calculating your tax liability you will be able to plan your tax saving accordingly.

Download All in One TDS on Salary for Govt & Non-Govt employees for F.Y.2017-18 & A.Y.2018-19 with new Income Tax Slab.


Tuesday, 4 July 2017

Automated Arrears Relief Calculator U/s 89(1) with Form 10e up to F.Y.2017-18, Automated Form 16 Part A and B and Part B for F.Y.2017-18,Automated H.R.A. Exemption Calculator, Automated TDS on Salary for Govt and Non-Govt employees for F.Y.2017-18 Plus deduction u/s 80C A.Y.2017-18 and A.Y.2018-19

Deduction under section 80C for A.Y.2018-19We know that you are very much interested to know the deduction from gross total income to calculate net income taxAs we will discuss only here deduction under section 80C in detail for the Financial Year 2017-18 as per the Finance Budget 2017-18
Income Tax Slab Rate for the F.Y.2017-18 as given below:-

There are lots of deductions comes under Chapter VI-A from section 80C to 80U like 80HH, 80RRB, 80U and more. But this article is exclusively for the deduction comes under section 80C.

Download Automated Income Tax Preparation Excel Based Software for Govt & Non-Govt Employees for Financial Year 2017-18 & Ass Year 2018-19 [This Excel Utility can prepare at a time Tax Computed Sheet + Individual Salary Structure + Individual Salary sheet + Automated H.R.A. Exemption Calculation + Automated Arrears Relief Calculator U/s 89(1) with Form 10e + Automated Form 16 Part A&B and Form 16 Part B as per the new tax slab for F.Y.2017-18]


You can claim the deduction under section 80C as per follows: 
Aggregate amount of deduction u/s 80C, 80CCC, 80CCD and new section 80CCE  is restricted to Rs.1,50,000.& Additional deduction Rs.50,000/- U/s 80CCD(1B)
You can avail the benefit of deduction u/s 80C by investing in the following schemes. 
1.                       Payment for Life Insurance Premium.
2.                       Payment for Deferred Annuity Plan.
3.                       Deferred Annuity Payable by Government.
4.                       Contribution to Public Provident Fund.
5.                       Contribution to Provident Fund set up by Central Government.
6.                       Contribution to Recognised Provident Fund.
7.                       Contribution to recognized superannuation fund.
8.                       Subscription to any security or deposit notified by Government.
9.                       Subscription to Saving Certificates.
10.                   Subscription for Unit Linked Insurance Plan 1971.
11.                   Contribution for Unit Linked Insurance Plan of LIC Mutual Fund.
12.                   Payment for annuity plan of LIC or any other insurer.
13.                   Subscription to units of notified mutual fund.
14.                   Contribution to notified pension fund of mutual fund.
15.                   Pension fund set up National Housing Bank.
16.                   Subscription to a deposit scheme of Public Sector Company engaged in providing long term finance for housing.
17.                   Tuition fees of two children in India.
18.                   Payment of installment for self-financing of a residential property for repayment of the loan.
19.                   Subscription to equity shares or debentures as approved for infrastructure.
20.                   Subscription to any units of the mutual fund as approved by the Central Board of Direct Taxes.
21.                   As per the Finance Act, 2006 for F.Y. 2006-07, a term deposit for a fixed period of not less than five years with a scheduled bank would also qualify for tax deduction under Section 80 C within the overall limit of Rs.1.5 lakh. This deduction to some Rules.
22.                   Notified bonds of NABARD.
23.                   Deposit in an account under the Senior Citizens Savings Scheme Rules, 2004.
24.                   Five-years time deposit in an account under the Post Officer Time Deposit Rules, 1981.

Download Automated Arrears Relief Calculator U/s 89(1) with Form 10E from the F.Y.2000-01 to F.Y.2017-18 ( Up to dated Version).


Popular Tax Saving Schemes Under Section 80C

Life Insurance Premium: You can get the deduction by depositing or paying life insurance premium in the previous year. You must note here that premium paid on behalf of wife/husband/child or any member of the family where assesses in an HUFChild includes adult children also, Thus, a deduction is available in respect of premium paid on a policy on the life of a married daughter.
Provident Fund & Public Provident FundYou can claim deduction under section 80C for the amount deposit in provident fund also. The amount deposit in the name of wife/husband/child or any member of the family where you are as an HUF is also eligible for deduction u/s 80C. The annual contribution is Rs.1,50,000 (A.Y. 2018-19) (A.Y.2017-18, A.Y.2016-17 & A.Y.2015-16).
You can deposit Rs. 1,50,000 (A.Y.2018-19 & A.Y.2017-18) in PPF A/c even if you have paid the amount in LIC,NSCULIP etc. However, the deduction u/s 80C is available on the total contribution of PPF, LIC, ULIP, etc. up to a maximum of Rs.1,50,000.
Interest on PPF is not treated as reinvestment for purpose of section u/s 80C is available even if the contribution is made in the PPF account of minor/major children or spouse.

Download Automated Master of Form 16 Part A&B for Financial Year 2017-18 & Ass Year 2018-19. [This Excel Based Utility can prepare at a time 50 employees Form 16 Part A&B as per the New Income Tax Slab for F.Y.2017-18 with all amended Tax Section]


National Saving Certificates (NSC): You can also get deduction under section 80C for the amount deposit in national saving certification along with PPF/LIC/ULIP up to a maximum of Rs.1,50,000 accrued during the year.  There is no TDS deduction for repayment of NSC. Interested accrued during the year (except for the last year) shall be deemed to be reinvested and shall also qualify for deduction u/s 80C.
Bank Term Deposit SchemesAmount invested in bank term deposits along with PPF/LIC/NSC/ULIP etc. up to a maximum of Rs.1,50,000  is also eligible for deduction under section 80C. The maturity period for bank term deposit schemes is 5 years.

Download Automated House Rent Exemption Calculator U/s 10(13A)


Post Office Time Deposit Schemes: You can also opt for post office time deposit to get deduction under section 80C up to Rs.1,50,000. You must note that the deduction is available only to the first holder.
Mutual Fund Schemes: Some of the schemes of mutual funds are eligible for deduction u/s 80C along with other investments give above. The income from mutual funds is also fully exempted u/s 10 (35).
Senior Citizens Saving Scheme, 2004You can also get the benefit of Senior Citizens Saving Scheme to get deduction u/s 80C of Rs.1,50,000. No TDS deduction is required if you provide form 15H/15G (as the case may be).

Download Automated One by One preparation Form 16 Part A&B and Part B for Financial Year 2017-18 and Ass Year 2018-19[This Excel Utility can prepare One by One Income Tax Form 16 Part A&B and Part B for F.Y.2017-18 as per the new tax slab rate.

NABARAD Rural Bonds: The deduction is also available under section 80C for a subscription to notified bonds issued by National Bank for Agriculture and Rural Development.
ULIP: The deduction is also eligible for the amount deposit in the name of himself, his/her wife/husband or his child, and an HUF in the name of its members to any Unit Linked Insurance Plan of UTI.
Tuition Fees: You can claim the deduction of paying the tuition fee of your two children. Here, you should note that tuition fees eligible paid to any university, college, school or other educational institution situated in India. However, any development fees or donation or payment of similar nature shall not be eligible for deduction.

New Pension Fund U/s 80CCD(1B): - The Additional can be avail Rs.50,000/- for New Pension Fund, which is not bound U/s 80C Max Rs. 1.5 lakh.