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

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…

1 hour ago

Bank Holidays 2025: National Capital Territory Delhi

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

22 hours 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…

23 hours 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

Deepfake videos of RBI Governor: RBI warns public to be careful

 The Reserve Bank of India on Tuesday placed on its website that the deepfake videos…

3 days ago