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
9 months ago

Recent Posts

Distinction between Capital Receipt and Revenue Receipts

There are two different types of receipts that a business or a government generates during…

4 hours ago

Govt. revises norms for Dividend payout, Bonus Shares, Stock split, and Share buybacks

The Department of Investment and Public Asset Management (DIPAM) released new guidelines amending its earlier2016…

6 hours ago

Bank Holidays 2025: National Capital Territory Delhi

The Government of the National Capital Territory of Delhi has released the official list of…

1 day ago

Bank Holidays 2025: State of Rajasthan

The Government of Rajasthan in their Order No.16 (1).v.m./2024 dated 19.11.2024 declared bank Holidays under…

1 day ago

Distinguishing Capital expenditure and Revenue expenditure

Meaning of Expenditure and Expenses: Expenditure refers to the total amount spent to acquire goods…

1 day ago

Bank Holidays 2025: Gujarat State

In pursuance of the explanation in section 25 of NI Act 1881, read with the…

2 days ago