All Rights ReservedView Non-AMP Version

Arrears Calculator for Bank Officers

Download the File!

Arrears Calculator for Officers

1. Download the Excel file by clicking the blue button.

2. Open the file from your Downloads folder. It should look similar to the screen in the video. The layout may vary slightly depending on your spreadsheet software and screen size, but the basic functionality will be the same.

3. If the file opens in read-only mode, look for an ‘Enable Editing’ option and select it before making changes

If you don’t have MS Excel or need help with the file, please email your salary details (basic salary, PQP, FPP, HRA, CCA center) to iamvarunnaik@gmail.com. I’ll fill out the form and send the PDF back to you.

Updated in v3.0:

Provision to add CAIIB increments in the new/revised salary section.
Provision for Officiating Allowance included.
The formula for PF/NPS Deductions has been corrected.

Arrears Calculator Officer v3.0

INSTRUCTIONS

DESIGN

You do not require a password to use this Excel calculator. Not all of the cells in the sheet are protected. Here’s how it’s designed:

Blue cells: These cells are editable. You can input your own data and values here.
White cells: These cells contain formulas that are essential for the sheet’s calculations. They are locked to prevent accidental changes made to formula cells that could disrupt the results. The document is protected only to ensure that the calculator functions correctly and reliably, especially when shared among multiple users.

BASIC SALARY

Click cell B10 and choose your salary from the drop-down list.
If your salary changed or you retired during this period, click the cell for the correct month and update the salary.

PQP and FPP (if applicable):

Click cell E10 to update PQP from the drop-down list.
if you are eligible for the new PQP amount of Rs.5480, change the value in cell range E32 to E48.
Click cell F10 to update FPP from the drop-down list.

CCA Centres:

Click cell K10 and select your CCA area (non-CCA, lower, or higher).

OFFICIATING ALLOWANCE

If you are eligible for the officiating allowance, manually enter the amount in any cell within these ranges:

- Old/existing salary table: H10 to H26
- New salary table: H32 to H48

HRA %:

Click cell M10 and choose the applicable HRA % from the drop-down list.

CAIIB INCREMENTS

To add CAIIB increments, find the section labeled “INCREMENTS” in your Excel tool.
Click on any cell from C32 to C48. Choose the correct CAIIB increment applicable to you from the drop-down list..

That’s it! Your arrears are now calculated. Scroll down to compare your old and new salary, and see your potential arrears and take-home pay.

Depending on your screen size, you might need to scroll right to see columns like Gross Salary, PF/NPS deductions, and Net Salary.

HOW-TO VIDEO

Dear Bankers,

We’ve been overwhelmed with positive feedback for our arrears calculator. If you found it helpful, we could really use your assistance in spreading the word to your colleagues.

Unfortunately, Facebook limitations prevent us from sharing the URL in too many groups at once. Additionally, visibility of posts on feeds have reduced drastically, hence reaching everyone organically through Facebook posts can be challenging due to their algorithm changes.

Sharing the arrears calculator URL within your trusted networks on WhatsApp, Telegram groups, or even through direct messages would be an enormous help.

Thanks & Regards!
Varun Naik

REFERENCE CHART FOR EXISTING AND REVISED SALARIES

EXISTING	REVISED
SCALE 1 – 36000	SCALE 1 – 48480
SCALE 1 – 37490	SCALE 1 – 50480
SCALE 1 – 38980	SCALE 1 – 52480
SCALE 1 – 40470	SCALE 1 – 54480
SCALE 1 – 41960	SCALE 1 – 56480
SCALE 1 – 43450	SCALE 1 – 58480
SCALE 1 – 44940	SCALE 1 – 60480
SCALE 1 – 46430	SCALE 1 – 62480
SCALE 1 – 48170	SCALE 1 – 64820
SCALE 1 – 49910	SCALE 1 – 67160
SCALE 1 – 51900	SCALE 1 – 69840
SCALE 1 – 53890	SCALE 1 – 72520
SCALE 1 – 55880	SCALE 1 – 75200
SCALE 1 – 57870	SCALE 1 – 77880
SCALE 1 – 59860	SCALE 1 – 80560
SCALE 1 – 61850	SCALE 1 – 83240
SCALE 1 – 63840	SCALE 1 – 85920
SCALE 1 – 65830	SCALE 1 – 88600
SCALE 1 – 67820	SCALE 1 – 91280
SCALE 1 – 69810	SCALE 1 – 93960
SCALE 1 – STAG 1 – 71800	SCALE 1 – STAG 1 – 96640
SCALE 1 – STAG 2 – 73790	SCALE 1 – STAG 2 – 99320
SCALE 1 – STAG 3 – 76010	SCALE 1 – STAG 3 – 102300
SCALE 1 – STAG 4 – 78230	SCALE 1 – STAG 4 – 105280
SCALE 1 – STAG 5 – 80450	SCALE 1 – STAG 5 – 108260
—	SCALE 1 – ADD STAG 6 – 111240
—	SCALE 1 – ADD STAG 7 – 114220
SCALE 2 – 48170	SCALE 2 – 64820
SCALE 2 – 49910	SCALE 2 – 67160
SCALE 2 – 51900	SCALE 2 – 69840
SCALE 2 – 53890	SCALE 2 – 72520
SCALE 2 – 55880	SCALE 2 – 75200
SCALE 2 – 57870	SCALE 2 – 77880
SCALE 2 – 59860	SCALE 2 – 80560
SCALE 2 – 61850	SCALE 2 – 83240
SCALE 2 – 63840	SCALE 2 – 85920
SCALE 2 – 65830	SCALE 2 – 88600
SCALE 2 – 67820	SCALE 2 – 91280
SCALE 2 – 69810	SCALE 2 – 93960
SCALE 2 – 71800	SCALE 2 – 96640
SCALE 2 – 73790	SCALE 2 – 99320
SCALE 2 – 76010	SCALE 2 – 102300
SCALE 2 – 78230	SCALE 2 – 105280
SCALE 2 – STAG 1 – 80450	SCALE 2 – STAG 1 – 108260
SCALE 2 – STAG 2 – 82670	SCALE 2 – STAG 2 – 111240
SCALE 2 – STAG 3 – 84890	SCALE 2 – STAG 3 – 114220
SCALE 2 – STAG 4 – 87110	SCALE 2 – STAG 4 – 117200
SCALE 2 – STAG 5 – 89330	SCALE 2 – STAG 5 – 120180
—	SCALE 2 – ADD STAG 6- 123540
—	SCALE 2 – ADD STAG 7- 126900
SCALE 3 – 63840	SCALE 3 – 85920
SCALE 3 – 65830	SCALE 3 – 88600
SCALE 3 – 67820	SCALE 3 – 91280
SCALE 3 – 69810	SCALE 3 – 93960
SCALE 3 – 71800	SCALE 3 – 96640
SCALE 3 – 73790	SCALE 3 – 99320
SCALE 3 – 76010	SCALE 3 – 102300
SCALE 3 – 78230	SCALE 3 – 105280
SCALE 3 – STAG 1 – 80450	SCALE 3 – STAG 1 – 108260
SCALE 3 – STAG 2 – 82670	SCALE 3 – STAG 2 – 111240
SCALE 3 – STAG 3 – 84890	SCALE 3 – STAG 3 – 114220
SCALE 3 – STAG 4 – 87110	SCALE 3 – STAG 4 – 117200
SCALE 3 – STAG 5 – 89330	SCALE 3 – STAG 5 – 120560
SCALE 3 – STAG 6 – 92110	SCALE 3 – STAG 6 – 123920
—	SCALE 3 – ADD STAG 7- 127600
—	SCALE 3 – ADD STAG 8- 131280
SCALE 4 – 76010	SCALE 4 – 102300
SCALE 4 – 78230	SCALE 4 – 105280
SCALE 4 – 80450	SCALE 4 – 108260
SCALE 4 – 82670	SCALE 4 – 111240
SCALE 4 – 84890	SCALE 4 – 114220
SCALE 4 – 87390	SCALE 4 – 117580
SCALE 4 – 89890	SCALE 4 – 120940
SCALE 4 – STAG 1 – 92390	SCALE 4 – STAG 1 – 124300
SCALE 4 – STAG 2 – 95120	SCALE 4 – STAG 2 – 127980
—	SCALE 4 – ADD STAG 3- 131980
—	SCALE 4 – ADD STAG 4- 135980
—	SCALE 4 – ADD STAG 5- 139980
SCALE 5 – 89890	SCALE 5 – 120940
SCALE 5 – 92390	SCALE 5 – 124300
SCALE 5 – 94890	SCALE 5 – 127660
SCALE 5 – 97620	SCALE 5 – 131340
SCALE 5 -100350	SCALE 5 -135020
SCALE 5 – STAG 1 – 103320	SCALE 5 – STAG 1 – 139020
—	SCALE 5 – ADD STAG 2 – 143020
—	SCALE 5 – ADD STAG 3 – 147360
—	SCALE 5 – ADD STAG 4 – 151700
SCALE 6 – 104240	SCALE 6 – 140500
SCALE 6 – 107210	SCALE 6 – 144500
SCALE 6 – 110180	SCALE 6 – 148500
SCALE 6 – 113150	SCALE 6 – 152500
SCALE 6 – 116120	SCALE 6 – 156500
—	SCALE 6 – ADD STAG 1 – 160840
—	SCALE 6 – ADD STAG 2 – 165180
—	SCALE 6 – ADD STAG 3 – 169520
SCALE 7 – 116120	SCALE 7 – 156500
SCALE 7 – 119340	SCALE 7 – 160840
SCALE 7 – 122560	SCALE 7 – 165180
SCALE 7 – 125780	SCALE 7 – 169520
SCALE 7 – 129000	SCALE 7 – 173860
—	SCALE 7 – ADD STAG 1- 178560
—	SCALE 7 – ADD STAG 2- 183260
—	SCALE 7 – ADD STAG 3 – 187960

FPP

Old FPP	New FPP
1990	2680
2220	2980
2500	3360
2730	3680
2970	4000
3220	4340

CCA

Non CCA Centre	700	1200
Lower Centres	1150	1900
Higher Area	1400	2300

LEARNING ALLOWANCE

600

850

HRA

7%	8%
8%	9%
9%	10%
10.5%	12.0%
12%	13.5%
14%	15%

PQP

Old PQP	New PQP
1020	1370
2550	3425
—	5480

admin

Next Arrears Calculator for Clerical / Customer Service Associates »

Previous « Arrears Calculator for Bank Officers and Award Staff

Published by

admin

11 months ago

Bank Holidays 2025: GOA
“Under the explanation to Section 25 of the Negotiable Instruments Act, 1881 (Central Act 26…
Bank Holidays 2025: State of Kerala
“Under the explanation to Section 25 of the Negotiable Instruments Act, 1881 (Central Act 26…
Bank Officers DA Chart: Dearness Allowance Payable for November ’24 to January ‘25
Labour Bureau announces CPI (IW) index numbers for July, August, and September 2024. July 2024=142.70…