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