ABCDEFGHIJKLMNOPQRSTUYZAAABACADAE
1
2
3
4
5
6
7
8
9
10th Bipartite Arrears Calculation Package - Substaff
10
11
How to use this package :
12
1. Enter your name, designation, etc. in the fields coloured "yellow".
13
2. When you click on the fields coloured "light brown" you will get a small triangle like object on the right side. Click on the small triangle and a Menu will drop down. Select the appropriate information like your HRA Centre, CCA Centre, Basic Pay, Special Pay, FPP etc. (use copy & paste for multiple entries of same value)
14
15
16
3. Enter the number of days on Leave on Loss of Pay/Half-pay Sick Leave/Strike for which Pay is to be deducted.
17
4. Go to the "Print" worksheet (by clicking the Printer Picture on the bottom of this sheet) and take a print out.
18
5. After taking the print out, if you want to enter the details of another person, please select the yellow coloured and light brown coloured areas and press the delete key. Do not try to enter "Zero" in columns where you have no figures to enter. To remove already entered figures, use delete key.
19
6. Salary for 10 and 11.02.2014, 12.11.2014 and 2 to 5.12.2014 (one day) has to be deducted for participation in the Strike call given by AIBEA.
20
21
Name
22
Designation
23
Employee Code
24
Bank
25
Branch
26
HRA CentreAbove 45 Lakhs
27
Pension/NPSPension
28
Enter your existing (9th Bipartite) details for full month
29
MonthBasicSpl. PayFPPLOP Days
30
Nov-12
31
Dec-12
32
Jan-13
33
Feb-13
34
Mar-13
35
Apr-13
36
May-13
37
Jun-13
38
Jul-13
39
Aug-13
40
Sep-13
41
Oct-13
42
Nov-13
43
Dec-13
44
Jan-14
45
Feb-142
46
Mar-14
47
Apr-14
48
May-14
49
Jun-14
50
Jul-14
51
Aug-14
52
Sep-14
53
Oct-14
54
Nov-141
55
Dec-141
56
Jan-15
57
Feb-15
58
Mar-15
59
Apr-15
60
May-15
61
Jun-15
62
Jul-15
63
64
65
Note: This Package will calculate arrears for the 10th Bipartite based on the Industry-level Settlement and will not cover any Bank-wise Settlements. While granting of the 8th Stagnation increment is built-in, reduction in periodicity of Stagnation Increment, if any, is not being calculated by this package. The accuracy of the results are based on the input given in this page by the user, incorrect input will only produce wrong results.
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100