6th pay arrear xls prog. for gpf
TRANSCRIPT
-
8/14/2019 6th Pay Arrear XLS prog. for GPF
1/31
1 Office Name Office Of The Regional Dy.Director(trg),Vadodara.
2 Name Of Employee M.K.Mavi
3 Designation Assit.App.Advisor
4 Paid Pay Scale S-12 (6500-200-10500)
5 To be Paid Pay Scale PB2 (9300-34800)
6 Enter Old Basic Pay as on 1-1-06 7900
7 Enter New Grade Pay 42008 Enter New HRA rate of your city 20
9 Enter Month of Old increment 10
10 Enter old Increment amount 200
11 Are you staying in quarters(Yes/No) No
12 Enter Old TA amount 75
13 Enter Old HRA rate 15
14 Enter Old CLA rate 180
15 G.P.F. Number GA/GUJ/
This Program only for those employee who has no change pay scale from 1st janua
but if you want to do some changed, then you can change some criteria
-
8/14/2019 6th Pay Arrear XLS prog. for GPF
2/31
Enter Your Office Name in sort
Enter Your Name
Enter Your Desig.
Select Yor Old Scale 10500
This fild will fill Automatic
Enter Basic Pay as on 1-1-06
This fild will fill AutomaticSelect Yor New Hra Rate
Select Increment Month
This fild will fill Automatic
Select Yes / No
Select Old TA
Select Old HRA
Enter Old CLA
Enter G.P.F.Number
ry-2006 to march-2009
your self.
-
8/14/2019 6th Pay Arrear XLS prog. for GPF
3/31
-
8/14/2019 6th Pay Arrear XLS prog. for GPF
4/31
-
8/14/2019 6th Pay Arrear XLS prog. for GPF
5/31
-
8/14/2019 6th Pay Arrear XLS prog. for GPF
6/31
-
8/14/2019 6th Pay Arrear XLS prog. for GPF
7/31
-
8/14/2019 6th Pay Arrear XLS prog. for GPF
8/31
-
8/14/2019 6th Pay Arrear XLS prog. for GPF
9/31
-
8/14/2019 6th Pay Arrear XLS prog. for GPF
10/31
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
Sep-08
Oct-08
Nov-08
Dec-08
Jan-09
Feb-09
Mar-09
-
8/14/2019 6th Pay Arrear XLS prog. for GPF
11/31
New Sixth PC Arrears and New Pay Calculator (up to Pay Band 2)Statment Showing The Deffrence of Pay in 6th Pay Commission
Employee Name M.K.Mavi Office Office Of The Regional Dy.Director(trg),Vadodara.
Designation Assit.App.Advisor 01/01/2006 to 31/03/2009 DA rate %Enter Old Basic Pay as on 1-1-06 7900 Jul-2006 2
Enter New Grade Pay 4200 Jan-2007 6
Enter New HRA rate of your city 20 % 10500 0 Jul-2007 9
Enter Month of Old increment 10 Jan-2008 12
Enter old Increment amount 200 200 July-08 16Are you staying in quarters No Jan-2009 22
Old TA amount Rs. 75
Enter old HRA Rate 15.0 %
-
8/14/2019 6th Pay Arrear XLS prog. for GPF
12/31
Month FIXED GRADE BASIC DA Total Pay PAY DRAWN Arrears
Jan-06 14700 4200 18900 0 18900 7900 3950 2844 14694 4206
Feb-06 14700 4200 18900 0 18900 7900 3950 2844 14694 4206
Mar-06 14700 4200 18900 0 18900 7900 3950 2844 14694 4206
Apr-06 14700 4200 18900 0 18900 7900 3950 2844 14694 4206
May-06 14700 4200 18900 0 18900 7900 3950 2844 14694 4206Jun-06 14700 4200 18900 0 18900 7900 3950 2844 14694 4206
Jul-06 15270 4200 19470 389 19859 7900 3950 3437 15287 4572
Aug-06 15270 4200 19470 389 19859 7900 3950 3437 15287 4572
Sep-06 15270 4200 19470 389 19859 7900 3950 3437 15287 4572
Oct-06 15270 4200 19470 389 19859 8100 4050 3524 15674 4185
Nov-06 15270 4200 19470 389 19859 8100 4050 3524 15674 4185
Dec-06 15270 4200 19470 389 19859 8100 4050 3524 15674 4185
Jan-07 15270 4200 19470 1168 20638 8100 4050 4253 16403 4235
Feb-07 15270 4200 19470 1168 20638 8100 4050 4253 16403 4235
Mar-07 15270 4200 19470 1168 20638 8100 4050 4253 16403 4235
Apr-07 15270 4200 19470 1168 20638 8100 4050 4253 16403 4235
May-07 15270 4200 19470 1168 20638 8100 4050 4253 16403 4235
Jun-07 15270 4200 19470 1168 20638 8100 4050 4253 16403 4235
Jul-07 15860 4200 20060 1805 21865 8100 4050 4982 17132 4733
Aug-07 15860 4200 20060 1805 21865 8100 4050 4982 17132 4733
Sep-07 15860 4200 20060 1805 21865 8100 4050 4982 17132 4733
Oct-07 15860 4200 20060 1805 21865 8300 4150 5105 17555 4310
Nov-07 15860 4200 20060 1805 21865 8300 4150 5105 17555 4310
Dec-07 15860 4200 20060 1805 21865 8300 4150 5105 17555 4310
Jan-08 15860 4200 20060 2407 22467 8300 4150 5852 18302 4165
Feb-08 15860 4200 20060 2407 22467 8300 4150 5852 18302 4165
Mar-08 15860 4200 20060 2407 22467 8300 4150 5852 18302 4165
Apr-08 15860 4200 20060 2407 22467 8300 4150 5852 18302 4165
May-08 15860 4200 20060 2407 22467 8300 4150 5852 18302 4165
Jun-08 15860 4200 20060 2407 22467 8300 4150 5852 18302 4165
Jul-08 16470 4200 20670 3307 23977 8300 4150 5852 18302 5675
Aug-08 16470 4200 20670 3307 23977 8300 4150 5852 18302 5675
Sep-08 16470 4200 20670 3307 23977 8300 4150 5852 18302 5675
Oct-08 16470 4200 20670 3307 23977 8500 4250 5993 18743 5234
Nov-08 16470 4200 20670 3307 23977 8500 4250 5993 18743 5234
Dec-08 16470 4200 20670 3307 23977 8500 4250 5993 18743 5234
Jan-09 16470 4200 20670 4547 25217 8500 4250 5993 18743 6474
Feb-09 16470 4200 20670 4547 25217 8500 4250 5993 18743 6474
Mar-09 16470 4200 20670 4547 25217 8500 4250 5993 18743 6474
609990 163800 773790 68097 841887 318900 159450 182352 660702 181185
As per approved 6CPC report merger ratio and increment (annual) are 1.86 times and 3% respectively. This
Calculator has been updated to that extent
-
8/14/2019 6th Pay Arrear XLS prog. for GPF
13/31
Expected Pay as on April-2009
FIXED GRADE TOTAL DA Total TA HRA M.A. CLA GROSS Raise
16470 4200 20670 4547 25217 400 4134 100 240 30091
9080OLD PAY PAY DA DA Total TA HRA M.A. CLA GROSS
8500 4250 5993 18743 75 1913 100 180 21011
A.F.Shaikh, Sr.Clerk ,RDD Office Vadodara E-mail :- [email protected] [M]99798 91506
Total Amount of Arrears in to G.P.F.M.K.Mavi Note : Please Select Your New T.A. & CLA
1st Installment Dec-09 36237 with selection button wich indicate with
2nd Installment Dec-10 36237 Yellow color cell
3rd Installment Dec-11 36237
4th Installment Dec-12 36237
5th Installment Dec-13 36237
New C.L.A. From 1-4-2009 New H.R.A. From 1-4-2009
Pay Band (Bsic Pay) Grade PayRate Of CLA
Classification of Cities/towns Rate Of H.R.A.X(A1) Y(A-B1-B2) Z(C)
300 240 0 X (earlier Classification A-1) 30%
Rs. 5200-20200 200 150 0 20%
Rs. 5200-20200 125 95 0 Z (earlier Classification C) 10%
New Transport Allowance from 1-4-2009
Sr.No.
Rate Of T.A.
1 800 400
2
400 200
3 100 75
Rs. 5200-20200
& Above
2400 &
Above1800 &Above &
Below2400
Y (earlier Classification A-B1& B2)
Below1800
Employees drawing grade payof X/Y Class
Cities
Z (Other
Places)
Grade pay of Rs. 5400 &Above
[i]Grade pay of Rs.4200,Rs.4600, & R.4800
[ii]Thouse drawing Grade paybelow Rs. 4200 but in the payband equal to Rs. 7400 &Above
Grade pay below Rs. 4200 andpay in the pay band below
Rs.7440
-
8/14/2019 6th Pay Arrear XLS prog. for GPF
14/31
0
S-1 (2550-55-2660-60-3200) 2550 55 3200 A 60
S-2 (2610-60-3150-65-3540) 2610 60 3540 B 65
S-2A (2610-60-2910-65-3300) 2610 60 3300 C 65
S-3 (2650-65-3300-70-4000) 2650 65 4000 D 70
S-4 (2750-70-3800-75-4400) 2750 70 4400 E 75
S-5 (3050-75-3950-80-4590) 3050 75 4590 F 80S-6 (3200-85-4900) 3200 85 4900 85
S-7 (4000-100-6000) 4000 100 6000 100
S-8 (4500-125-7000) 4500 125 7000 125
S-9 (5000-150-8000) 5000 150 8000 150
S-10 (5500-175-9000) 5500 175 9000 175
S-11 (6500-200-6900) 6500 200 6900 200
S-12 (6500-200-10500) 6500 200 10500 200
S-13 (7450-225-11500) 7450 225 11500 225
S-14 (7500-250-12000) 7500 250 12000 250
S-15 (8000-275-13500) 8000 275 13500 275
S-15A (8000-275-13500) 8000 275 13500 275
S-16 (9000) 9000 0S-17 (9000-275-9550) 9000 275 9550 275
S-18 (10325-325-10975) 10325 325 10975 325
S-19 (10000-325-15200) 10000 325 15200 325
S-20 (10650-325-15850) 10650 325 15850 325
S-21 (12000-375-16500) 12000 375 16500 375
S-22 (12750-375-16500) 12750 375 16500 375
S-23 (12000-375-18000) 12000 375 18000 375
S-24 (14300-400-18300) 14300 400 18300 400
S-25 (15100-400-18300) 15100 400 18300 400
S-26 (16400-450-20000) 16400 450 20000 450
S-27 (16400-450-20900) 16400 450 20900 450
S-28 (14300-450-22400) 14300 450 22400 450S-29 (18400-500-22400) 18400 500 22400 500
S-30 (22400-525-24500) 22400 525 24500 525
-
8/14/2019 6th Pay Arrear XLS prog. for GPF
15/31
-
8/14/2019 6th Pay Arrear XLS prog. for GPF
16/31
-
8/14/2019 6th Pay Arrear XLS prog. for GPF
17/31
1S (4440-7440) 4440 1300 5740 2550 2605 2660 2720
1S (4440-7440) 4440 1400 5840 2610 2670 2730 2790
1S (4440-7440) 4440 1600 6040
1S (4440-7440) 4440 1650 6090
PB1 (5200-20200) 5200 1800 7000
PB1 (5200-20200) 5200 1900 7100PB1 (5200-20200) 5200 2000 7200
PB1 (5200-20200) 5200 2400 7600
PB1 (5200-20200) 5200 2800 8000
PB2 (9300-34800) 9300 4200 13500
PB2 (9300-34800) 9300 4200 13500
PB2 (9300-34800) 9300 4200 13500
PB2 (9300-34800) 9300 4200 13500
PB2 (9300-34800) 9300 4600 13900
PB2 (9300-34800) 9300 4800 14100
PB2 (9300-34800) 9300 5400 14700
PB-3 (15600-39100) 15600 5400 21000
PB-3 (15600-39100) 15600 5400 21000PB-3 (15600-39100) 15600 5400 21000
PB-3 (15600-39100) 15600 6600 22200
PB-3 (15600-39100) 15600 6600 22200
PB-3 (15600-39100) 15600 6600 22200
PB-3 (15600-39100) 15600 7600 23200
PB-3 (15600-39100) 15600 7600 23200
PB-3 (15600-39100) 15600 7600 23200
PB-4 (37400-67000) 37400 8700 46100
PB-4 (37400-67000) 37400 8700 46100
PB-4 (37400-67000) 37400 8900 46300
PB-4 (37400-67000) 37400 8900 46300
PB-4 (37400-67000) 37400 10000 47400PB-4 (37400-67000) 37400 10000 47400
PB-4 (37400-67000) 37400 12000 49400
-
8/14/2019 6th Pay Arrear XLS prog. for GPF
18/31
-
8/14/2019 6th Pay Arrear XLS prog. for GPF
19/31
Yes 10
No 20
30
-
8/14/2019 6th Pay Arrear XLS prog. for GPF
20/31
2780 2840 2900 2960 3020 3080 3140 3200
2850 2910 2970 3030 3090 3150 3215 3280 3345 3410
-
8/14/2019 6th Pay Arrear XLS prog. for GPF
21/31
-
8/14/2019 6th Pay Arrear XLS prog. for GPF
22/31
1 75 5
2 100 7.5
3 200 15
4 400 30
5 8006
7
89
10
11
12
-
8/14/2019 6th Pay Arrear XLS prog. for GPF
23/31
3475 3540
-
8/14/2019 6th Pay Arrear XLS prog. for GPF
24/31
-
8/14/2019 6th Pay Arrear XLS prog. for GPF
25/31
-
8/14/2019 6th Pay Arrear XLS prog. for GPF
26/31
Annexure - II
Statement of fixation of pay under Gujarat Civil Services ( Revision of Pay ) Rules, 20091 Name of the Government Servant : M.K.Mavi
2 : Assit.App.Advisor
3 Status (Substantive / Officiating ) :
4 : S-12 (6500-200-10500)
5 Existing emoluments as on January 1, 2006 :(a). : 7900.00
(b). Dearness Pay : 3950.00
(c). : 2844.00
(d). Total existing emoluments [ (a) to (c) ] : 14694.00
6 : PB2 (9300-34800)
: PB2 Pay-band
: 4200.00
7 : 14700.00
8 : 4200.00 18900.00
9 :
10 :
11 Personal Pay, if any [ Notes 6 and 8 below Rule 7(1)] :
12 Revised emoluments after fixation :
(a). Pay in the Revised Pay Band / Pay Scale : 14700.00
(b). Grade Pay : 4200.00
(c). :
(d). Personal Pay, if admissible :
(e). :
13 :Date Increment Pay after Increment
Basic pay
7/1/2006 PB2 (9300-34800) 4200.00 19470.00
7/1/2007 PB2 (9300-34800) 4200.00 20060.00
7/1/2008 PB2 (9300-34800) 4200.00 20670.00
14 Any other relevant information
Date : Signature & Designation of Head of Office
Designation of the post in which pay is to be fixed as onJanuary 1,2006
Pre-revised scale(s) of pay applicable for the post [ Incase more than one scale of pay is applicable for the post
Basic pay ( including Stagnation Increments, ifany )
Dearness Allowance applicable at AICPI average536 ( 1982=100)
Revised pay band and grade pay corresponding to thepre-revised scale shown at Sl. No. 4 above. ( In the case
of HAG + and above the appropriate scale may bementioned)
( RevisedPay Band )
( GradePay )
Pay in the revised pay band / scale in which pay is to befixed as per the fitment table attached at annex-1.
Basic payas on 01-
01-2006Grade pay to be applied in terms of Rule of GCS(RP)Rules, 2009Stepped up pay with reference to the revised pay ofJunior, if applicable [ Notes 7 and 10 below Rule 7(1) ofRevised pay with reference to the Substantive Pay incases where the pay fixed in the officiating post is lower
Special Pay, if admissible ( Sub Rule 1( C ) ofRule 7)
Non-Practising Allowance, if admissible [ SeeRule 1(D) of Rule 7]
Date of next increment ( Rule 9 & 10 ) and pay aftergrant of increment
Pay in the PayBand / Scale
GradePay
( wherever
applicable )
-
8/14/2019 6th Pay Arrear XLS prog. for GPF
27/31
Annexure - III
Undertaking
Signature
Name : M.K.Mavi
Designatio Assit.App.Advisor
I hereby undertake that any excess payment that may be found to have been made as aresult of incorrect fixation of pay or any excess payment detected in the light ofdiscrepancies noticed subsequently will be refunded by me to the Government either byadjustment against future payments due to me or otherwise.
-
8/14/2019 6th Pay Arrear XLS prog. for GPF
28/31
Form No. - I
Form of Option
*(i) I M.K.Mavi Assit.App.Advisor hereby elect
the revised pay structure ( pay band and grade pay ) with effect from 1st January,2006
*(ii) I hereby elect to
* the date of my next increment,
the date of my subsequent increment,
raising my pay to Rs.
I vacate or cease to draw pay in the existing scale
The date of my promotion to
Existing Scale :Signature
Name : M.K.Mavi
Date : Designation : Assit.App.Advisor
Station : Office to which empolyed
Signed before me
Signature
Head of office ( in case of non-gazetted Government servant )
Signature
Another Gazetted officer ( in case of Gazetted Government servant )
Revised the above declaration
Signature
Pay and Accounts Officer / Head of Office
* To be scored out if not applicabel.
contihue on the existing scale of pay of my substantive / officiating post mentioned below
untill :
Office Of The RegionalDy.Director(trg),Vadodara.
-
8/14/2019 6th Pay Arrear XLS prog. for GPF
29/31
No:
Dated / / 2009
Ref. : - [1]
[2]
[3]
[4]
- : Office Order : -( 1 )
M.K.Mavi is fixed at Rs. 18900.00 per Month
w.e.f. 01-01-2006 in the pay band PB2 (9300-34800) and pay band Rs.
4200.00
( 2 ) The date of next increment will be 7/1/2006
( 3 ) The details of pay fixation are shown in the statement appended herewith.
( 4 )
( 5 )
( 6 ) The option from the concerned Government employee is received.
( 7 ) An undertaking is also obtained from the concerned Government employee.
SignatureOffice Seal
Copy with compliments to
1 The District / sub Treasury Office
2 The Head Off The Department
3 Account Branch (2 Copy)
4 The Service Book
In pursuance of the provision contained in Gujarat Civil Services ( Revision of pay ) Rules,2009 and other order issued by the Government in this behalf, the initial pay ofShri/Smt./Kum/
The revised pay for the month of January - 2006 and onwards will be drawn on the basis of payas fixed above. The revised pay is subject to its admissibility in audit and subsequent verificationby the pay verification unit.
The payment of arrears arising on account of revision of pay for the period from 1st January -
2006 to 31st March - 2009 shall be regulated as under
The total amount of arrears payable shall be credited in the "General Provident Fund" accountof the Government employee concerned in five equal yearly installments with a " lock in period "of five years for each installment.
-
8/14/2019 6th Pay Arrear XLS prog. for GPF
30/31
5 Personal file
-
8/14/2019 6th Pay Arrear XLS prog. for GPF
31/31
Calculation of arrears for the period 01-01-2006 to 31-03-2009 on account of Revision of Pay
under sixth pay commission recommending in respect of Mr. M.K.Mavi
Name of the Employee M.K.Mavi Arrears Payment Schedule
Existing Scale of pay S-12 (6500-200-10500) Payable Arrears Amount
Old Basic pay Rs. 7900 as on 01-01-2006 date
Date of Revision 1/1/2006 2009 20% of Net arrears 36237
Post :- Assit.App.Advisor 2010 20% of Net arrears 36237
Pay Band :- PB2 (9300-34800) 2011 20% of Net arrears 36237Grade pay :- 4200 2012 20% of Net arrears 36237
New Basic pay Rs.:- 14700 2013 20% of Net arrears 36237
Name of Office :- Office Of The Regional Dy.Director(trg),Vadodara. GPF NO. GA/GUJ/
Payable Paid
Sr.No. Month Grade pay D.A. Total Basic D.P. D.A. Total Difference
1 Jan-06 14700 4200 0 18900 7900 3950 2844 14694 4206
2 Feb-06 14700 4200 0 18900 7900 3950 2844 14694 4206
3 Mar-06 14700 4200 0 18900 7900 3950 2844 14694 4206
4 Apr-06 14700 4200 0 18900 7900 3950 2844 14694 4206
5 May-06 14700 4200 0 18900 7900 3950 2844 14694 4206
6 Jun-06 14700 4200 0 18900 7900 3950 2844 14694 4206
7 Jul-06 15270 4200 389 19859 7900 3950 3437 15287 4572
8 Aug-06 15270 4200 389 19859 7900 3950 3437 15287 45729 Sep-06 15270 4200 389 19859 7900 3950 3437 15287 4572
10 Oct-06 15270 4200 389 19859 8100 4050 3524 15674 4185
11 Nov-06 15270 4200 389 19859 8100 4050 3524 15674 4185
12 Dec-06 15270 4200 389 19859 8100 4050 3524 15674 4185
13 Jan-07 15270 4200 1168 20638 8100 4050 4253 16403 4235
14 Feb-07 15270 4200 1168 20638 8100 4050 4253 16403 4235
15 Mar-07 15270 4200 1168 20638 8100 4050 4253 16403 4235
16 Apr-07 15270 4200 1168 20638 8100 4050 4253 16403 4235
17 May-07 15270 4200 1168 20638 8100 4050 4253 16403 4235
18 Jun-07 15270 4200 1168 20638 8100 4050 4253 16403 4235
19 Jul-07 15860 4200 1805 21865 8100 4050 4982 17132 4733
20 Aug-07 15860 4200 1805 21865 8100 4050 4982 17132 4733
21 Sep-07 15860 4200 1805 21865 8100 4050 4982 17132 4733
22 Oct-07 15860 4200 1805 21865 8300 4150 5105 17555 4310
23 Nov-07 15860 4200 1805 21865 8300 4150 5105 17555 4310
24 Dec-07 15860 4200 1805 21865 8300 4150 5105 17555 4310
25 Jan-08 15860 4200 2407 22467 8300 4150 5852 18302 4165
26 Feb-08 15860 4200 2407 22467 8300 4150 5852 18302 4165
27 Mar-08 15860 4200 2407 22467 8300 4150 5852 18302 4165
28 Apr-08 15860 4200 2407 22467 8300 4150 5852 18302 4165
29 May-08 15860 4200 2407 22467 8300 4150 5852 18302 4165
30 Jun-08 15860 4200 2407 22467 8300 4150 5852 18302 4165
31 Jul-08 16470 4200 3307 23977 8300 4150 5852 18302 5675
32 Aug-08 16470 4200 3307 23977 8300 4150 5852 18302 5675
33 Sep-08 16470 4200 3307 23977 8300 4150 5852 18302 5675
34 Oct-08 16470 4200 3307 23977 8500 4250 5993 18743 5234
35 Nov-08 16470 4200 3307 23977 8500 4250 5993 18743 5234
36 Dec-08 16470 4200 3307 23977 8500 4250 5993 18743 5234
37 Jan-09 16470 4200 4547 25217 8500 4250 5993 18743 6474
38 Feb-09 16470 4200 4547 25217 8500 4250 5993 18743 6474
39 Mar-09 16470 4200 4547 25217 8500 4250 5993 18743 6474
Total 181185
As par Govt.resolutation dated 17-06-09 para(3)(kh),this is certified that above mention payble,paid and difference
amount of pay and allowance are verified by me personally and found correct.
Designation & Signature
Pay in Payband