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

Recent Posts

Features of a Computerized Accounting System

Accounting is a multifaceted discipline. It caters to the diverse informational needs of stakeholders within…

8 hours ago

What is the meaning of computerized accounting?

As the name says ‘computerised accounting’ is the use of computers, software, and hardware to…

1 day ago

Supreme Court overrules capping of Credit card charges

The Supreme Court today overruled a 2008 decision by the National Consumer Disputes Redressal Commission…

2 days ago

Preparation and Presentation of Financial Statements of Banks

The Bank’s financial statements are prepared under the historical cost convention, on the accrual basis…

3 days ago

Accounting Treatment of Specific Items under accounting policies of banks

The term "accounting treatment" represents the prescribed manner or method in which an accountant records…

3 days ago

Explained: Disclosures Prescribed by RBI under Basel-III

The Basel Committee on Banking Supervision (BCBS) is the primary global standard setter for the…

4 days ago