Click here to download the Automated Income Tax Preparation Excel Based Software All in One for West Bengal Govt Employees for F.Y.2016-17.
The feature of this Excel utility:-
1) You can prepare more than 50 employees Tax Calculation ( One by One)
2) Easy to install in any Computer in any version
3) Easy to generate just like as an Excel File
4) Automatic Calculation Income Tax with all amended income tax section
5) Automatic House Rent Exemption Calculation U/s 10(13A)
6) Automated Form 16 Part A&B and Form 16 Part B for F.Y.2016-17
7) Automatic Convert the Amount into the In – Words
8) Inbuilt the Salary Structure as per the W.B.Govt Salary Pattern
9) Recently declare I.R. and D.A. have also incorporated in this utility.
 |
| Employees Salary Structure |
Click here to Download the All in One TDS on Salary for W.B.Govt Employees for F.Y.2016-17
 |
Employees & Employer's details sheet   |
A look at current I-T slabs
*Individual taxpayers (Tax rate/Relief as per Budget 2016)
Up to Rs 2,50,000 - NIL / NIL
Rs 2,50,001 to Rs 5,00,000 - 10% / Rs 5,000 (Savings increased from Rs 2,000)
Rs 5,00,001 to Rs 10,00,000 - 20% / NIL
Rs 10,00,001 to Rs 1 crore - 30% / NIL
Above Rs 1 crore - 30% / 15% surcharge (Increased from 12%)
*Senior citizens (60 years and above, but less than 80 years) (Tax rate/Relief as per Budget 2016)
Up to Rs 3,00,000 - NIL / NIL
Rs 3,00,001 to Rs 5,00,000 - 10% / Rs 5,000 (Savings increased from Rs 2,000)
Rs 5,00,001 to Rs 10,00,000 - 20% / NIL
Rs 10,00,001 to Rs 1 crore - 30% / NIL
Above Rs 1 crore - 30% / 15% surcharge (Increased from 12%)
*Senior citizens (80 years and above) (Tax rate/Relief as per Budget 2016)
Up to Rs 5,00,000 - NIL / Rs 5,000 (Savings increased from Rs 2,000)
Rs 5,00,001 to Rs 10,00,000 - 20% / NIL
Rs 10,00,001 to Rs 1 crore - 30% / NIL
For income above Rs 1 crore - 30% / 15% surcharge (Increased from 12%)
Other measures proposed by Budget 2016
Increase in tax rebate: Those earning below Rs 5 lakh to save an additional Rs 3,000 in taxes. Tax rebate under Section 87A raised from Rs 2,000 to Rs 5,000. Effectively, this means the basic exemption now is of Rs 3 lakh.
Home loans: First home buyers to get additional deduction of Rs 50,000. However, this benefit is only for loans up to Rs 35 lakh where the cost of a house is less than Rs 50 lakh.
Pension schemes: Withdrawal from NPS corpus of up to 40% at the time of retirement has been made tax exempt. Similarly, in the case of superannuation funds and recognised provident funds, including EPF, the same norm of 40% of the corpus to be tax-free will apply in respect of corpus created out of contributions made after April 1, 2016. Further, the annuity fund, which goes to the legal heir after the death of a pensioner, will not be taxable in all three cases. The FM has also reduced the service tax on Single premium Annuity (Insurance) Policies from 3.5% to 1.4% of the premium paid.
Deduction of rent: Increase in the limit of deduction of rent paid under Section 80GG, from Rs 24,000 per annum to Rs 60,000 p.a., to provide relief to those who live in rented houses.
*Individual taxpayers (Tax rate/Relief as per Budget 2016)
Up to Rs 2,50,000 - NIL / NIL
Rs 2,50,001 to Rs 5,00,000 - 10% / Rs 5,000 (Savings increased from Rs 2,000)
Rs 5,00,001 to Rs 10,00,000 - 20% / NIL
Rs 10,00,001 to Rs 1 crore - 30% / NIL
Above Rs 1 crore - 30% / 15% surcharge (Increased from 12%)
*Senior citizens (60 years and above, but less than 80 years) (Tax rate/Relief as per Budget 2016)
Up to Rs 3,00,000 - NIL / NIL
Rs 3,00,001 to Rs 5,00,000 - 10% / Rs 5,000 (Savings increased from Rs 2,000)
Rs 5,00,001 to Rs 10,00,000 - 20% / NIL
Rs 10,00,001 to Rs 1 crore - 30% / NIL
Above Rs 1 crore - 30% / 15% surcharge (Increased from 12%)
*Senior citizens (80 years and above) (Tax rate/Relief as per Budget 2016)
Up to Rs 5,00,000 - NIL / Rs 5,000 (Savings increased from Rs 2,000)
Rs 5,00,001 to Rs 10,00,000 - 20% / NIL
Rs 10,00,001 to Rs 1 crore - 30% / NIL
For income above Rs 1 crore - 30% / 15% surcharge (Increased from 12%)
Other measures proposed by Budget 2016
Increase in tax rebate: Those earning below Rs 5 lakh to save an additional Rs 3,000 in taxes. Tax rebate under Section 87A raised from Rs 2,000 to Rs 5,000. Effectively, this means the basic exemption now is of Rs 3 lakh.
Home loans: First home buyers to get additional deduction of Rs 50,000. However, this benefit is only for loans up to Rs 35 lakh where the cost of a house is less than Rs 50 lakh.
Pension schemes: Withdrawal from NPS corpus of up to 40% at the time of retirement has been made tax exempt. Similarly, in the case of superannuation funds and recognised provident funds, including EPF, the same norm of 40% of the corpus to be tax-free will apply in respect of corpus created out of contributions made after April 1, 2016. Further, the annuity fund, which goes to the legal heir after the death of a pensioner, will not be taxable in all three cases. The FM has also reduced the service tax on Single premium Annuity (Insurance) Policies from 3.5% to 1.4% of the premium paid.
Deduction of rent: Increase in the limit of deduction of rent paid under Section 80GG, from Rs 24,000 per annum to Rs 60,000 p.a., to provide relief to those who live in rented houses.
