Income Tax

Excel Form 10E-Salary Arrears Relief calculator for AY 2026-27 for claiming rebate u/s 89(1)

Excel Form 10E-Salary Arrears Relief calculator AY 2026-27 (FY 2025-26) for claiming rebate under section 89(1) of Income Tax Act 1961-Download version 3.15

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 2nd 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 e-file menu go to Prepare and Submit Form Online Other than ITR

3. From the Tab “Persons without Business/Professional Income” Select the Form No. 10e

Click on Fill and choose AY and click on Lets Get started

4. Fill the relevant Annexure/Form from the details as computed in ABCAUS Excel utility and click on submit. Read Instructions carefully.

ABCAUS calculator for working out relief is simple, automatic and a 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. Option for New Tax Regime has been incorporated in the calculator.

Download ABCAUS Section 10E Salary Arrears Relief Calculator for AY 2026-27 (FY 2025-26)

Please note that by downloading the ABCAUS Excel Form10E, 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. 

Download Excel 10E Calculator Version 3.15 AY 2026-27 Click Here >> 

ABCAUS Section 10E Salary Arrears Relief Calculators for preceding previous years are as under:

AY 2025-26 Download Excel Form 10E Calculator
AY 2024-25 Download Form 10E Calculator
AY 2023-24 Download >>
AY 2022-23 Download >>
AY 2021-22 Download >>
AY 2020-21 Download >>
AY 2019-20 Download >>
AY 2018-19 Download >>
AY 2017-18 Download >>
AY 2016-17 Download >>
AY 2015-16 Download >>

Share

View Comments

  • THANKS FOR RECTIFYING THE ISSUE. BUT IN TABLE - A, CALCULATION OF TAX FOR PREVIOUS YEAR IS SHOWING WITHOUT ADDING 4% OF EC TO THE TAX PAYABLE, RESULTED IN LESS CALCULATION OF TAX (VERSION 3.15). HENCE KINDLY LOOK INTO AND RECTIFY THE SAME. THANK U.

  • SIR ,
    IN VERSION 3.14 WHEN WE SELECT OPTION 1. (If opting for new tax regime in FY 2025-26 --> Select Yes or No) SELECTED "YES" THEN SHOWING ERROR #VALUE! AT SHEET Annexure-I SR NO 5, 6 AND 8

    WORKS WELL IF WE SELECT NEW TEX REGIME AS " NO"

  • 10E RELIEF EXCEL CALCULATION FOR FY 2025-26 / AY 2026-27 IS NOT WORKING IT SEEMS. FOR THE YEAR OF 2023-24 IN DATA SHEET RS. 7,00,000/- IS SHOWING BY DEFAULT, NO CORRECTIONS ALLOWED. SO THE AMMOUNT FETCHING IN TABLE-A AS IT IS. SIMILARLY IN ANNEXURE-I, THE INCOME TAX VALUE AND RELIEFVALUE ARE NOT AUTO CALCULATING AND IN THAT PLACE 'VALUE' MESSAGE IS BEING DISPLAYED. KINDLY FIX THESE ISSUES AT AN EARLIEST AND OBLIGE. THANK U.

  • Hello Sir,
    This Excel tool is very helpful for me in 2018-19.
    Now i need Section 89(1) relief again, please provide excel tools for calculating Section 89(1) relief for FY 2025-26.
    Thanks In advance.

Recent Posts

  • ICAI

Applicability of Guidance Note on Financial Statements of Non-Corporate Entities/LLPs

Applicability of ICAI Guidance Note on Financial Statements of Non-Corporate Entities/LLPs for FY 2025-26 and 2026-27 ICAI has issued an…

2 days ago
  • Income Tax

Requirement of DIN referencing in Income Tax notices etc. and exceptions

CBDT has issued revised requirements of DIN referencing in Income Tax notices etc. and exceptions Section 292B of Income Tax…

4 days ago
  • Income Tax

Applicability of deeming fiction u/s 50C when property purchased & sold within same year

When property purchased and sold within same year both sale and purchase price has to be adopted by applying same…

4 days ago
  • ICAI

ICAI defers the effective date of Standard on Quality Management SQM1 and SQM2

ICAI defers the mandatory effective date of SQM 1 and SQM 2 The Council of ICAI, at its 451st Meeting…

4 days ago
  • Income Tax

Addition based on letter of District Magistrate not recovered during search deleted

Addition deleted as it was made on the basis of letter of District Magistrate which not recovered during the search…

4 days ago
  • Income Tax

CBDT clarification on threshold for TDS on interest by banks under Income Tax Act 2025

Banks not required to deduct TDS under Income Tax Act 2025 on interest income below threshold limit - CBDT clarification …

4 days ago