Please read all the instructions before you start working on the excel sheet.
STEP 1 : DOWNLOAD THE EXCEL SHEET
Download Arrear calculator for clerical by clicking on the blue button with a calculator icon below.
Update: 28th Nov 2020, 10:30 AM.
Based on the inputs by some of the members, I have updated the calculator application to make some more provisions and will help those who are eligible for FPP or have joined/retired between Nov 2017 and Nov 2020.
If you are unable to download the calculator, please email me at [email protected]. I will email the excel sheet to you.
Once downloaded, open the excel sheet and you should be able to see a screen similar to the screenshot attached below. The look of this screen might slightly vary if you’re using a different version of Microsoft excel software than mine, but don’t worry! Your calculator will work perfectly well on your application too.
STEP 2 : ENABLE EDITING
This is an optional step depending on your software settings. If you can see a yellow ribbon on the header area of your excel sheet, its important that you press the enable editing button and the ribbon will disappear. You are required to input your salary details into your excel sheet. As long as you can see that ribbon, you won’t be able to make any changes to the excel sheet.
STEP 3 : BASIC SALARY
To get started, we need to fill out the details corresponding to Nov ’17 row (row #10).
To enter BASIC salary, single-click/tap on the B10 cell next to Nov-17. You will notice a small button with a down arrow starts to appear next to the cell. Click the down arrow button and you will get a drop-down list of all BASIC salaries for clerical as per 10th BPS. Select the one that you used to earn back in Nov-17.
Incase of promotion or increment, you can update your BASIC by single-clicking/tapping on the cell next to the correct month / year and selecting the higher BASIC from the drop down.
In event of retirement or if you have joined midway, fill the months where you were not in active service with 0.
On entering your BASIC, special allowance cell will be calculated automatically.
STEP 4 : SPECIAL PAY
If you’re not eligible for special pay, select 0. If you’re an SWO, Head Cashier, or a Special Assistant then you’re eligible for special pay. To enter the details for the month of Nov-17, single-click/tap on the D10 cell and select the pay from the drop-down which is applicable to you.
If you aren’t sure, you can use this pay chart for reference.
STEP 5 : PQP
If you’re not eligible for PQP, please select 0. If you’re eligible for PQP, single-click / tap on E10 cell, click on the down arrow button next to the cell and pick the correct PQP amount from the drop-down list.
STEP 6 : FPP
If you’re not eligible for FFP, please select 0. If you’re eligible for FPP, you need to update two fields.
1. OLD SALARY table: single-click/tap on the F10 cell, click on the down arrow button next to the cell, and pick the correct FPP amount from the drop-down list.
2. NEW SALARY table: Since FPP change in 11th BPS follows a different structure than the FPP as per 10th BPS, you need to manually change the FPP value in the new salary table as well. To do that, scroll down past the old table and reach row #51, single-click/tap on F51, click on the down arrow button next to cell and select the new FPP applicable to you from the drop-down list.
FINAL STEP: HRA
If you’re not eligible for HRA, select 0. If you’re eligible , then please single-click/tap on the J10 cell, click the down arrow button next to the cell and select the appropriate HRA percentage applicable to you.
Well! That's It! Your arrears calculation is ready!
If everything went as expected, you should now have a completely computed NEW SALARY table. Scroll past the NEW SALARY table to row #90 and there it is! in big and bold! Congratulations!
If you’re not seeing what you should be seeing at this point or running into a technical issue, leave me a message at [email protected] and I will get back to you as soon as I can.
