Get documents about "Relief US 89(1) CALCULATER FOR FY 2012-2013
W
Description
This automated calculated is well run on Excel03-13
Document Sample
THIS CALCULATION SHEET IS COMPILED BY employeesforum1@gmail.com
1 FILL ONLY LIGHT SHADED CELLS IN DATA SHEET PREFERABLY.
CORRECTLY FILL ACP PORTION.INSERT ROWS WHERE U GOT ACP & SEE FORMULA S
2 CORRECTLY.ILLUSTRATION IS GIVEN IN DATA SHEET.IF U WANT TO FILL ANNUAL AREAR IN
DATA SHEET DIRECTLY THEN UNPROTECT SHEET FROM REVIEW SECTION.CODE IS
SELECT CATEGORY IN CALCULATION SHEET TO GET CORRECT TAX CALCULATION.CALCULATION SHEET IS
3 ALSO NOT FULLY PROTECTED.IF U DONOT WANT TO USE DATA SHEET,EVEN CALCULATION SHEET CAN
BE USED DIRECTLY.THEN FILL LIGHT SHADED CELLS IN CALCULATION SHEET.IN THIS CASE,U HAD TO
IF U USE DATA SHEET,YEAR SHEETS ONCE AGAIN.
4 DOWNLOAD CALCULATION WISE BREAKUP WILL BE AUTOMATED.
5 ALWAYS CALCULATE MANUALLY ALSO.
6 ALL OTHER FORMS WILL BE FILLED AUTOMATICALLY STILL CHECK IF ANY FIELD REMAIN UNFILLED.
7 TAKE PRINT OUT & PRESENT.
8 IN CASE OF DOUBT/MISTAKE,CONTACT AT MY MAIL ADDRESS.
YEARWISE AREAR BREAK UP
AREAR PAID DIVIDEND INCOME DEDUCTIONS REBATE INCOME TAX ON
INTERES AREAR REBATE
FINANCIAL & OTHER WITH UNDER VI-A(HBA ON INCOME WITH
TOTAL SALARY T IN FY 2011- PAID IN FY U/S 10
INTEREST, 80-D,80- SAVING
YEAR INCOME
EXEMPTED SPECIAL
(HRA etc.)
SPECIAL TAX
12 2012-13 INCOME TAX RATE L etc.) U/S 80 C RATE
2005-06 290178 0 0 4321 0 0 0 0 43173 0 10803 4321
2006-07 182588 0 0 16810 0 0 0 0 66107 0 42024 16810
2007-08 227418 3771 0 16511 0 0 0 0 103785 0 41279 16511
2008-09 215551 5200 0 16016 0 0 0 0 67536 0 40040 16016
2009-10 242394 3262 0 15654 0 0 0 0 77832 0 39136 15654
2010-11 318127 3656 0 14824 0 0 0 0 105392 0 37059 14824
2011-12 391028 531 0 0 0 0 0 39758 125637 0 210341 84136
2012-13 430000 7000 0 0 0 0 0 33000 110000 0
CALCULATOR FOR RELIEF U/S 89(1) FOR FY 2012-13 DESIGNED FOR www.employeesforum.in
FOR CORRESPONDANCE MAIL TO employeesforum1@gmail.com
NAME OF EMPLOYEE OFFICE/DEPTT. PAN
DESIGNATION CATEGORY FEMALE<=60 YRS.
PLACE OF POSTING
CALCULATION OF INCOME TAX RELIEF ON AREAR RECEIVED IN FY 2012-13 U/S 89(1)
FINANCIAL YEAR 2012-13 2011-12 2010-11 2009-10 2008-09 2007-08 2006-07 2005-06
INCOME TAX ON ACCRUEL BASIS
TOTAL INCOME UNDER THE HEAD SALARIES
EXCLUDING AREAR
430000 391028 318127 242394 215551 227418 182588 290178
OTHER INCOME 7000 531 3656 3262 5200 3771 0 0
INTEREST 7000 531 3656 3262 5200 3771 0 0
DIVIDEND & OTHER
0 0 0 0 0 0 0 0
EXEMPTED INCOME
INCOME WITH SPECIAL TAX
0 0 0 0 0 0 0 0
BRACKET
AREAR OF SALARY FY 2012-13 0 14824 15654 16016 16511 16810 4321
GROSS SALARY 437000 391559 336607 261310 236767 247700 199398 294499
TOTAL REBATES & RELIEFS 143000 165395 105392 77832 67536 103785 66107 43173
REBATE U/S 10 (HRA ETC.) 0 0 0 0 0 0 0 0
DEDUCTION UNDER CHAPTER VI-A 33000 39758 0 0 0 0 0 0
REBATE ON SAVINGS U/S 80C 110000 125637 105392 77832 67536 103785 66107 43173
INCOME EXEMPTED FROM TAXATION 0 0 0 0 0 0 0 0
TOTAL TAXABLE INCOME 294000 226164 231215 183478 169231 143915 133291 251326
TOTAL TAXABLE INCOME FOR
294000 226164 231215 183478 169231 143915 133291 251326
NORMAL RATE OF TAX
TOTAL INCOME TAX 9682 3724 4246 0 0 0 0 22336
NORMAL RATES 9400 3616.4 4121.5 0 0 0 0 21897.8
SPECIAL RATES 0 0 0 0 0 0 0 0
SURCHARGE 0 0 0 0
EDUCATION CESS 282 108 124 0 0 0 0 438
TOTAL INCOME TAX ON ACCRUEL BASIS (A) 39988
INCOME TAX ON RECIEPT BASIS
TOTAL INCOME UNDER THE HEAD SALARIES
EXCLUDING AREAR
430000 391028 318127 242394 215551 227418 182588 290178
OTHER INCOME 7000 531 3656 3262 5200 3771 0 0
INTEREST 7000 531 3656 3262 5200 3771 0 0
DIVIDEND & OTHER 0 0 0 0 0 0 0 0
EXEMPTED INCOME
INCOME WITH SPECIAL TAX 0 0 0 0 0 0 0 0
BRACKET
AREAR OF SALARY FY 2012-13 84136
GROSS SALARY 521136 391559 321783 245656 220751 231189 182588 290178
TOTAL EXEMPTIONS,REBATES & 143000 165395 105392 77832 67536 103785 66107 43173
RELIEFS
REBATE U/S 10 (HRA ETC.) 0 0 0 0 0 0 0 0
DEDUCTION UNDER CHAPTER VI-A 33000 39758 0 0 0 0 0 0
REBATE ON SAVINGS U/S 80C 110000 125637 105392 77832 67536 103785 66107 43173
INCOME EXEMPTED FROM TAXATION 0 0 0 0 0 0 0 0
TOTAL TAXABLE INCOME 378136 226164 216391 167824 153215 127404 116481 247005
TOTAL TAXABLE INCOME FOR
378136 226164 216391 167824 153215 127404 116481 247005
NOMAL TAX RATE
TOTAL INCOME TAX 18348 3724 2718 0 0 0 0 21319
NORMAL RATES 17813.6
http://www.employeeforum.yolasite.com/ 3616.4 2639.1 0 0 0 0 20901
SPECIAL RATES 0 0 0 0 0 0 0 0
SURCHARGE 0 0 0 0 0 0 0
EDUCATION CESS 534 108 79 0 0 0 0 418
TOTAL INCOME TAX ON RECIEPT BASIS (B) 46109
FEMALE<=60 (UPTO
FEMALE SR.CITIZEN YRS. 65 YEAR)TAX RELIEF U/S 89(1)
MALE SR. CITIZEN UPTO 65 YRS. 0
4400 4616.4
9400 3616.4 4121.5
7121.5
4121.5 0
2347.8
0
[B-A] 0
1923.1
0 0
3391.5
0
6,121
0Rs.21897.8
0 25397.8
MALESR. CITIZEN
VERYSENIOR CITIZEN(>65 YEARS)
ANY 4400
0
4400 0
0 0
0 0 0
0 0 0 21897.8
13397.8
MALE SR. CITIZEN UPTO 65 YRS.
FEMALE<=60 YRS.
MALE
VERYSENIORCITIZEN(UPTOYEAR)
ANY SR.SR. CITIZEN(>65 65 YEAR)
CITIZEN
17813.6 4616.4
12813.6 3616.4
0
12813.6 0
0
5639.1
2639.1
0
782.4
0
0
321.5
0
0
1740.4
0
0 3329.1 0 13397.8
1648.1
0
24401
20901
12401
12401
FEMALE
YES 2639.1 0 0 20901
NO
FORM NO.10 E
[See rule 21AA]
Form for furnishing particulars of income under section 192(2A) for the year ending 31 st March, 2011 for claiming relief under
section 89(1) by a Government servant or an employee in a 2[company,co-operative society,local authority ,university,
institution,association or body]
0
1 Name and address of the employee
0
2 Permanent account number 0
3 Residential status RESIDENT AND ORDINARILY RESIDENT
Particulars of income referred to in rule 21A of the Income-tax Rules, 1962,during the previous year relevant
to assessment year 2011-12
mailto:employeesforum1@gmail.com (Rs.)
1 (a) Salary received in arrears or in advance in accordance with the provisions of sub-rule (2) of 84136
rule 21A.
Payment in the nature of gratuity in respect of past services, extending over a period of
(b) nil
not less than 5 years in accordance with the provisions of sub-rule (3) of rule 21A.
Payment in the nature of compensation from the employer or former employer at or in
(c) connection with termination of employment after continuous service of not less than 3 nil
years or where the unexpired portion of term of employment is also not less than 3 year.
(d) Payment in commutation of pension in accordance with the provisions of sub-rule (5) of nil
rule 21A
2 Detailed particulars of payments referred to above may be given in Annexure I,II,IIA,III, or I
IV as the case may be.
Signature of the employee
VARIFICATION
,do hereby declare that what is stated above is true to the best of my
I, 0
knowledge and belief.
Verified today, the Day of 14/03/2011
Place 0 Signature of the employee
Date 14/03/2011
ANNEXURE-I
[See item 2 of Form No.10E]
Arrears or advance salary
Sl No. Particulars Amount (Rs.)
1 Total income (excluding salary received in arrears or advance) 437,000
2 Salary received in arrears or advance 84,136
3 Total income (as increased by salary received in arrears or advance) [Add item 1 and item 521,136
4 2] on total income [as per item 3]
Tax 18,348
5 Tax on total income [as per item 1] 9,682
6 Tax on salary received in arrears or advance [Difference of item 4 and item 5] 8,666
7 Tax computed in accordance with Table "A" [Brought from column 7 of Table A] 2,545
8 Relief under Section 89(1) [Indicate difference between the amounts mentioned against 6,121
item 6 and item 7]
Signature:
Name: 0
Designation 0
TABLE "A"
[See item 7 of Annexure 1]
Salary Tax on
received in total
Total income (as Tax on total
arrears or income[a
increased by income [as
advance s per Difference in tax
salary received per column
relating to column [Amount under
in arrears or (2)-After
Previous Total income of the relevent the (4) After column (6) minus
advance) of the Rebate and
year previous year(Rs.) relevent Rebate amount under
relevent including Edn
previous and column (5)]
previous year Cess and
year as including (Rs.)
mentioned in Surcharge]
mentioned Edn Cess
column (1) (Rs.) (Rs.)
in column and
(1) (Rs.) Surcharg
e] (Rs.)
(1) (2) (3) (4) (5) (6) (7)
2005-06 290,178 4321 294499 21,319 22,336 1,017
2006-07 182,588 16810 199398 0 0 0
2007-08 231,189 16511 247700 0 0 0
2008-09 220,751 16016 236767 0 0 0
2009-10 245,656 15654 261310 0 0 0
2010-11 321,783 14824 336607 2,718 4,246 1,528
2011-12 391,559 0 391559 3,724 3,724 0
TOTAL 1,883,704 84,136 1,967,840 27,761 30,306 2,545
Signature:
Name: 0
Designation: 0
Place: 0
Dept: 0
Date: 14/03/2011
http://www.employeeforum.yolasite.com/
