126-Calculator of a commutation of a pension

Dear friends,

Now you can download FORM-1 from this site also. Go to the bottom, click on the top-right symbol which shows as a "pop-out " and download the form.

Click here to watch a video on this topic. 

This post calculates the commutation of a pension and the pension amount after commutation. So many employees have taken VRS even at the age of 50 years. So, this software will help them to set a reminder for submission of Form-1 in their admin office. The following essential particulars regarding the commutation of a pension will be available in this software.

Enter only the following information:

The output will be as follows:

125-How to open your NPS Account Online

Dear friends,
Due to COVID-19, it is always safe to stay at home. So this blog will help you to open your NPS account (National Pension System) online. 

It will really help you a lot.

NPS Tier 1 Tax Benefits

You get a tax deduction under Section 80CCD(1) and 80CCD(2) on contributions to the NPS up to Rs 1.5 lakh per annum.

• In addition, you can get a tax deduction on contributions up to Rs 50,000 under Section 80CCD(1B). Hence the total tax benefit on contributions to the NPS is Rs 2 lakh per annum.
• In addition, the returns on NPS are tax-exempt while the money is retained in the NPS account.
• On maturity, up to 60% of the accumulated NPS corpus can be withdrawn free of tax. Another 40% must be used to buy an annuity (regular pension).

When I was trying to open an online NPS account, I faced some problems and the same is being shared here.

So we will see the procedure step by step:

124-Interest and amount calculator of Senior Citizen Saving Scheme

Dear friends,

We started getting various amounts from our organization. Here is your personal calculation sheet for SCSS (Senior Citizen Saving Scheme) where you will get the details of the receivable amount at the time of maturity. It is developed in excel for you  This file you can download on your mobile, laptop, or desktop.

Step 1:

If you are using mobile for this software use, then install EXCEL from the App station. Different methods are there for mobile as well as laptop. We will see both.

Click here to download the calculator of the SCSS account.

It is in "View only" format, so download it on your laptop or mobile. First of all, Enter your name,  then start using it.

Here you must open RD (Recurring Deposit) account in any nationalized bank or post office for 5 years at the same time when you opened your SCSS account.

How to use this software tool:

1) Enter your name.

2) Enter the amount which you want to deposit in the SCSS account either in the bank or post-office.

3) Enter the rate of interest of the SCSS account.
4) Enter the rate of interest of the Recurring Deposit account.

Here you can enter your data only in 4 yellow colored cells.

Thanks for visiting my site.

ANIL SATPUTE

123-Details of the Amount received from MTNL/BSNL

We started getting various amounts from our organization. Now, this software will keep records of all such details of amounts received systematically and very simple manner.

Step 1:

If you are using mobile for this software use, then install EXCEL from the App station. Different methods are there for mobile as well as laptop. We will see both.

Click here to visit the software tool.

Step 2:

Now you will reach the software as shown below: (For laptop users) 

122-First installment amount of EX-Gratia of VRS-2019-for MTNL and BSNL Employees

Dear friends,

Click here to see the video on this software tool.

Note: Please enter the same staff number while checking your VRS Amount details that you entered in the form.

On 30/03/2020 our 1st installment of Ex-Gratia will be deposited in our bank. So this is the software to see how much amount will we receive?

We will get the details of the amounts as follows:

This software is prepared for everyone who opted for VRS-2019 and wants to calculate the VRS amount.

MTNL and all BSNL Employees can follow the following steps.

Step-1:

121-Tool-to-calculate-VRS-amount-for MTNL Delhi and BSNL Employees by entering Staff number

Dear friends,

Note: Please enter the same staff number while checking your VRS Amount details that you entered in the form.

Now everything regarding your VRS is over. Now it's time to see how much will we get from this VRS.

This software is prepared for everyone who opted for VRS-2019 and wants to calculate the VRS amount.

MTNL Mumbai employees can click here to get their ready-made calculation sheet.

MTNL Delhi and all BSNL Employees can follow the following steps.

Step-1:

Click here to fill in the following information as per your Last Pay Slip.

1) Your Name,
2) Designation,

3) Date of entry in the department,
4) Actual retirement Date,

5) Basic Pay,

6) EL,

7) HPL.

Please see the following diagram and fill it out completely. (Click here to fill out the form)

Step-2:

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

Click HERE to get your VRS calculations.

Enter your staff number (M012345) in the yellow-colored portion of an excel sheet as shown below.

Now we will get all VRS amounts simply by entering our Staff-Number MTNL-Delhi and BSNL employees.

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 7.9 % 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.

Step-3: Case-1

If your result shows some fields like " #N/A " as shown in the following figure, then follow the instructions given in cell no E12: L21 of your google sheet.

Step-3: Case-2

If your result shows some fields (like Total Ex-Graia, Final estimated VRS Amount, and so on)  as " 0 " as shown in the following figure, then follow the instructions given in cell no E31: L31 of your google sheet, (Correct your form).

This shows that you entered the Actual retirement date as your VRS date, so your calculations are like this. So, now you can correct your details in the form. Please see the following figure.

Clicking on "Edit your response" you can correct your form and recheck your VRS amount details.

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

ANIL SATPUTE

120-Tool-to-calculate-VRS-amount-for MTNL MUMBAI Employees by entering Staff number

Important Notes:

Now, MTNL Mumbai Employees can get their VRS details, simply by entering their Staff No in the form of "M0xxxxx". Please click on this statement.

Now we will get all VRS amounts simply by entering our Staff-Number only for MTNL Mumbai employees.

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 7.9 % interest after the age of 60 years.

9) Leave encashment.

Important Notes:

In case, if your information such as your Name, Designation, Date of entry in the department, Actual retirement Date, Basic Pay, EL, and HPL is not as per your latest payslip, then please click on the following link and enter your details as per your payslip only for the PURPOSE of getting correct calculations of all VRS amounts through this software.

Please note that these changes will be done only for this blog and not in any other system.

Click HERE to enter your data to get the correct calculations for your all VRS amounts.

Important Notes:

Now, MTNL Mumbai Employees can get their VRS details, simply by entering their Staff No in the form of "M0xxxxx". Please click on this statement.

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.

Enter your staff number (M012345) in the yellow-colored portion of an excel sheet as shown below.

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.

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

ANIL SATPUTE

118-Step-by-step Online CGHS form creation of MTNL & BSNL Employees

Dear friends,
In the previous blog "117-Online CGHS form submission of MTNL & BSNL Employees"
The details of the CGHS procedure are given in this blog.

Now we will see the procedure for "how to fill the CGHS form online.

Step-1

Click HERE for the CGHS site:

We will see the following screen:

Step-2

Click on "Apply for Plastic cards", and we will see the following screen:

Enter your mobile number and Captcha which is case-sensitive. 

Step-3

We will get OTP on our mobile. Enter it on the web page as shown in the following screen.

Step-4

Then go for "New Employees/Pensioners who are not CGHS beneficiaries" and click on the green button "Apply Now"

Step-5

Note 1) If you are entering your details the FIRST time enters all the details asked in this form.

         2) If you want to EDIT your data NEXT time, then click on EDIT DETAILS & PRINT FORM    and edit your data any time.

Step-6

After entering your details and clicking on Save & Proceed system will allot one acknowledgment number

THIS IS MOST IMPORTANT TO NOTE "acknowledgment number"

Step-7

If you want to EDIT your data NEXT time, then click on EDIT DETAILS & PRINT FORM    and edit your data any time.

After clicking on the EDIT DETAILS & PRINT FORM button, you have to enter the acknowledgment number.

Step-8

Edit the remaining family details and get the print.

ANIL SATPUTE

117-Online CGHS form submission of MTNL & BSNL Employees

Dear Friends,
Now we will see how to fill out the CGHS form online.

Keep the following things with you:
1) LPC received from AO (P & A)
2) Obtain NOC from the area Admin from where you got retired on form 2 signed by SM Admin. No claim for Fixed Medical Allowance - mentioned in NoC from SM(Admin).
3) Fill out the online application at https://cghs.nic.in/ website. (See the following chart for respective levels.

For MTNL Employees (Level 1 to 6):

For MTNL Employees (Level 7 to 12 & above):

For BSNL Employees (Level 1 to 6):

For BSNL Employees (Level 7 to 12 & above):

4) Approach the respective CGHS office and confirm from there the amount of DD to be taken. (It will be 120 times the amount shown in "Contribution (in Rs./Month) as per MoH&FW OM dated 09.01.2017 (Last column in the above tables) "

5) Fill out the online application at https://cghs.nic.in/ website.
6) Keep the blood group of you and all dependants ready to fill the same in the online CGHS form.
7) Once correctly filled up you will get a token number from the website. Take the printout.
8) Take a copy of Adhar and PAN card of self and of wife duly self-attested.
9) Take DD and submit it along with the application.
10) Keep all originals for verification at the CGHS counter.
11) CGHS on accepting applications will give an acknowledgment and give a date for collecting the receipt and ID.
12) Receipt to be submitted to area AO for receiving 50% (Maximum up to Rs, 40000) of the contribution from MTNL.

ANIL SATPUTE

116-Covering letters of 3 sets of pension form documents of MTNL Employees

Dear friends,
Click here to download the softcopy

This blog will help you to prepare 3 cover letters for the submission of your pension documents.

1 set is Area AO works (P & A)

1 set is CCA and,

1 set is for GPF.

Covering letters for all the above sets will be prepared for you and without any error, you will get your printouts of these 3 sets.

The only thing is that you will have to fill the first sheet of this excel form correctly and get all 3 sheets.

Please forward the link to this blog to everyone, so that they will be benefited

In the EXCEL sheets given for download, the first sheet is as shown above. Only fill in the data given in colored cells. Then you will get the printout for 3 sets to be submitted in the accounts office.

1) Area AO (Works/P & A) Set

2) CCA Set

3) GPF Set

So covering letters for your 3 sets are ready. Take the print and submit the pension form documents.

ANIL SATPUTE

115-Documentation of pension forms of MTNL Employees

Dear friends,
I am writing this blog which contains my view and my concepts only. According to this concept, I think it may be easy for every one of us. If you like this, then follow it, or else you may have your own way to adopt the procedure for arranging the pension papers and submitting them in the accounts unit.

Let us have a look at this concept.

If we arrange the pension papers as per the requirements of the Account section, it will be easy for us to arrange the papers, and the wastage of papers will be avoided.

Step 1:

Step 2:

As per the above list, please arrange the number of copies in the following three sets.

Step 3:
After arranging these papers according to the above list. Set these labels to these bunch of papers and submit them to the account section.

Note: These are my views. I think it may help all of us.

ANIL SATPUTE

114-Detail procedure of pension form of MTNL Employees

Dear friends,

Click here for English Video

Now it's time to submit our pension forms. So follow the following steps systematically to make our pension form submission easily.

1) Submit your data entry form in WFMS after saving,
2) Take the print outs as given below.
3) Write the page number on the top right-hand corner by pencil which is to be erased at the end.
4) MOST IMPORTANT: Please don't staple, don't tie or don't punch any paper as different papers are going to different sections.

5) Take all actions for each page as given above.

6) Page No 20 is the cover letter for your submission.
7) Arrange all pages along with some document copies as given below.

All the best for the submission of your pension form.

ANIL SATPUTE

113-Ready to fill Pension form for MTNL Employees in WFMS

Dear friends,
Click on this link to download the "Ready-to-fill" software click on this link and download the ready-to-fill form.

Click here to see the video related to the pension form

All MTNL VRS opted employees are aware that everyone must fill out their pension form through WFMS. While filling in data in this system, we need to enter some data in the system and some data will be populated by the system through the system's search window.

Here first we will see the procedure to fill the form and we will prepare one ready-to-fill form well in advance to get your data entry in the WFMS very very fast as many more employees can fill these forms as fast as possible.

Procedure:

1) Open the WFMS screen using the user ID and password of the officer through whom the timesheet is being prepared.

2) See the following picture:

3) Clicking on the "Common" tab given in the above screen, we will see "VRS Data Input" under the tab "7 Voluntary Retirement Scheme"
4) Click on the search button to get Employee details.

Employee-related data will be populated by the system shown with water-marked data in the grey-colored fields.
5) All date-related fields are to be filled through the Calander populated screen as shown below.

6) Now, family details and Alternative Nominees must be filled in very carefully. So download the following Excel sheet which is also called "Ready-to-fill-format". This Ready-to-fill-format must be prepared well in advance before starting the data input in WFMS.

Click on this link to download the "Ready-to-fill" software

7) After entering the data in the WFMS, save the data. Now you can make any changes to this form till we submit it in the system. The filled data will look like this:

8) After submitting it on WFMS, we can't change any data. Now go to Common with option 7-5-2 for VRS Pension Form, we will see the following window:

9) Search for our Employee No through WFMS, and we will see the following:

This is our final output of 24 pages of pension documents.

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

ANIL SATPUTE

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

Important Notes:

Now, MTNL Mumbai Employees can get their VRS details, simply by entering their Staff No in the form of "M0xxxxx". Please click on this statement.

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

ANIL SATPUTE