February 9, 2017

Income Tax Preparation Excel Based Automated All in One for Govt and Non Govt Employees for F.Y.2016-17 +Tax Saving Sections Summary

Download Automatic All in One IncomeTax Preparation Excel Based Software for Govt & Non-Govt (PrivateEmployees) for F.Y.2016-17.

Main Data Input sheet
Salary Structure for Govt & Non-Govt Employees
Tax Compute Sheet
Main Data Input Sheet for Arrears Relief Calculato
Arrears Relief Calculator with Form 10E
Automatic Form 16 Part A&B

Feature of this Excel Utility :-

1) Prepare at a time Individual Salary Structure as per Govt & Non-Gvt Employees Salary pattern.

2) Prepare Individual Salary Sheet

3) Prepare Individual Tax Compute Sheet

4) Automatic H.R.A. Exemption Calculation U/s 10(13A)

5) Automatic Arrears Relief Calculator with Form 10E from F.Y. 2000-01 to 2016-17

6) Automatic Income Tax Form 16 Part A&B for F.Y.2016-17

7) Automatic Income Tax Form 16 Part B for F.Y.2016-17

8) Automatic Convert the amount in to the In-Words

Below given a Snapshot where you can guess the All Income Tax Deduction and the Tax Section Limit for the Financial Year 2016-17

Section 80C/80CCC/80CCD: Investment in EPF, ELSS, PPF, FD, NPS, NSC, Pension Plans, Life Insurance, SCSS, SSA and NPS. Also includes Home Loan Principal repayment, Tuition Fees, Stamp Duty (Best Tax Saving Investments u/s 80C) Max.Limit Rs.1.5 Lakh

Section 80CCD(1B): Investment in NPS (Should you Invest Rs 50,000 in NPS to Save Tax u/s 80CCD (1B)?), Max limit Rs. 50,000/-

Section 24: Interest paid on Home Loan for Self occupied homes. No Limit for Rented house, Max Limit Rs. 2,00,000/-

Section 80EE: Additional exemption on Home Loan Interest for First time home buyers. (Budget 2016), Max Limit Rs. 50,000/-

Section 80E: Interest paid on Education Loan. No upper/lower Limit! (Tax Benefit on Education Loan (Sec 80E) , Actual Expenses

Section 80CCG: 50% of investment in RGESS approved stocks & mutual funds. Max investment limit is Rs 50,000 (RGESS – Save Taxes up to Rs 25000)

Section 80D: Premium payment for medical insurance for self and parents. Also includes Rs 5,000 limit for preventive health checkup (Making Sense of Tax Benefit on Health Insurance u/s 80D), For Medical Insurance for below 60 years Rs. 25,000/- and Sr.Citizen Rs. 30,000/-

Section 80DDB: Treatment of Serious illness for self and dependents (Limit of Rs 80,000 for person above 80 years, Rs 60,000 for person above 60 years and Rs 40,000 for rest)

Section 80U: Physically Disabled Tax payer (Rs 75,000 for 40% to 80% disability and Rs 1,25,000 for more than 80%)

Section 80DD: Physically Disabled Dependent (Rs 75,000 for 40% to 80% disability and Rs 1,25,000 for more than 80%)

Section 80G: Donation to approved charitable funds like Prime Minister Relief fund, etc

Section 80GGA: Donations for scientific research or rural development

Section 80GGC: Donations to political parties

Section 80GG: In case you do not receive HRA from employer or are self-employed but NO house in your name (Claim Tax Benefit for Rent Paid u/s 80GG

Section 80TTA: Interest received in Savings Account,Max Limit Rs. 10,000/-


Section 87A :- Tax Rebate Rs.5000/- who’s taxable income less then 5 Lakh