11th Bipartite settlement | Clerical Salary Arrear calculation

Sub staff Arrear Calculation

11th Bipartite Settlement Expected Arrear Salary Calculation

Select HRA %:Select7.50910

Select PQP:Select PQP410800121016202010

Select Transport Allowance:Select T Allowance425470

Months	Basic	PQP	Tra. Allowance	HRA%	DA Rates	DA	Special Basic 7.75%	Special basic DA	HRA 7%	Net Salary Old
Nov-17	select basic011765124201307513730145451536016175171551813519115200952124022385235302467525820269652811030230315403285034160354703678038090394004071042020	Select PQP0410800121016202010	Select T Allowance0425470	Select7.50910	51.60
Dec-17	select basic011765124201307513730145451536016175171551813519115200952124022385235302467525820269652811030230315403285034160354703678038090394004071042020	Select PQP0410800121016202010	Select T Allowance0425470	Select7.50910	51.60
Jan-18	select basic011765124201307513730145451536016175171551813519115200952124022385235302467525820269652811030230315403285034160354703678038090394004071042020	Select PQP0410800121016202010	Select T Allowance0425470	Select7.50910	51.60
Feb-18	select basic011765124201307513730145451536016175171551813519115200952124022385235302467525820269652811030230315403285034160354703678038090394004071042020	Select PQP0410800121016202010	Select T Allowance0425470	Select7.50910	52.70
March-18	select basic011765124201307513730145451536016175171551813519115200952124022385235302467525820269652811030230315403285034160354703678038090394004071042020	Select PQP0410800121016202010	Select T Allowance0425470	Select7.50910	52.70
April-18	select basic011765124201307513730145451536016175171551813519115200952124022385235302467525820269652811030230315403285034160354703678038090394004071042020	Select PQP0410800121016202010	Select T Allowance0425470	Select7.50910	52.70
May-18	select basic011765124201307513730145451536016175171551813519115200952124022385235302467525820269652811030230315403285034160354703678038090394004071042020	Select PQP0410800121016202010	Select T Allowance0425470	Select7.50910	52.90
June-18	select basic011765124201307513730145451536016175171551813519115200952124022385235302467525820269652811030230315403285034160354703678038090394004071042020	Select PQP0410800121016202010	Select T Allowance0425470	Select7.50910	52.90
July-18	select basic011765124201307513730145451536016175171551813519115200952124022385235302467525820269652811030230315403285034160354703678038090394004071042020	Select PQP0410800121016202010	Select T Allowance0425470	Select7.50910	52.90
Aug-18	select basic011765124201307513730145451536016175171551813519115200952124022385235302467525820269652811030230315403285034160354703678038090394004071042020	Select PQP0410800121016202010	Select T Allowance0425470	Select7.50910	54.10
Sept-18	select basic011765124201307513730145451536016175171551813519115200952124022385235302467525820269652811030230315403285034160354703678038090394004071042020	Select PQP0410800121016202010	Select T Allowance0425470	Select7.50910	54.10
Oct-18	select basic011765124201307513730145451536016175171551813519115200952124022385235302467525820269652811030230315403285034160354703678038090394004071042020	Select PQP0410800121016202010	Select T Allowance0425470	Select7.50910	54.10
Nov-18	select basic011765124201307513730145451536016175171551813519115200952124022385235302467525820269652811030230315403285034160354703678038090394004071042020	Select PQP0410800121016202010	Select T Allowance0425470	Select7.50910	60.70
Dec-18	select basic011765124201307513730145451536016175171551813519115200952124022385235302467525820269652811030230315403285034160354703678038090394004071042020	Select PQP0410800121016202010	Select T Allowance0425470	Select7.50910	60.70
Jan-19	select basic011765124201307513730145451536016175171551813519115200952124022385235302467525820269652811030230315403285034160354703678038090394004071042020	Select PQP0410800121016202010	Select T Allowance0425470	Select7.50910	60.70
Feb-19	select basic011765124201307513730145451536016175171551813519115200952124022385235302467525820269652811030230315403285034160354703678038090394004071042020	Select PQP0410800121016202010	Select T Allowance0425470	Select7.50910	61.10
March-19	select basic011765124201307513730145451536016175171551813519115200952124022385235302467525820269652811030230315403285034160354703678038090394004071042020	Select PQP0410800121016202010	Select T Allowance0425470	Select7.50910	61.10
April-19	select basic011765124201307513730145451536016175171551813519115200952124022385235302467525820269652811030230315403285034160354703678038090394004071042020	Select PQP0410800121016202010	Select T Allowance0425470	Select7.50910	61.10
May-19	select basic11765124201307513730145451536016175171551813519115200952124022385235302467525820269652811030230315403285034160354703678038090394004071042020	Select PQP0410800121016202010	Select T Allowance0425470	Select7.50910	64.50
June-19	select basic11765124201307513730145451536016175171551813519115200952124022385235302467525820269652811030230315403285034160354703678038090394004071042020	Select PQP0410800121016202010	Select T Allowance0425470	Select7.50910	64.50
July-19	select basic11765124201307513730145451536016175171551813519115200952124022385235302467525820269652811030230315403285034160354703678038090394004071042020	Select PQP0410800121016202010	Select T Allowance0425470	Select7.50910	64.50
Aug-19	select basic11765124201307513730145451536016175171551813519115200952124022385235302467525820269652811030230315403285034160354703678038090394004071042020	Select PQP0410800121016202010	Select T Allowance0425470	Select7.50910	68.10
Sept-19	select basic11765124201307513730145451536016175171551813519115200952124022385235302467525820269652811030230315403285034160354703678038090394004071042020	Select PQP0410800121016202010	Select T Allowance0425470	Select7.50910	68.10
Oct-19	select basic11765124201307513730145451536016175171551813519115200952124022385235302467525820269652811030230315403285034160354703678038090394004071042020	Select PQP0410800121016202010	Select T Allowance0425470	Select7.50910	68.10
Nov-19	select basic11765124201307513730145451536016175171551813519115200952124022385235302467525820269652811030230315403285034160354703678038090394004071042020	Select PQP0410800121016202010	Select T Allowance0425470	Select7.50910	71.70
Dec-19	select basic11765124201307513730145451536016175171551813519115200952124022385235302467525820269652811030230315403285034160354703678038090394004071042020	Select PQP0410800121016202010	Select T Allowance0425470	Select7.50910	71.70
Jan-20	select basic11765124201307513730145451536016175171551813519115200952124022385235302467525820269652811030230315403285034160354703678038090394004071042020	Select PQP0410800121016202010	Select T Allowance0425470	Select7.50910	71.70
Feb-20	select basic11765124201307513730145451536016175171551813519115200952124022385235302467525820269652811030230315403285034160354703678038090394004071042020	Select PQP0410800121016202010	Select T Allowance0425470	Select7.50910	75.90
March-20	select basic11765124201307513730145451536016175171551813519115200952124022385235302467525820269652811030230315403285034160354703678038090394004071042020	Select PQP0410800121016202010	Select T Allowance0425470	Select7.50910	75.90
April-20	select basic11765124201307513730145451536016175171551813519115200952124022385235302467525820269652811030230315403285034160354703678038090394004071042020	Select PQP0410800121016202010	Select T Allowance0425470	Select7.50910	75.90
May-20	select basic11765124201307513730145451536016175171551813519115200952124022385235302467525820269652811030230315403285034160354703678038090394004071042020	Select PQP0410800121016202010	Select T Allowance0425470	Select7.50910	76.10
June-20	select basic11765124201307513730145451536016175171551813519115200952124022385235302467525820269652811030230315403285034160354703678038090394004071042020	Select PQP0410800121016202010	Select T Allowance0425470	Select7.50910	76.10
July-20	select basic11765124201307513730145451536016175171551813519115200952124022385235302467525820269652811030230315403285034160354703678038090394004071042020	Select PQP0410800121016202010	Select T Allowance0425470	Select7.50910	76.10
Aug-20	select basic11765124201307513730145451536016175171551813519115200952124022385235302467525820269652811030230315403285034160354703678038090394004071042020	Select PQP0410800121016202010	Select T Allowance0425470	Select7.50910	77.50
Sept-20	select basic11765124201307513730145451536016175171551813519115200952124022385235302467525820269652811030230315403285034160354703678038090394004071042020	Select PQP0410800121016202010	Select T Allowance0425470	Select7.50910	77.50
Oct-20	select basic11765124201307513730145451536016175171551813519115200952124022385235302467525820269652811030230315403285034160354703678038090394004071042020	Select PQP0410800121016202010	Select T Allowance0425470	Select7.50910	77.50
Nov-20	select basic11765124201307513730145451536016175171551813519115200952124022385235302467525820269652811030230315403285034160354703678038090394004071042020	Select PQP0410800121016202010	Select T Allowance0425470	Select7.50910	81.80

Month	Basic Pay	P Q P	Special All 16.4%	DA on Spl All	DA Rates	D A	Transport allowance	DA on Trans	HRA 10.25%	Salary New	Difference
NOV-17					2.66
Dec-17					2.66
Jan-18					2.66
Feb-18					3.43
March-18					3.43
April-18					3.43
May-18					3.57
June-18					3.57
July-18					3.57
Aug-18					4.41
Sept-18					4.41
Oct-18					4.41
Nov-18					9.03
Dec-18					9.03
Jan-19					9.03
Feb-19					9.31
March-19					9.31
April-19					9.31
May-19					11.69
June-19					11.69
July-19					11.69
Aug-19					14.21
Sept-19					14.21
Oct-19					14.21
Nov-19					16.73
Dec-19					16.73
Jan-20					16.73
Feb-20					19.67
March-20					19.67
April-20					19.67
May-20					19.81
June-20					19.81
July-20					19.81
Aug-20					20.79
Sept-20					20.79
Oct-20					20.79
Nov-20					23.80