ARREARS CALCULATOR- CLERICAL STAFF by bankingschool.

Instructions
To make calculations simple and easy, this excel sheet is divided into two tables. (i) OLD SALARY (ii) NEW SALARY. All blue coloured cells in
'OLD SALARY' table can be manually updated to accomodate any changes due to increments. If you are eligible for FPP, you need to updat
cell on both OLD SALARY and NEW SALARY table. Rest all fields will be updated automatically.

For Step-by-Step instructions with screenshots visit

https://bankingschool.co.in/bank-news/arrears-calculator-for-clerical-customer-service-associates/
Please update the blue fields (BASIC,PQP, FPP, SPL. PAY, HRA%) on the first row [ Nov-22 ]. If you are not eligible for PQP or FPP, then plea
OLD / EXISTING SALARY
Month BASIC SPL ALL. SPL.PAY PQP FPP TA DA % DA HRA %
Nov-22 0 0 0 0 0 0 38.92% 0 10.25%
Dec-22 0 0 0 0 0 0 38.92% 0 10.25%
Jan-23 0 0 0 0 0 0 38.92% 0 10.25%
Feb-23 0 0 0 0 0 0 41.16% 0 10.25%
Mar-23 0 0 0 0 0 0 41.16% 0 10.25%
Apr-23 0 0 0 0 0 0 41.16% 0 10.25%
May-23 0 0 0 0 0 0 41.72% 0 10.25%
Jun-23 0 0 0 0 0 0 41.72% 0 10.25%
Jul-23 0 0 0 0 0 0 41.72% 0 10.25%
Aug-23 0 0 0 0 0 0 44.24% 0 10.25%
Sep-23 0 0 0 0 0 0 44.24% 0 10.25%
Oct-23 0 0 0 0 0 0 44.24% 0 10.25%
Nov-23 0 0 0 0 0 0 48.51% 0 10.25%
Dec-23 0 0 0 0 0 0 48.51% 0 10.25%
Jan-24 0 0 0 0 0 0 48.51% 0 10.25%
Feb-24 0 0 0 0 0 0 48.51% 0 10.25%
Mar-24 0 0 0 0 0 0 48.51% 0 10.25%

NEW / REVISED SALARY

Month BASIC SPL ALL. SPL.PAY PQP FPP TA DA % DA HRA %
Nov-22 0 0 0 0 0 0 7.43% 0 10.25%
Dec-22 0 0 0 0 0 0 7.43% 0 10.25%
Jan-23 0 0 0 0 0 0 7.43% 0 10.25%
Feb-23 0 0 0 0 0 0 9.40% 0 10.25%
Mar-23 0 0 0 0 0 0 9.40% 0 10.25%
Apr-23 0 0 0 0 0 0 9.40% 0 10.25%
May-23 0 0 0 0 0 0 9.90% 0 10.25%
Jun-23 0 0 0 0 0 0 9.90% 0 10.25%
Jul-23 0 0 0 0 0 0 9.90% 0 10.25%
Aug-23 0 0 0 0 0 0 12.07% 0 10.25%
Sep-23 0 0 0 0 0 0 12.07% 0 10.25%
Oct-23 0 0 0 0 0 0 12.07% 0 10.25%
Nov-23 0 0 0 0 0 0 15.77% 0 10.25%
Dec-23 0 0 0 0 0 0 15.77% 0 10.25%
 Jan-24 0 0 0 0 0 0 15.77% 0 10.25%
Feb-24 0 0 0 0 0 0 15.73% 0 10.25%
Mar-24 0 0 0 0 0 0 15.73% 0 10.25%

ARREARS 0
Some amount will be deducted from the above.To calculate actual take home, fill the form below
1. DIFFERENCE OF PF/NPS 0 A-B
Gross New Salary 0
PF/NPS Deductable on New Salary 0 (A)
Gross Old Salary 0
PF/NPS already paid on Old Salary 0 (B)
3. TAX DEDUCTED AT SOURCE (TDS) Please type your TDS here
4. OTHERS Use it to compute any other deduction known to you

ACTUAL TAKE HOME 0

 by bankingschool.co.in

. All blue coloured cells inside the

or FPP, you need to update the blue

for PQP or FPP, then please select 0.

REFERENCE
HRA GROSS Special Pay (old salary)
0 0 SWO / Customer Service Associate 1250
0 0 Head Cashier / Senior Customer Service Associate 1940
0 0 Special Assistant / Special Customer Service Associate 2920
0 0 *new special pay will be calculated automatically
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0

HRA GROSS
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0
This sheet is created for formulas and reference purposes only. You are not required to make any changes in this sheet.
Old BASIC New BASIC
0 0
17900 24050
18900 25390
19900 26730
20900 28070
22130 29720
23360 31370
24590 33020
26080 35020
27570 37020
29060 39020
30550 41020
32280 43360 1
34010 45700 2
35740 48040 3
37470 50380 4
39200 52720 5
40930 55060 6
42660 57400 7
45930 61800
47920 64480
49910 67160
51900 69840
53890 72520
55880 75200
57870 77880
59860 80560
61850 83240
63840 85920
65830 88600
91280
93960
hanges in this sheet.
PQP SPL PAY FPP
Old PQP New PQP 0 0 Old FPP New FPP
0 0 1250 1680 0 0
625 820 1940 2605 1990 3155
1215 1640 2920 3925 2220 3155
1835 2460 2500 3155
2455 3280 2730 3155
3045 4100 2970 3155
3220 3155
0 0