STEP 1 : DOWNLOAD THE EXCEL SHEET
Download Arrear calculator for sub-staff by clicking on the blue button with a calculator icon below.
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 from mine, if we both are using different versions of the excel software, but it’s not gonna be an issue! The calculator will work perfectly well on your application too.
STEP 2 : ENABLE EDITING
This is an optional step and you may or may not see a yellow ribbon like the one I have attached in the screenshot below depending on your software settings. But If you do see this ribbon, then it’s important that you press the enable editing button. No cells in the excel sheet can be edited and you cannot enter your salary details until you enable the edit option for your software.
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. a small button with a down arrow icon starts to appear next to the cell. You need to click this button and you will see a drop-down of all BASIC salaries options for sub-staff listed 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 list.
In event of retirement or if you have joined midway, fill the months where you were not in active service with 0.
STEP 4 : SPECIAL PAY
If you’re not eligible for special pay, select 0. However, If you’re one of the following: Armed Guard, Bill Collector, Daftary, Head Peon, Electrician, Driver, Head Messenger (IOB) 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.
I have also attached a special pay chart below for your reference.
STEP 5 : 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 E10 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 there is no direct correlation between FPP values of 10th and 11th 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 E51, 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 I10 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@example.com and I will get back to you as soon as I can.