Simple Superannuation Pension (After ROPA, 2019)
Finance, Excel Utility , Pension 👁️ 161
Please note that this excel utility is based on up to date DCRB Rules and in view of Rules laid down in W.B.S. (ROPA), 2019 and it can calculate the pension before two years of retirement.This utility will calculate the period of service, date of retirement, date of starting pension & family pension, date and amount of next increment, amount of pension & family pension, gratuity, C.V.P., and all related calculations for superannuation case only.
This will also prepare Single Comprehensive Form + all other pension papers including forwarding letter.
Just fill the green cell properly and leave the red cells. The red cells are automatic. Fill the loan forms manually as the same is not auto generated.
Please note that this excel utility is based on up to date DCRB Rules and in view of Rules laid down in W.B.S. (ROPA), 2019 and it can calculate the pension before two years of retirement.
Prepared by: Sri Somnath Das, Judicial Department, Katwa, Burdwan.