RELIEF u/s 89(1) CALCULATOR -AVAILABLE FOR DOWNLOAD

SHARE:

Last year Govt Has implemented the Sixth Central pay commission pay recommendations and distributed the arrears in two instalments .This years most of Govt employees has received heavy salary after release of 60% arrears.Now they are thinking about whether tax can be saved on such arrears ,the answer is yes .We can distribute income according to which it relates to and if after distribution of income in relevant years the tax due of all years is less than the tax due by receipt Method then difference will allowed as exemption under section 89(1) .I have prepared a calculator for calculation of relief under section 89(1) in below excel sheet.Sheet is now available for download.

Just fill your correct name and email and press submit ,Download link will be send at your mail.You may add your friend email address to inform him about the calculator.



Specified DDO CAN ALLOW RELIEF U/s 89(1)
Following employer may allow benefit u/s 89(1) if claimed by employee.
1.company,
2.co-operative society,
3.local authority,
4.university,
5.institution,
6.association or body
7.Govt State or center
8.Public sector undertaking


How it works
This calculator show two calculation one is on the basis of the receipt of salary and other is on the basis of relevant years and if tax on receipt basis is more than relevant years basis then relief under section 89(1) will be available otherwise nothing is available means no benefit in distributing the arrears in respective years.
How to Use.

  • You have to fill only yellow column only .after each entry an updating sign will be shown,after disappearance of the sign then only enter next data.
  • All yellow cell are not mandatory fill only which are required.
  • Arrears in aggregate can be distributed to all relevant years and we can not distribute partial arrears to few years .Means we(avail 89(1)) do it in full or not to do at all.
  • This calculator will not work where in any of the previous year there is Long term capital gain in few cases where slabs changes.Against each row ,which contains a yellow cell a note has been described as under. 
After Feed back from viewers ,few changes has been made in the calculator now all input to be filled are given at one place.No of inputs are also reduced.(updated on 26.01.2010)
Note.
  1. Fill M for male and F for female and S for Sr Citizen
  2. Fill Total Income excluding arrears excluding 40 % arrears received in 2008-09 and 60 % in 2009-10 Financial years but including all other income and after all the deduction like section 80C,80CC,80D,80G ...........80U etc.
  3. Fill 60% arrears received in 2009-10 ,year wise break up under respective year.
  4. Fill 40 % arrears received in 2008-09,year wise break up under respective year.
  5. Fill "1" (one in figure) if relief u/s 89(1) if it is claimed in year 2008-09 on 40 % of arrears.
  6. Fill relief under section 89(1) on 40% arrears , if relief u/s 89(1) if it is claimed in year 2008-09 on 40 % of arrears.
  7. In this column calculation of 89(1) relief on 40 % will be shown on the basis of data entered by you ,if it would have been claimed by you in previous year.if your interested now to claim the same then you can revise your return .
  8. Nothing to fill here ,result is out ,if total A >Total B then relief under section 89(1) will be shown ,otherwise 0 will be shown .Further Form 10E with relevant annexure will also be filled automatically with table-1

Download Format of Form 10E with annexure and Table


Download Format of Form 10E with annexure and Table
Relevant section and rules
Relief when salary, etc., is paid in arrears or in advance.
Section 89. Where an assessee is in receipt of a sum in the nature of salary, being paid in arrears or in advance or is in receipt, in any one financial year, of salary for more than twelve months or a payment which under the provisions of clause (3) of section 17 is a profit in lieu of salary, or is in receipt of a sum in the nature of family pension as defined in the Explanation to clause (iia) of section 57, being paid in arrears, due to which his total income is assessed at a rate higher than that at which it would otherwise have been assessed, the Assessing Officer shall, on an application made to him in this behalf, grant such relief as may be prescribed
The following proviso shall be inserted in section 89 by the Finance (No. 2) Act, 2009, w.e.f. 1-4-2010 :
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 referred to in sub-clause (i) of clause (10C) of section 10, a scheme of voluntary separation, 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.

Rule 21AA. Where the assessee, being a Government servant or an employee in a [company, co-operative society, local authority, university, institution, association or body], is entitled to relief under sub-section (1) of section 89, he may furnish to the person responsible for making the payment referred to in sub-section (1) of section 192, the particulars specified in Form No. 10E.]

SECTION 89
Relief in case of receipt of salary in arrears or in advance
Year in which relief is to be allowed - Relief under section 89(1) is to be given in the assessment in which the extra payment by way of arrears, advance, etc., is taxed. Basically, the relief under section 89(1) is arithmetical. It involves finding out of two rates of tax. The first is the rate of tax applicable to the total income including the extra amount in the year of receipt. The second is finding out the rate by adding the arrears to the total income of the years to which they relate.—Circular : No. 331 [F.No. 174/102/79-IT(A-I)], dated 22-3-1982.

SECTION 89 (l) RELIEF WHEN SALARY ETC., IS PAID IN ARREARS OR IN ADVANCE
Circular : No. 331 [F. No. 174/102/79-IT(A-I)], dated 22-3-1982.
Scope of relief under the section in five situations explained

1. Section 89(1) authorises grant of relief in a case where an employee receives salary in arrears or in advance or has received in any financial year salary for more than twelve months, a payment which under the provisions of section 17(3)(ii) is a profit in lieu of salary. The effect of such increase is that the income will be assessed at a higher rate than it otherwise would have been assessed and it is for this reason that section 89(1) authorises relief to be allowed. The relief is to be allowed in terms of rule 21A of the Income-tax Rules, 1962.
2. Rule 21A(1) enumerates the following five different situations wherein the assessees will be entitled to relief (four of these are specific situations while the fifth is a residuary one) :
a. salary being received in arrears or advance;
b. where the payment is in the nature of gratuity in respect of past services extending over a period of not less than five years is received;
c. where the payment is in the nature of compensation received by the employee from his employer or former employer at or in connection with termination of his employment after continuous service of not less than three years and where the unexpired portion of the term of employment is also not less than three years;
d. where the payment is in the nature of commutation of pension;
e. where the payment is not covered by the description given in (a) to (d) above.
The relief is to be worked out in the first four situations in accordance with the specific modes described in rule 21A (2)(a) to (d).
3. The authority to grant relief in the four specific cases is the Income-tax Officer assessing the employee. In the residuary case, it is Central Board of Direct Taxes.
4. The relief under section 89(1) is to be given in the assessment in which the extra payment by way of arrears, advance, etc., is taxed. The mode of granting relief spelt out in rule 21A(2) to 21A(5) would show that in all the four different cases the exercise of giving relief is initiated by bringing to tax the whole of the extra amount in the assessment for the assessment year relevant to the year of receipt. Basically, the relief under section 89(1) is arithmetical. It involves finding out of two rates of tax. The first is the rate of tax applicable to the total income including the extra amount in the year of receipt. The second is finding out the rate by adding the arrears to the total income of the years to which they relate. For this purpose the assessee should be asked for a true and authentic statement of the total income of the earlier years to which the arrears pertain There is no warrant for issuing a notice under section 148 or calling for returns of income of the earlier years.
--------------------------------------------------------------

Circular : No. 9-D (LIII-6), dated 17-3-1966 as modified by Circular No. 14-D (LIII-7), dated 19-4-1966.
Relief in case of encashment of leave salary by an employee while in service - Whether admissible


1. Section 89(1) provides for relief to an assessee when salary, etc., is paid in arrears or in advance or if he receives in one financial year salary for more than 12 months or a payment which under the provisions of clause (3) of section 17 is a profit in lieu of salary and therefore, his income is assessed at a rate higher than at which it would have otherwise been assessed. This relief is granted by the Income-tax Officer on an application made to him in this behalf.
2. The question of admissibility of relief under section 89(1) in respect of amounts received on encashment of leave salary while in service was considered by the Board. The Board are advised that relief under section 89(1) read with rule 21A of the Income-tax Rules would be admissible in respect of encashment of leave salary by an employee when in service. The encashment of leave salary on retirement whether on superannuation or otherwise has already been exempted, by insertion of clause (10AA) in section 10, by the Finance Act, 1982 with effect from 1-4-1978.
Circular : No. 431 [F. No. 174/43/82-IT (A-II)], dated 12-9-1985.
630. Computation of relief under the section - Basis therefor

1. In modification of the instructions contained in the Board’s Circular No. 65 (LIII-I)-IT/49, dated 2-11-1951 regarding computation of relief under section 60(2) of the 1922 Act, it has been decided that the relief under section 60(2)/89(1) shall hereafter be calculated on the following basis.
2. (a) Where the payment to an employee is reasonably attributable to past services of less than 5 years (and is not of the nature of arrears of pay), no relief shall be admissible.
(b)Where the payment to an employee is reasonably attributable to past services of not less than 5 years but less than 15 years, relief will be allowed by subjecting the gratuity payment to tax at the average of the average rates determined by dividing the gratuity amount into two equal portions and adding a portion to the employee’s income in 1[each of] the last two years of his service during which he was in receipt of salary for a full period of 12 months.
(c) Where the payment to an employee is reasonably attributable to past services of 15 years or more, the relief will be calculated by taxing the gratuity payment at the average of the average rates determined by dividing the gratuity amount into three equal portions and adding a portion to the employee’s income in 1[each of] the last three years of service during which he received salary for the full period of 12 months.
3. Where the payment is for arrears of salary, the relief shall as at present be calculated by treating the arrears as the income of the years to which the arrears relate.
1[4. Notwithstanding the above, relief due on account of a payment having been assessed in the assessment year 1965-66 and earlier years will continue to be governed according to the old formula.]
--------------------------------------------------
Circular : No. 239 [F. No. 174/72/78-IT(A-I)], dated 16-5-1978.

Relief in the case of amounts repaid under Additional Emoluments (Compulsory Deposit) Act - Procedure laid down for working out relief under the section


1. Section 8(2) of the Additional Emoluments (Compulsory Deposit) Act, 1974 provides that for the purposes of computing the total income under the Income-tax Act, the amount repaid to an individual is deemed to be salary paid in arrears and the provisions of section 89(1) of the Income-tax Act shall apply. Under section 89(1), relief to be accorded in such cases is to be worked out on the basis of the rules as prescribed in rule 21A(2)(a) of the Income-tax Rules, 1962.
2. Representations have been received by the Board that the claiming of relief under section 89(1), as prescribed, is causing considerable hardship to certain categories of employees, particularly, in those cases of employees where the income of the employee was not taxable but for the repayment of compulsory deposits.
3. The Board have considered these representations and have decided with a view to removing hardship that the following procedure may be adopted by the Disbursing Officers :
a. compute the total income of the relevant previous year excluding the amount, received as repayment of deposit ;
b. allocate the amount received as repayment to the years to which the deposit relates ;
c. add to the amount allocated to each year, the total income of the year; and
d. compute the tax payable on such total income for each year at the rate applicable to that year.
4. If thereafter, it is found that no tax is payable as per (d) above for any of the years to which the repayment has been allocated, the Disbursing Officer need not deduct tax at source from the total income of the employee in the year in which the deposit is being repaid notwithstanding the fact that in the year in which the deposit is repaid the income is taxable.
5. If, however, it is found that by allocating the repayment to the relevant years tax is payable for any year, the Disbursing Officers must deduct tax on the total income including repayment at the rate applicable to the year in which repayment is made. Such employees will have to apply to the Income-tax Officer for claiming relief under section 89(1).
Download Format of Form 10E with annexure and Table
Get Latest Updates In your Inbox

$show=index

Name

. SECURITIES (MNP) (TDS)2007-08 ` 01.07.12 01.09.2008 01.10.2012 06.07.2009 07.08.2012 1 PERCENT EXCISE ITEMS LIST 1 sep 1% excise 10 year nsc 10(10C) 1000 court cases judgements supplied to ITO 1000 rupee note 11-2008 11-2010 130 items 14.08.2008 15 august 150 Rs coin 15g 15h 18-12-2009 192(1A) 192A 194 I 194A 194c from 01.10.2009 194H 194j 194LC 1981-2007 2% cst 2% excise 2004 2008 2008-09 FY 2010 206AA 234A 234B 234C 234c interest calculator 234E 23AC 23ACA 23B 24C 24q annexure II 25 paisa coin 271(1)(c) 271B 271H 272B 27A 280 280 challan 281 282 283 29 AUGUST 29.04.2010. 29/08/2008 29/2008 service tax 2g meaning use 3 idiots 30 MARCH 31st March 32-2010 33 of 2009 35(2AA) 35(2AB) 3CD 3g meaning use 40(b) 43B 44 AB EXEMPTED INCOME 44AA 44AB AGRICULTURE 44AB new limit 44AB NON RESIDENT 44ad 46/2012 45/2012 49C 5 day week 5 years post office deposit 5/2011 50 paisa coin 54b 54EC 54ee 54f 54gb 5th paycommission punjab 6 % excise 6 crore advance limit 6/2005 69/2010 6th cpc 6TH PAY COMMISSION 70% of pan etds 7th Central Pay Commission 8 tips to save tax 80C 80ccc 80CCD 80cce 80CCF 80CCG 80d 80DDB 80EE 80G 80GG 80GGA 80GGB 80ggc 80tta 80U 85% of pan etds 86/2008 DATED 13-08-2008 87A rebate 89(1) 89(1) relief calculator 9.5 % rate for private epf 92E 95% of pan etds 98 dated 04/01/08 aadhaar aakash tablet aam admi aar Aayakar Sampark Kendra abatement abolished ACCOUNT PAYEE DRAFT Accounting ACCOUNTING CODE accounting code for services ACCOUNTING FOR GOVT GRANTS accounting standards ACES ADD IN Add-Ins additional relief in budget 2010 adjustment of advance FBT with advance Tax advance rullings advance salary ADVANCE TAX CALCULATOR advance tax challan ADVANCE TAX CUT OFF AMOUNT ADVANCE TAX DATES AFFIDAVIT AG Projects Technologies Ltd RT age 80 addition pension aibea wage revision aibea wage revision latest news aiboa aiboc aiboc wage revision AIG AIR airline ticket booking tds airlines all is well allowances allownces alphabet of inspiration alteration on check allowed alternate minimum tax AMENDED 3CD amendment in companies bill 2011 amendment in gratuity act 2010 amendment in registration service tax AMENDMENT IN SERVICE TAX ON RENT amendment to finance Bill 2010 AMNESTY SCHEME 2007 amt Anna Hazare anna hazzare bill vs govt lokpal bill appeal apply for new pan card against old pan card aqb arbitration arrears of salary arrears of sixth pay ARRERS TAX AS-12 ASBA assessee in default ASSESSMENT REOPENING ASSESSMENT YEAR 2008-09 REFUND atm atm 100 per day atm cash without card atm tips atm wrong debit audit cases itr filing audit limit enhanced Audit Questionaire AUDIT REPORT AUS VS IND.INDIA VS SL Automated teller machine AUTOMATION OF CENTRAL EXCISE AND SERVICE TAX ay 2010-11 bad debts Bank Bank account bank audit bank audit 2012 bank charges BANK SALARY bank strike 06/07/09 and 07/07/09 banking law amendment banknotes banks npa provisioning BARE ACT bare rules BASE RATE BY BANKS bcct BIMAL JAIN biometric pan card black and white form not acceptable black money BLOCK PERIOD blogging bobay refund BONUS bonus share book discount BOOK ON EFILING BOOK REVIEW books of accounts BOOMING INDIAN ECONOMY both House rent allowance both hra and house loan Brass Scrap BRIBE CASE BROKER BSE bsnl broadband bsnl broadband usage bsnl land line sms alert BSR CODES BUDGET 2009 budget 2010 budget 2010-11 budget 2011 BUDGET 2012 budget 2013 BUDGET 2014 BUDGET 2014 CONTEST budget expectations BUDGET HIGHLIGHTS budget live on computer budget live telecast budget notification budget on tv budget speech BUDGET SPEECH DOWNLOAD Budget-2014 Budget-2015 BUDGET-2016 BUDGET08 Business BUSINESS AND PROFESSION MEANING BUSINESS COVERED UNDER 44ab BUY HOUSE C FORM CA CAN ONLY AUDIT MVAT CA CLUB INDIA CA GIRISH AHUJA CA NITIN GUPTA CA PARDEEP JAIN CA ROHIT GUPTA ca services CA sudhir Halakhandi CA Swapnil Munot CA Vikas Khandelwal calculate arrear CALCULATE NEW PAY calculate your emi calculation of tax on salary arrears CALCULATOR CALCULATOR REVISED capital asset capital formation huf Capital gain capital gain account scheme 1988 CAPITAL GAIN INDEX capital gain on repayment of loan capital gain on tenancy rights capital goods capital revenue CAPITAL SUBSIDY CAR LOAN RATE INCREASE carry forward of losses in late return cas cash flow statement CASH PAYMENT DIS ALLOWANCE CASH PAYMENTS EXCEEDING 20000 CASH SUBSIDY cbdt cbec CBI ARRESTED centeral sales tax rate CENTRAL PAY COMMISSION CENTRAL PROCESSING CENTER CENTRALISED PROCESSING OF RETURNS Cenvat CENVAT Credit Rules cgas 1988 challan challan 281 CHALLAN 289 challan correction challan Form 17 CHALLAN STATUS INQUIRY change change in cst rate change in excise duty rates CHANGE IN PAN ADDRESS CHANGE IN PAN DATA change in tds rates in budget changes CHANGES IN SERVICE TAX ACT changes in new itr forms CHANGES IN TDS CHARGES ON CASH PAYMENT OF CREDIT CARD BILL charitable organisation check name from PAN check tds deducted online Cheque cheque bounce cheque payment before due date cheque tender date /realisation date Cheque Truncation CHEQUE VALIDITY child care leave CHILD DEPENDENT PREMIUM CHILD MARRIED PREMIUM child plan childeren name children education allownces chip based atm card cibil cibil for companies CII 2007-08 CII 2008-09 CII 2010 cii 2012-13 CII2011-12 cin CIRCULAR 3/2010 DT 2.03.2010 CIRCULAR 8-2010 CIT v. Emilio Ruiz Berdejo (2010) 320 ITR 190 (Bom.) cloning of atm card clubbing of income COLLECTION CHARGES COLOR SCHEME COMMISSION ON SMALL SAVINGS common error in 2009-10 common error in itr 4-5-6 compa companies bill 2012 COMPANIES RATE COMPANY BILL 2011 company deposit Company Law Settlement Scheme COMPANY REGISTRATION complusory payment of taxes Composition scheme service tax COMPUTER AS FAX MACHINE computer sytem at ito office CONCEPT PAPER configure yahoo mail in outlook express consolidate account statement construction purchase of house Consultancy Service Consumer Price Index continues services CONTRIBUTION TO NEW PENSION SCHEME CONTRIBUTORY PENSION FUND CONVERT FIGURES INTO WORD EXCEL COPARCENER CorpMcash corporation bank correction etds CORRECTION IN PAN DATA correction in section CORRECTION RETURN CORRECTION RETURN.ETDS cost accounting cost audit cost inflation index cost inflation index 2012-13 COST INFLATION INDEX FY 2010-11 COST INFLATION INDEX FY 2011-12 COST OF INDEXATION CALCULATOR court case in entry tax punjab cpc phone number cpf Credit card CREDIT CARD BILL PAYMENT ICICI BANK credit scores cricket team critical illness CROSSED DEMAND DRAFT CRR crr reducred CS DIVESH GOYAL CST CST 3% OR 2 % cst act 1956 cst form CST FORM STATUS cst rate changed CST REDUCE RATE ctt currency CURRENCY TRADING ILLEGAL custom custom changes in budget cusual leave DA MERGE da rate da rate 01.07.2012 da rate january 2013 da rate july 2012 da rate wef 01.01.2012 date extension DDO ASK RENT RECIPT ddt dearness allowance Debit card DEBT EQUITY RATIO debt funds debt trap declared goods DEDUCTION 80C deduction for higher studies deduction on saving bank interst deduction u/s 80DD Deemed income of employee deemed services defective return defence officers defence pay defence pay scales DELAY IN FILING delete ledger in tally DELHI HIGH COURT demat deposit tax of two quarter in single challan depreciation depreciation on car depreciation on commercial vehicle. DEPRECIATION ON INTANGIBLE ASSETS depreciation rate depreciation rate 2009-10 DETAIL AFTER E FILLING DETAIL OF TIN Determination of value DIFFRENT TYPE OF TAXES digital signature din direct payment in bank account DIRECT SUBSIDY direct tax bill direct tax changes in budget direct tax code direct tax code 2009 Disability insurance discussion Paper distribution of salary dividend distribution tax dividend striping dnd do not call. document identification number document ientification number documents required for service tax registration domestic transfer pricing donation dot double taxation dow jones download download 89(1) relief calculator download direct tax code 2012 download form 16A download fvu download idfc INFRA BONDS FORM draft reply drawback rates dtaa dtc DUE DATE AY 2010-11 due date ay 2011-12 due date extended due date extended to 31.08.2012. due date for service tax return due date form 16 due date form 16a due date June due date march tax due date of return 2008-09 due date pf esi due date to deposit tds DUE DATES DUE DATES CALENDAR DUE DATES CALENDER DUE DATES INCOME TAX DUE DATES SERVICE TAX DUE FAMILY PENSION DULICATE PAN DUPLICATE TAN dvat e book Income Tax rules e book on service tax E ERA OF TAXES e filing do and don'ts e filing of audit report e filing processing status e filing software excel free e filing through evc e filing utilities e mode for notice to shareholder e notice to share holder e payment of epf E PAYMENT OF EXCISE DUTY e payment of income tax E PAYMENT OF SERVICE TAX e payment of tds E STAMP DUTY e tutorial for TAN registration E-1 FORM E-1 SALE e-commerce E-FILE SERVICE TAX RETURN e-Intermediary e-payment from friends account E-PAYMENT OF SERVICE TAX e-payment of taxes E-SEVA BY ICAI e-TDS/TCS statements earn from home earned leave Easy Exit Scheme ebay EBOOK EBOOK ON SERVICE TAX economic survey economic survey 2010 economic survey 2011 economic survey 2012 Edible Oils EDITABLE INCOME TAX FORM education cess EDUCATION LOAN eet EFFECTIVE DATE CST RATE REDUCTION effective date of allowncs efiling errors efiling free efiling income tax return efiling of excise return efiling registration problem Electricity act ELECTRONIC FOREX TRADING Electronic Verification Code (EVC) elegent card on holi ELSS EMANAGEMENT OF TAXES EMI CALCULATOR empanelment as branch auditor EMPLOYEE PROVIDENT FUND employee state insurance employee state insurance act 1948 employee state insurance act Limit employer e sewa eMudhra Consumer Services entries r off in 50 paisa entries rounded off in rs ENTRY TAX entry tax punjab epf epf challan epf claim epf e passbook EPF FAQ epf int rate 11-12 epf interest exemption epf interest rate epf interest rate for fy 2010-11 epf limit epf online EPF ONLINE CHALLAN GENERATION epf statement EPF TRUST epf withdrawals epfo equal monthly installments equity funds ER-1 ER-2 er4 form online error in etds return error in st-3 esi esi contribution esi limit 10000