Excel Form 10E-Salary Arrears Relief calculator AY 2020-21 for claiming rebate under section 89(1) of Income Tax Act 1961-Download
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 efile menu go to Prepare and Submit Form Online Other than ITR
3. Select the AY and Form No. 10e
4. Fill 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.
Download ABCAUS Section 10E Salary Arrears Relief Calculator for AY 2020-21
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 10E Calculator AY 2020-21 Click Here >>
(updated on 04/02/2020 6:30 PM)
ABCAUS Section 10E Salary Arrears Relief Calculators for previous years are as under:
- Assessee must be put to notice of all provisions on which revenue relies upon – Supreme Court
- CBIC issues GST Notifications/Circular to clarify relief given due to Corona Virus
- Enrolments for Limited Insolvency / Valuation Exams. Date extended till 14.04.2020
- RBI Notifies Changes in Market Hours due to COVID-19 outbreak
- Foreign Trade Policy & Hand Book of Procedures 2015-2020 extended upto 31.03.2021
){kind=link}
NICE AND EASY FOR CALCULATING INCOME TAX FOR ARREARS AMOUNT BY BIFURGATION OF TAX IN PREVIOUS YEARS.
Hi,
This is regarding relief u/s 89(1) calculator for AY 2020-21. The programming for computation of tax is incorrect for following years:
1. FY 2006-07: Secondary & Higher Education Cess (@1%) was not applicable for FY 2006-07, but calculator available here computes tax liability including SHEC.
2. FY 2018-19: Tax computation on total income including arrear for FY 2018-19 is incorrect as it doesn’t consider surcharge@10%, if total income exceeds Rs. 50,00,000.00.
Kindly update the calculator for the above mentioned imitations & share the updated one.
Sir Form 10E for AY 20-21 is not opening although I have enabled macros..plz provide solution.
thanks
Dear Sir,
I have downloaded the form 10E for FY-2019-20 for calculation of my income tax relief. Please provide me.
Thanks
nafis malek
request for send download link of 10 e calculator in excel Format for the A.Y 2020-2021
Do we need to mention gross salary (excluding deductions) for past FY while entering 10E form in Income tax site?
The excel utility provided by you a good relief for someone like me. Thanks for uploading it.
Sir, I have received arrear in the financial year 2018-19 under NPS scheme. Should i prepare ten e with the help of Form 16 or with the help of Due and drawn statement provided to me (Subtracting the saving and NPS according to Form 16). Should i also show the amount of NPS in back year.
Is it possible to submit revised 10E for us 89(1) income tax relief?
no such facility exists. however you can simply file it gain
Sir, for claiming relief u/s 89 for the AY 2016-17 and 2017-2018, whether two 10e is to be filled or in one 10e form both the tax of 2016-17 and 17-18 is to be mentioned.
two forms if relief is claimed separately in two AYs
Dear Sir,
I am not able to edit the 2nd page of that file as it is password protected. Please look into the matter.
pls provide 89 rilfe calculater for fy 2018-19
Dear Sir,
I have downloaded the form 10E for FY-2018-19 for calculation of my income tax relief. Please provide me the password so that I can work with the file.
With regards,
Santu Chakraborty
dear user, no password is needed to work with the file.
Sir, I want to fill 10(e) form for the fy 2018-19. But when I am trying to fill the 10 e form from income tax department site, it is still showing AY 2018-19 instead of 2019-20. Plz guide me for filling of 10 (e) form.
you can not fill it before the end of the fy. however you can submit it to your employer
PLEASE PROVIDE 10E EXCEL A/Y 2019-20
Sir I have received arrear of salary from 1995-96 where I fill this salary amount as per ur ay 18-19 form 10e please give a solution or send excel if available regarding this case
chetannedake@gmail.com
I want to make use of 10 E please help.
In your Excel Utility, You have taken Financial Year (FY) in “Previous Year column”, while income tax web site says to fill assessment year. I am confused. Please guide
The format of 10E asks for Financial year. However, in ITD Website, you may fill AY.
Sir
In financial year 2017-2018 and Assessment Year 2018-2019 got arrears 11years and 05 months i.e. from 2006 to 2017, so I need updated Abacus Excel 10E salary arrear calculator.
Kindly sent its link to at my id.
thanks in anticipation
In financial year 2014-2015 and Assessment Year 2015-2016 got arrears 16years and 05 months i.e. from 1996 to 2012, and department deducted 84500/- as a TDS. Department alos not provide form 10E .so I need updated Abacus Excel 10E salary arrear calculator.
Kindly sent its link to at my id.
thanks in anticipation
Dear sir I want to know about 80C, as per my form 16 my 80C relief is 90K but I have LICs also.when I file ITR I want to fill 150000 in 80C.
Pls explain me
yes you may claim
Dear Sir,
I received for Financial Year 2004-05 to Financial Year 2007-08 (Four Years) in Financial Year 2017-18 . Can I claim relief u/s 89 and how. Thanks
yes. read the procedures
KINDLY SEND THIS YEAR F.Y. 2017-18 89(1) RELIEF CALCULATOR
Good evening sir,
I got salary arrear fy 2014-15,2015-16 & 2016-17 so plz sir send 10E format/ calculator my email.
Thank you very much. Very nice effort.
please send me the software or excel sheet format to claculate 20 years arrear.
Thanks in Advance.
sir please send 10e software in excel format for AY 18-19
Thanks
Sir
Good Morning.
This financial year 2017-18 /Assessment year 2018-19, I got 3 years arrears i.e. 2015-16 (2 month), 2016-17 and 2017-18. So I need updated Abacus excel form 10-E salary arrears relief calculator for the assessment year 2017-18
Kindly send to my mail address – …………
Sir
Good Morning.
This financial year 2017-18 /Assessment year 2018-19, I got 10 years arrear from FY 1995-96 to FY 2003-04. So I need updated Abacus excel form 10-E salary arrears relief calculator for the assessment year 2018-19
Kindly send to my mail address – …………
Thanking you
Sameer
I NEED UPDATED ABACUS EXCEL FORM 10E SALARY ARREARS RELIEF CALCULATOR FOR THE ASSESSMENT YEAR 2018-19
please help what should i have to do for this
Please send download link for arrear relief calculator for ay 2018-19.
I am already email subscriber
Please send download link for arrear relief calculator for ay 2018-19.
SIR,
I NEED UPDATED ABACUS EXCEL FORM 10E SALARY ARREARS RELIEF CALCULATOR FOR THE ASSESSMENT YEAR 2017-18..
KINDLY SEND ME MY MAIL ADDRESS
THANKING YOU….
sir please send 10e software in excel format for AY 18-19
Thanks
Kindly send me an updated Excel.form 10 e calculator for AY 2018-19
SIR,
I NEED UPDATED ABACUS EXCEL FORM 10E SALARY ARREARS RELIEF CALCULATOR FOR THE ASSESSMENT YEAR 2017-18..
KINDLY SEND ME MY MAIL ADDRESS
THANKING YOU….
please send me the updated version for f.Y 2017-18 along with passwords. i have cas arrears from F.Y 2012-13.
regard
abdul majeed.
please send me the updated version for f.Y 2017-18 along with passwords. i have cas arrears from F.Y 2012-13.
regard
abdul majeed
Kindly send me an updated Excel.form 10 e calculator for AY 2018-19. My email ID is nongthomba@rediffmail.com
Hi Sir,
It is a very good utility, thanks for sharing.
Please also provide the updated version for financial year 2017-18 along with password.
Thanks.
Hi Sir,
It is a very good utility, thanks for sharing.
Please also provide the password for 10E form AY2017-18
Thanks.
Please send me the updated version for FY 2017-18 along with password.
regards
Partha
good job on XL utility for form 10 E, please update for financial year 2017-18.
Sir,
I have received arrears from 1992-93.I have excel workbook contained up to year 2002-03.How can i add more raws in your excel work book ? can you revised for me please
KINDLY SEND ME FORM 10E FOR A.Y 17-18.ON MY MAIL
Hi, Please provide password for 10E form 2017-18 AY. Thanks.
SIR,
KINDLY SEND ME THE UPDATED ABACUS EXL FORM 10E SALARY ARREARS RELIEF CALCULATOR
Dear Sir,
I request u to kindly send me the updated ABACUS Excel 10E salary arrears relief calculator
as I received last 10 years arrears in the financial year 201-17
Thanks & Best regards
Divakaran
Sir,
I have received the arrears from F.Y. 2002-03 to 2015-16 during F.Y. 2016-17.
Kindly send the updated version of Abacus excel 10E salary arrears calculator, on my e-mail .
Thanks
Sir
i have downloaded excel 10e calculator software from your website, but even after filling the required details and followed the instructions, in Table-A columns 5,6 & 7 it is showing #VALUE!, so please send me the Updated version of 10e excel utility. to my mail id
do not use cut/copy and paste.
Sir
I need updated Abacus excel form 10 E salary arrears relief calculator in the AY 2016-17.Kindly send to my mail address
Thank you…..
respected sir,
please, provide a password and download link for “excel form 10E salary arrears relief calculator download for AY 2017-18.
thanks..
siddharthkumar parmar
Sir
In financial year 2016-2017 and Assessment Year 2017-2018, I got arrear 08 years and 02 months i.e. from 2009 to 2016 and January – February- 2017, so I need updated Abacus Excel 10E salary arrear calculator.
Kindly sent its link to at my id.
thanks in anticipation
inder raj
Sir, I got arrier 126256/= of 2013-14 what is rebate under 89 1 for 2017-18
RESPECTED SIR , PLEASE PROVIDE link of 89 RELIEF EXCEL CALCULATOR FOR AY 2017-18 ON MY EMAIL ID
KINDLY PROVIDE 10E FOR THE AY 2017-18
kindly send the update 10 e form for assessment year 2017-18
sir,
please provide 89 relief calculator a. y. 2017-18 early as posible.
sir,
pls provide 89 rilfe calculater for fy 2016-17 & ay 2017-18
I have sent mail requesting Form 10E excel calculator for AY 2017-18. Kindly send immediately as I am in urgent need of the same
SIR,
I NEED UPDATED ABACUS EXCEL FORM 10E SALARY ARREARS RELIEF CALCULATOR FOR THE ASSESSMENT YEAR 2017-18..
KINDLY SEND ME MY MAIL ADDRESS
Sir,
I have requested to provide link/password for 89(1) Relief calculator utility for AY 2017-18
but I have not received it.Pl. send at the earliest
please send form 10e in exel auto calculated on my e mail for assessment year 2017-18
sir pl pro0vide 89(1) relief calculator for assessment year 2017-18
Thanking you
Salary is taxed at normal rate and STCG is taxed at 15% so to claim relief for salary arrears should I consider only income heads which are taxed at normal rate that is income from salary and other sourses please explain about total income to be written in annexure 1
I got pension arrears of earlier years in ay 17-18 that is fy 16-17. I have one query about total income in to be entered in column 2 of table 1 my total income consists of salary and short term capital gain from shares so while writting total income of previous years should I include or exclude the short term capital gain amount
Mujhe 10e calculator mere e-mail id pr bhej dijiye akalan varsh 2016-17 ke liye
KINDLY SEND 10 E FORM THE THE F.Y. 2016-17
I NEED UPDATED ABACUS EXCEL FORM 10E SALARY ARREARS RELIEF CALCULATOR FOR THE ASSESSMENT YEAR 2017/2018
KINDLY SEND ME IN MY MAIL ADDRESS-cbp855@gmail.com
I need ABACUS Excel form 10-E Salary Arrears relief calculator for the assessment year for AY 2017-18. Thanks…
plz provide the password /link to the form 10-e program for the current year.
You consider a standard deduction of rs.4000 according to tax slab fy2017-18.my question is can we get relief of standard deduction?
I NEED UPDATED ABACUS EXCEL FORM 10E SALARY ARREARS RELIEF CALCULATOR FOR THE ASSESSMENT YEAR 2017/2018
KINDLY SEND ME IN MY MAIL ADDRESS- rps123daltonganj@gmail.com
sir, 10e form table a previous yer 2015-16 a.y. 2016-17 salary 150000 and arrears 80000 recived fy 2016-17 ay 2017018 but table a previous year colom year select 2015-16 or 2016-17
Respected Sir,
I require upadated ABACUS Exel form 10-E salary aerriers relief calculater for the assesment year of 2017-18. I got aerriers from the year 2010-11/Assesment year 2011-12 to year 2016-17/Assesment year 1017-18.
Kindly send on my email address,
Thanks,
Mahesh Prajapati
please send its updated version with key
Sir,
I have a doubt regarding 80 C deduction while claiming 89(1) relief. Now CPS is deducting from all employees for the arrears accrued and deducted the same in the financial year in which the arrears are paid. My doubt is whether I can claim deduction u/s 80 C for the CPS allocated amount in Table A calculation under the head accrued basis. i.e income accrued as well as accrued CPS on such income. Another doubt is whether 80 C deduction shall be claimed for excluding arrears calculation statement for the financial year in which the tax is calculated ? Please advice me and answer me at your earliest convenience.
SIR,
I NEED UPDATED ABACUS EXCEL FORM 10E SALARY ARREARS RELIEF CALCULATOR FOR THE ASSESSMENT YEAR 2017-18..
KINDLY SEND ME MY MAIL ADDRESS (anoop.amit@gmail.com)
THANKING YOU….
Sir
Good Morning.
This financial year 2016-17 /Assessment year 2017-18, I got 3 years arrear. So I need updated Abacus excel form 10-E salary arrears relief calculator for the assessment year 2017-18
Kindly send to my mail address – …………
Thanking you
Sridhar
request for download link of 10 e calculator for the A.Y 2016-2017
Kindly observe the steps prescribed.
Admin
Could you please guide on tax calculation on with arrears and wiout, should be take tax only or incl use cess? ,
please update relief u/s 89 a.y. 2019-2020