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

What is Weighted Marginal Cost of Capital?

The marginal cost of capital (MCC) is the total combined cost of debt, equity, and…

27 minutes ago

Meaning of WACC and factors affecting the WACC

The weighted average cost of capital (WACC) is the average rate that a business pays…

17 hours ago

Regulations on Interest Rate Resets on EMI based personal loans explained

The Reserve Bank of India (RBI) defines a personal loan as a type of unsecured…

18 hours ago

Determining the Proportion:  Preference V/s Equity Shares

A share is a unit of ownership in a company and has an exchangeable value…

1 day ago

Overview: Cost of Debt, Taxation, & Capital Structure

The cost of debt is the interest rate a company pays on its debt, and…

2 days ago

Various Theories/Approaches on Capital Structuring Explained

This article explains the assumptions and key aspects of approaches to capital structuring, including the…

3 days ago