Breaking News
Loading...
Share It
Showing posts with label Arrears Relief Calculator U/s 89(1). Show all posts
Showing posts with label Arrears Relief Calculator U/s 89(1). Show all posts

Wednesday, 11 June 2025

  Form 10E


Have you received a salary hike or arrears for past financial years? Wondering how much extra tax you’ll need to pay? Don’t worry. There’s a smart and simple solution — the Income Tax Arrears Relief Calculator U/s 89(1) with Form 10E in Excel for the Financial Year 2025-26. This tool helps salaried individuals compute their tax relief in minutes.

Tax arrears can feel like unexpected guests — they show up late and bring an extra burden. But with the right calculator, you can stay one step ahead. In this guide, we’ll walk you through everything you need to know about downloading and using this powerful Excel-based calculator.

Table of Contents

Sr#Headings
1What Is Income Tax Arrears Relief U/s 89(1)?
2Why Form 10E Is Mandatory Before Claiming Relief
3Who Needs the Income Tax Arrears Relief Calculator?
4Benefits of Using an Automatic Calculator
5Key Features of the Excel-Based Calculator
6Step-by-Step Guide to Download the Calculator
7How to Fill in the Calculator Properly
8Common Mistakes to Avoid While Using the Calculator
9How to Submit Form 10E Online
10Practical Example for Better Understanding
11Tips for Accurate Data Entry
12When Should You Use Section 89(1) Relief?
13What Happens If You Skip Filing Form 10E?
14Comparing Manual vs Automatic Calculations
15Final Thoughts and User Testimonials

1. What Is Income Tax Arrears Relief U/s 89(1)?

Section 89(1) of the Income Tax Act allows relief if you’ve received any portion of your salary or pension in arrears or advance. It prevents you from paying higher taxes due to income bunching up in one year.

2. Why Form 10E Is Mandatory Before Claiming Relief

Form 10E is a declaration form you must file before claiming tax relief under Section 89(1). Without this form, the income tax department may reject your claim, even if you’re eligible. Think of it as the official permission slip that lets you claim your rightful tax benefit.

3. Who Needs the Income Tax Arrears Relief Calculator?

If you're a government or private employeeretired pensioner, or even a teacher who received delayed increments or payments, this calculator is your best friend. It simplifies your complex arrears data into actionable figures.

4. Benefits of Using an Automatic Calculator

Using the Automatic Income Tax Arrears Relief Calculator U/s 89(1) with Form 10E offers several advantages:

  • Saves Time: No manual calculations.
  • Accuracy: Reduces chances of human error.
  • Built-in Logic: Handles multiple years’ data.
  • Free to Use: Most Excel-based tools are available at no cost.

5. Key Features of the Excel-Based Calculator

The calculator is designed with user-friendly fields, drop-down menus, and pre-filled formulas. Here are some features:

  • Compatible with Excel 2007 and above
  • Integrated Form 10E format
  • Handles multiple arrears years
  • Auto-relief computation
  • Printable output

6. Step-by-Step Guide to Download the Calculator

  1. Download from the link below.
  2. Locate the "Income Tax Arrears Relief Calculator U/s 89(1) with Form 10E" for FY 2025-26.
  3. Click on the download link.
  4. Save the Excel file to your computer.

7. How to Fill in the Calculator Properly

Once downloaded:

  • Enter your basic details like name, PAN, and employer info.
  • Input arrears received year-wise.
  • Fill in your previous income details for the respective years.
  • Let the calculator auto-generate the relief figures.

8. Common Mistakes to Avoid While Using the Calculator

Avoid these pitfalls:

  • Skipping Form 10E submission
  • Entering incorrect assessment years
  • Using old or outdated calculator versions
  • Not verifying TDS entries

9. How to Submit Form 10E Online

To submit Form 10E:

  1. Visit the Income Tax e-Filing portal
  2. Log in with your PAN credentials.
  3. Navigate to e-File > Income Tax Forms > File Income Tax Forms
  4. Select Form 10E and fill in the details.
  5. Submit and download the acknowledgement.

10. Practical Example for Better Understanding

Imagine Mr. Sharma received an arrear of ₹1,20,000 in FY 2025-26 for FYs 2022-23 and 2023-24. Without relief, this bumps him into a higher tax bracket. Using the calculator, he splits the arrear and saves nearly ₹8,000 in tax through Section 89(1).

11. Tips for Accurate Data Entry

  • Double-check salary slips and Form 16.
  • Use exact dates and amounts.
  • Match figures with TDS statements.
  • Recalculate before finalising.

12. When Should You Use Section 89(1) Relief?

Whenever you receive:

  • Salary/pension arrears
  • Advance salary
  • Commuted pension
  • Gratuity paid late
    Use Section 89(1) to offset tax unfairness caused by income being bunched together.

13. What Happens If You Skip Filing Form 10E?

You may still file your ITR, but your claim under Section 89(1) will be denied. Even if the tax relief is shown in Form 16, the CPC will ignore it without a filed Form 10E. Don’t miss it!

14. Comparing Manual vs Automatic Calculations

Manual MethodAutomatic Calculator
Time-consumingTime-saving
Risk of errorsAuto-verified formulas
Complex for common usersEasy for all
No print formatPrintable results

15. Final Thoughts and User Testimonials

Hundreds of users have reported significant time savings and peace of mind using the Income Tax Arrears Relief Calculator U/s 89(1) with Form 10E. Don’t let tax stress weigh you down. Let Excel do the heavy lifting.

Conclusion

Tax arrears can create confusion and stress, but you don’t need to navigate them alone. With the Automatic Income Tax Arrears Relief Calculator U/s 89(1) with Form 10E, you can simplify your calculations, file accurately, and claim what’s rightfully yours. Be proactive — download the calculator today and experience hassle-free tax filing for the Financial Year 2025-26.

FAQs

1. Can I use this calculator if I work in the private sector?
Yes, both private and government employees can use this calculator to claim tax relief on arrears.

2. Do I need to file Form 10E every year?
Only in the year you are claiming arrears relief. No need to file if there’s no arrears income.

3. Can I edit the calculator formulas?
It’s not recommended unless you’re confident with Excel. The pre-filled formulas are optimised for accuracy.

4. Will the tax department reject my claim if I forget Form 10E?
Yes, skipping Form 10E will result in the denial of your 89(1) tax relief claim, even if it's mentioned in Form 16.

Download Automatic Income Tax Arrears Relief Calculator U/s 89(1) with Form 10E in Excel for the F.Y.2025-26

Download Automatic Income Tax Arrears Relief Calculator U/s 89(1) with Form 10E in Excel for the F.Y.2025-26
Download Automatic Income Tax Arrears Relief Calculator U/s 89(1) with Form 10E in Excel for the F.Y.2025-26

Friday, 28 May 2021

 

Salary Arrears Relief Calculator U/s 89(1)| If you received arrears of salary/pension in the previous financial year 2121-22, your tax liability will increase due to arrears, but did you know that you can double your income from arrears? You can get relief on 89 (1) of the Year and Income Tax Act, 19 of 1 on a conceptual basis. 

Income Tax Arrears Relief Calculator U/s 89(1)

We have developed a unique Excel-based calculator which will be helpful to calculate relief under Section 89 (1) of the Autofill Form 10E for recovery of arrears received in F, Y 2021-22 and the arrears are the oldest till the financial year 2000-01. 

This calculator used for offline use. 

How it works 

This calculator calculates both sides that are a present financial year and also the past/relevant financial year. , relief will be available under section89 (1) otherwise nothing is available. There is no benefit in distributing arrears over the years. 

Terms of use. Note / Calculator usage questions 

All you have to do is fill in the white column. If the bucket corresponds to a few years compared to the year provided on the sheet, fill in the blanks in other unnecessary years. 

All white cells are only necessary which is not mandatory to fill. Fill in the blanks where no image is required 

Select the option as new or old tax under section 115 (calculator is not working for very senior citizens). You must select the status each year. Make sure the status is selected correctly 

Fill in the total income with all other income and excluding arrears such as Section 80C, 80cc, 80D, 80G ... 80U, etc. after all discounts 

Fill in the arrears for the year 2021-22 under the corresponding year. The total will automatically appear under F.Y 2021-22. 

The arrears column (C-11 of the calculation sheet) is protected and cannot be edited under FY 2021-22. If you receive arrears with F.Y 2020-21 then it is not covered by the definition of arrears and F.Y 2020-21. Inclusion of total income (C-10 of the calculation sheet). 

The result is out if the total is A> Total B, relief will be shown under section 89 (1), otherwise, 0 will be displayed. Form 10 E, more forms with relevant additions will be filled automatically with Table-1

Limitations 

1. The calculation of long-term capital gain is not covered in this calculator. So if you have any LTCG in previous years that need to be calculated, this calculator will not help you. 

2. Income tax at special rates like a tax on short-term capital gains on equity shares/securities also does not fall under this calculator

Automatic Salary Arrears Relief Calculator U / S 89( 1) along with  Form 10E from the F.Y 2000-01  to the F.Y.2021-22 (Updated Version) as per Budget 2021

Master Data Input Sheet
Income Tax Form 10 E Annexure-I
Income Tax Arrears Relief form 10 E

 

Thursday, 27 August 2020


Section 89 comes in picture when salary/annuity or different parts are paid financially past due or advance. As indicated by Section 89, on the off chance that you get salary financially past due or advance in a budgetary year because of which your all-out income for the year expands, which thus builds your taxable income, you can guarantee for relief under Section 89. You should fill up Form 10E with these subtleties and afterwards submit it to your current manager to guarantee the relief. Structure 10E must be submitted on the web and no duplicate is required to be connected with your tax return.

Tuesday, 14 January 2020


As per the Finance Budget 2019, some Important Income Tax Section and Income Tax Rebate has changed.

Saturday, 21 December 2019

As per the latest Central Finance Budget 2019 have some changed along with the Income Tax Slab for the Financial Year 2017-18.The Tax benefits who have already get the House Building Loan, they have also good news in this Central Financial Budget 2019. Now look how to get tax benefits on paying Rent & taking home loan interest:-

Wednesday, 11 December 2019

As per the latest Central Finance Budget 2019 have some changed along with the Income Tax Slab for the Financial Year 2017-18.The Tax benefits who have already get the House Building Loan, they have also good news in this Central Financial Budget 2019. Now look how to get tax benefits on paying Rent & taking home loan interest :-

Monday, 9 December 2019

As per the latest Central Finance Budget 2019 have some changed along with the Income Tax Slab for the Financial Year 2017-18. The Tax benefits who have already get the House Building Loan, they have also good news in this Central Financial Budget 2019. Now look how to get tax benefits on paying Rent & taking home loan interest:-

Tuesday, 27 August 2019


As per the Finance Budget 2019, some Important Income Tax Section and Income Tax Rebate has changed. The Major modification including the Income Tax Slab Rate for the F.Y. 2019-20 is given below.

Wednesday, 14 August 2019


The Budget 2019 India: The FM has proposed an extra deduction of Rs 1.5 lakh for the intrigue paid on the home advance for private house property. Be that as it may, there are sure conditions to be satisfied before you can guarantee it.

Tuesday, 13 August 2019


In the Union Budget 2019, affordable housing got a further fillip with an increase in Income Tax deduction of Rs 1.5 lakh on home loans.
Finance Minister Nirmala Sitharaman said the interest paid on housing loans is currently allowed as a deduction to the extent of Rs 2 lakh under Section 24 B.

Monday, 15 October 2018

 Budget 2018: Changes in Income Tax Rules

1. Standard Deduction of Rs 40,000 for Salaried and Pensioners
2. Transport Allowance & Medical Reimbursement No more tax exempt for salaried
3. Cess hiked from 3% to 4% (renamed as Health & Education cess)
4. Rs 50,000 interest income for senior citizens tax exempted under newly introduced Section 80TTB
5. Health Insurance Premium Tax exemption limit increased to Rs 50,000 u/s 80D for senior citizens
6. Increased deduction for medical treatment u/s 80DDB for senior citizens up to Rs 1 lakh
7. 10% tax on long-term capital gains (above Rs 1 Lakh) on stocks & equity-based mutual funds. Also, 10% dividend distribution tax imposed on the dividend paid by equity mutual funds.

Monday, 19 February 2018

It appears that the most of the salaried persons got the salary amount from the previous Financial Year, and after got the arrears Salary the Income have raised in this Financial Year. But this amount which you have got this Financial year as Salary Income, this amount not for this Financial Year earning and this is not liable to pay the Tax in this Financial Year, as this amount received from the financial year.

Friday, 16 February 2018

Most of the employees have to get the arrears salary as their previous years, some employees have to get the arrears from the Financial Year 2000-01 and onwards financial Year, in this regard this Excel Based Software can prepare the Form 10 E from the Financial Year 2000-01 to Financial Year 2017-18. You can use this utility to calculate your Arrears Relief U/s 89(1) with Auto fill the Form 10E.

Sunday, 11 February 2018

If you have a dependent person in your family who is suffering from a disability, then you can avail tax benefit under section 80DD. This deduction is offered to help you take care of your disabled family member who is dependent on you.
If the individual himself is suffering from a disability, then he can claim tax benefits under section 80U.

Thursday, 25 January 2018

It appears that the most of the salaried persons got the salary amount from the previous Financial Year , and after got the arrears Salary the Income have raised in this Financial Year. But this amount which you have got this Financial year as Salary Income, this amount not for this Financial Year earning and this is not liable to paid the Tax in this Financial Year , as this amount received from the financial year.

Thursday, 23 November 2017

Download All in One TDS on Salary for Non-Govt (Private) employeesfor the Financial Year 2017-18.

[ This Excel Based Software can prepare at a time Tax Compute sheet +Automatic HRA Calculation + Form 12 BA +  Form 16 Part A&B and Part B for F.Y. 2017-18]


Salary Structure with Tax Deduction Section
Main Data Input Sheet
Automated Tax Computed Sheet
Automated Form 12 BA
Automated Form 16 Part A&B 
Automated Form 16 Part B

Saturday, 4 November 2017

The table below gives the details of all  tax exemptions available for F.Y.2017-18

Wednesday, 11 October 2017

Due to Demonetization and government drive against black money, a lot of Income Tax rules are either amended or changed with change in financial bills. Here are the list of major Income tax rules which are changed and implemented by next financial years are :

Wednesday, 13 September 2017

Prepare at a time your Income Tax with House Rent Exemption Calculation + Arrears Relief Calculation with Form 10E + Form 16 Part A&B and Part B + Arrears Relief Calculator with Form 10E From F.Y.2000-01 to 2017-18 with the help of universal Salary Structure for the any Private & Govt  Concerned.

Sunday, 13 August 2017

Recently Government reported that it has canceled more than 11.5 lakhs PAN Card in a bid to weed out duplicate and fake cards.  As per Income Tax Laws, one person can hold only one PAN Card. However, it was found that there had been multiple duplicate PAN cards issued to the same person. Also, there were cases where a PAN card was allotted to the non-existent person. The government hopes to get rid of more such duplicate/forged PAN cards as they get linked to Aadhaar Number.

Download:- Automated Income Tax All in One TDS on Salary for Non-Govt employees for F.Y.2017-18 & A.Y 2018-19

Also as there have been so many PAN card cancellations, it's important for tax payers to check if their PAN card is still active as more often than not a few genuine people also suffer when such actions take place. Deactivating PAN can seriously jeopardize person financial transactions.
Below is step by step instructions and screenshot to check if your PAN card is still active.

Step 1:  Go to www.incometaxindiaefiling.gov.in and Click “Login Here” (It does not matter if you are registered user or not)

Step 2: On Menu Click on Services >> ‘Know Your PAN’ (there is NO need to Login)

Step 3: A small Form opens as shown below where you need to fill up details such as name, status, date of birth and contact number.

Download:- Automated TDS on Salary for Govt & Non-Govt Employees For F.Y.2017-18 & A.Y.2018-19 with Automated Arrears Relief Calculator U/s 89(1) with Form 16 from F.Y.2000-01 to 2017-18


Step 4: On the next page you have to enter OTP (One Time Password) received on the phone hit ‘Validate’.
In case there is more than one PAN card registered with the above details, a message appears saying “There are multiple records for this query. Provide additional information.” Enter some more details such as your father’s name.

Step 5: On the final page, if the PAN number is not duplicated, it will be indicated as ‘Active’ under the ‘Remarks’ column.

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