Excel Form 10E-Salary Arrears Relief calculator AY 2017-18 for claiming rebate under section 89(1) of Income Tax Act 1961-Download

Author: | Posted in Calculators, Income Tax 21 Comments | 42,952 views

Excel Form 10E-Salary Arrears Relief calculator AY 2017-18 for claiming rebate under section 89(1) of Income Tax Act 1961-Download

Excel Form 10E-Salary Arrears Relief calculator

As per section 89(1) of the Income Tax Act, 1961 relief for income tax has been provided when in a financial year an employee receives salary in arrears or advance. As per Rule 21AA of the Income Tax Rules, 1962, Form 10-E  has been prescribed for claiming the relief.

According to the said rule, in case the employee is a Government servant or is an employee in a company, cooperative society, local authority, university, institution or association of body, he/she may for claiming the relief submit the form 10E to his/her employer who is responsible for making the payment of the salary as referred to in sub section (1) of section 192 of the Income Tax Act, 1961

In all other cases, the assessee for claiming the relief should file an application in form 10E to his/her income tax assessing officer.   The relief under section 89(1) is allowable in the assessment year  in which the arrears or the advance is received by the employee.

Pay revisions particularly in Government Sector has become common. Since independence six Pay Commissions have been set up by the Government so far. Recommendations of each commission with retrospective effect have resulted in arrears of salaries. The rationale behind giving this relief under section 89 is that due to the payment of arrear or advance salary received in a given financial   year , the income of the employee for that financial year gets increased due to the amount of the arrears or advances. As a result, the income of the employee attracts taxation at a higher rate than that rate at which his income would have been taxed had there been no such arrears or advances.  

The steps involved in computing the relief under section 89(1) basically involves the following steps:

First- spread out the amount of arrears or advance received over the specific financial year to which they relate and re-calculate the income tax for each year had the arrears been received during the concerned financial year itself.

Second-calculate income tax for each of the financial years without taking into account the arrears or the advance received.

Third- deduct the total of income tax arrived at 2 nd step from step-1.

Fourth-calculate income tax for the Financial year in which the arrears is received, including the arrears/advance received.

Fifth- calculate income tax for the Financial year in which the arrears is received, excluding the arrears/advance received.

Sixth- deduct income tax arrived at step-5 from  income tax arrived at step-4

Seventh- deduct income tax arrived at step-3 from income tax arrived at step-6

The figure so arrived is the amount of the relief under section 89(1)

Please note that this excel utility is for helping you to compute the relief and the details thereof are required to be filled online electronicaly.

The steps for filing online form No. 10E are as under:

1. Login to your income-tax e-filing account

2. Under efile menu go to Prepare and Submit Form Online Other than ITR

3. Select the AY and Form No. 10e

Excel Form 10E-Salary Arrears Relief calculator

4. Fill the details as computed in ABCAUS Excel utility and click on submit. Read Instructions carefully.

Excel Form 10E-Salary Arrears Relief calculator

ABCAUS salary arrears relief calculators have been provided to automatically calculate relief for Assessment Year 2017-18 AY 2016-17 and AY 2015-16 . They are simple, automatic and user friendly utility which calls for minimum effort and data input. users are required to fill only data sheet and it automatically calculates relief and prepare the Form 10E, Table-A, Annexure-I. Built in instructions with examples and auto checks have been provided inside. macros must be enabled to use this utility.

Excel Form 10E-Salary Arrears Relief calculator

Excel Form 10E-Salary Arrears Relief calculator

Excel Form 10E-Salary Arrears Relief calculator download for AY 2017-18

To download the ABCAUS Excel Form 10E for AY 2017-18, users may observe the following  steps:

(1) Subscribe to ABCAUS Newsletter (if not already a subscriber) Click Here >>

(2) Activate the subscription link. After successful subscribing as above, click on the activation link sent to your email. Check your spam/junk folders also. Add info@abcaus.in to your email address book so that password mail do not land in junk or spam folder

(3) Request for download link and password. On successful subscription activation, request a password at info@abcaus.in with the following details:

(i) your complete name,
(ii) your complete address
(iii) Your mobile number
(iv) Your occupation
(CA/CS/CWA, Accountant, Individual Salaried Employee/HR Professional, Tax Practitioner  etc.)

The utility is password protected. The download link and the password shall be sent from 05-12-2016 to the email used for the subscribing to ABCAUS Newsletter.

Please note that download link and the password shall be provided within 24 hours of the request and the Admin reserves the right to decline such request without assigning any reason.

Please note that by requesting password you agree to the terms of use that you do not have permission to modify, copy, edit, upload, reproduce, republish, distribute or transmit the utility except with the written prior approval. 

----------- Similar Posts: -----------

Comments
  1. Posted by ANIRUDDHA BASU
    • Posted by administrator
  2. Posted by E. Sridhar
  3. Posted by ANOOP KUMAR SRIVASTAVA
  4. Posted by Hariharakrishnan
  5. Posted by Mahesh M.Prajapati
    • Posted by MAHENDRA KUMAR JANGID
  6. Posted by RANJIV PRATAP SINGH
  7. Posted by Samikkannu A V
  8. Posted by joginder Kumar
  9. Posted by CHANDRAKANT
  10. Posted by KINDLY SEND THIS YEAR F.Y. 2016-17 89(1) RELIEF CALCULATOR
  11. Posted by lokendra
  12. Posted by Malhar Deshpande
  13. Posted by Malhar Deshpande
  14. Posted by Ch Satyanrayana
  15. Posted by TEJVIR SAINI
  16. Posted by DR SUNIL KAKKAR
  17. Posted by ASHISH KUMAR
  18. Posted by SANKARAN
  19. Posted by DEEPAK AGRAWAL

Add Your Comment

error: Content is protected ! Share the page link instead