125-How to open your NPS Account Online

Dear friends,
Due to COVID-2019, 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 on-line NPS account, I faced some problems and the same is being shared hare.

So we will see the procedure step by step:

Step-1:

Click on the following link to open the NPS account.

http://www.npstrust.org.in/content/open-your-nps-account-online

I used KARVY to register for NPS. You can choose anything.

Step-2:

Click on the Join NPS New User button.

Step-3:

If you select PAN, then the following task is being done.

NOTE: Please select the Point of Presence (POP) where you have an existing relationship – either a Savings/ Current account (in case of Bank) or any Demat/ Mutual Fund/ Insurance, etc. (in case of non-Bank). Your KYC verification under NPS will be done by the selected POP (Bank/ non-Bank). A onetime fee of up to maximum Rs. 125 (plus applicable taxes) will be charged by POP (Bank/ non-Bank) as KYC authentication charges.

Secondly, if you choose the AADHAR card, then follow the following diagram.

Here you need to be ready for the following:

Step-4:

Now generate an XML file of your AADHAR card which is to be uploaded while registering for the NPS account.

Step-5:

Now upload XML file on the system.

Step-6:

Now fill all the steps as given below.

Step-7:

Now you can pay a minimum of Rs. 500 and after payment, you will get your PRAN

Step-8:

Kindly note that your KYC details will be sent to the Bank selected by you during the registration process for verification. Once Bank has confirmed the KYC verification, you have the option to esign the registration form.

Step-9:

Now you can also download the NPS mobile app from Google Play Store for Android (http://bit.do/ewpU8) and Apple Play Store for iOS by searching "NPS by KFintech CRA".

In the same way, you can also register for the NPS account using the NSDL portal. 

Thanks for visiting my site.

ANIL SATPUTE

124-Details of the Amount deposited in SCS Scheme

Dear friends,

We started getting various amounts from our organization. Here is your personal calculation sheet of 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 App station. Different methods are there for mobile as well as a 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 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

Dear friends,

We started getting various amounts from our organization. Now, this software will keep the 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 App station. Different methods are there for mobile as well as a laptop. We will see both.

Click here to visit the software tool.

Step 2:

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

Click on download symbol to get the software on the laptop as shown in the above figure.

Mobile users can get their file on mobile using the following step:

After getting the software from the site, you can save it on your mobile. for that, please click on the 3 vertical dots as shown in the adjoining figure.

Click on Save as button, and get the software on your mobile.

Step 3:

Now, the software is available on your laptop. Please see the following figure.

On the top, in the yellow-colored strip, you will see some warning, please click on the "Enable Editing" button to enter your data.

Step 4:

Now, start entering your information purely for you on your laptop. Keep this record safe for further entries and details of your records of the various amounts you received. See the following figure.

Thanks for visiting my site.

ANIL SATPUTE

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 which 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:

Click here to fill 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 completely. (Click here to fill 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 and BSNL employees.

The following results will be available

1) Estimated VRS Amount

2) First installment amount to be received on 30/03/2020

3) Monthly Pension After VRS

4) Second installment amount.

5) Gratuity Amount

6) Gratuity Amount with 7.9 % interest after the age of 60 years.

7) 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.

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.

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

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 which you entered in the form.

Now everything regarding your VRS is over. Now it's time so 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 readymade calculation-sheet.

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

Step-1:

Click here to fill 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 completely. (Click here to fill 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 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 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, HPL are 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 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

119 Divisibility test of 7

Dear friends,

When I was in 7th grade in 1972, my teacher taught me the divisibility tests of 2, 3, 4, 5, 6, 8, 9, 10,  except 7, then I asked her the divisibility test of 7. On this, she told that there is no test available for 7. I took it as a challenge.

While studying the table of 7 carefully, one day I fount the wonderful method for the divisibility test of 7. Actually, it's very interesting.

This method is published in my book titled "JADU NAGARI SANKHYANCHI". (Magic world of numbers) written in Marathi by "Bruhan Mumbai Ganit Adhyapak Mandal, Mumbai" published on 26th Dec 1980.

Procedure:

1) Take a number.

2) Write down its unit placed digit.

3) Double this unit placed digit.

4) Write down our new number excluding unit placed digit.

5) Subtract double of the unit placed digit from our new number.

6) Repeat this till we get a 2 or 1 digit number. If this number is divisible by 7, then our original number is also divisible by 7.

Example-1:

Check the divisibility of 7 for the number:			6902
1	Your Number	A	6902	6902
2	Its Unit Placed Digit	B	2	2
3	Double of Unit placed Digit	2B	2x2	4
4	Your new Number excluding Unit Placed Digit	C	690	690
5	Subtract double of unit placed digit from remaining number	C-2B	690-4	686
Repeat the same procedure
6	Your Number	A	686	686
7	Its Unit Placed Digit	B	6	6
8	Double of Unit placed Digit	2B	2x6	12
9	Your new Number excluding Unit Placed Digit	C	68	68
10	Subtract double of unit placed digit from remaining number	C-2B	68-12	56
As 56 is divisible by 7, our number 6902 is also divisible by 7.

Example-2:

Check the divisibility of 7 for the number:			1981
1	Your Number	A	1981	1981
2	Its Unit Placed Digit	B	1	1
3	Double of Unit placed Digit	2B	2x1	2
4	Your new Number excluding Unit Placed Digit	C	198	198
5	Subtract double of unit placed digit from remaining number	C-2B	198-2	196
Repeat the same procedure
6	Your Number	A	196	196
7	Its Unit Placed Digit	B	6	6
8	Double of Unit placed Digit	2B	2x6	12
9	Your new Number excluding Unit Placed Digit	C	19	19
10	Subtract double of unit placed digit from remaining number	C-2B	19-12	7
As 7 is divisible by 7, our number 1981 is also divisible by 7.

Example-3:

Check the divisibility of 7 for the number:			20237
1	Your Number	A	20237	20237
2	Its Unit Placed Digit	B	7	7
3	Double of Unit placed Digit	2B	2x7	14
4	Your new Number excluding Unit Placed Digit	C	2023	2023
5	Subtract double of unit placed digit from remaining number	C-2B	2023-14	2009
Repeat the same procedure
6	Your Number	A	2009	2009
7	Its Unit Placed Digit	B	9	9
8	Double of Unit placed Digit	2B	2x9	18
9	Your new Number excluding Unit Placed Digit	C	200	200
10	Subtract double of unit placed digit from remaining number	C-2B	200-18	182
Repeat the same procedure
11	Your Number	A	182	182
12	Its Unit Placed Digit	B	2	2
13	Double of Unit placed Digit	2B	2x2	4
14	Your new Number excluding Unit Placed Digit	C	18	18
15	Subtract double of unit placed digit from remaining number	C-2B	18-4	14
As 14 is divisible by 7, our number 20237 is also divisible by 7.

In the same way, we can check the divisibility test for any number.

ANIL SATPUTE