INCOME TAX for - FY 2008-09

NAME: Madhuri Goyal PAN: Desig: Associate Prof Office: Deshbandhu College

TPT All +
BP DP/GP DA CCA HRA Arrears Addl Pay Tax+Cess TOTAL
Month DA on TPT
(a) (b) (c) (d) (e) (g) (h) Deducted Sum of (a) to (i)
(f)
March-08 17460 8730 10738 300 7857 800 11813 0 2500 57698
April-08 17880 8940 12605 300 8046 800 4638 0 2500 53209
May-08 17880 8940 12605 300 8046 800 0 0 2500 48571
June-08 17880 8940 12605 300 8046 800 0 0 2500 48571
July-08 17880 8940 12605 300 8046 800 0 0 2500 48571
August-08 17880 8940 12605 300 8046 800 0 0 2500 48571
September-08 17880 8940 12605 300 8046 800 0 0 2500 48571
October-08 17880 8940 12605 300 8046 800 0 0 2500 48571
November-08 17880 8940 12605 300 8046 800 0 0 2500 48571
December-08 17880 8940 12605 300 8046 800 0 0 2500 48571
January-09 17880 8940 12605 300 8046 800 25000 0 3000 73571
February-09 45240 9000 8678 0 16272 3712 145000 0 0 227902
Total= 800952

AMOUNT BALANCE
TOTAL SALARY including Transport Allowance 0 800952
(-) Transport Allowance @ Rs 800/- pm 9600 791352
GROSS SALARY 791352
OTHER INCOME (LeaveSalary) 0 791352
SETTING OFF LOSS - HOUSE 103690 687662
LESS SAVINGS U/S 80C (Max 100000) : (GPF+CGEIS) 100000 587662
LESS U/S 80D,80DD,80DDB (Mediclame, Handicap,Chronic Disease) 0 587662
LESS Recovery 0 587662
LESS U/S 80G (PM Relief Fund) 0 587662
NET TAXABLE INCOME 587662
Income Tax 78299
Cess 2349
Surcharge (If income > 1000000) 0
Total Tax Payable 80648
[ - ] Tax from Arrear 0

TAX DUE for FEB 2009

Tax+ Cess Paid from Regular Pay Bills Till Jan 09 28000
Tax deducted from Arrear 0
Balance Tax + Cess to be recovered 52648
Tax Cess Total (Tax+Cess)
Balance Recovery (Tax + Cess) pm
Feb-09 0 0 52648
Revised Pay, Arrears and Tax Calculator
NAME: Dr XYZ New Desi: Associate Professor 3
Sex: Female 2 PAN No.: Getting Tpt All? Getting HRA?
Old Basic Pay: 16620 Select PB: 37400-67000
INPUT DATA FOR
16620 1 Yes 1 Yes 1
Revised BP: 42120 AGP: 29000 Incr. Month: Apr
RED COLOR
FIELDS

NAME: Dr XYZ Associate Professor Software Version 01.03.09

REVISED PAY IN PB4 37400-67000

Date Revised Pay GP Total Gross Pay % Change

1.01.2006 42120 9000 51120 51120 65.37

1.09.2008 45240 9000 54240 82902 71.74

INPUT FOR INCOME TAX CALCULATIONS Total Arrears

Tax + Cess Paid up to Dec 2008: 27500 From Jan 2006 to Aug 2008 639368
Savings U/S 80C (Max 100000): 100000 ARREARS AND INCOME TAX
Interest Paid on Housing Loan: 100000 FY Arr. to be Paid FY Income Tax
Interest Paid on Education Loan: 0 2008-09 255747 80648
Income from other Sources: 0 2009-10 383621 Not Calculated

NEW TAX CALCULATIONS

TOTAL Tax+ Cess Paid upto Jan 2009 27500
Balance Tax to be recovered 53148
Tax Deduction From Arrears 0
Balance Tax Recovery Feb 2009 53148
Summary: Implementation of 6th Pay commission
Name: Dr XYZ Designation: Associate Professor Office: Deshbandhu College
New Scale: 37400-67000
Date BandPay GradePay Total DA HRA TPT Add.Incr/Pay Gross Pay
1.1.2006 42120 9000 51120 0 0 0 0 51120
1.7.2006 42120 9000 51120 0 0 0 0 51120
1.7.2007 43660 9000 52660 4738 0 0 0 57398
1.7.2008 45240 9000
0 54240 8678 0 0 0 62918
1.9.2008 45240 9000 54240 8678 16272 3712 0 82902

PAYMENTS OF ARREARS TAX CALCULATIONS

Total Arrears (1.1.06 to 1.8.09) 639368 Total Tax for 08-09 with arrears 80648
To be paid in FY 08-09 (40%) 255747 Tax deducted from March 08 to Jan 09 28000
To be paid in FY 09-10 (60%) 383621 Tax Deducted from Arrears 0
Arrears of Sep 08 - Jan 09 173155 Balance Tax to be paid 52648
Tax on arrears +Cees @ 0
Net Arrears Due in 08-09 428902 Tax deduction Feb-09 52648
NAME: Dr XYZ Associate Professor Deshbandhu College
DRAWN [A] DUE [B]
DATE TOTAL Band TPT+DA TOTAL Diff
BP DP DA Spl Pay HRA TPT AGP Spl Pay DA HRA
(A) Pay there on (B) (B-A)
1-Jan-2006 16620 8310 5983 0 0 0 30913
### 42120 9000 0 0 0 0 51120 20207
1-Feb-2006 16620 8310 5983 0 0 0 30913
### 42120 9000 0 0 0 0 51120 20207
1-Mar-2006 16620 8310 5983 0 0 0 30913
### 42120 9000 0 0 0 0 51120 20207
1-Apr-2006 17040 8520 6134 0 0 0 31694
### 42120 9000 0 0 0 0 51120 19426
1-May-2006 17040 8520 6134 0 0 0 31694
### 42120 9000 0 0 0 0 51120 19426
1-Jun-2006 17040 8520 6134 0 0 0 31694
### 42120 9000 0 0 0 0 51120 19426
1-Jul-2006 17040 8520 7412 0 0 0 32972
### 42120 9000 0 1022 0 0 52142 19170
1-Aug-2006 17040 8520 7412 0 0 0 32972
### 42120 9000 0 1022 0 0 52142 19170
1-Sep-2006 17040 8520 7412 0 0 0 32972
### 42120 9000 0 1022 0 0 52142 19170
1-Oct-2006 17040 8520 7412 0 0 0 32972
### 42120 9000 0 1022 0 0 52142 19170
1-Nov-2006 17040 8520 7412 0 0 0 32972
### 42120 9000 0 1022 0 0 52142 19170
1-Dec-2006 17040 8520 7412 0 0 0 32972
### 42120 9000 0 1022 0 0 52142 19170
1-Jan-2007 17040 8520 8946 0 0 0 34506
### 42120 9000 0 3067 0 0 54187 19681
1-Feb-2007 17040 8520 8946 0 0 0 34506
### 42120 9000 0 3067 0 0 54187 19681
1-Mar-2007 17040 8520 8946 0 0 0 34506
### 42120 9000 0 3067 0 0 54187 19681
1-Apr-2007 17460 8730 9167 0 0 0 35357
### 42120 9000 0 3067 0 0 54187 18831
1-May-2007 17460 8730 9167 0 0 0 35357
### 42120 9000 0 3067 0 0 54187 18831
1-Jun-2007 17460 8730 9167 0 0 0 35357
### 42120 9000 0 3067 0 0 54187 18831
1-Jul-2007 17460 8730 10738 0 0 0 36928
### 43660 9000 0 4738 0 0 57398 20471
1-Aug-2007 17460 8730 10738 0 0 0 36928
### 43660 9000 0 4739 0 0 57399 20472
1-Sep-2007 17460 8730 10738 0 0 0 36928
### 43660 9000 0 4739 0 0 57399 20472
1-Oct-2007 17460 8730 10738 0 0 0 36928
### 43660 9000 0 4739 0 0 57399 20472
1-Nov-2007 17460 8730 10738 0 0 0 36928
### 43660 9000 0 4739 0 0 57399 20472
1-Dec-2007 17460 8730 10738 0 0 0 36928
### 43660 9000 0 4739 0 0 57399 20472
1-Jan-2008 17460 8730 12309 0 0 0 38499
### 43660 9000 0 6319 0 0 58979 20480
1-Feb-2008 17460 8730 12309 0 0 0 38499
### 43660 9000 0 6319 0 0 58979 20480
1-Mar-2008 17460 8730 12309 0 0 0 38499
### 43660 9000 0 6319 0 0 58979 20480
1-Apr-2008 17880 8940 12605 0 0 0 39425
### 43660 9000 0 6319 0 0 58979 19554
1-May-2008 17880 8940 12605 0 0 0 39425
### 43660 9000 0 6319 0 0 58979 19554
1-Jun-2008 17880 8940 12605 0 0 0 39425
### 43660 9000 0 6319 0 0 58979 19554
1-Jul-2008 17880 8940 12605 0 0 0 39425
### 45240 9000 0 8678 0 0 62918 23493
1-Aug-2008 17880 8940 12605 0 0 0 39425
### 45240 9000 0 8678 0 0 62918 23493
1-Sep-2008 17880 8940 12605 0 8046 800 48271
### 45240 9000 0 8678 16272 3712 82902 34631
1-Oct-2008 17880 8940 12605 0 8046 800 48271 45240 9000 0 8678 16272 3712 82902 34631
1-Nov-2008 17880 8940 12605 0 8046 800 48271 45240 9000 0 8678 16272 3712 82902 34631
1-Dec-2008 17880 8940 12605 0 8046 800 48271 45240 9000 0 8678 16272 3712 82902 34631
1-Jan-09 17880 8940 12605 0 8046 800 48271 45240 9000 0 8678 16272 3712 82902 34631
### Arrear Till August 2008= 639368
Paymet recieved Jan 2009: 25000 40% of Arrears(Jan 06-Aug 09)= 255747
Payment recieved in Feb 2009: 145000 Pay Arrears of Sept 08 to Jan 09= 173155
Balance Due: 258902 ### Net Balance to be Paid 428902
UGC Old BP Rev BP
Old BP Value SET 50 1 8000 15600 1
2 8275 15600 2
3 8550 15910 3
4 8825 16420 4
5 9100 16930 5
6 9375 17440
7 9650 17950
8 9925 18470
9 10200 18980
10 10475 19490
11 10750 20000
12 11025 20510
13 11300 21020
14 11575 21530
15 11850 22050
16 12125 22560
17 12400 23070
18 12675 23580
19 12950 24090
20 13225 24600
21 13500 25110
22 10000 18600
23 10325 19210
24 10650 19810
25 10975 20420
26 11300 21020
27 11625 21630
28 11950 22230
29 12275 22840
30 12600 23440
31 12925 24050
32 13250 24650
33 13575 25250
34 13900 25860
35 14225 26460
36 14550 27070
37 14875 27670
38 15200 28280
39 12000 22600
40 12420 23590
41 12840 24000
42 13260 37400
43 13680 37400
44 14100 38530
45 14520 38530
46 14940 39690
47 15360 39690
48 15780 40890
49 16200 40890
50 16620 42120
51 17040 42120
52 17460 43390
53 17880 43390
54 18300 44700
55 18720 44700
56 19140 46050
57 19560 46050
GP Incre Month Designation:
10000 1 Jan 1 Assistant Professor
9000 2 Feb 2 Reader/Sr Lecturer
8000 3 Mar 3 Associate Professor
7000 4 Apr 4 Professor
6000 5 May Value Set= 3
6 Jun
7 July
8 Aug
9 Sep
10 Oct
11 Nov
12 Dec
Value Set= 4

HRA/ TPT Opt:

1 Yes
2 No
HRA Velue Set= 1
TPT Value Set= 1
For Tax Relief under Sec 89(1) for Arrears received during the year 2008-09

Dr XYZ Associate Professor PAN No.: 0

ANNEXURE-I
1. Total net taxable Income excluding Salary received in arrears of previous Fys
2. Salary received in arrears of previous FYs
3. Total income (as increased by salary received in arrears (1)+(2)
4. Tax+Cess on total income (as per item 3)
5. Tax+Cess on total income (as per item 1)
6. Tax+Cess on salary received in arrears of previous FYs (4)-(5) (Refer Table-A below)

TABLE -A
Previous Total Net Taxable Salary received Tax on Total
Total Income for Tax on Total Difference in
Financial Income of relevant in arrears for Income as per
the relevant FY Income as per Tax+Cess
Years year in col (1) relevant FY col (2)
Col (4) (6)-(5)
(1) (2) (3) (4) (5) (6) (7)
2005-06 0
2006-07 0
2007-08 0
Total 0