11th Bipartite Arrears Calculation Package - Clerk

How to use this package :

1. Enter your name, designation, etc. in the fields coloured "yellow".
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, Basic Pay,
Special Pay, PQP, FPP etc. (use copy & paste for multiple entries of same value)
3. Enter the number of days on Leave on Loss of Pay/Half-pay Sick Leave/Strike for which Pay is to be deducted.
4. Go to the "Print" worksheet (by clicking the Printer Picture on the bottom of this sheet) and take a print out.
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.
6. Salary for 30-5-2018, 31-5-2018, 26-12-2018, 8-1-2019, 9-1-2019, 22-10-2019, 8-1-2020, 31-1-2020, 1-2-2020 and 26-11-
2020 has to be deducted for participation in the Strike call given by AIBEA.

Name PANKAJ
Designation SWO B
Employee Code 080255
Bank CENTRAL BANK
Branch PARLIAMENT
HRA Centre Above 45 Lakhs
Pension/NPS Pension
Enter your existing (10th Bipartite) details for full month
LOP
Month Basic Spl. Pay PQP/GP FPP
Days
Nov-17 38090 820 1210 1585
Dec-17 38090 820 1210 1585
Jan-18 38090 820 1210 1585
Feb-18 38090 820 1210 1585
Mar-18 38090 820 1210 1585
Apr-18 38090 820 1210 1585
May-18 38090 820 1210 1585 2
Jun-18 39400 820 1210 1585
Jul-18 39400 820 1210 1585
Aug-18 39400 820 1210 1585
Sep-18 39400 820 1210 1585
Oct-18 39400 820 1210 1585
Nov-18 39400 820 1210 1585
Dec-18 39400 820 1210 1585 1
Jan-19 39400 820 1210 1585 2
Feb-19 39400 820 1210 1585
Mar-19 39400 820 1210 1585
Apr-19 39400 820 1210 1585
May-19 39400 820 1210 1585
Jun-19 39400 820 1210 1585
Jul-19 39400 820 1210 1585
Aug-19 39400 820 1210 1585
Sep-19 39400 820 1210 1585
Oct-19 39400 820 1210 1585 1
Nov-19 39400 820 1210 1585
Dec-19 39400 820 1210 1585
 Jan-20 39400 820 1210 1585 2
Feb-20 39400 820 1210 1585 1
Mar-20 39400 820 1210 1585
Apr-20 39400 820 1210 1585
May-20 39400 820 1210 1585
Jun-20 40710 820 1210 1585
Jul-20 40710 820 1210 1585
Aug-20 40710 820 1210 1585
Sep-20 40710 820 1210 1585
Oct-20 40710 820 1210 1585
Nov-20 40710 820 1210 1585 1
Dec-20 40710 820 1210 1585
Jan-21 40710 820 1210 1585
Eligible for 9th Stagnation from month: Aug-18

Note: This Package will calculate arrears for the 11th Bipartite based on the Industry-level Settlement and
will not cover any Bank-wise Settlements. 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.
 Fighting for wage revision and fighting against Banking Reforms are inseparable tasks.
11th Bipartite Arrears Calculations using AIBEA's Chart
Name of the Employee PANKAJ Bank CENTRAL BANK
Employee Code No. 080255 Branch PARLIAMENT
Employee Designation :SWO B HRA 10.00
Clerks - Existing

ys
Month Special

Da
Basic Spl. Pay PQP/GP FPP Transport DA HRA Gross PF Net
Allowance
Nov-17 30 38090.00 820.00 1210.00 1585.00 2951.98 470.00 22225.14 4012.00 71364.11 4143.00 67221.11
Dec-17 31 38090.00 820.00 1210.00 1585.00 2951.98 470.00 22225.14 4012.00 71364.11 4143.00 67221.11
Jan-18 31 38090.00 820.00 1210.00 1585.00 2951.98 470.00 22225.14 4012.00 71364.11 4143.00 67221.11
Feb-18 28 38090.00 820.00 1210.00 1585.00 2951.98 470.00 22698.93 4012.00 71837.91 4143.00 67694.91
Mar-18 31 38090.00 820.00 1210.00 1585.00 2951.98 470.00 22698.93 4012.00 71837.91 4143.00 67694.91
2017-18 190450.00 4100.00 6050.00 7925.00 14759.88 2350.00 112073.28 20060.00 357768.15 20715.00 337053.15
Apr-18 30 38090.00 820.00 1210.00 1585.00 2951.98 470.00 22698.93 4012.00 71837.91 4143.00 67694.91
May-18 29 35632.58 767.10 1131.94 1482.74 2761.53 439.68 21315.07 3753.16 67283.79 3875.71 63408.08
Jun-18 30 39400.00 820.00 1210.00 1585.00 3053.50 470.00 23531.77 4143.00 74213.27 4274.00 69939.27
Jul-18 31 39400.00 820.00 1210.00 1585.00 3053.50 470.00 23531.77 4143.00 74213.27 4274.00 69939.27
Aug-18 31 39400.00 820.00 1210.00 1585.00 3053.50 470.00 24065.57 4143.00 74747.07 4274.00 70473.07
Sep-18 30 39400.00 820.00 1210.00 1585.00 3053.50 470.00 24065.57 4143.00 74747.07 4274.00 70473.07
Oct-18 31 39400.00 820.00 1210.00 1585.00 3053.50 470.00 24065.57 4143.00 74747.07 4274.00 70473.07
Nov-18 30 39400.00 820.00 1210.00 1585.00 3053.50 470.00 27001.48 4143.00 77682.98 4274.00 73408.98
Dec-18 30 38129.03 793.55 1170.97 1533.87 2955.00 454.84 26130.47 4009.35 75177.08 4136.13 71040.95
Jan-19 29 36858.06 767.10 1131.94 1482.74 2856.50 439.68 25259.45 3875.71 72671.18 3998.26 68672.92
Feb-19 28 39400.00 820.00 1210.00 1585.00 3053.50 470.00 27179.42 4143.00 77860.92 4274.00 73586.92
Mar-19 31 39400.00 820.00 1210.00 1585.00 3053.50 470.00 27179.42 4143.00 77860.92 4274.00 73586.92
2018-19 463909.68 9707.74 14324.84 18764.35 35953.00 5564.19 296024.51 48794.23 893042.54 50345.10 842697.44
Apr-19 30 39400.00 820.00 1210.00 1585.00 3053.50 470.00 27179.42 4143.00 77860.92 4274.00 73586.92
May-19 31 39400.00 820.00 1210.00 1585.00 3053.50 470.00 28691.86 4143.00 79373.36 4274.00 75099.36
Jun-19 30 39400.00 820.00 1210.00 1585.00 3053.50 470.00 28691.86 4143.00 79373.36 4274.00 75099.36
Jul-19 31 39400.00 820.00 1210.00 1585.00 3053.50 470.00 28691.86 4143.00 79373.36 4274.00 75099.36
Aug-19 31 39400.00 820.00 1210.00 1585.00 3053.50 470.00 30293.26 4143.00 80974.76 4274.00 76700.76
Sep-19 30 39400.00 820.00 1210.00 1585.00 3053.50 470.00 30293.26 4143.00 80974.76 4274.00 76700.76
Oct-19 30 38129.03 793.55 1170.97 1533.87 2955.00 454.84 29316.06 4009.35 78362.67 4136.13 74226.55
Nov-19 30 39400.00 820.00 1210.00 1585.00 3053.50 470.00 31894.67 4143.00 82576.17 4274.00 78302.17
Dec-19 31 39400.00 820.00 1210.00 1585.00 3053.50 470.00 31894.67 4143.00 82576.17 4274.00 78302.17
Jan-20 29 36858.06 767.10 1131.94 1482.74 2856.50 439.68 29836.95 3875.71 77248.67 3998.26 73250.42
Feb-20 28 38041.38 791.72 1168.28 1530.34 2948.21 453.79 32598.74 4000.14 81532.60 4126.62 77405.98
Mar-20 31 39400.00 820.00 1210.00 1585.00 3053.50 470.00 33762.98 4143.00 84444.48 4274.00 80170.48
2019-20 467628.48 9732.37 14361.18 18811.96 36241.21 5578.31 363145.58 49172.20 964671.28 50727.01 913944.27
 Fighting for wage revision and fighting against Banking Reforms are inseparable tasks.
11th Bipartite Arrears Calculations using AIBEA's Chart
Name of the Employee PANKAJ Bank CENTRAL BANK
Employee Code No. 080255 Branch PARLIAMENT
Employee Designation :SWO B HRA 10.00
Clerks - Existing

ys
Month Special

Da
Basic Spl. Pay PQP/GP FPP Transport DA HRA Gross PF Net
Allowance
Apr-20 30 39400.00 820.00 1210.00 1585.00 3053.50 470.00 33762.98 4143.00 84444.48 4274.00 80170.48
May-20 31 39400.00 820.00 1210.00 1585.00 3053.50 470.00 33851.94 4143.00 84533.44 4274.00 80259.44
Jun-20 30 40710.00 820.00 1210.00 1585.00 3155.03 470.00 34926.11 4274.00 87150.14 4405.00 82745.14
Jul-20 31 40710.00 820.00 1210.00 1585.00 3155.03 470.00 34926.11 4274.00 87150.14 4405.00 82745.14
Aug-20 31 40710.00 820.00 1210.00 1585.00 3155.03 470.00 35568.64 4274.00 87792.67 4405.00 83387.67
Sep-20 30 40710.00 820.00 1210.00 1585.00 3155.03 470.00 35568.64 4274.00 87792.67 4405.00 83387.67
Oct-20 31 40710.00 820.00 1210.00 1585.00 3155.03 470.00 35568.64 4274.00 87792.67 4405.00 83387.67
Nov-20 29 39353.00 792.67 1169.67 1532.17 3049.86 454.33 36290.73 4131.53 86773.95 4258.17 82515.78
Dec-20 31 40710.00 820.00 1210.00 1585.00 3155.03 470.00 37542.13 4274.00 89766.16 4405.00 85361.16
Jan-21 31 40710.00 820.00 1210.00 1585.00 3155.03 470.00 37542.13 4274.00 89766.16 4405.00 85361.16
2020-21 403123.00 8172.67 12059.67 15797.17 31242.03 4684.33 355548.07 42335.53 872962.47 43641.17 829321.30
Total 1525111.15 31712.78 46795.68 61298.48 118196.11 18176.84 1126791.43 160361.96 3088444.44 165428.27 2923016.17
 Fighting for wage revision and fighting against Banking Reforms are inseparable tasks.
11th Bipartite Arrears Calculations using AIBEA's Chart
Name of the Employee PANKAJ Bank CENTRAL BANK
Employee Code No. 080255 Branch PARLIAMENT
Employee Designation :SWO B HRA 10.00
Clerks - Existing

ys
Month Special

Da
Basic Spl. Pay PQP/GP FPP Transport DA HRA Gross PF Net
Allowance
 Fighting for wage revision and fighting against Banking Reforms are inseparable tasks.
11th Bipartite Arrears Calculations using AIBEA's Chart
Name of the Employee : PANKAJ Bank CENTRAL BANK
Employee Code No. 080255 Branch PARLIAMENT
Employee Designation : SWO B HRA 10.25
Clerks - Revised Increase
ys

Month Special Gross

Da

Basic Spl. Pay PQP/GP FPP Transport DA HRA Gross PF Net Net Increase
Allow. Increase
Nov-17 30 57870.00 1250.00 1835.00 2262.00 9490.68 600.00 1889.82 6247.89 81445.38 6294.50 75150.88 10081.27 7929.77
Dec-17 31 57870.00 1250.00 1835.00 2262.00 9490.68 600.00 1889.82 6247.89 81445.38 6294.50 75150.88 10081.27 7929.77
Jan-18 31 57870.00 1250.00 1835.00 2262.00 9490.68 600.00 1889.82 6247.89 81445.38 6294.50 75150.88 10081.27 7929.77
Feb-18 28 57870.00 1250.00 1835.00 2262.00 9490.68 600.00 2436.87 6247.89 81992.43 6294.50 75697.93 10154.53 8003.03
Mar-18 31 57870.00 1250.00 1835.00 2262.00 9490.68 600.00 2436.87 6247.89 81992.43 6294.50 75697.93 10154.53 8003.03
2017-18 289350.00 6250.00 9175.00 11310.00 47453.40 3000.00 10543.18 31239.44 408321.02 31472.50 376848.52 50552.86 39795.36
Apr-18 30 57870.00 1250.00 1835.00 2262.00 9490.68 600.00 2436.87 6247.89 81992.43 6294.50 75697.93 10154.53 8003.03
May-18 29 54136.45 1169.35 1716.61 2116.06 8878.38 561.29 2372.70 5844.80 76795.65 5888.40 70907.24 9511.86 7499.16
Jun-18 30 59860.00 1250.00 1835.00 2262.00 9817.04 600.00 2619.02 6451.86 84694.93 6493.50 78201.43 10481.66 8262.16
Jul-18 31 59860.00 1250.00 1835.00 2262.00 9817.04 600.00 2619.02 6451.86 84694.93 6493.50 78201.43 10481.66 8262.16
Aug-18 31 59860.00 1250.00 1835.00 2262.00 9817.04 600.00 3235.27 6451.86 85311.17 6493.50 78817.67 10564.09 8344.59
Sep-18 30 59860.00 1250.00 1835.00 2262.00 9817.04 600.00 3235.27 6451.86 85311.17 6493.50 78817.67 10564.09 8344.59
Oct-18 31 59860.00 1250.00 1835.00 2262.00 9817.04 600.00 3235.27 6451.86 85311.17 6493.50 78817.67 10564.09 8344.59
Nov-18 30 59860.00 1250.00 1835.00 2262.00 9817.04 600.00 6624.59 6451.86 88700.49 6493.50 82206.99 11017.51 8798.01
Dec-18 30 57929.03 1209.68 1775.81 2189.03 9500.36 580.65 6410.90 6243.74 85839.19 6284.03 79555.16 10662.11 8514.20
Jan-19 29 55998.06 1169.35 1716.61 2116.06 9183.68 561.29 6197.20 6035.61 82977.88 6074.56 76903.32 10306.70 8230.40
Feb-19 28 59860.00 1250.00 1835.00 2262.00 9817.04 600.00 6830.01 6451.86 88905.91 6493.50 82412.41 11044.99 8825.49
Mar-19 31 59860.00 1250.00 1835.00 2262.00 9817.04 600.00 6830.01 6451.86 88905.91 6493.50 82412.41 11044.99 8825.49
2018-19 704813.55 14798.39 21724.03 26779.16 115589.42 7103.23 52646.11 75986.94 1019440.82 76489.50 942951.32 126398.28 100253.88
Apr-19 30 59860.00 1250.00 1835.00 2262.00 9817.04 600.00 6830.01 6451.86 88905.91 6493.50 82412.41 11044.99 8825.49
May-19 31 59860.00 1250.00 1835.00 2262.00 9817.04 600.00 8576.02 6451.86 90651.92 6493.50 84158.42 11278.57 9059.07
Jun-19 30 59860.00 1250.00 1835.00 2262.00 9817.04 600.00 8576.02 6451.86 90651.92 6493.50 84158.42 11278.57 9059.07
Jul-19 31 59860.00 1250.00 1835.00 2262.00 9817.04 600.00 8576.02 6451.86 90651.92 6493.50 84158.42 11278.57 9059.07
Aug-19 31 59860.00 1250.00 1835.00 2262.00 9817.04 600.00 10424.75 6451.86 92500.65 6493.50 86007.15 11525.88 9306.38
Sep-19 30 59860.00 1250.00 1835.00 2262.00 9817.04 600.00 10424.75 6451.86 92500.65 6493.50 86007.15 11525.88 9306.38
Oct-19 30 57929.03 1209.68 1775.81 2189.03 9500.36 580.65 10088.46 6243.74 89516.76 6284.03 83232.72 11154.08 9006.18
Nov-19 30 59860.00 1250.00 1835.00 2262.00 9817.04 600.00 12273.47 6451.86 94349.37 6493.50 87855.87 11773.20 9553.70
Dec-19 31 59860.00 1250.00 1835.00 2262.00 9817.04 600.00 12273.47 6451.86 94349.37 6493.50 87855.87 11773.20 9553.70
Jan-20 29 55998.06 1169.35 1716.61 2116.06 9183.68 561.29 11481.63 6035.61 88262.32 6074.56 82187.75 11013.64 8937.33
Feb-20 28 57795.86 1206.90 1771.72 2184.00 9478.52 579.31 13932.72 6229.38 93178.42 6269.59 86908.83 11645.82 9502.85
Mar-20 31 59860.00 1250.00 1835.00 2262.00 9817.04 600.00 14430.31 6451.86 96506.22 6493.50 90012.72 12061.74 9842.24
2019-20 710462.96 14835.93 21779.14 26847.10 116515.93 7121.25 127887.63 76575.50 1102025.43 77069.68 1024955.74 137354.15 111011.47
 Fighting for wage revision and fighting against Banking Reforms are inseparable tasks.
11th Bipartite Arrears Calculations using AIBEA's Chart
Name of the Employee : PANKAJ Bank CENTRAL BANK
Employee Code No. 080255 Branch PARLIAMENT
Employee Designation : SWO B HRA 10.25
Clerks - Revised Increase
ys

Month Special Gross

Da

Basic Spl. Pay PQP/GP FPP Transport DA HRA Gross PF Net Net Increase
Allow. Increase
Apr-20 30 59860.00 1250.00 1835.00 2262.00 9817.04 600.00 14430.31 6451.86 96506.22 6493.50 90012.72 12061.74 9842.24
May-20 31 59860.00 1250.00 1835.00 2262.00 9817.04 600.00 14533.02 6451.86 96608.92 6493.50 90115.42 12075.48 9855.98
Jun-20 30 61850.00 1250.00 1835.00 2262.00 10143.40 600.00 14991.89 6655.84 99588.13 6692.50 92895.63 12437.99 10150.49
Jul-20 31 61850.00 1250.00 1835.00 2262.00 10143.40 600.00 14991.89 6655.84 99588.13 6692.50 92895.63 12437.99 10150.49
Aug-20 31 61850.00 1250.00 1835.00 2262.00 10143.40 600.00 15733.54 6655.84 100329.78 6692.50 93637.28 12537.11 10249.61
Sep-20 30 61850.00 1250.00 1835.00 2262.00 10143.40 600.00 15733.54 6655.84 100329.78 6692.50 93637.28 12537.11 10249.61
Oct-20 31 61850.00 1250.00 1835.00 2262.00 10143.40 600.00 15733.54 6655.84 100329.78 6692.50 93637.28 12537.11 10249.61
Nov-20 29 59788.33 1208.33 1773.83 2186.60 9805.29 580.00 17411.08 6433.98 99187.44 6469.42 92718.02 12413.49 10202.24
Dec-20 31 61850.00 1250.00 1835.00 2262.00 10143.40 600.00 18011.46 6655.84 102607.70 6692.50 95915.20 12841.54 10554.04
Jan-21 31 61850.00 1250.00 1835.00 2262.00 10143.40 600.00 18011.46 6655.84 102607.70 6692.50 95915.20 12841.54 10554.04
2020-21 612458.33 12458.33 18288.83 22544.60 100443.17 5980.00 159581.73 65928.56 997683.56 66303.92 931379.64 124721.09 102058.34
Total 2317084.84 48342.65 70967.01 87480.86 380001.91 23204.47 350658.65 249730.44 3527470.83 251335.60 3276135.23 439026.38 353119.06