The calculation sheet is provided by : allbankingsolutions.com
Download and calculate.
While using the sheet, the following points to be remembered.
|(1) This is a protected sheet so that one does not by mistake overwrite the formulas used in the sheet|
|(2) You are allowed to enter your name, scale and employee number etc.|
| (3) This is the most flexible Arrear Sheet, where you can enter your Old Basic, |
Old HRA %age, New HRA %, CCA etc.
as per the place of posting during that particular month.
|(4) You are allowed to change your old basic pay in Arrear-Sheet column "B".|
| (5) We have taken PPQ, FPP as zero as at present no details of adjustment of these |
is available. However, you can change your CA, HRA in percentage terms as applicable to you and your place
|of posting during that month|
| (6) In case you are getting HRA at some other centre, you should |
change the HRA percentage for old scales only
| (7) In case you are using official accommodation and not getting HRA, change the |
HRA percentage to zero
| (8) In case, some HRA deduction is made due to allotment of official accommodation, |
you are also allowed to enter the actual figures