Saturday, August 17, 2019

112-Tool-to-calculate-VRS-amount-for MTNL-BSNL-Employees

Important Notes:

1) Please click on the following links for a detailed video. Watch it till the end to get the working of the VRS tool and details of each calculation.
    a) For English ------ here
    b) For Hindi ---------here
    c) For Marathi-------here

2) In the new version of a software tool, leave encashment and the total amount of gratuity amount after the age of 60 years with interest is updated.

As per the VRS schemes for MTNL and BSNL, the following steps will help us to calculate our VRS amount.

Keep the following data ready.

1) Basic pay
2) IDA rate
3) Date of joining the department
4) Date of actual retirement
5) Date of VRS option
6) Total numbers of EL
7) Total numbers of HPL

Enter the above data in the yellow-colored portion of an excel sheet.

The following results will be available

1) Estimated VRS Amount
2) If, not opted for VRS, the total salary for the remaining period of service
3) Monthly Pension After VRS
4) So, the pension amount received after VRS till the remaining service
5) Total amount received along with monthly pension
6) Opt for VRS or not
7) Gratuity Amount
8) Gratuity Amount with 8 % interest after the age of 60 years.
9) Leave encashment.

In this model, an amount equivalent to 35 days of salary for each completed year of service, and 25 days of salary for each year of service left till retirement is considered.

In this VRS calculation for MTNL and BSNL employees, the pension amount for the remaining period of service is the most important factor taken into consideration, so that everyone will get an idea about the receivable total amount if opted for VRS along with the receivable amount if not opted.

Now see how to download the software link of the VRS calculator for MTNL and BSNL employees:

1) Step 1: Click here for the VRS calculator for MTNL and BSNL employees.
2) Step 2: The following window will be seen. Enter the date using the calendar by double-clicking on the DATE cells or simply Enter it in "MM/DD/YYYY" format


3) After opening the software, the following diagram will be seen

4) Step 4: Enter all the details marked in the yellow-colored portion:
5) Step 5: All calculated information will be available.

Please write your valuable comments/suggestions to improve this software tool.

Tag: MTNL, BSNL, VRS, VRS Scheme for MTNL and BSNL Staff, VRS Calculator for MTNL, BSNL Employees, VRS tool for MTNL, VRS tool for BSNL

33 comments:

  1. Excellent Satpute saheb धन्यवाद

    ReplyDelete
  2. good but people are not able to input the date of joining here. please show the format to be entered... thanks

    ReplyDelete
    Replies
    1. Sir ji, now, you can try. Modification done and fault is rectified.

      Delete
    2. sir we are not able to edit the date of joining

      Delete
  3. Sir,
    What about prorata pension optee? The pension value is not as per prorata optees pension calculation.

    ReplyDelete
    Replies
    1. Tool for that also in progress. Very soon, it will be updated.

      Delete
  4. And advice on whether vrs advisable or not is also not clear.

    ReplyDelete
    Replies
    1. If amount through salary for the remaining period is more then no need to opt for VRS.

      Delete
    2. If an amount for the remaining period through salary is more than the VRS amount, then no need to opt for VRS.

      Delete
  5. Input unable to put. The system is not taking inputs

    ReplyDelete
    Replies
    1. Try it now. Its from google doc and so many peoples are trying it, so there may be some delay. But it's working fine.

      Delete
  6. cannot put any input such as dates and basic

    ReplyDelete
    Replies
    1. Enter date in mm/dd/yyyy format or double click on date cells

      Delete
  7. please remove the protection for the file and resend the link here in the comment box.

    ReplyDelete
    Replies
    1. It's working fine. Right now also so many users are waiting for their turn.

      Delete
  8. input could not be given and cells are protected and to be removed

    ReplyDelete
    Replies
    1. It's working fine. Right now also so many users are waiting for their turn.

      Delete
  9. Sir, what is the difference between Maximum amount remaining period and total salary for remaining period if not opted for VRS

    ReplyDelete
    Replies
    1. If you are not opting for vrs then you will get full salary. It also with yearly increamented. Actually your salary amount will be more than this amount which is calculated only on this yesrsy basic. Thanks for using this software and spread the word about the same.

      Delete
  10. sir office PC have open office program the file is not opening. cant put the dates and basic. kindly help. I am a prorata pensioner.

    ReplyDelete
    Replies
    1. Sir ji, thanks for using this software. Actually calculations for prorata pension is not available with me. If you provide it to me then I can prepare the software for it. Secondly when you go through this blog, in step no 1, you will find the link to go to the soft ware tool. Everyone is getting it. Till now more than 7000 visitors viewed and used this tool.

      Delete
  11. whether 125 percent of monthly salary of remaining month as declared by minister is taken in calculation or not

    ReplyDelete
  12. I think that the calculation of pension amount after vrs is not giving correct output. So please review the same and update.

    ReplyDelete
  13. Cannot enter to Your estimated VRS amount after filling yellow coloumns

    ReplyDelete
  14. I already submitted it no calculation received

    ReplyDelete