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)
September 03, 2020Automated Income Tax Arrears Relief Calculator for F.Y. 2020-21, Income Tax Form 10e in Excel Format, Income Tax New Section 115BAC, Income Tax New Slab for the F.Y.2020-21No comments
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
October 26, 2019Download Automated Income Tax arrears Relief Calculator U/s 89(1) for F.Y. 2019-20, How to file income tax Form 10E, Income Tax Form 10e in Excel FormatNo comments
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
- 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
- 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.
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
October 20, 2019Aumated Income Tax Arrears Relief Calculator U/s 89(1) for F.Y. 2019-20, Income Tax Section 80C, Income Tax Form 10e in Excel FormatNo comments
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
October 15, 2019Aumated Income Tax Arrears Relief Calculator U/s 89(1) for F.Y. 2019-20, Income Tax Section 80C, Income Tax Form 10e in Excel FormatNo comments
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
October 14, 2019Aumated Income Tax Arrears Relief Calculator U/s 89(1) for F.Y. 2019-20, Income Tax Section 80C, Income Tax Form 10e in Excel FormatNo comments
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
October 11, 2019Aumated Income Tax Arrears Relief Calculator U/s 89(1) for F.Y. 2019-20, Income Tax Section 80C, Income Tax Form 10e in Excel FormatNo comments
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
November 25, 2018Automated Income Tax Excel Software All in One for Govt. & Non-Govt Employees for the F.Y. 2018-19, how to Claim Health Insurance under Section 80D from 2018-19, Income Tax Form 10e in Excel FormatNo comments
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.





















