Categories: Bank NewsBank Staff

Arrears Calculator for Clerical / Customer Service Associates

Download the File!

Arrears Calculator for Clerical / Customer Service Associates

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.

INSTRUCTIONS

BASIC SALARY

  1. Locate cell B10.
  2. Select your current salary from the drop-down list. This will update your salary for the entire period.
  3. If your salary changed or you retired:
    • Click the cell for the month where the change occurred.
    • Update your salary. The following months will automatically reflect the change.

SPECIAL PAY

  • Find Cell D10.
  • Select your special pay from the drop-down list.

PQP and FPP

  • Skip this step if it doesn’t apply to you.
  • Update PQP in cell E10 using the drop-down list.
  • Update FPP in cell F10 using the drop-down list.

TA, DA, and HRA

Will update automatically through formulas.

That’s it! Your arrears will be calculated.

Scroll down to:

  • Compare your old and new salary
  • See your potential arrears and take-home pay

HOW TO VIDEO

REFERENCE CHART FOR EXISTING AND REVISED SALARIES

Old BASIC New BASIC
17900 24050
18900 25390
19900 26730
20900 28070
22130 29720
23360 31370
24590 33020
26080 35020
27570 37020
29060 39020
30550 41020
32280 43360
34010 45700
35740 48040
37470 50380
39200 52720
40930 55060
42660 57400
45930 61800
47920 64480
49910 67160
51900 69840
53890 72520
55880 75200
57870 77880
59860 80560
61850 83240
63840 85920
65830 88600
ADD STAG 1 – 91280
ADD STAG 2 – 93960
admin

Share
Published by
admin

Recent Posts

Features of a Computerized Accounting System

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

10 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