We have created this excel sheet to help out every Indian individuals. Because we understand that most of peoples struggles in calculating the income tax during ITR. Specifically, middle class, lower middle cast and salaried persons. We included most of the deductions and exemptions options as well as investments which can exempt. You can also adjust on the basis of requirement.
Deductions
Less: Deduction under Sec 80C (Max Rs.1,50,000/-)
Public Provident Fund
E.L.S.S Tax Saving Funds
Tax Saving Fixed Deposits (5 and 5+ years)
Life Insurance Premiums
Principal Repayment of Housing. Loan
Stamp Duty & Registration Charges
80 CCD Central Govt. Employees Pension Plan (u/s 80CCD)
Pension Plan from Insurance Companies/Mutual Funds (u/s 80CCC)
Tuition fees (Max 2 children)
EPF & VPF Contribution
Tax Savings Bonds
Senior Citizen’s Saving Scheme (SCSS)
N.S.C (Investment + accrued Interest before Maturity Year)
Sukanya Samriddhi Account
New Pension Scheme (NPS) (u/s 80CCC)
Less: Additional Deduction under Sec 80CCD NPS (Max Rs 50,000/-)
Less: Deduction under RGESS Sec 80CCG (Max Rs. 50,000/-)
Less: Deduction under chapter VI A Except the Above
Medical Insurance premiums – Self (u/s 80 D)
Medical Insurance premiums – Parents (u/s 80 D)
Interest on Education Loan (u/s 80 E)
Medical Treatment of handicapped Dependent (u/s 80 DD)
Selected Medical Treatment for self/ dependent (u/s 80 DDB)
Donation to approved funds (u/s 80G, 80GGA, 80 GGC)
For Rent in case of NO HRA Component (u/s 80 GG)
For Physically Disable Assesses (u/s 80 U)
Interest Income (Max Rs 50,000 for Senior Citizens & Rs 10,000 for others u/s 80 TTA)
Important Links: