Categories: Bank NewsBank Staff

Arrears Calculator for Sub Staff / Customer Service Assistants

Download the File!

Arrears Calculator For Sub-Staff / Customer Service Assistants

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, SPL. PAY, PQP, FPP, HRA to iamvarunnaik@gmail.com. I’ll fill out the form and send the PDF back to you.
Arrears Calculator Sub Staff

INSTRUCTIONS

BASIC SALARY

  • Click cell B10.
  • Select salary from the drop-down.
  • If your salary changed, update the correct month’s cell.

SPECIAL PAY

  • Click cell D10.
  • Select special pay from the drop-down.

PQP and FPP

  • Click cell E10 to update PQP (drop-down).
  • Click cell F10 to update FPP (drop-down).

Scroll down to compare salaries and see your arrears/take-home.

HOW-TO VIDEO

REFERENCE CHART FOR EXISTING AND REVISED SALARIES

Old BASIC New BASIC
14500 19500
15000 20165
15500 20830
16000 21495
16500 22160
17115 22990
17730 23820
18345 24650
18960 25480
19575 26310
20315 27300
21055 28290
21795 29280
22535 30270
23405 31440
24275 32610
25145 33780
26145 35125
27145 36470
28145 37815
29145 39160
30145 40505
31145 41850
32145 43195
33145 44540
34145 45885
35145 47230
36145 48575
37145 49920
ADD STAG 1- 51265
ADD STAG 2 – 52610
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…

3 days ago

Four types of economic systems explained

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

5 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…

5 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…

6 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…

7 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