Breaking News
Loading...
Share It

Enter your email address:

Powered by Feedio

Showing posts with label 80CCD. Show all posts
Showing posts with label 80CCD. Show all posts

Wednesday 10 June 2015

Download the All in One TDS on Salary for Govt & Non Govt employees for Financial Year 2015-16 and Assessment Year 2016-17 [ This Excel Based Software can prepare at a time Tax Compute Sheet + Automatic HRA Calculation + Automatic Arrears Relief Calculation with Form 10E + Automatic Form 16 Part A&B and Form 16 Part B for A.Y.2016-17]

 

As per the Central Finance Budget 2015, it is clear that the Tax Slab have not changed, but some of the limit of Tax Section has hike and one more deduction has include U/s 80C in the name of Sukanya Samriddhi Account. 

As the financial Year 2015-16 and Assessment Year 2016-17 is just now started and the Advance Tax will be paid for this financial year very shortly. So it is necessary to calculate your Tax Liability
for the Financial Year 2015-16. 

Most of the tax changes is given below for the Financial Year 2015-16 :-
  1. Section 80D is hike the max limit Rs. 25,000/- for below 60 years and Rs.30,000/- for Sr.Ctzn.
  2. Section 80U has raised the Max limit Rs. 25,000//-
  3. Section 80DDB hike the Max Limit Rs. 80 thousand
  4. Section 80 the Travelling Allowances has hike the Max Limit Rs. 19200/- P.A.
  5. Section 80CCC has hike the Max Limit Rs. 1.5 Lakh as the previous year's was Rs. 1 Lakh
The taxexcel.net has prepared a Excel Based Advance Tax Calculator for Govt and Non Govt employees for the Financial Year 2015-16 and Assessment Year 2016-17 with the Automated Arrears Calculator with Form 10E since FY 2000-01 to 2015-16 and Automated House Rent Exemption Calculation U/s 10(13A). This Excel Utility can use both are Govt and Non-Govt employees with Salary Structure.
Main Input Sheet

Salary Structure 
Tax Compute Sheet
Arrears Relief Calculator

Download the All in One TDS on Salary for Govt & Non Govt employees for Financial Year 2015-16 and Assessment Year 2016-17 [ This Excel Based Software can prepare at a time Tax Compute Sheet + Automatic HRA Calculation + Automatic Arrears Relief Calculation with Form 10E + Automatic Form 16 Part A&B and Form 16 Part B for A.Y.2016-17]



Monday 13 April 2015

Download Income Tax Calculator for Non-Govt employees  For the Assessment Year 2016-2017 for Individual tax calculation.  

Mr Arun Jaitley,The Finance Minister of India Presented his first full fledged budget today (28 Feb 2015).  There were huge expectations from tax payers from the budget like increase in tax exemption slabs, Higher deductions on interest for housing loans etc.,  But the Finance Minister has chosen not to alter tax slabs during the budget.  Although he hinted about the possibility of revision of tax slabs, it may not be before next budget.

So this Income Tax Calculator which is for Financial Year 2015-16 (FY 15-16) is made with little modification from the previous years Income Tax Calculator .  The major changes proposed in the budget are also incorporate in  the calculator for Financial Year 2015-16 and Assessment Year 2016-17 as per the Central Finance Budget 2015-16.

Major proposals in the union budget for Individual tax payers which are also included in the above income tax calculator for the assessment year 2016-17.  The exemptions and deductions will be applicable if the investments / deductions are from 01 Apr 2015 to 31 Mar 2016.

There are no changes in the tax slabs. Previous tax slabs will remain same.

In spite of huge expectations from individual tax payers for increase in the limit of 80C from existing 1.5 Lakhs to atleast 2 lakhs, No increase is made.  It must be appreciated that this limit is already increased in his last interim budget.  But there is more thought out deduction announced in the budget which is deduction of Rs 50,000 if invested in New Pension Scheme or NPS.  It almost works similar to exemption of 80C but can not be clubbed with other investments like PPF, Insurance Premium, ELSS Mutual Funds or even bank FD.  This is a sort of making people having disciplined investment for their pension scheme which is in fact a good move.  It augurs well for both Investors by rewarding them well in their golden years with pension and making investments available for the Nation.
Similarly, Health Insurance premium is increased from earlier 15000 rupees to 25000 and the same is increased from 20,000 to 30,000 in case of senior citizens.  This will augur well for the people who wish to take complete health plan and paying premiums more than 15000 per annum.
For senior citizen who are above 80 years thus not eligible for health insurance, Rs 30,000 deduction is allowed for medical expenditure. Deduction limit of Rs 60,000 on expenditure of specified diseases is enhanced to Rs 80,000 in the case of senior citizens.
Similarly Investments in Sukanya Samriddhi Scheme are eligible for deduction under section 80C of the income-tax and any both principal and interest will be exempted from tax.
The other concession provided during the union budget, which can also be entered in the income tax calculator is transport allowance.  For salaried people, the exemption limit in case of transport allowance is increased from earlier 800 rupees to 1600 rupees per month.
The Tax Rebate Rs.2000/- U/s 87A will be continue in the FY 2015-16 and Rs.10,000/- can be get relief from tax U/s 80TTA from Savings Bank Interest.

Wednesday 18 March 2015

Download Automated Master of Form 16 for the Financial Year 2014-15 [ This Excel Utility can prepare at a time 100 employees Form 16 for the FY 2014-15]

How to Save Tax on Salary Income? This question is popping up in the mind of every salaried employee. Since March is fast approaching, HR department has started buzzing employees about the tax savings investment he has made.
Tax Savings investments have to be made before 31st March to claim the tax benefit and maximize savings. But before rushing to invest, one needs to and plan out his investment keeping in mind the changes made in the Budget 2014 to maximize his tax savings.
Tax Savings does not necessarily means acknowledging various sections of Income Tax Act, few sections along with your salary slip can very well accomplish the peculiar task of tax planning for you. In this article we will discuss the additional tax benefit and marginal reliefs offered by budget 2014.

The Tax Slab has already Raised up to Rs. 2.5 Lakh by the Budget 2014 and the deduction limit of U/s 80C has also raised up to Rs.1.5 Lakh.
Enhanced limit of Section 80C
Budget 2014 has augmented the limit of section 80C from Rs.1 lakh to Rs.1.5 lakhs. This enhanced limit gives additional tax relief of Rs.15,450 for the person falling in the tax slab of 30%, similarly Rs.10,300 to person falling in the tax bracket of 20% and Rs.5,150 to the person falling in the lowest tax bracket of 10%.

Maximize tax savings from increased limit of section 80C:

Home Loan Benefit

Budget 2014 has also enhanced the limit of deduction for Home Loan Principal u/s 80C and Home Loan Interest u/s 24.
Tax Benefits on Home Loan – Principal Repayment
Principal Repayment of the Home Loan taken from Financial Institutions is eligible for deductions u/s 80C but restricted to the maximum of Rs.1.5 lakhs per annum. Remember this limit of Rs.1.5 lakhs includes all deduction u/s 80C i.e. PPF, Tax Savings Bank FD, NSC, EPF, LIC etc.
Reintroduce Kissan Vikas Patra ( K.V.P.) :-
Amount invested in Kissan Vikas Patra (KVP) doubles in 100 months at the present rates. The certificates can be purchased by an adult for himself or on behalf of a minor or to a minor. It can also be purchased jointly by two adults.

A certificate may be transferred from one person to another with consent in writing to an officer of the Post Office or Bank. Under the scheme the transferee has to be eligible to purchase the certificate. The certificate may be prematurely encashed any time after two years and a half from the date of purchase, in the event of death of holder or any holder in case of joint holder, on order of court of Law and forfeiture by a pledge. 

The Government has no proposal to separately tax benefit on KVP. However, income on KVP would be taxable as per existing provisions. Investor will have to undergo Know Your Customer (KYC) modalities at the time of application. In the case of transfer of KVP from one customer to another, a request has to be made in writing to an officer of the Post Office or Bank and the transferee has to be eligible to purchase KVP certification in the first instance. 

Kissan Vikas Patra (KYP) has been reintroduced and is available in Post Offices. In future, KVP will be available in banks which are/will be authorized for handling small savings schemes.

Download Automated Form 16 Part B for the Financial Year 2014-15 [ This Excel Utility can prepare at a time 100 employees Form 16 Part B]

Tax Benefits on Home Loan – Interest Component
Threshold limit of deduction of Interest on the home loan u/s 24 is also increased in budget 2014 by Rs.50,000. Now you can get maximum of Rs.2 lakhs deduction on the accrued interest on Home Loan per annum.
Remember section 24 is applicable for self-occupied house only i.e. capping limit of Rs.2 lakh applies when you hold a self-occupied house. In case the house is not self-occupied than you can claim the actual amount of interest paid which can even exceed Rs.2 lakhs.

Contribution towards Provident Funds

Section 80C comprises for various instruments but contributions towards Provident Fund i.e. Employees Provident Fund or Public Provident Fund are best amongst them. Being EEE scheme (Exempt, Exempt, Exempt) these provide best solution for accumulating corpus for retirement. Point to note is that provident fund is a long term investment scheme, so opt this scheme considering it for post-retirement life.

National Savings Certificate (NSC) and Tax Savings Bank FD

Both National Savings Certificate (NSC) and Tax Savings Bank FD offers same rate of interest and same tax treatment. The only things that makes NSC more lucrative than tax savings bank FD is the method of interest calculation. The interest is compounded annually in case of tax savings bank FD while the interest is compounded half-yearly in case of NSC.
Equity Linked Savings Scheme
ELSS is also enjoys EEE tax treatment as EPF and PPF but it comes with a high degree of risk. Since ELSS is exposed to market the risk involved is similar to any other mutual fund but the quantum is increased due to lock-in period of 3 years.
You can choose any of the four for maximize your tax savings. No need to see any other investment scheme u/s 80C.
Continuation of Section 87A
Last year budget has introduced tax credit system under which person having gross salary up to Rs.5,00,000 can get additional tax rebate of Rs.2,000 from the income tax payable. This year budget did not drop this section and thus letting taxpayer to get benefitted this year also.

Click to download All in One TDS on Salary for Govt and Non-Govt employees for the Financial Year 2014-15

Sunday 15 February 2015

The Financial Year 2014-15 which was started from April 2014 and end this Financial Year 31st March 2015. It is necessary to submit the Tax Challan 24Q for Govt Concerned and Challan 26Q for Non-Govt Concerned. Below given below the unique Excel Based Software which can calculate at a time 50 employees Tax Calculation with Synopsis of 24Q or 26Q as per the new Tax Slab for the Financial Year 2014-15.
You can easily calculate the 50 employees Tax Calculate with month wise Tax deducted and deposit in to the Central Govt.
Most of the Govt and Non Govt Concerned prepare and deposit the 24Q or 26Q to the Curvey (nearest NSDL) Center and they can up load through there Self Software with create the FVU file format .
The below given Excel Based Software can prepare at a time 50 employees Tax Calculation Sheet with Synopsis of 24Q or 26Q which is mainly required to submit to the NSDL.
                                              Snapshot of main Data Input Sheet
Snapshot of Synopsis of Tax Deducted and Deposit Sheet 24Q & 26Q Sheet
Snapshot of Synopsis of Month wise or Year wise Tax Deposit Sheet





















Saturday 22 November 2014

Download the above link All in One TDS on Salary for Non-Govt (Private ) employees for the FY 2014-15 which can prepare at a time Tax Compute Sheet + HRA Calculation + Form 16 Part A&B and Part B)

Summary and List of Income Tax Deductions under Section 80C, 80CCA, 80CCC, 80CCD,  80CCG, 80D, 80DD, 80DDB, 80E, 80EE, 80G, 80GG, 80GGB, 80GGC, 80JJAA, 80QQB, 80RRB, 80TTA to 80U of Income Tax Act, 1961. There are different tax saving options i.e. Allowable Deductions/Exemption under Income Tax, are given under chapter VIA of the Income Tax Act, 1961. Summary of different tax saving section under which person can claim deduction or exemption from total Income are given below.

                          Deduction under section 80C for investment in various financial instrument, insurance policy, fixed deposits, etc. Maximum Deduction under Section 80C, 80CCC and 80CCD is Rs.150,000/-

                  Deduction under section 80CCA: Discontinued from April, 1992 Income Tax Deduction under section 80CCA for investment in National Savings Scheme or payment to a deferred annuity plan.

                         Deduction under section 80CCC for Contribution to pension scheme Maximum Deduction under Section 80C, 80CCC and 80CCD is Rs.100,000/- Deduction under section 80CCD for Contribution to pension scheme of Central Government.

             Deduction under section 80CCG for Contribution to equity shares or equity mutual fund under Rajiv Gandhi Equity Saving Scheme and maximum deduction under Section 80CCG is Rs.50,000/-

                          Deduction under section 80D for Contribution to medical premium and maximum deduction under Section 80D is Rs.15,000/-

                         Deduction under section 80DD for Contribution to medical treatment and maintenance of handicapped dependent and Maximum Deduction under Section 80DD is Rs.100,000/- & Rs 50,000/-.

                          Deduction under section 80DDB for Contribution to medical treatment of specified diseases and maximum deduction under Section 80DDB is Rs.60,000/- and Rs 40,000/-

                     Deduction under section 80E for interest payment of loan taken for higher education and there is no maximum Deduction under Section 80E so individual can total interest paid on education loan.

                      Deduction under section 80EE for interest payment of loan taken for new home for home loan amount of Rs 25 Lakhs and maximum Deduction under Section 80EE is Rs.100,000/-

                      Deduction under section 80G for Contribution/Donation to charitable organization and maximum deduction under Section 80G is 100% of contribution amount to 10% of 10% of adjusted gross total income of the taxpayer.

                      Deduction under section 80GG for payment of rent by individual salaried taxpayer who is not receiving House rent allowance (HRA) and should not own any residential accommodation and maximum deduction under Section 80GG is Rs 2000/- per Month.

.                      Deduction under section 80GGB for Contribution/ Donation to political parties by Indian Company and there is no maximum deduction limit under Section 80GGB so assessee can claim whatever donation he made to political party as deduction u/s 80GGB.

                      Deduction under section 80GGC for Contribution/ Donation to political parties by tax payer other than Indian Company and there is no maximum deduction limit under Section 80GGC so assessee can claim whatever donation he made to political party as deduction u/s 80GGC.

                    Deduction under section 80JJAA for additional wages paid to new workmen in factory and maximum deduction under Section 80JJAA is 30% of additional wages paid to new workmen in factory.

                     Deduction under section 80QQB for income from royalty to author for lump sum consideration for the assignment or grant of any of his interests in the copyright of any book being a work of literary, artistic or scientific nature, or of royalty or copyright fees in respect of such book and maximum deduction under Section 80QQB is Rs.300,000/-

                      Deduction under section 80RRB Any individual who is resident in India having a patent and receiving any income by way of royalty for that registered patent can claim maximum deduction of Rs 300,000/- from his gross total income for that royalty income.

                      Deduction under section 80U for disable person. Individual can claim deduction from taxable income based on his physical disability and amount of deduction is dependent on percentage of disability  and maximum deduction under Section 80U is Rs.50,000/- and Rs 100,000/-.

Thursday 24 April 2014

As per the Central Finance Budget 2013, The great news about the Income Tax Rebate  can get the tax payers who’s taxable Income not more than 5 Lakhs, It has been announced in Budget 2013 for Assessment Year 2014-15 worth Rs. 2000/-.  This rebate can be availed under section 87A.   For more clarity it is necessary to read clauses 19 and 20 of the bill as given below :-

Clauses 19 and 20 of the Bill seek to amend section 87 and insert a new section 87A in the Income-tax Act relating to rebate of income-tax in case of certain individuals.

The proposed new section 87A seeks to provide that an assessee, being an individual resident in India, whose total income does not exceed five hundred thousand rupees, shall be entitled to a deduction, from the amount of income-tax (as computed before allowing the deductions under Chapter VIII of the Income-tax Act) on his total income with which he is chargeable for any assessment year, of an amount equal to hundred per cent. of such income-tax or an amount of two thousand rupees, whichever is less.

Consequential amendments have been proposed in section 87, so as to provide reference to proposed new section 87A.

These amendments will take effect from 1st April, 2014 and will, accordingly, apply in relation to the assessment year 2014-15 and subsequent assessment years.

Below given the Excel Based New Amended Form 16 which can prepare automatically Form 16 Part B after filling the employee's Salary data. This Excel Based Software can prepare at a time 50 employees form 16 Part B and also can prepare another one Form 16 Part A&B both in one file. Download the Excel Based Software from the below link:-

Download Master of Form 16 Part B (Prepare at a time 50 employees Form 16 Part B) For FY 2013-14