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

 

77 Comments

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

  2. farooq says:

    Mare pension or commute please bata dan

  3. 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
    thanks

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

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

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

  6. 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,

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

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

    regards

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

  10. 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 33,200/-
    Special pay 400/-
    Let me one, when I will be able to get double pension

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

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

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

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

  15. syedtalha says:

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

  16. Asif Majeed says:

    I want 17-A rule for childeren employee

  17. 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.
    Thanks./

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

  19. Amjad Latif says:

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

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

  21. Rashhida says:

    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

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

    Thanks

  23. Ikram khan says:

    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.

  24. Ikram khan says:

    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.

  25. 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
    0332-5537524

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

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

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

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

  30. khalil says:

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

  31. ASIFAWAN says:

    net pension is not correct.please correct the farmula

  32. mahboob alam says:

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

  33. shaheen-ur-rehman says:

    I appreciate the formula. I checked & found O.K.

  34. MUHAMMAD SAFDAR JANJUA says:

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

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

  36. Ejaz says:

    Its very good for all employess thank u very much

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

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

  39. Hamid Ali says:

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

  40. inayatullah jagirani says:

    Good

  41. Akhtar Iqbal Bhutta says:

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

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

Comment moderation is enabled. Your comment may take some time to appear.