Last Updated on October 30, 2021 by
It is very simple software designed in MS Excel Sheet, prepared by Mirza Asghar Baig. You can find out your pension and commute in just less than 5 seconds with the help of this software. You have to feed only your Basic Pay, Length of Service & Age and this formula will calculate your Pension along with allowances and commute. You can say that it is a very simple Pension Calculator.
There are four categories of employees according to age range in this formula sheet. The 1st one is for the employees of age ranging from 29 to 36 years. 2nd one is for the age group of 37 to 44, 3rd one is for 45 to 52 years employees and the last one is for the employees who are going to retired between the age ranges of 53 to 60 years.
The 1st Column is for the Employees name, 2nd one is for Basic Pay, 3rd column is for Length of Service and the 4th column is for age. In the second last column pension per month is shown and in the last column total commute is shown. Here is to mention that this calculator is effective wef 01-07-2012 as soon as there occur changes in pension, new version of the same calculator will be released.
Note: I have tried to calculate Pension by this calculator. Some times the result are not accurate. How ever gratuity is 100 % accurate.
Don’t Forget: Calculate Pension & Commute Manually
Aoa madam i had a question regarding commutation amount .jo commutation amount banti kya wo total amount jo banti wo apko milti hai ?
Commutation calculation main kul pension main say 35% li jati hay.
dear madam please share complete calculation of pention with formula and exemple
D–O–B==== 01-11-1969
D-O-JOIN- 30–09–1993
BPS—17. SIR I REQUEST ME.
Basic pay 28400 in Bs 14 date of birth 20.07.1969 Date of Appointment 19.04.1988 Data of Retirement 1.12.2017 please Colcalation my pension
if someone is taking 30000 thousand pension per month. And in the budget 10 per cent increases. Then, how much is going to be increased on 30000 thousand pension. please, reply.
Madam i m junior clerk from fata education deprtment madam plz tell me about a rules books which one related with our job mean pension .leave etc
Where is pension calculation excel sheet that is not available on website kindly provide the facility of download the excel formula sheet for the purpose of pension calculation,
Thank you,
Muhammad Ayaz
Date of Joining 6.6.1980
Date of Birth 10.3.1961
BPS 16 (50440)
how much I collect as plz help if I retired pre mature service i.e. on 1.12.2017
Dear Madam. Thanks for giving pension information to the old age pensioners.Kindly give me the information about Group Insurance benefits.My son- in-law died in a road accident on 23-01-2013 while going to duty in the capacity of Junior Clerk in Education Deptt. of KPK. His last basic pay was Rs.10900/- The Group insurance contriution was Rs.67 + 7 = 74/- monthly. My daughter widow of deceased employee of Junior clerk Education Deptt. Nowshera of KPK has been granted lum sup amount of Group Insurance as Rs.175000/- It seems to me incorrect, ecause clss IV employee has also get the same amount. Kindly help me so that the case referred to State Life Ins.through Education Deptt. Nowshera. Also give me the reference, where I can get the Table of benifits/contribution. Thank you again .Praying for your long life & good health.
Respected Madam
Please guide me about my father pension, as he make confused by clerks.
Details are below
DOB.16.10.1956
DOJoining. 4.4.1979
DOR 16.10.2016
Basic pay 59800
BPS 17
i ll be thankful
Date of birth 01 -02-1966 service start on 15-10-1985 bps number 14 date of retirement 31 -10-2016 please mare pension or commute bata dan farooq ali
Mare pension or commute please bata dan
mahana pension ko gross pension kehtay hain ya gross pension ka 65% mahana milay ga aur 35% comuted please explain
Basic pay 44870/-(include adv inc 01-12-2017)
age 55 years
DOB 01-01-1963
retired on 31-08-2017
Gross Pension 30960 (Basic payx30x70/3000)
65% 20124/-
Commuted 35% 10836/- (10836x12xage rate=1969698/-)
Pl tell me that my monthly pension 30960 ya 20124
thanks
سلام مادام کس تاریخ سے پنشن مناسب ھے مشورہ درکار ھے پیدائش 24:04:1963 پہلی تقرری 08:12:1988 سکیل16ایجوکیشن Bps 44040 عمر 53 ریٹائر تاریخ 01:07:2017 ماھوار پنشن اور یکمشت کتنا ملے گا شکریہ عبدالغفار
Date of birth . 27-4-1962
Date of appointment 11-1-1990
Current basic pay . 79960
Date of retirement 22-9-2016
Grade 18 assistant professor
ate of birth 30.08.1954
date of joining Service 30.6.1974
my Basic pay scale is 16
date of retirement 29.08.2014
current basic pay 32,400/-
Special pay 400/-
Let me my pension and commutation. in the same, when I will be able to get double pension
my length of service 40 years 2 month 28 days from the date of appointment i.e
1.6.1974 ti 29.08.014,
THANK U SO MUCH MADEM FOR QUICK RESPONSE: i am asking for ad hoc increase of 10% on basic pay scale. and i calculated my self according to your formula it came little different. my basic pay is 15400+specail pay1732+adhoc 10%which is 1540 =18672*30*70/3000 so the gross pension will be 13070 and comute according to the formula will be 4574 which is of 35% of the gross pension=4574*12*12.3719(age rate) it will become 679143 kindly give your opnion plz
Dear Sajid, for pension calculation there will be not included 10% increase in basic pay. However it will be added in the pension. That is calculated automatically in the formula that I uploaded. In the basic pay only B.PAy, Special Pay and Usual Increment will be added.
asalam alekum
kindly inform how much would be my commute and pension
basic pay current 14000 grade 16
date of retirement 15-05-2040
regards
Dear fawad plz email me in 2040. Thanks
dob:1954 doj:1983 bps:07 basic pay 15400 special pay1732 retired from service on 18-07-2014 last drawn net salary 43280 Iwant to know about my comute monthly pension and also that ad hoc relief of 2014 @10 will be added for me
Dear Sajid increase in pension in 2014 will also be added in ur pensoin. Ur pension detail is as under:
Commute 634788.33
Net Pension 17531.15
date of birth 30.08.1954
date of joining Service 30.6.1974
date of retirement 29.08.2014
current basic pay 33,200/-
Special pay 400/-
Let me one, when I will be able to get double pension
Dear Muhammad Abdul Qadir, plz email me ur length of service & your basic pay scale alonngwith all these details.
date of appointment 12-12-1973. date of Birth 02-01-1955,Basic Pay in BS-19 Rs.63000/-PM.what will be accurate amount of monthly pension & commutation ? plz give details
Dear Iftikhar I ll soon update the calculation sheet. Just w8 a few days more for accurate calculation.
date of birth 30.08.1954
date of joining Service 30.6.1974
date of retirement 29.08.2014
current basic pay 32,400/-
Special pay 400/-
Dear Qadir ur pension detail is as under:
Commute 1222145.77
Net Pension 29745.86
There is not yet included 10% increase in pension of the year 2014.
myre basic pay 46500 date of retirement 17:6:2014 lenghth of service 37 years scale 18 hay to pension kitne bnay ge
Dear Rahat Zaid if the basic pay is now 45500/- then:
Commute 1709549.14
Net Pension 41608.79
basic pay 38500 scale 17 length of service 23 year date of aponintment 1988 date of bith 1962 hay pension kitne bnay ge
Dear Syed Talha if the age is 56 then:
Commute 1263519.60
Net Pension 26130.91
age 51 hay
Dear Talha just send me all detail again via email Thanks
basic pay 38500 hay or length of service 23 or scale 17 pension kitne bnay ge
Dear Syed Talha send again all this detail along with age and date of birth.
I want 17-A rule for childeren employee
Dear Asif just type “Rule 17 A” in the search engine of this site and u ll find the same.
Sir i am in problem because the pension formula for employees of government is not calculate in M.S. Excel i wan to share pension formula in excel upload please.
so i make pension for our Irrigation employees.
Thanks./
Dear Asif the same formula is also available in the MS-Excel sheet at this site.
Dear Sir
Greetings from Hyderabad
I am working for Labor , I am happy that I am taking information from this website , This is very informative for labor and local people
Sir My question , please tell me those who retired or died be fore 2001 , can their legal heirs take double pension facilities ?
or those who retired before 1990 can they take double pension facilities
Thanks dear Sooba Bhatti sb for appreciating mine efforts. Just send email to Mr. Amir Agha whose detail is available at CONTACT US at the site.
Mam AOA plz send me notification of ban on nomanclature by establishment devision dated 15-11-1996 if possible plz.
myre ant ke basic pay 22030 hay or date of retirement 8.8.2014 or scale 14 hay to un ke pension kitne bnay ge
Dear Syed Talha the pension and commute detail is as under if the service is 30 years or more.
Commute 823493.46
Net Pension 20558.10
Aoa,
felt amazing to find such an helpful post, i have recently applied for my Pension, my clerk calculated following things for the pension emoluments form.
D.O.B:
12-Jan-1953
D.O.R
11-Jan-2013
Basic Pay:
39,500/-
Years of Service:
28 Years, 10 Months and 21 Days.
Basic Pension Calculated: around 26,732/-
Ordinary Pension Calculated around 9,372/-
Gratuity Calculated around 1,341,000/-
I tested your Excel app, it is calculating Net amount almost equivalent to what has been calculated by my clerk, but Per Month calculated by Excel is around 41,000/- which is way much different than what has been calculated by my clerk.
Upon asking my clerk said that in Papers we write as per gov rates and rest is done by AG Office. So do you confirm that actual Pension will differ from what has been estimated in Pension papers.?
i would be very thankful.
Thanks dear Rashhida, for liking this post, your clerk says right. In pension papers net pension alongwith increases during various years is not mentioned. These all net pension calculation is done by the AG Office. In pension papers only Commute and 65% pension is mentioned. Thanks
Dear Madam,
My question is very simple , i am devolping a software for Pension estimates of retired/retiring employee, for calculation of Date of Retirement from Date of Birth i add 60 years to the Date of Birth,
example: Date of Birth : 27-06-1958 , Date of Retirement : 27-06-2018
various sources from internet , that you will take 1 day minus of your date of birth. i-e 26-06-2018 .
my question is whether 27-06-2018 is correect or 26-06-2018.?
Thanks
Dear Khurrum 26-06-2018 is correct.
AoA
At the time of my retirement my total service will be 18 years. I am grade 1 office doing job in BPS-17, I will get LPR or not at my retirement? please drop a line for me.
Dear Ikram I have already answered u that u can get LPR.
AoA
When I will retire at that time my total service will be 18 years. Could I will get LPR or not.
please tell me.
Dear Ikram Khan u can get LPR at that time.
AOA. Madam is pension calculator software mey kuch problem hey, net pension is not correct.meny Mirza Asghar Baig sy ess No. per call bhi ki thi on ko batany k ley 03017745843. magar ye No asgar ka nahi hey , kia aap ka koi rabat ho sakta hey Mirza Asghar Baig tu is problem ko correct karwa dey thanks
Thanks Farooq
0332-5537524
Dear Muhammad Farooq, I ll try. U can see his facebook id in mine friends list.
Salam.mehrabani kar k mujy is sof ka password send karain. Ta k unprotect karon.kiyonke kpk govt naay 15% ka izafa kia hay.awr aap ny 10% ka hesab kia hy.wassalam
Dear Habib ur Rehman, plz contact the cell number that is given in this sof.
My Baisic Pay is 21100 grade 15 Date of birth is 27.07.1969 iwant to retire from my service on 01.sep.2013 kindly calculate my all benifits including LPR my office clerk saying that Iam not able to get 12 month LPR as my service is 25 years .
Dear Khalil 25 years service is compulsory for LPR or 30 Years service for Leave Encashment.
what is the difference between LPR and Leave encasement …..?
Dear Khalil, LPR means Leave Priorotary to Encashment. Is ka matlab hay agar aap kay aacount main 200 chutian hain to aap yeh chutian avail kar kay retire ho jain gay. Aour agar aap yeh chutian nahin letay to phir aap ko is ky payment milay gi jo keh Basic pay hoti hay.
Thanks a lot shumaila for explain it
Respected Sir, please tell us how pension commutation will work out if a government employees dies during his service after serving for more than 30 years. Will his family be entitled to receive pension commutation and if yes then will it be half of what it would have originally been had he not died or will they get the full commutation. Please reply. Thanks
Dear Bilal, his wife is eligible to get the pension and commute.
AoA plz ap mujy bata suckty hain k mre pention etc kia ho ge dob is 07-10-1966 date of apa 17-07-1985 & date of retairdment 15-07-2012 12200 last baick pay they plz halp me plz mare id per send kar dain thank s
Dear Manzoor plz email me.
salam, I like your work thats very important web site of government employees.
Thanks Dear Khalil for appreciating mine work for the employees.
net pension is not correct.please correct the farmula
Dear the net pension includes all the allowances too.
aoa.please,mention detail of allownces which are added to ordinary pension to determine Net pension.
Dear these are 2010 ARA, 2011 ARA and 2012 as well as Medical Allowance that is added in pension.
are these allownces caculated on the base of gross pension or ordinary pension?your spoftware calculate on gross while account office on ordinary pension. please clarify with example and relevant notifications.
I appreciate the formula. I checked & found O.K.
( 1 )
Date of birth : 15-6-58
Date of appointment : 11-1-1982
Present Basic Pay : 27600 + (one pre-mature increment on my
upgradation is awaited as per court
judgement inshaallah)
Then : 28400/- (if I get retirement now.?
I also have Spl Pay : 320/-
———————
( 2 )
and if I retire on 15-6-2018 (without revision the salaries)
i.e. the age limit 60 years. then my Basic Pay will be : 34000/-
Please tell me about the both i.e. (1)& (2)stages. Almight Allah bless you with many more pleasures.
Dear just go to the Employees Corner then Pension column and there will be Pension Calculator. Download the Pension calculator and then Plz try urself the amount of Pension & Commute.
Plz ap mhj ko pension aur commutation k bary mai bta dain.
D.O.B:- 10/1101979
D.o.App:-18/11/1998
D.O.Retired.:-17/10/2017
Basic pay:- 20500
Sir plz tell me.
M.ARIF PAKISTAN
Thanx dear ejaz gud app it is also helpful to prepare docs of pensioners. And shumaila u r doing wndrful work to help us. Thanx
THanks for appreciating.
Its very good for all employess thank u very much
dear app k caculator par apni pension ko cal calculate karny sy 30660.84 ban rahee hy jabkeh meri pension 22 hazar bani hy. y
Aap kab retired huay they?
plz date of retirement?
This calculator is valid wef 01-07-2012.
Sir mujhy ye btain ky iss main 1st Catagory main 3 khany hain. in sb ko pur kerna pry ga ye sir aik hi row istimal ho gi. thanks
teenon main say koi aik row use kar lain koi farq nahin parta
bohat hi umda koshish hy. Allah aap ki taraqiyan kery. Aameen
Good
very good service for govt.employees. May Allah give more.
Thank you very much for giving this type of software. It will very helpful for all the employees especially for those who are going to be retired in near future.