Showing posts with label Automated Income Tax Arrears Relief Calculator U/s 89(1) for F.Y.2017-18. Show all posts
Showing posts with label Automated Income Tax Arrears Relief Calculator U/s 89(1) for F.Y.2017-18. Show all posts

Wednesday, 21 February 2018

Income Tax Relief Under Section 89(1) Read with Rule 21A, With Automatic Arrears Relief Calculator with Form 10E U/s 89(1)

Usually salary income is chargeable to tax either on due basis or on receipt basis. For the purpose of changeability salary consist of;
  1. Any salary due from an employer including former employer in the previous year, whether or not actually received.
  2. Any salary paid or allowed in the previous year by or on behalf of employer including former employer, although not due or before it became due, and
  3. Any arrears of salary paid or allowed in the previous year by or on behalf of employer including former employer, if not charged to income tax in any of the previous year.
 If an employee is in receipt of any component of his salary in arrears or paid in advance, or receives profit in lieu of salary, he can claim relief as allowed by Section 89 read with rule 21A of Income Tax Act and Income Tax Rules. The relief can be claimed for following;
  1. Relief in respect of salary or family pension received in arrears or in advance [Rule 21A(2)]
  2. Relief in respect of gratuity [Rule 21A(3)]
  3. Relief in respect of compensation on termination of employment [Rule 21A(4)]
  4. Relief in respect of payment of commutation of pension [Rule 21A(5)]
  5. Relief in respect of other payment [Rule 21A96)]
Provided that no such relief shall be granted 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 or schemes of voluntary retirement or in the case of a public sector company, if an exemption in respect of any amount received or receivable on such voluntary retirement or termination of his service or voluntary separation has been claimed by the assessee under clause (10C) of section 10 in respect of such, or any other, assessment year.

Click here to Download Automatic Arrears Relief Calculator with Form 10E from F.Y. 2000-01 to F.Y. 2017-18 (Up to date Version) in Excel.

Now let us elaborate and understand the each case separately.

Relief in respect of salary or family pension received in arrears or in advance [Rule 21A(2)]
The relief on salary received in arrears or in advance is computed in the manner as refined by rule 21A(2) which is produced as below;
  1. Calculate the tax payable on the total income, including the salary received in arrears or in advance, of the relevant previous year in which the same is received.
  2. Calculate the tax payable on the total income, excluding the salary received in arrears or in advance, of the relevant previous year in which the additional salary is received.
  3. Find out the difference between tax at (1) and (2).
  4. Compute the tax on the total income after including the salary received in arrears or in advance in the previous year to which such salary relates.
  5. Compute the tax on the total income after excluding the additional salary in the previous year to which such salary relates.
  6. Find out the difference between tax at (4) and (5).
  7. Amount of relief: The excess of tax computed at (3) over tax computed at (6)
Relief in respect of gratuity [Rule 21A(3)]
Relief for gratuity can is claimed if the amount of gratuity received is in excess of gratuity specified under section 10(10). However no relief is permissible if the taxable gratuity is received for less than 5 years of service period. The amount of relief is admissible in the as per following category
  1. Where gratuity payable is in respect of past service of 15 years or more
       The amount of relief is calculated as follows:
  1. Compute the average rate of tax on the total income including the gratuity in the year of receipt
  2. Find out the tax on gratuity at the average tax rate as computed in (1)
  3. Compute the average rate of tax by adding 1/3 gratuity to preceding 3 previous years
  4. Find out the average of 3 years average rate as computer in (3) and compute the tax on gratuity at that rate
  5. Relief admissible : difference between (2) and (4)
      2. Where such period is 5 years or more but less than 15 Years
       The amount of relief for this category , the relief is calculated as on the similar lines of above with only difference that instead of average of average rates of 3 years, the average of average rate of 2 years shall be taken by adding ½ of gratuity to each of two preceding year.
Relief in respect of compensation on termination of employment [Rule 21A(4)]
If the compensation received by the employee from his current or previous employer at or in relation with termination of his employment after completion of 3 years of service and unexpired portion of his term of employment is more than 3 years, the relief is calculated in the same manner as if gratuity paid to employee in respect of service rendered for a period of 15 years or more.
Relief in respect of payment of commutation of pension [Rule 21A(5)]
A relief can be claimed in respect of commutation of pension received in excess of limits specified under section 17(1)(ii). Such relief is computed in the same manner as if gratuity paid to employee in respect of service rendered for a period of 15 years or more.
Relief in respect of other payment [Rule 21A(6)]
In respect of any other payment received by employee other than those specified above, the relief will be granted by the CBDT after examination of circumstances of each case.
Procedure for claiming the tax relief – In order to claim tax relief under the aforesaid circumstances, the employee should give relevant information in his income tax return.
Basically relief under section 89 is arithmetical. It involves finding out two tax rates.

Tuesday, 9 January 2018

Prepare at a time Tax Compute Sheet + Individual Salary Sheet + Automatic H.R.A.Exemption Calculation + Automated Arrears Relief Calculator with Form 10E + Automated Form 16 Part A&B and Part B for F.Y.2017-18

Highlights of Income-tax Slab 2017-18

·             The Slab for Tax-free Income is the same. For FY 2017-18, No Tax on income up to Rs.2.5 lakhs.
·             The Government has reduced the tax rate for the income up to Rs 5 lakhs. The new tax rate for income between 2.5 lakhs to 5 lakhs is 5%.
·             The Upper limit to claim income tax deduction under section 80C is still at 1.5 lakhs.
·             The government has reduced the income tax rebate. Now, it is Rs 2,000 instead of Rs 5000.
·             The Upper limit to get the rebate is also reduced. Now, you would be eligible for the rebate if income is less than Rs 3.5 lakhs. Earlier this limit was at 5 lakhs.
·             The threshold for surcharge came down. Now, you have to pay a surcharge if your taxable income is more than 50 lakhs (5 million rupees). Earlier, this limit was 1 crore.

Tax Slab for Individuals

This is the general income tax slab. This slab is applicable to those who are less than 60 years old. It means if you born on or after 1ST April 1957, refer to the following tax ratesThis slab rate is also applicable to Non-Resident Indian, Hindu undivided family (HUF), Association of Persons, Body of Individuals and Artificial Judicial Person.

Income Tax Slab for 2017- 18

Tax Rate

Details
Income Up to Rs. 2,50,000
0

Rs. 2,50,000 –  Rs. 5,00,000
5%
On Amount above and over 2,50,000
Rs. 5,00,000 – Rs. 10,00,000
20%
On Amount above and over 5,00,000
Above Rs. 10,00,000
30%
On Amount above and over 10,00,000

Click here to Download Automated All in One TDS on Salary for Government & Non-Government Employees For Financial Year 2017-18 with New Tax Slab for A.Y.2018-19

Feature of this Excel Utility:-


1) Automated Individual  Tax Compute Sheet

2) Individual Salary Structure for both of the Government & Non-Government Employees

3) Automatic House Rent Exemption Calculation U/s 10(13A)

4) Automated Arrears Relief Calculation with Form 10E from F.Y. 2000-01 to F.Y.2017-18

5) Automated Income Tax Salary Certificate Form 16 Part A & B for F.Y.2017-18

6) Automated Income Tax Salary Certificate Form 16 Part - B for F.Y.2017-18
Main Data Sheet for details of Employer & Employees
Individual Salary Structure with Tax Deduction all sections
Automated Tax Computed Sheet
House Rent Exemption Calculation 
Automated Arrears Relief Calculation with Form 10E
Automated Form 16 Part A&B
Automated Form 16 Part B


Tuesday, 26 December 2017

Download All in One TDS on Salary for Govt & Non-Govt Employees for F.Y.2017-18

Click here to Download All in One Income Tax preparation Excel Based Software for Government & Non-Government Employees for Financial Year 2017-18 & Ass Year 2018-19 with New Tax Slab Rate F.Y.2017-18

Main Feature of this Excel Utility:-

1) Automated Income Tax Compute as per New Tax Slab for F.Y.2017-18

2) Individual Salary Structure for both of Govt & Non-Govt Employees

3) Individual Salary Sheet

4) Automatic House Rent Exemption Calculation U/s 10(13A)

5) Automated Arrears Relief Calculation U/s 89(1) with Form 10E from F.Y.2000-01 to 2017-18

6) Automated Income Tax Form 16 Part A&B for F.Y.2017-18

7) Automated Form 16 Part B for F.Y.2017-18

Main Data Sheet for Employee & Employer Details
Salary Structure for both of Govt & Non-Govt Employee
Tax Computed Sheet
Arrears Relief Calculation U/s 89(1)
Arrears Relief Annexure I
Automated Form 16 Part A&B
Automated Form 16 Part B

Thursday, 21 December 2017

Download All in One TDS on Salary for Govt & Non-Govt Employees for F.Y.2017-18

Click here to Download All in One Income Tax preparation Excel Based Software for Government & Non-Government Employees for Financial Year 2017-18 & Ass Year 2018-19 with New Tax Slab Rate F.Y.2017-18

Main Feature of this Excel Utility:-

1) Automated Income Tax Compute as per New Tax Slab for F.Y.2017-18

2) Individual Salary Structure for both of Govt & Non-Govt Employees

3) Individual Salary Sheet

4) Automatic House Rent Exemption Calculation U/s 10(13A)

5) Automated Arrears Relief Calculation U/s 89(1) with Form 10E from F.Y.2000-01 to 2017-18

6) Automated Income Tax Form 16 Part A&B for F.Y.2017-18

7) Automated Form 16 Part B for F.Y.2017-18

Main Data Sheet for Employee & Employer Details
Salary Structure for both of Govt & Non-Govt Employee
Tax Computed Sheet
Arrears Relief Calculation U/s 89(1)
Arrears Relief Annexure I
Automated Form 16 Part A&B
Automated Form 16 Part B