Relief Calculator

  • Uploaded by: ANVER P S
  • 0
  • 0
  • May 2020
  • PDF

This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA


Overview

Download & View Relief Calculator as PDF for free.

More details

  • Words: 2,132
  • Pages: 11
ENTER YOUR DETAILS IN YELLOW COLOURED COLUMNS By

ANVER

P S

BEFORE STARTING CLEAR ALL DATA IN YELLOW COLOMNS

Name 2 Male OR Female 3 PAN No 1

4 5 6 7 8 9 10 11 12 13

MALE

If Splitting of 40% of Arrears was done that amount should be included in taxable income of 05-06, 06-07 & 07-08

94044 98550 124690 267060 466008 35000 160941 98309 18590 5400

Taxable inc in 2005-06* Taxable inc in 2006-07* Taxable inc in 2007-08* Taxable inc in 2008-09* Taxable inc in 2009-10* PRIS 1 Arrears (20%)* TOTAL 6 PC Arrears 6 PC Arrears in 2009 Basic Pay on Mar 09 Grade Pay VI PC ARREARS

* After deduction of savings

* After deduction of savings* (Including all Arrears)

14

2005-06

9182

5609

15

2006-07

55438

33864

16

2007-08

63993

39089

17

2008-09

32328

19747

TOTAL

160941

98309

19 20 21 22 23 24 25 26 27 28 29

Jul-09

19310

Click Here to See The Relief Calculation

Relief = 10479 Tax to pay in 2009-10 after Relief without Cess =

0 10 15 20 30

RELIEF

36723

FORMS TO BE SUBMITTED FOR CLAIMING RELIEF 1. Form 10E & Table A & Annexure 1 2 Copies of Form 16 (2005-06,06-07,07-08 & 08-09) 3. Arrears Statement

BY ADDING

0

ENSURE "0" if no round-up is required

IF INCOME IN 2009-10 IS NOT CALCULATED USE THE BELOW COLUMNS(Better Calculate Yourself) TA 800 HRA 20 P Tax (Per Month) CGEIS (Per Month) PF (Per Month) LIC (Per Month) HRA/HBA Exemption Other Savings DD Other Savings Other Arrears & Income FPA (if availing) 0

0 400 800 1600 3200

CLICK )

Enter Basic Pay & Gpay of March 09 As on today

BASIC ROUND-UP TO 10s if required BASIC

(If not calculated

* If You received PRIS arrers otherwise leave blank

YEAR (If TOTAL 61.084% not calculated use Calculator in ARREARS OF M.A sheet) (100%) ARREARS

18

ENABLE MACROS Sent your queries &feedback to [email protected]

1800 MALE 1900 FEMALE 2000 2400 2800 4200 4600 4800 5400 6600 7600 8700 8900 10000

Select "0" if availing official accommadation; Otherwise 400/800/1600/3200 Select "0" if Not availing; Otherwise "Select % of HRA"

(Enter if morethan standard amount(10%) deducted for whole year)

(Direct Deduction Savings) Enter other savings including extra addittion in PF other than Colomn no 23 Including DA Arrears, Bonus, Update Allowance, RTF, Leave Encashment etc

ENTER YOUR DETAILS IN YELLOW COLOURED COLUMNS By ANVER P S ENTER DATA IN THIS ORDER

1 to 10 AND

1 Name

11 OR 12 to 21 AND

2 Taxable inc in 2005-06*

94044 98550 124690

3 Taxable inc in 2006-07* 4 Taxable inc in 2007-08*

6 PRIS 1 Arrears (20%) 7 TOTAL 6 PC Arrears 8 6 PC Arrears in 2009 9 Basic Pay on Mar 09 10 Grade Pay

YEAR

VI PC ARREARS

61.084% OF ARREARS ARREARS

26 MONTH

OR

2005-06

9182

5609

23

2006-07

55438

33864

24

2007-08

63993

39089

Apr-06

25

2008-09

32328

19747

May-06

98309

Jun-06

160941

BASIC ROUND-UP TO 10s if required

466008

BASIC 27 Jul-09

(Including all Arrears)

19310

BY ADDING

0

Jul-06 Aug-06

Oct-06

800 Select "0" if Not availing; Otherwise 400/800/1600

13 HRA

Feb-06 Mar-06

Sep-06

ENSURE "0" if no round-up is required

12 TA

20 Enter "0" if Not availing; Otherwise "1"

Nov-06 Dec-06

14 P Tax

0

Jan-07

15 CGEIS

0

Feb-07

16 PF

0 (Enter if morethan standard amount)

Mar-07

17 LIC

0

Apr-07

18 HRA/HBA Exemption

0

May-07

19 Other Savings DD

0 (Direct Deduction Savings)

Jun-07

20 Other Savings

0

Jul-07

21 Arrears (Others)

0

Aug-07

98309

Sep-07

6 PC Arrears in 2009 PRIS 1 Arrears (20%) T A Deduction % of 6 PC Arrears in 2009 61.084% OF ARREARS FPA

35000

Oct-07

9600

Nov-07

61.08

Dec-07

98309 0

Jan-08 Feb-08 Mar-08

Click Here to See The Relief Calculation

497616

497616

Relief = 10479 Tax to pay in 2009-10

ARREARS

Jan-06

22

TOTAL

OR

YES

VI PC ARREARS

* After deduction of savings 11 Taxable inc in 2009-10*

AND 27

* After deduction of savings

267060 35000 160941 98309 18590 5400

5 Taxable inc in 2008-09*

22 to 25 OR 26

CALCULATION IS CORRECT ?

0

RELIEF

Apr-08 May-08 Jun-08

=

37825

Jul-08 Aug-08

458652

342295

TOTAL

0

MONTH

ARREARS

TOTAL

Jan-06

0

Feb-06

0

2005-06 Mar-06 Apr-06

0 0

May-06 Jun-06

0 0

Jul-06 Aug-06

0 0

Sep-06 Oct-06

0 0

Nov-06 Dec-06

0 0

Jan-07 Feb-07

0 0

2006-07 Mar-07

0

Apr-07 May-07

0 0

Jun-07 Jul-07

0 0

Aug-07 Sep-07

0 0

Oct-07 Nov-07 Dec-07 Jan-08 Feb-08

0 0 0 0 0

2007-08 Mar-08 Apr-08

0 0

May-08

0

Jun-08

0

Jul-08

0

Aug-08 2008-09

0

TOTAL SPLIT ARREARS

61.084%

0

5609

0

33864

0

39089

0

19747

98309

PRIS 1 TOTAL ARREARS

25404 123713

0 2005-06 Taxable inc Tax Cess Total tax

NEW 94044 0 0 0

0 Taxable

1

inc

Total tax

2006-07 Taxable inc Tax Cess Total tax

0 Taxable

1

inc

132414 3241 65 3306

10% Tax 2% Cess

1.5

Total tax

2007-08 0 Taxable

1.1

inc

163779 6756 203 6959

10% Tax 3% Cess

1.5

Total tax

2008-09 0 Taxable

1.5

inc

312211 17442 523 17965

10% Tax 3% Cess

3

Total tax TOTAL Diff without Cess

2009-10

2009-10

TAX 1 - With Arrears

TAX 2- Without Arrears

466008 47202 0 47202

Taxable Income Total Tax Tax Paid Tax to be paid Tax1 Tax2

Relief

=

5287

NEW 267060 11706 351 12057

Taxable Income Total Tax Tax Paid Tax to be paid

3241

NEW 124690 1469 44 1513

Taxable inc Tax Cess Total tax

0

NEW 98550 0 0 0

Taxable inc Tax Cess Total tax

99653 0 0 0

10% Tax 2% Cess

1.5

Diff in Tax

14264

342295 22459 0 22459

47202 36723

10479 TAX TO PAY IN 2009-10( Inc Cess)

5736

37825

INCOME TAX CALCULATION FOR 2009-10 Month

Mar Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Total

Basic 18590 18590 18590 18590 19310 19310 19310 19310 19310 19310 19310 19310

D PAY 5400 5400 5400 5400 5400 5400 5400 5400 5400 5400 5400 5400

228840

64800

Total Salary Professional Tax HRA/HBA Exmption Direct Deduction Salary Income Total Income Savings Ded Taxable Income Total Tax Tax Paid Tax to be paid Cess Total

SALARY S PAY DA 0 5278 0 5278 4798 5278 4798 5278 4942 6672 4942 6672 4942 6672 4942 6672 4942 6672 4942 6672 4942 6672 4942 6672

TA 976 976 976 976 1016 1016 1016 1016 1016 1016 1016 1016

HRA 4798 4798 4798 4798 4942 4942 4942 4942 4942 4942 4942 4942

P TAX 0 0 0 0 0 0 0 0 0 0 0 0

49132

12032

58728

0

74488

621329 0 0 9600 611729 611729 29364 582365 78710 0 78710 2361 81071

DEDUCTIONS CEGIS PF LIC 0 2399 0 0 2399 0 0 2399 0 0 2399 0 0 2471 0 0 2471 0 0 2471 0 0 2471 0 0 2471 0 0 2471 0 0 2471 0 0 2471 0 0

Other Savings Other Arrears

29364 = =

0

GROSS SALARY ARREARS 35042 35042 39840 35000 39840 42282 98309 42282 42282 42282 42282 42282 42282 42282 488020

133309

0 0

INCOME TAX CALCULATION FOR 2009-10 Month

Mar Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Total

Basic 18590 18590 18590 18590 19310 19310 19310 19310 19310 19310 19310 19310

D PAY 5400 5400 5400 5400 5400 5400 5400 5400 5400 5400 5400 5400

228840

64800

Total Salary Professional Tax HRA/HBA Exmption Direct Deduction Salary Income Total Income Savings Ded Taxable Income Total Tax Tax Paid Tax to be paid Cess Total

497616 0 0 9600 488016 488016 29364 458652 45730 0 45730 1372 47102

SALARY S PAY DA 4798 5278 4798 5278 4798 5278 4798 5278 4942 6672 4942 6672 4942 6672 4942 6672 4942 6672 4942 6672 4942 6672 4942 6672

TA 976 976 976 976 1016 1016 1016 1016 1016 1016 1016 1016

HRA 4798 4798 4798 4798 4942 4942 4942 4942 4942 4942 4942 4942

58728

12032

58728

74488

P TAX 0 0 0 0 0 0 0 0 0 0 0 0

DEDUCTIONS CEGIS PF LIC 0 2399 0 0 2399 0 0 2399 0 0 2399 0 0 2471 0 0 2471 0 0 2471 0 0 2471 0 0 2471 0 0 2471 0 0 2471 0 0 2471 0

0 Other Savings Other Arrears

0

29364 = =

0 0 0

GROSS SALARY ARREARS 39840 39840 39840 39840 42282 0 42282 42282 42282 42282 42282 42282 42282 497616

0

20% 60%

TABLE "A" [See item 7 of Annexure 1]

Previous year

(1)

2005-06 2006-07 2007-08 2008-09 TOTAL

Salary received in Total income (as arrears or advance increased by salary Total income of the relating to the relevent received in arrears or relevent previous year previous year as advance) of the (Rs.) mentioned in column relevent previous year (1) mentioned in column (Rs.) (1) (Rs.)

Tax on total income [as per column (2)] (Rs.)

Difference in tax [Amount under Tax on total column (6) minus income[as per amount under column (4) ] (Rs.) column (5)] (Rs.)

(2)

(3)

(4)

(5)

(6)

(7)

94044 98550 124690 267060 584344

5609 33864 39089 45151 123713

99653 132414 163779 312211 708057

0 0 1469 11706 13175

0 3241 6756 17442 27439

0 3241 5287 5736 14264

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)

342295

2

Salary received in arrears or advance

123713

3

Total income (as increased by salary received in arrears or advance) [Add item 1 and item 2]

466008

4

Tax on total income [as per item 3]

47202

5

Tax on total income [as per item 1]

22459

6 7 8

Tax on salary received in arrears or advance [Difference of item 4 and item 5] Tax computed in accordance with Table "A" [Brought from column 7 of Table A] Relief under Section 89(1) [Indicate difference between the amounts mentioned against item 6 and item 7]

24743 14264

10479

FORM NO. 10E [See rule 21AA] Form for furnishing particulars of Income under section 192(2A) for the year ending 31st March, 2010 for claiming relief under section 89(1) by a Government servant or an employee in a company, co-operative society, local authority, university,institution, association or body 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 2010-11 Rs. 1 (a)

Salary received in arrears or in advance in accordance with

123713

the provisions of sub-rule (2) of rule 21A

(b) Payment in the nature of gratuity in respect of past services, extending over a period of not less than 5 years in accordance with the provisions of sub-rule (3) of rule 21A (c) Payment in the nature of compensation from the employer or former employer at or in connection with termination of employment after continuous service of not less than 3 years or where the unexpired portion of term of employment is also not less than 3 years in accordance with the provisions of sub-rule (4) of rule 21A (d) Payment in commutation of pension in accordance with the provisions of sub-rule (5)of rule 21A

2

NIL

NIL

NIL

Detailed particulars of payments referred to above may be given in Annexure I, II, IIA, III or IV, as the case may be

……………………………… Signature of the employee

Verification I, ………………………………………….do hereby declare that what is stated above is true to the best of my knowledge and belief. Verified today, the........... day of ........……………….

Place:................... Date:......................

…………………………… Signature of the employee

ENTER YEARWISE AMOUNT IN DATA SHEET MANUALY

MONTH Jan-06 Feb-06 Mar-06 Apr-06 May-06 Jun-06 Jul-06 Aug-06 Sep-06 Oct-06 Nov-06 Dec-06 Jan-07 Feb-07 Mar-07 Apr-07 May-07 Jun-07 Jul-07 Aug-07 Sep-07 Oct-07 Nov-07 Dec-07 Jan-08 Feb-08 Mar-08 Apr-08 May-08 Jun-08 Jul-08 Aug-08

AMT

TOTAL

0

TOTAL 0

0

0

0

Income Tax Calculation Sheet Name:

0

Income Through Salary Income Through Other Source Govt. Contribution of NPS H.R.A. exemption if any (-) Professional Tax Recovered (-) Income Through Housing Property(12C) Total Income Savings Through Salary Bills Provident Fund Group Insurance Scheme New Pension Contribution Govt. Contribution on NPS LIC,PLI etc HBA Recovery Other Savings

0

Personal Savings NSC Mutual Funds Tax Savings Bonds Housing Loan Refunds Pension Schemes Insurance Premia Others Total Savings Savings Admissible Under Sec 80C Taxable Income Rounded to for Tax Calculation Income Tax Relief under section 89(1) Tax paid Tax to be paid Education Cess Total IT and Edu. Cess Recoverable

0 0 0 0 10479 -10479 -314 -10793

Related Documents

Relief Calculator
May 2020 5
Relief
November 2019 36
Calculator
August 2019 67
Calculator
November 2019 57
Calculator
October 2019 49
Calculator
November 2019 60

More Documents from ""