Jitendra.A patel ( M.Sc,B.Ed,CIC) Smt. M. K.Patel High School,Gozaria TA & Dist - Mehsana E-MAIL -
[email protected]
Note
This calculator is not useful for fix salary employees and getting higher scale between 01/01/2006 to 01/04/2009
Dear Friend , Do you want to count your six pay arrears and salary of April 2009 ? If yes then follows the step. If no then close the programme. Step - 1
WRITE YOUR BASIC SALARY AS ON 01/01/2006 IN THE YELLOW CELL
Step - 2
WRITE YOUR GRADE BAND IN BLUE CELL .IF YOU DO NOT KNOW GRADE BAND THEN REFER TABLE.GRADE PAY BAND IS LIKE 2400,2800,4200 ……..
Step - 3
WRITE YOUR INCREMENT MONTH IN RED CELL. ( ONLY THREE NUMBER)
Step - 4
WRITE YOUR INCREMENT IN RUPESS IN PINK CELL
Step - 5
WRITE YOUR NEW HRA. IT IS 10 % FOR RURAL AND 20 % FOR A CITY WHOSE POPULATION IS GRATHER THEN 5 LAKHS
Step - 6
WRITE YOUR ALL OTHER ALLOWANCES IN BLUE CELL
Step - 7
NOW GO THE FOLLOWING ARREARS CALCULATION SHEET AND SEE IT. PRINT IT IN LEGEAL SIZE PAPER. DO NOT SET PRINT MARGIN. IT IS OK.
Step - 8
NOW GO THE FOLLOWING SALARY OF APRIL 2009 SHEET AND SEE IT. PRINT IT IN LEGEAL OR A4 SIZE PAPER. DO NOT SET PRINT MARGIN. IT IS OK.
IF you do not understand the above steps then mail me on
[email protected] Thanks for using Six pay calculator.
Read the steps 1 TO 8 and write in color cell. Jitendra
5900 4200 FEB 150 10 0
Basic (as on 1 Jan 06)
5900
Grade Pay
4200
FEB
PAY Drawn
150
Jul
PAY Due
Month
Year
Basic
DP
DA
Total
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar
2006 2006 2006 2006 2006 2006 2006 2006 2006 2006 2006 2006 2007 2007 2007 2007 2007 2007 2007 2007 2007 2007 2007 2007 2008 2008 2008 2008 2008 2008 2008 2008 2008 2008 2008 2008 2009 2009 2009
5900 6050 6050 6050 6050 6050 6050 6050 6050 6050 6050 6050 6050 6200 6200 6200 6200 6200 6200 6200 6200 6200 6200 6200 6200 6350 6350 6350 6350 6350 6350 6350 6350 6350 6350 6350 6350 6500 6500
2950 3025 3025 3025 3025 3025 3025 3025 3025 3025 3025 3025 3025 3100 3100 3100 3100 3100 3100 3100 3100 3100 3100 3100 3100 3175 3175 3175 3175 3175 3175 3175 3175 3175 3175 3175 3175 3250 3250
2124 2178 2178 2178 2178 2178 2632 2632 2632 2632 2632 2632 3176 3255 3255 3255 3255 3255 3813 3813 3813 3813 3813 3813 4371 4477 4477 4477 4477 4477 4477 4477 4477 4477 4477 4477 4477 4583 4583
10974 11253 11253 11253 11253 11253 11707 11707 11707 11707 11707 11707 12251 12555 12555 12555 12555 12555 13113 13113 13113 13113 13113 13113 13671 14002 14002 14002 14002 14002 14002 14002 14002 14002 14002 14002 14002 14333 14333
New Basic Roundup 10 Rs 15180 15180 15180 15180 15180 15180 15630 15630 15630 15630 15630 15630 15630 15630 15630 15630 15630 15630 16100 16100 16100 16100 16100 16100 16100 16100 16100 16100 16100 16100 16590 16590 16590 16590 16590 16590 16590 16590 16590
DA
Total
Arrears
Month
Year
0 0 0 0 0 0 313 313 313 313 313 313 938 938 938 938 938 938 1449 1449 1449 1449 1449 1449 1932 1932 1932 1932 1932 1932 2653 2653 2653 2653 2653 2653 2653 2653 2653
15180 15180 15180 15180 15180 15180 15943 15943 15943 15943 15943 15943 16568 16568 16568 16568 16568 16568 17549 17549 17549 17549 17549 17549 18032 18032 18032 18032 18032 18032 19243 19243 19243 19243 19243 19243 19243 19243 19243
4206 3927 3927 3927 3927 3927 4236 4236 4236 4236 4236 4236 4317 4013 4013 4013 4013 4013 4436 4436 4436 4436 4436 4436 4361 4030 4030 4030 4030 4030 5241 5241 5241 5241 5241 5241 5241 4910 4910
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar
2006 2006 2006 2006 2006 2006 2006 2006 2006 2006 2006 2006 2007 2007 2007 2007 2007 2007 2007 2007 2007 2007 2007 2007 2008 2008 2008 2008 2008 2008 2008 2008 2008 2008 2008 2008 2009 2009 2009
171273
Old D.A 24 24 24 24 24 24 29 29 29 29 29 29 35 35 35 35 35 35 41 41 41 41 41 41 47 47 47 47 47 47 47 47 47 47 47 47 47 47 47
New D.A 0 0 0 0 0 0 2 2 2 2 2 2 6 6 6 6 6 6 9 9 9 9 9 9 12 12 12 12 12 12 16 16 16 16 16 16 16 16 16
If you have any query then contact me on
[email protected] Give me your basic as on 01-01-2006 , increament month , increament Rs, rural or city location, then I will send your arrears and salary of april 2009 by coun Jitendra.A patel ( M.Sc,B.Ed,CIC) Smt. M. K.Patel High School,Gozaria TA & Dist - Mehsana E-MAIL -
[email protected]
your arrears and salary of april 2009 by counting it.
Salary Of April 2009 New Basic D.A (16 % ) H.R.A Medical
16590 2653 1659 100
Rs Rs Rs Rs
Total
21002
Rs
Add Allowances
+
Gross Salary
0 21002
Rs
Jitendra.A patel ( M.Sc,B.Ed,CIC)
Rs
Smt. M. K.Patel High School,Gozaria TA & Dist - Mehsana E-MAIL -
Total Arrears First Installment in G.P.F - 2009 Second Installment in G.P.F- 2010 Third Installment in G.P.F - 2011 Fourth Installment in G.P.F - 2012 Fifth Installment in G.P.F - 2013
171273 34255 34255 34255 34255 34255
Rs Rs Rs Rs Rs Rs
[email protected]
Dist - Mehsana