Categories: Bank NewsBank Staff

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

Share
Published by
admin
2 months ago

Recent Posts

UPI ATM: Check how to withdraw cash from ATM without debit card

Bank customers can now withdraw cash from ATMs without using physical cards. Even if you…

2 days ago

Four types of economic systems explained

Economic systems can be classified as Traditional Economies, command economies, market economies, and mixed economies.…

4 days ago

How to interpret and infer a financial statement?

The analysis of financial statements means identifying a business establishment's financial strengths and weaknesses by…

4 days ago

Framework for project financing and provisioning in infrastructure and real estate sectors

The Reserve Bank of India issued draft guidelines to provide a harmonised prudential framework for…

5 days ago

RBI relaxes norms for margin for derivative contracts and maintenance of Non-resident deposits and accounts

RBI has recently issued two notifications. The first notification is about Margin for Derivative Contracts…

6 days ago

Explained: Fundamentals of microeconomics and macroeconomics

Economists may define the subject of economics in several ways considering different aspects of the…

1 week ago