Breaking News
Loading...
Share It

Enter your email address:

Powered by Feedio

Showing posts with label Tax Calculator for Financial Year 2014-15. Show all posts
Showing posts with label Tax Calculator for Financial Year 2014-15. Show all posts

Friday, 6 February 2015

Download & Prepare at a time any State Employees Automatic Tax Compute Sheet + Salary Structure + House Rent Exemption Calculation + Arrears Relief + Form 10E + Automated Form 16 Part A&B and Form 16 Part B for Financial Year 2014-15

This Excel Utility can prepare your Income Tax for the Financial Year 2014-15 & Assessment Year 2015-16 . Just put the data in Salary Sheet and the data in Data Input Sheet and prepare the Tax Computed Sheet + Arrears Relief U/s 89(1) + House Rent Exemption U/s 10(13A) Automatically. 

In this Excel Based Tax Calculator you can find the All of Income Tax Section with the New Section which introduce in the Finance Budget 2014. 
This Excel Utility most useful to All Central Govt employees as well as the All State Govt employees of India. In this Calculator in build a Salary Structure of all State Govt employees.
      Snapshot of Salary Structure for any State employees           


Download All in One TDS on Salary for All State Employees for the FY 2014-15(Automatic Tax Compute Sheet + Salary Structure + House Rent Exemption Calculation + Arrears Relief + Form 10E + Automated Form 16 Part A&B and Form 16 Part B for Financial Year 2014-15

Thursday, 11 December 2014

Click above link to download the All in One Income Tax Calculator for Financial Year 2014-15 ( This Excel Utility can prepare at a time Tax Compute Sheet + HRA Exemption+Form 16 Part A&B and Part B only for Private Employees)

Section 87A after Budget 2014

The existence of section 87A after budget 2014, since there were no words on the section 87A in the budget, many of our readers are eager to know whether the section 87A still exists or faded away like section 80EE.??

There is good news for all assessees who are getting benefited by section 87A because it will continue to give benefit this year also. Since section 87A is neither withdrawn nor was it for a particular year like section 80EE, so it still holds the ground. Even the Online Tax Calculator present on the Income Tax Site also calculates tax after taking tax rebate u/s 87A into account.

Thus assessee having gross total income between Rs.2.5 lakh to Rs.5 lakh are still able to reduce their tax liability by Rs 2,000. Essentially, there is NIL tax liability for annual income up to Rs.2.70 lakh. Calculate your Income tax by this Excel Based Income Tax Preparation Software for the Financial Year 2014-15

Click here to download the All in One Income Tax Calculator for the Financial Year 2014-15 (Prepare at a time Automated Tax Compute Sheet + HRA Calculation + Form 16 Part B and Part A&B for the Private employees for the Financial Year 2014-15 )


Tuesday, 18 November 2014

Click here to download Master of Form 16 Part A&B for the Financial Year 2014-15 ( This Excel Based 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 TRACES Portal, they can use this Excel Utility. The details of deduction U/s 80 is given below as per the latest amended for the Financial Year 2014-15.


Chart for deduction u/s 80C to 80U  Rebate u/s 87A
Section
Details of deductions
Quantum
Remarks
80C (Individual
& HUF)
A. ULIP of Spouse and Children and any member in case of HUF
B. Deferred annuity, SPF, RPF, PPF, Superannuation Fund, NSC(8TH),5 years   PO Time deposit, Senior citizen Saving Scheme, Term deposit of 5 years, Deposit for 10 or 15 years in Post office saving bank.
C. Bonds of NABARD, Deposit scheme of NHB, Notified deposit scheme,.
D. MF referred u/s 10(23D), Pension fund of MF[10(23D)], Eligible issue of securities.
E. Cost of purchase or construction of residential house including repayment of loan and expenses on transfer of property, tution fees to any educational institutions for full time eduction of 2 childrens.
Maximum Rs 1 ,50,000 is allowed Investment.

No Dedcution Allowed:
Terminates the insurance policy within 2 years, Terminate ULIP within 5 years, transfer house within 5 years
Limit of eligible premium in case of insurance policy on life of disable person has been increased to 15 % instead of 10 % from FY 13-14.
Max. 10% of the minimum amt assured under Life policies
80CCC
(Individual)
Deduction in case of contribution to pension fund. However, it should be noted that surrender value or employer contribution is considered income.
Maximum is Rs 1,00,000
Aggregate of 80C  80CCC  80CCD is Rs 1,00,000
80CCD
(individual)  
Deduction in respect to contribution to new pension scheme. Employees of central and others are eligible.
Maximum is sum of employer’s and employee’s contribution to the scheme limited upto 10 % of salary.
Aggregate of 80C  80CCC  80CCD is Rs 1,00,000
80CCE
It should be noted that employer contribution is allowable as extra u/s 80CCD(2) of the Income Tax Act from Asst Yr 2012-13 and only employee's contribution is within limit of Rs 1 Lakh as stated in 80CCE
It should be noted that as per section 80CCE , the maximum amount of deduction which can be claimed in aggregate of 80C ,80CCC  80CCD(1) is Rs 1,00,0000

80CCG
Individual having gross total income upto Rs 12 Lakh can claim this deduction for inveting in IPOs of share or mututal fund units.
50 % 0f the invested amount . Limit is Rs 25,000 max.
The deduction is allowed for three years only.
80D
(Individual &HUF)
Medical insurance on self, spouse , children or parents. The deuction is also allowable for CGHS contribution to Cenral and State scheme. It is also for conducting health check up to Rs 6000.
Age Below 60 years: Rs 15,000 including Rs. 5000 on preventive checkup for self , spouse  children + Rs 15,000 for insurance on parents.
Age above 60 years: Replace Rs 15,000 with 20,000.
Cash payment not allowed. But for Preventive Checkup it is allowed.
80DD (Individual &HUF)
For maintenance including treatment or insurancing the lives of physical disable dependent relatives
Rs 50,000 . In case disability is severe , the amount is Rs 1,00,000.
dependent relatives includes spouse, child, parents, brother sister
80DDB (Individual &HUF)
For medical treatment of self or relatives suffering from specified disease
Acutal amount paid to the extent of Rs 40,000. In case of patient being Sr Citizen , amount is Rs 60,000.
Deduction reduced by the amount received under insurance from an insurer or reimbursed by an employer.
80E
(Individual)
For interest payment on loan taken for higher studies(after 12)  for self or education of spouse or children
Actual amount paid as interest and start from the financial year in which he /she starts paying interest and upto maximum of 8 years.
loan from any financial institution banking or approved charitable institution
80EE
interest on home loan sanctioned during Fy 2013-14. However, value of the property should be below Rs 50 Lakh and max loan sanctioned should be Rs 25 lakh. Further assessee should not have any other residential house.
RS 1 lakh

80G
(All Assessee)
Donations to charitable institution
(Max. 10,000 if paid in cash from A/Y 13-14)
100% of amount of donation made to 19 entities (National defense fund , Prime minister relief fund etc. ).  50%  (Gandhi/ Drouhgt/ charitable purpose/infrastructural development fund). For Asst Yr 2014-15, Natital Children Fund will also get 100% deduction.
Where the aggregate
of sums exceed 10% of adjusted gross total income, then such excess amount is ignored for computing such aggregate.
80GG
For rent paid
This is only for people not getting any House Rent Allowance. Maximum is Rs 2000 per month. Rule 11B is method of computation.

80GGA
For donation to entities in scientific research or rural development (Max. 10,000 if paid in cash from A/Y 13-14)
Only those tax payers who have no business income can claim this deduction .Maximum is equivalent to 100 % of donation.
Cash payment not allowed
80GGB  80GGC
For contribution to political parties
100 % of donations
Cash payment not allowed
80QQB
Allowed only to resident authors for royalty income for books other than text book
Royalty income or Rs 3,00,000 whichever is less.

80RRB
For income receipt as royalty on patents of resident individuals
Actual royalty or Rs 3,00,000 whichever is less.

80U
Deduction in respect of permanent physical disability including blindness to taxpayer
RS 50,000 which goes to Rs 1,00,000 in case taxpayer is suffering from severe disability.

87A
Rebate to individual having low taxable income
Amount of tax or Rs 2,000 which ever is less
Only resident individual gets this rebate.

Download All in One TDS on Salary for Govt and Non-Govt Employees [This Excel Based Software can prepare at a time Tax Compute Sheet + Arrears Relief Calculation + HRA Calculation + Form 16 Part A&B and Part B]

Wednesday, 22 October 2014

Free Income Tax Calculator for Financial Year 2014-15 & Ass Year 2015-16

This Excel Utility can prepare your Income Tax for the Financial Year 2014-15 & Assessment Year 2015-16 . Just put the data in Salary Sheet and the data in Data Input Sheet and prepare the Tax Computed Sheet + Arrears Relief U/s 89(1) + House Rent Exemption U/s 10(13A) Automatically. 
In this Excel Based Tax Calculator you can find the All of Income Tax Section with the New Section which introduce in the Finance Budget 2014. 
This Excel Utility most useful to All Central Govt employees as well as the All State Govt employees of India. 
In this Calculator in build a Salary Structure of all State Govt employees.

Download All in One TDS on Salary for All State Employees for the FY 2014-15

Thursday, 16 October 2014

Click to download All in One Master of Form 16 Part B( This excel utility can prepare at a time 50 employees Form 16 Part B with Individual Salary Sheet + Individual Salary Structure)
With the tax-planning season about to end, most individuals are rushing around to make investments to minimize their tax liability. It has been observed that individuals (often salaried ones) end up paying more taxes than they are obligated to.
While lack of sufficient time to conduct the tax-planning exercise is a reason, largely, this can be attributed to lack of awareness about different incentives, allowances and rebates under the Income Tax Act. Apart from the Section 80C deductions which are quite popular, there are various other sections which can help salaried individuals save taxes.
We believe there is a need for salaried individuals to devote adequate time and effort to the tax planning exercise and be aware of the various benefits that they can avail of. In this article, we present 5 tax-planning tips that can aid salaried individuals minimize their tax liability.
1. Utilise the entire Section 80C deduction Click to view details of 80C
Under Section 80C, the maximum deduction available is Rs 150,000 pa. Ideally, salaried individuals whose gross total income is equal to or more than Rs 250,000 should utilise the entire Rs 150,000 limit.
Also, at times, individuals make investments of over Rs 150,000 in Section 80C designated avenues, since they fail to understand that the benefits are capped. For example, despite making investments of Rs 70,000 in Public Provident Fund and Rs 40,000 in ELSS, the amount eligible is only Rs 150,000.
Following investments/contributions qualify for Section 80C deductions,
  • Public Provident Fund
  • National Saving Certificate
  • Accrued interest on National Saving Certificate
  • Life Insurance Premium
  • Tuition fees paid for children's education (maximum 2 children)
  • Principal component of home loan repayment
  • Equity Linked Savings Schemes (ELSS)
  • 5-Year fixed deposits with banks and Post Office

Download Income Tax Preparation Excel Based Software for Financial Year 2014-15 for all Central Govt employees ( Tax Compute Sheet + HRA Exemption Calculation + Form 16 Part A&B and Part B)

For salaried individuals whose gross total income exceeds Rs 250,000 pa, deductions under Section 80C may not be sufficient to reduce the overall tax liability. In such cases they can consider the following:
Home loan: Individuals intending to buy a house should consider opting for a home loan. Interest payments of upto Rs 2,00,000 pa are eligible for deduction under Section 24. And Another Section can avail HB Loan Interest up to Rs. 1 Lakh U/s 80EE since 1/4/2013
Medical insurance: An individual who pays medical insurance premium for self or spouse/dependent children is allowed a deduction of upto Rs 15,000 pa under section 80D.
An additional deduction of up to Rs 15,000 pa is allowed for premium payment made for parents. In case the parents are senior citizens, then the maximum deduction allowed is Rs 20,000 per year.
Donations: Subject to the stated limits, donations to specified funds/institutions are eligible for tax benefits under Section 80G.
Salaried individuals who plan to pursue higher education should avail of an education loan as the entire interest is eligible for deduction under Section 80E. The loan can be for self, spouse or child from an approved charitable institution or a notified financial institution.
3. Restructure the salary
Restructuring the salary and including certain components can go a long way in reducing the tax liability. Unlike eligible investments which lead to an additional cash outflow, restructuring the salary is a more 'efficient' means of claiming tax benefits. The following can form a part of one's salary structure:





  • Food coupons like Sodexo and Ticket Restaurant; they are exempt from tax up to Rs 60,000 per year.
  • Medical expenses which are reimbursed by the employer are exempt up to Rs 15,000 per year.
  • Individuals living in a rented accommodation should have House Rent Allowance (HRA) as part of their salary.
  • Transport allowance is exempt upto Rs 800 per month.
  • Leave Travel Allowance (LTA) can be claimed twice in a block of four years for domestic travel.
    4. Claim tax benefits on house rent paid Calculate HRA Exemption U/s 10(13A)
    Salaried individuals can claim rent paid by them for residential accommodation, if HRA doesn't form part of their salary. This deduction is available under Section 80GG and is least of the following:
  • 25% of the total income or,
  • Rs 2,000 per month or,
  • Excess of rent paid over 10% of total income
    Please note that the above deduction will be denied if the taxpayer or his spouse or minor child owns a residential accommodation in the location where the taxpayer resides or performs his office duties.
    5. Opt for a joint home loan
    As discussed earlier, the principal repayment on a home loan is eligible for a deduction of up to Rs 150,000 pa and the interest paid is eligible for a deduction of up to Rs 2,00,000 per year.
    In cases where the home loan is for a substantial sum, it is not uncommon for the interest and principal repayment to exceed the stated limit. To ensure that the tax benefit is optimally utilised, an individual can consider opting for a joint loan with his spouse or parent or sibling.
    This will ensure that both the co-owners can claim tax deductions in the proportion of their holding in the loan. The co-owner falling in the higher tax bracket should hold a higher proportion of home loan to ensure that the tax benefits are maximised.

    Download All in One TDS on Salary for only Non-Govt Employees for the Financial Year 2014-15 ( Prepare at a time Tax Compute Sheet + Individual Salary Structure as per Non-Govt Salary Pattern + Automated HRA Exemption U/s 10(13A) + Automated Form 16 Part A&B and Part B)


  • Tuesday, 7 October 2014

    Download Excel Utility
    Click above to download the Tax Preparation Excel Based Software ( All in One ) for Only Private Concerned Employees for FY 2014-15
    Taxation and evasion are the two facets of a single coin. Whenever there is a question of taxation, individuals often look to find ways to avoid paying their tax liability in any which way possible. Even the government has devised investments which are tax free and offer a rebate in your taxable income. There are various sections which specifically cater to particular investments like 80C, 80D, 80DD, 24(b), etc. For now, let us concentrate on the benefits available under section 80D.
    What does section 80D cover?
    Section 80D deals with the contributions made by individuals towards their health insurance premium. According to this section, any amount paid by an assessee (an individual who is liable to pay tax on his income) or a HUF (Hindu Undivided Family) towards mediclaim insurance for their family (self, spouse, children and parents in case of an individual) or their members (in case of a HUF) would be exempt from tax. This exemption is over and above the exemption granted under section 80C.
    What are the conditions to avail exemption under the section?
    The exemption can be claimed by an individual (resident or non-resident) or by a HUF.
    The payment must be made by any mode other than cash. Cash payments do not qualify for exemption.
    An individual can make contribution for his parents whether they are dependent on him or not.
    What is the maximum amount of deduction?
    The maximum amount that can be availed under section 80D is Rs. 40,000. However, a new sub limit of Rs. 5000 has been introduced under this section for preventive health check up for self, spouse, children and parents with effect from the financial year 2012-13. This introduction raises the maximum deductible amount to Rs. 45,000.
    How is the total amount segregated?
    The maximum amount available to an individual paying towards self, spouse and children is Rs. 15,000. A further Rs. 15000 is allowed if payment is made for parents. If the parents have attained 60 years or more, the amount increases to Rs. 20,000. If the assessee or any of his family is above 60 years, then the maximum allowable amount is Rs. 20,000 for self, spouse and children and another Rs. 20,000 for parents (given they are 60 or above).
    Thus, many of us are unaware of the actual total benefit we can avail under section 80D in respect of our mediclaim insurance. We generally consider Rs. 15,000 for ourselves and an additional Rs. 20,000 in case of our parents, if covered. The additional amount of Rs. 5000 escapes our knowledge simply because it was introduced quite recently. So, sit up and take notice of your deductions, they may well save quite a considerable amount of your tax.
    Click here & Calculate and Prepare your Tax for the Financial Year 2014-15 (All in One TDS on Salary for Govt and Non-Govt employees Tax Calculator Fy 2014-15)