Calculate Your Pension & Commute in Just 5 Seconds with Simple Software

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



  1. ahmad ahmad says:

    dear madam please share complete calculation of pention with formula and exemple

  2. Muhammad Salih Detho says:

    D--O--B==== 01-11-1969
    D-O-JOIN- 30--09--1993

  3. Muhammed Zahid says:

    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

  4. sheraz says:

    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.

  5. shaukat says:

    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

  6. Muhammad Ayaz says:

    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

  7. Muhammad Amjad Perwaiz says:

    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

  8. ali khan says:

    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.

  9. sajjad ahmad says:

    Respected Madam
    Please guide me about my father pension, as he make confused by clerks.
    Details are below
    DOJoining. 4.4.1979
    DOR 16.10.2016
    Basic pay 59800
    BPS 17
    i ll be thankful

  10. farooq says:

    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

  11. farooq says:

    Mare pension or commute please bata dan

  12. azmat ali says:

    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

  13. عبدالغفار says:

    سلام مادام کس تاریخ سے پنشن مناسب ھے مشورہ درکار ھے پیدائش 24:04:1963 پہلی تقرری 08:12:1988 سکیل16ایجوکیشن Bps 44040 عمر 53 ریٹائر تاریخ 01:07:2017 ماھوار پنشن اور یکمشت کتنا ملے گا شکریہ عبدالغفار

  14. NotanLal says:

    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

  15. Muhammad Abdul Qadir says:

    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,

  16. sajid rafique says:

    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.

  17. fawad says:

    asalam alekum
    kindly inform how much would be my commute and pension
    basic pay current 14000 grade 16
    date of retirement 15-05-2040


  18. sajid rafique says:

    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


    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

  20. Iftikhar Malik says:

    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

  21. muhammad Abdul Qadir says:

    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/-

  22. rahat naseem zaide says:

    myre basic pay 46500 date of retirement 17:6:2014 lenghth of service 37 years scale 18 hay to pension kitne bnay ge

  23. syed talha says:

    basic pay 38500 scale 17 length of service 23 year date of aponintment 1988 date of bith 1962 hay pension kitne bnay ge

  24. syedtalha says:

    basic pay 38500 hay or length of service 23 or scale 17 pension kitne bnay ge

  25. Asif Majeed says:

    I want 17-A rule for childeren employee

  26. Asif Majeed says:

    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.

  27. Sooba Bhatti says:

    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

  28. Amjad Latif says:

    Mam AOA plz send me notification of ban on nomanclature by establishment devision dated 15-11-1996 if possible plz.

  29. syed talha says:

    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

  30. Rashhida says:


    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.





    Basic Pay:


    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

  31. Khuram says:

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


  32. Ikram khan says:


    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.

  33. Ikram khan says:


    When I will retire at that time my total service will be 18 years. Could I will get LPR or not.
    please tell me.

  34. Muhammad Farooq says:

    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

  35. habib ur Rahman says:

    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

  36. khalil says:

    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 .

  37. Bilal says:

    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

  38. manzoor ahmad says:

    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

  39. khalil says:

    salam, I like your work thats very important web site of government employees.

  40. ASIFAWAN says:

    net pension is not correct.please correct the farmula

  41. mahboob alam says:

    aoa.please,mention detail of allownces which are added to ordinary pension to determine Net pension.

  42. shaheen-ur-rehman says:

    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.

      • arif mehmood says:

        Plz ap mhj ko pension aur commutation k bary mai bta dain.
        D.O.B:- 10/1101979
        Basic pay:- 20500
        Sir plz tell me.

  44. Jamil Ahmed says:

    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

  45. Ejaz says:

    Its very good for all employess thank u very much

  46. M Yaqub says:

    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

  47. Hamid Ali says:

    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

  48. Hamid Ali says:

    bohat hi umda koshish hy. Allah aap ki taraqiyan kery. Aameen

  49. inayatullah jagirani says:


  50. Akhtar Iqbal Bhutta says:

    very good service for govt.employees. May Allah give more.

  51. Yasir says:

    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.

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.