TDS Form 16 in Excel with Auto-calculation formulas
※ Download: Computation of income tax format in excel for ay 2018-19
Since independence six Pay Commissions have been set up by the Government so far. Download Simple Income Tax Calculation Sheet for FY 2017-18, AY 2018-19.
This Advance Excel based Income Tax calculator is having all the features as per Income Tax department including ready made auto generated Form 16. The allowed dedudtion if for Rs 75,000. Gift from relatives vs non relatives: Gifts from relatives would be non-taxable with no limits attached.
TDS Form 16 in Excel with Auto-calculation formulas - Basic exemptions and income tax slabs for the year has been kept unchanged for all category of persons.
Download Tax Calculator for FY 2017-18 Income tax for individual is what most tax payers want to know in Budget. In Budget 2017, the finance minister has made little changes to this. Changes in Income Tax Rules: 1. Tax reduced from 10% to 5% for Income from Rs 2,50,000 — Rs 5,00,000 leading to tax saving of up to Rs 12,500. For people with net taxable income below Rs 3. NO RGESS Tax exemption from FY 2017-18 5. Sir, The income tax calculator is awesome. Non-finance people like me also can easily understand. You did a great job. I am buying a flat this month and registration will be done before 30th March 2018. I understand my first emi falls next year so there is no problem with that, but I am concerned on the additional benefit of Rs. Do I need to claim this additional amount this year itself or I can claim in the next financial year? Hi Ashish, I did my tax planning last year with help of your Tax Planning Excel, let me thanks to you for your help. Can you please add monthwise salary template which you had previousely? Please update this excel if possible ………..
However if you want to know what formulas are used and know advance excel skills, you can unlock the sheet and use it. Children education allowance: Per school going child 1200 per annum is non-taxable. If the disability is severe, the deduction amount will be 125,000. The size of this excel utility is just 15 KB. Else it would be non-taxable up to Rs 10 lakh in case of non-government servants. Download Auto Income Tax Calculator for FY 2017-18 by B. A HR or personnel department may utilize this excel format for auto generating the Form 16 along with earning record of any number of employees automatically without much work pressure.
