DOWNLOAD EXCEL FILE FOR 12TH BPS SALARY ARREARS CALCULATOR AMONG OFFICERS, CLERK AND SUB STAFF

In this article we will provide the information related to the 12TH BPS SALARY ARREARS CALCULATOR OFFICERS/CLERICALS/SUB STAFF and download excel file.

The wage revision under the 12th Bipartite Settlement (BPS) will come into effect starting from November 1, 2022, and will span a duration of five years. An annual increase in salary and allowances has been mutually agreed upon at 17%, based on the annual pay slip expenses for the financial year 2021-22.

This adjustment translates to Rs. 12,449 crores for all public sector banks, including the State Bank of India (SBI).

We have provided a salary and arrears calculator below for your convenience. Utilize this calculator to download and assess your salary and arrears.

With the assistance of this tool, you can determine the new basic pay, revised gross and net salary, as well as arrears for officers, clerks, and sub-staff employed in public sector banks.

YOU CAN DOWNLOAD 12TH BPS SALARY ARREARS CALCULATOR FROM BELOW LINKS

DOWNLOAD OFFICERS SALARY ARREARS CALCULATOR (LATEST ONE)

 

DOWNLOAD OFFICERS SALARY ARREARS CALCULATOR


DOWNLOAD CLERK SALARY ARREARS CALCULATOR

 

DOWNLOAD SUB STAFF SALARY ARREARS CALCULATOR

 

You can also check our Home Loan EMI calculator Excel (With prepayment option and normal repayment In this below link

 

HOME LOAN EMI CALCULATOR EXCEL (FREE DOWNLOAD)

 

After downloading 12TH BPS SALARY ARREARS CALCULATOR read below information for calculation

ARREARS CALCULATOR FOR OFFICERS

Follow these simple steps to utilize the Arrears CALCULATOR for Officers.

Download the Excel file using the blue button and proceed with the instructions outlined below.

Whether you are using a spreadsheet application or adjusting to your display size, rest assured that the tool functions seamlessly.

ENTER BASIC SALARY FROM DROP DOWN LIST

  1. Click on cell B10 to access the drop-down list for selecting your salary.
  2. Your chosen salary will automatically update for the entire designated period.

ENTER PQP AND FPP

This step is optional and can be skipped if it doesn’t apply to you.

  1. Click on cell D10 to update PQP (Qualifying Service) from the drop-down list.
  2. Click on cell E10 to update FPP (Fixed Personal Pay) from the available options.

ENTER CCA CENTRES

  1. Click on cell I10 to specify whether you work in a non-CCA, lower, or higher area.
  2. The CCA value will automatically update in column J.

ENTER HRA %

  1. Click on cell K10 to select the applicable HRA (House Rent Allowance) percentage from the drop-down list.
  2. HRA will be calculated automatically.

12TH BPS SALARY ARREARS CALCULATOR OFFICERS 

Upon correctly completing the above steps, all tables will be updated. Scroll down the page to compare your old and new salary, discover potential arrears, and determine your revised take-home pay.


Utilize this Arrears CALCULATOR for Officers to gain insights into your salary adjustments effortlessly.

Download the Excel file and navigate through the instructions to access valuable information about your arrears and financial outlook.

 ENTER CLERK BASIC SALARY

 

  1. Select Salary: Click on cell B10 and choose your salary from the provided dropdown list. The salary will automatically update for the entire designated period.

 

  1. Salary Changes: If your salary changed or you retired during the period, click on the corresponding month’s cell to update your salary. Subsequent cells will adjust accordingly.

 

 

 

 ENTER CLERK SPECIAL PAY

 

  1. Choose Special Pay: Click on cell D10. Select the applicable special pay from the dropdown list.

 

 

 

 ENTER CLERK PQP AND FPP

 

This step is optional and can be skipped if it doesn’t apply to you.

Update PQP:

Click on cell E10 to update PQP (Qualifying Service) from the dropdown list.

Update FPP:

Click on cell F10 to update FPP (Fixed Personal Pay) from the provided options.

 

TA, DA, and HRA will all be calculated automatically.

12TH BPS SALARY ARREARS CALCULATOR CLERKS IS CALCULATED

 

Upon correctly completing the above steps, all tables will be updated. Scroll down the page to compare your old and new salary, discover potential arrears, and determine your revised take home pay.

 

12TH BPS SALARY ARREARS CALCULATOR FOR SUB STAFF

12TH BPS SALARY ARREARS CALCULATOR SUB STAFF IS CALCULATED

 

ALSO READ

12TH BIPARTITE SETTLEMENT HIKE 17%

 

Leave a Comment