Showing posts with label Income Tax Form 10e in Excel Format. Show all posts
Showing posts with label Income Tax Form 10e in Excel Format. Show all posts

Thursday, 3 September 2020

Automated Income Tax Arrears Relief Calculator U/s 89(1) With Form 10E For the F.Y.2020-21 (Amended Version)


Did you get any development salary or arrears of salary? In the event that truly, you may be stressed over the tax ramifications of the equivalent. Do I need to pay taxes on the total amount? Shouldn't something be said about the tax counts of the earlier year, etc? Taxpayers who have such inquiries in their brain here is all that you have to know.

At this point, you would have just made sense of that income tax is calculated on the total income of a taxpayer for a specific year. The income can either be as salary or family annuity or different wellsprings of income. In any case, there may be situations where you have gotten arrears of family benefits or pending salary during the current monetary year. It can happen that an income taxpayer gets a piece of his benefit or salary ahead of time or as arrears in any money related year, which builds his total income accordingly increment the payable taxes. In such a case, an application can be made and the surveying official can allow relief to the taxpayer. To summarize it, the Income Tax Act guarantees there is equality in the income tax chunk rates, and hence, when a bit of the income got doesn't relate to the current year, a relief is conceded with the goal that the taxable income doesn't increment.

 

To guarantee that you are not troubled with making good on extra taxes, the income tax office gives Relief U/s 89(1). In the event that you get any annuity or instalments for the earlier year, you won't be taxed on the total amount for the current year. Basically getting you far from settling extra taxes, in light of the fact that there was a postponement in instalment.

 

To profit the advantages under Section 89(1) you would need to submit Form 10E. What is Form 10E would be the most evident inquiry. The subtleties of Form 10E, alongside how and for what reason to present the equivalent is given in detail underneath.

 

What is relief under section 89(1)?

 

At the point when the taxpayer gets:

 

1.         Arrears of salary or

 

2.         Advance salary or

 

3.         Arrears of family annuity

 

At that point, such amount is taxable in the Financial Year in which it is gotten.

 

Be that as it may, relief under section 89(1) is given to diminish extra tax trouble because of deferral in getting such income.

 

How to calculate relief under section 89(1)?

 

Here are the means to calculate relief under section 89(1) of Income Tax Act, 1961:

 

1.         Calculate tax payable on total income remembering arrears for the year in which it is gotten.

 

2.         Calculate tax payable on total income barring arrears in the year in which it is gotten.

 

3.         Calculate contrast somewhere in the range of (1) and (2).

 

4.         Calculate tax payable on total income of the year to which arrears are connected, including arrears.

 

5.         Calculate tax payable on total income of the year to which arrears are connected, barring arrears.

 

6.         Calculate contrast somewhere in the range of (4) and (5).

 

7.         The amount of relief will be the overabundance amount of (3) more than (6). No relief will be permitted if the amount of (6) is more than the amount in (3).

 

What is Form 10E?

 

For guaranteeing relief under section 89(1) for arrears of salary got, it is required to record Form 10E with the Income Tax division. In the event that Form 10E isn't recorded and relief is guaranteed, at that point the taxpayer is well on the way to get a notice from Income Tax office for not documenting Form10E.

Download Automated Income Tax Arrears Relief Calculator U/s 89(1) along with Form 10Efrom the Financial Year 2000-01 to Financial Year 2020-21 (Up-to-date Version)




 

Saturday, 26 October 2019

Download Automated Income Tax Arrears Relief Calculator U/s 89(1) with Form 10E From F.Y. 2000-01 to F.Y. 2019-20


HOW TO CLAIM RELIEF WHEN SALARY IS PAID IN ARREARS OR IN ADVANCE
Whereby any portion of assessee’s salary is received in arrears or in advance or by reason of his having received in any one financial year salary for more than 12 months or payment which under the provisions of section 17(3) is a profit in lieu of salary, he is hence taxed at a higher slab than that at which it would otherwise have been assessed. The Assessing Officer shall, on an Application made to him, grant such relief as prescribed. The Procedure for computing the relief is given in Rule 21.  This relief is provided in the financial year in which such arrears have been received.

The Procedure to calculate the amount of relief when salary is paid in arrears or in advance:-
STEP 1
First of all, calculate the tax payable of the previous year in which the arrears /advance salary is received on
      1.Total Income inclusive of Additional Salary
  1. Total Income exclusive of Additional Salary
The Difference between 1 & 2 is the tax on additional salary Included in total Income.
STEP 2
Now calculate the tax payable of every previous year to which the additional salary relates to
  1. 3.The total Income including Additional Salary
    The Total Income excluding Additional Salary
Calculate the difference between 4 & 5 for every previous year to which the additional salary relates & aggregates them.
STEP 3
The Admissible Relief shall be the Excess between the tax on Additional salary as calculated under STEP 1 & STEP 2.
No relief if:
  • There is no excess between the tax calculated on Additional Salary (Step 1 & Step 2)
  • In respect of any amount received or receivable by an assessee on his voluntary retirement or termination of his service in accordance with any scheme, the assessee has claimed exemption u/s 10(10C) in respect of such compensation received on voluntary retirement in the same assessment year or any other assessment year.
 WHERE AND HOW TO FURNISH INFORMATION FOR CLAIMING RELIEF
In the case where the assessee entitled to relief is a government servant or an employee in a company, co-operative society, local authority, university, association, institution, he
may furnish the particulars to his employer who is responsible for making the payment referred to in section 192(1) in specified form 10E.
In the case of other employees, the application for relief shall have to be made to the Assessing Officer instead of Employer.

Download Automated Section 89(1) Income Tax Arrears Relief Calculator with Form 10E From F.Y.2000-01 to Financial Year 2019-20 [Updated Version)
 
 






Sunday, 20 October 2019

INCOME TAX DEDUCTIONS U/s 80C FOR F.Y 2019-20 & A.Y 2020-21,WITH AUTOMATED INCOME TAX ARREARS RELIEF CALCULATOR U/S 89(1) WITH FORM 10E FOR F.Y. 2019-20


The maximum tax exemption limit under Section 80C has been retained at Rs 1.5 Lakh only. The various investment avenues or expenses that can be claimed as tax deductions under section 80c are as below;
  • PPF (Public Provident Fund)
  • EPF (Employees’ Provident Fund)
  • Five year Bank or Post office Tax Saving Deposits
  • NSC (National Savings Certificates)
  • ELSS Mutual Funds (Equity Linked Saving Schemes)
  • Kid’s Tuition Fees
  • SCSS (Post office Senior Citizen Savings Scheme)
  • Principal repayment of Home Loan
  • NPS (National Pension System)
    • Income Tax benefits are currently available on Tier-1 deposits only (FY 2018-19). The contributions by the government employees (only) under Tier-II of NPS will also be covered under Section 80C for deduction up to Rs 1.5 lakh for the purpose of income tax, with a three-year lock-in period. This is w.e.f April 2019.
  • Life Insurance Premium
  • Sukanya Samriddhi Account Deposit Scheme
Section 80CCC
Contribution to the annuity plan of LIC (Life Insurance Corporation of India) or any other Life Insurance Company for receiving a pension from the fund is considered for tax benefit. The maximum allowable Tax deduction under this section is Rs 1.5 Lakh.
Section 80CCD
The employee can contribute to the Government notified Pension Schemes (like National Pension Scheme – NPS). The contributions can be up to 10% of the salary (salaried individuals) and Rs 50,000 additional tax benefit u/s 80CCD (1b) was proposed in Budget 2015.
As per the Budget 2017-18, the self-employed (individual other than the salaried class) can contribute up to 20% of their gross income and the same can be deducted from the taxable income under Section 80CCD (1) of the Income Tax Act, 1961.
To claim this deduction, the employee has to contribute to Govt recognized Pension schemes like NPS. The 10% of the salary limit is applicable for salaried individuals only and the Gross income is applicable for non-salaried. The definition of Salary is only ‘Dearness Allowance.’ If your employer also contributes to the Pension Scheme, the whole contribution amount (10% of salary) can be claimed as tax deduction under Section 80CCD (2).
The Centre will now contribute 14% of basic salary to Govt employees’ pension corpus, up from 10%. This is w.e.f April 2019.
Kindly note that the Total Deduction under section 80C, 80CCC and 80CCD(1) together cannot exceed Rs 1,50,000 for the financial year 2019-20. The additional tax deduction of Rs 50,000 u/s 80CCD (1b) is over and above this Rs 1.5 Lakh limit.
Contributions to ‘Atal Pension Yojana‘ are eligible for Tax Deduction under section 80CCD.

Free Download Automated Income Tax Arrears Relief Calculator U/s 89(1) From the F.Y. 2000-01 to F.Y. 2019-20 [ Updated Version ]

 


 

Tuesday, 15 October 2019

INCOME TAX DEDUCTIONS U/s 80C FOR F.Y 2019-20 & A.Y 2020-21,WITH AUTOMATED INCOME TAX ARREARS RELIEF CALCULATOR U/S 89(1) WITH FORM 10E FOR F.Y. 2019-20


The maximum tax exemption limit under Section 80C has been retained at Rs 1.5 Lakh only. The various investment avenues or expenses that can be claimed as tax deductions under section 80c are as below;
  • PPF (Public Provident Fund)
  • EPF (Employees’ Provident Fund)
  • Five year Bank or Post office Tax Saving Deposits
  • NSC (National Savings Certificates)
  • ELSS Mutual Funds (Equity Linked Saving Schemes)
  • Kid’s Tuition Fees
  • SCSS (Post office Senior Citizen Savings Scheme)
  • Principal repayment of Home Loan
  • NPS (National Pension System)
    • Income Tax benefits are currently available on Tier-1 deposits only (FY 2018-19). The contributions by the government employees (only) under Tier-II of NPS will also be covered under Section 80C for deduction up to Rs 1.5 lakh for the purpose of income tax, with a three-year lock-in period. This is w.e.f April 2019.
  • Life Insurance Premium
  • Sukanya Samriddhi Account Deposit Scheme
Section 80CCC
Contribution to the annuity plan of LIC (Life Insurance Corporation of India) or any other Life Insurance Company for receiving a pension from the fund is considered for tax benefit. The maximum allowable Tax deduction under this section is Rs 1.5 Lakh.
Section 80CCD
The employee can contribute to the Government notified Pension Schemes (like National Pension Scheme – NPS). The contributions can be up to 10% of the salary (salaried individuals) and Rs 50,000 additional tax benefit u/s 80CCD (1b) was proposed in Budget 2015.
As per the Budget 2017-18, the self-employed (individual other than the salaried class) can contribute up to 20% of their gross income and the same can be deducted from the taxable income under Section 80CCD (1) of the Income Tax Act, 1961.
To claim this deduction, the employee has to contribute to Govt recognized Pension schemes like NPS. The 10% of the salary limit is applicable for salaried individuals only and the Gross income is applicable for non-salaried. The definition of Salary is only ‘Dearness Allowance.’ If your employer also contributes to the Pension Scheme, the whole contribution amount (10% of salary) can be claimed as tax deduction under Section 80CCD (2).
The Centre will now contribute 14% of basic salary to Govt employees’ pension corpus, up from 10%. This is w.e.f April 2019.
Kindly note that the Total Deduction under section 80C, 80CCC and 80CCD(1) together cannot exceed Rs 1,50,000 for the financial year 2019-20. The additional tax deduction of Rs 50,000 u/s 80CCD (1b) is over and above this Rs 1.5 Lakh limit.
Contributions to ‘Atal Pension Yojana‘ are eligible for Tax Deduction under section 80CCD.

Free Download Automated Income Tax Arrears Relief Calculator U/s 89(1) From the F.Y. 2000-01 to F.Y. 2019-20 [ Updated Version ]

 


 

Monday, 14 October 2019

INCOME TAX DEDUCTIONS U/s 80C FOR F.Y 2019-20 & A.Y 2020-21,WITH AUTOMATED INCOME TAX ARREARS RELIEF CALCULATOR U/S 89(1) WITH FORM 10E FOR F.Y. 2019-20


The maximum tax exemption limit under Section 80C has been retained at Rs 1.5 Lakh only. The various investment avenues or expenses that can be claimed as tax deductions under section 80c are as below;
  • PPF (Public Provident Fund)
  • EPF (Employees’ Provident Fund)
  • Five year Bank or Post office Tax Saving Deposits
  • NSC (National Savings Certificates)
  • ELSS Mutual Funds (Equity Linked Saving Schemes)
  • Kid’s Tuition Fees
  • SCSS (Post office Senior Citizen Savings Scheme)
  • Principal repayment of Home Loan
  • NPS (National Pension System)
    • Income Tax benefits are currently available on Tier-1 deposits only (FY 2018-19). The contributions by the government employees (only) under Tier-II of NPS will also be covered under Section 80C for deduction up to Rs 1.5 lakh for the purpose of income tax, with a three-year lock-in period. This is w.e.f April 2019.
  • Life Insurance Premium
  • Sukanya Samriddhi Account Deposit Scheme
Section 80CCC
Contribution to the annuity plan of LIC (Life Insurance Corporation of India) or any other Life Insurance Company for receiving a pension from the fund is considered for tax benefit. The maximum allowable Tax deduction under this section is Rs 1.5 Lakh.
Section 80CCD
The employee can contribute to the Government notified Pension Schemes (like National Pension Scheme – NPS). The contributions can be up to 10% of the salary (salaried individuals) and Rs 50,000 additional tax benefit u/s 80CCD (1b) was proposed in Budget 2015.
As per the Budget 2017-18, the self-employed (individual other than the salaried class) can contribute up to 20% of their gross income and the same can be deducted from the taxable income under Section 80CCD (1) of the Income Tax Act, 1961.
To claim this deduction, the employee has to contribute to Govt recognized Pension schemes like NPS. The 10% of the salary limit is applicable for salaried individuals only and the Gross income is applicable for non-salaried. The definition of Salary is only ‘Dearness Allowance.’ If your employer also contributes to the Pension Scheme, the whole contribution amount (10% of salary) can be claimed as tax deduction under Section 80CCD (2).
The Centre will now contribute 14% of basic salary to Govt employees’ pension corpus, up from 10%. This is w.e.f April 2019.
Kindly note that the Total Deduction under section 80C, 80CCC and 80CCD(1) together cannot exceed Rs 1,50,000 for the financial year 2019-20. The additional tax deduction of Rs 50,000 u/s 80CCD (1b) is over and above this Rs 1.5 Lakh limit.
Contributions to ‘Atal Pension Yojana‘ are eligible for Tax Deduction under section 80CCD.

Free Download Automated Income Tax Arrears Relief Calculator U/s 89(1) From the F.Y. 2000-01 to F.Y. 2019-20 [ Updated Version ]

 


 

Friday, 11 October 2019

INCOME TAX DEDUCTIONS U/s 80C FOR F.Y 2019-20 & A.Y 2020-21,WITH AUTOMATED INCOME TAX ARREARS RELIEF CALCULATOR U/S 89(1) WITH FORM 10E FOR F.Y. 2019-20


The maximum tax exemption limit under Section 80C has been retained at Rs 1.5 Lakh only. The various investment avenues or expenses that can be claimed as tax deductions under section 80c are as below;
  • PPF (Public Provident Fund)
  • EPF (Employees’ Provident Fund)
  • Five year Bank or Post office Tax Saving Deposits
  • NSC (National Savings Certificates)
  • ELSS Mutual Funds (Equity Linked Saving Schemes)
  • Kid’s Tuition Fees
  • SCSS (Post office Senior Citizen Savings Scheme)
  • Principal repayment of Home Loan
  • NPS (National Pension System)
    • Income Tax benefits are currently available on Tier-1 deposits only (FY 2018-19). The contributions by the government employees (only) under Tier-II of NPS will also be covered under Section 80C for deduction up to Rs 1.5 lakh for the purpose of income tax, with a three-year lock-in period. This is w.e.f April 2019.
  • Life Insurance Premium
  • Sukanya Samriddhi Account Deposit Scheme
Section 80CCC
Contribution to the annuity plan of LIC (Life Insurance Corporation of India) or any other Life Insurance Company for receiving a pension from the fund is considered for tax benefit. The maximum allowable Tax deduction under this section is Rs 1.5 Lakh.
Section 80CCD
The employee can contribute to the Government notified Pension Schemes (like National Pension Scheme – NPS). The contributions can be up to 10% of the salary (salaried individuals) and Rs 50,000 additional tax benefit u/s 80CCD (1b) was proposed in Budget 2015.
As per the Budget 2017-18, the self-employed (individual other than the salaried class) can contribute up to 20% of their gross income and the same can be deducted from the taxable income under Section 80CCD (1) of the Income Tax Act, 1961.
To claim this deduction, the employee has to contribute to Govt recognized Pension schemes like NPS. The 10% of the salary limit is applicable for salaried individuals only and the Gross income is applicable for non-salaried. The definition of Salary is only ‘Dearness Allowance.’ If your employer also contributes to the Pension Scheme, the whole contribution amount (10% of salary) can be claimed as tax deduction under Section 80CCD (2).
The Centre will now contribute 14% of basic salary to Govt employees’ pension corpus, up from 10%. This is w.e.f April 2019.
Kindly note that the Total Deduction under section 80C, 80CCC and 80CCD(1) together cannot exceed Rs 1,50,000 for the financial year 2019-20. The additional tax deduction of Rs 50,000 u/s 80CCD (1b) is over and above this Rs 1.5 Lakh limit.
Contributions to ‘Atal Pension Yojana‘ are eligible for Tax Deduction under section 80CCD.

Free Download Automated Income Tax Arrears Relief Calculator U/s 89(1) From the F.Y. 2000-01 to F.Y. 2019-20 [ Updated Version ]

 


 

Sunday, 25 November 2018

Automated Income Tax Excel Software All in One for Govt. & Non-Govt Employees for the F.Y. 2018-19 With how to claim Health Insurance under Section 80D from 2018-19

Health insurance Plans are important for us which would help to stave upper forfeit hospitalization expenses. We can requirement premium paid for health insurance plan under section 80D. It could for the premiums paid for self or family or for parents, we can require such value from income tax deductions. What is Section 80D all about? How to requirement Health Insurance under Section 80D of the IT Act from Towage Year 2018-19 onwards? Can we requirement 80D without financial year is closed? This vendible would provide the well-constructed guide on Section 80D deductions.

The Central Board of uncontrived taxes (CBDT) has un-liable the deduction towards the premium paid for health insurance U/s 80D of the Income Tax Act, 1961. There are a few important things to note regarding this matter

1) An individual or HUF can requirement the deduction u/s 80D for the premium paid for Health Insurance.

2) Payment should be made out of income chargeable to tax.

3) Payment should be made by any mode other than cash.

An individual can take the deduction of health insurance, preventive Health check-up and medical expenditure fees paid for the pursuit of persons: –

1) Self

2) Spouse

3) Dependent Children

4) Own parents (not spouse parents).

How to requirement Health Insurance under Section 80D of the IT Act from A.Y. 2018-19?

The pursuit tax regime would guide you well-nigh the deductions on payment of health insurance premium

If any taxpayer pays the health premium of himself and his family, he can requirement  the deduction in the pursuit manner:

Note: – in a specimen of parents, the parents of the spouse are not included)

If an individual pays the premium of health insurance of his parents, then withal with his family, he is entitled to spare deduction u/s 80D as described in the whilom table.

You may like: Which are the Upper-Interest Rates Post Office Schemes?

Deduction on preventive healthcare checkups. Along with the same limit of Rs. 25,000 (or Rs. 30,000 in a specimen of senior citizens), you can moreover requirement expenses incurred for preventive health checkups up to Rs 5,000 every financial year. This deduction can be personal only for senior citizens. This payment can be made through cash.

One important point to note is that the payment for medical insurance premium should be made through online banking, cheque, debit card, credit vellum or a draft. The tax deduction is not un-liable for payment of maximum towards the premium.

Eligibility for normal individuals and Senior Citizens

Under this Section, a taxpayer gets a maximum deduction of Rs. 25,000/- for Health insurance and preventive health check-up paid for himself, spouse and dependent children.

If the taxpayer or any family member is of 60 years or more, then the same deduction will be increased to Rs.30,000/-

If the parents are 80 years or more, then the payment towards the medical expenses is moreover misogynist as the deduction under this section.

What was eligible in Section 80D till the financial year 2016-17 (the Assessment year 2017-18)?

The exemptions u/s 80D for the financial year ending 31/3/2017 is the same as it was in previous years. There is no transpiration in the value of deduction in this towage year (i.e. 2018-19) as compared to the towage year 2017-18. It is worth mentioning here that the Finance Minister has introduced few changes in this upkeep but they are workable from next towage year i.e. 2019-20.

Can we requirement 80D without financial year is closed?

If an individual has filed his/ her IT return on time on or surpassing the due stage as prescribed u/s 139 and at the time of filing of return, he/she has by mistake forgot to require the deduction u/s 80D towards the premium paid for health insurance, then he/she can file the revised return and can requirement the deduction U/s 80D.

What are the exclusions in section 80D?

Here are the exclusions.

1) In order to get tax benefits u/s 80D, only the taxpayer must pay the health insurance premiums and not any third party. The payment of premium should not be made through maximum except for the preventive health checkups.

2) The taxpayers are not liable to receive any tax benefits on the Service tax and Cess charges levied on the premium paid.

3) Group health Insurance policies are not liable to vamp any tax benefits u/s 80D. However, if a taxpayer chooses to make the uneaten premium payments to enhance the group cover, he can require a deduction for that uneaten amount.

4) Such health insurance premiums should be paid surpassing 31st March to the requirement for that financial year.

Download Automated Income Tax Excel Based Software All in One TDS on Salary for Govt & Non-Govt Employees for the Financial Year 2018-19 & Ass Year 2019-20

Main Feature of this Excel Utility are:-

1) Automatic Calculate your Tax Liability after filing the Salary Structure

2) Inbuilt the Individual Salary Structure as per the Govt and Non-Govt Salary Pattern.

3) Automatic Calculate the House Rent Exemption Calculation U/s 10(13A)

4) Automated Arrears Relief Calculation U/s 89(1) with Form 10E Since F.Y.2000-01 to F.Y. 2018-19

5) Automated prepare Individual Salary Sheet

6) Automatic Prepare Individual Tax Computed Sheet

7) Automated Income Tax Form 16 Part A & B for F.Y.2018-19

8) Automated Income Tax Form 16 Part B for F.Y. 2018-19

9) Automatic Convert the Amount into the In-Words without any Excel Formula

10) All the amended Income Tax Section have in this Utility as per the Finance Budget 2018-19

11) Easy to Install ( Just like an Excel File)

12) You can prepare more than 100 employees Tax Calculation by this One Utility.