7th Pay Commission Salary Calculator in Excel

Here is our Seventh pay commission calculator online to help you in calculating your new salaries as latest 7th pay commission recommendations. There are some instructions to use this 7th Pay commission calculator, so read carefully.

7th Pay Commission Calculator Online

After you calculate the New Basic Pay using this 7th CPC Calculator online you need see the image below (click on image to enlarge).

Find the new pay level corresponding to your current grade pay by using table 4 in the image. Then in the image see table 5 and the corresponding level. In that level find the equal or next higher value of the new basic pay calculated using this seventh pay commission calculator.

Download on your PC our 7th pay commission calculator in excel here.

7th pay commission calculatorExample: Current Basic Pay=21000 and Grade Pay=6600 My New Pay Level as per table 4 in the image is 11, the New Basic Pay as per this 7th cpc calculator is 70932.

Now 70932 corresponds to 71800 in level 11 in table 5. So the Final New Basic Pay as on 01.01.2016 would be Rs.71800.

Current Basic Pay: Current Grade Pay: New Basic Pay:

If any problem,tell us in comments below. Also Check Our Latest Pay Arrears Calculator.

Check our New 7th Pay Commission Calculator for Salary and Arrears

With the announcement of 7th pay commission 2016 in India, everyone was excited about what their salaries would be w.e.f. 01.01.2016. We have already written about expected 7th pay commission pay scales. Lot of readers of this website were requesting to put up a utility on this site where they can calculate their expected salary w.e.f. 01.01.2016 based on the expected pay scales for India Government employees so we came up with this 7th pay commission calculator.

As the seventh pay commission report has been finalized and submitted to the government in Nov 2015, everyone is eager to know their new salaries as on 01.01.2016. This time the commission has changed the 7th pay commission pay structure. The 7th pay commission structure is done in the terms of pay levels unlike grade pay system in 6th CPC.Today the cabinet approved the 7th pay commission recommendations and accepted the latest seventh pay commission report.

So we have made a simple 7th pay commission calculator 2016 where you can fill in your current pay details and check the future expected pay. Simply enter the values in the box below and this seventh pay commission salary calculator will display your expected salary as on 01.01.2016. It is not a 7th pay commission salary calculator in excel but it works on excel at the back end. We have used the 7th pay commission calculation formula as given in the pay commission report. The calculation formula uses 2.57 as multiplication factor.

Click here for One Rank One Pension Calculation table for PBOR and Officers

For knowing the 7th pay commision latest news subscribe to our site by entering your email id in the box given on the right side bar. You will never miss any 7th pay commission latest news and other updates. You may want to download 7th pay commission report pdf here.


117 thoughts on “7th Pay Commission Salary Calculator in Excel”

  1. shashi kant says:

    Hello sir
    I am a primary teacher in basic siksha parishad schools sir please tell me my expected salary according to the recommendations of 7th pay comission. I am giving my details
    Pay band …. 9300-34800
    Basic pay……14800
    Grade pay……4200

  2. V KRISHNA says:


  3. Prakash KM says:

    Any mathematician can play any gymmics.That what seventh pay commission.See the case of my total salary? It is fifty thousand. According to seventh pay commission it is basic pay of just approximately fifty three.Means only two thousand without DA.

  4. Jagat dash says:

    When Govt. is thinking about Government employees, who are the practical voter for whom the elected govt. formed, why the Govt. is not giving them important and giving pensionary benefit to them either Old man/Woman, Cultivator,Road foot Path shop keeper,Private Taxi driver, Poor farmers or to the Bhinakhyam worker engaged in private small companies? Bring this to the notice of all political parties for taking a step for these people.

  5. Bala Krishna says:

    7th cpc calculator is Not Working

  6. ankur kumar says:

    Sir . Abhi mera grade pay 1800, pay band 5200 to meri salrey kitni hogi

  7. aashu says:

    Its corrected now…thanks for reporting.

  8. aashu says:

    Dear Shashi Kant Ji, your new basic pay as on 01.01.2016 would be Rs.49000/- …you can add other allowances like hra,tpt etc as per your admisibility

  9. shivanandkalekar says:

    bahut badhiya

  10. ramesh says:

    My basic pay is 9800+grade pay is 2400 and ms pay is 2000 now how much new basic pay sir

  11. ratan debnath says:


  12. CHandan Boro says:

    My basic pay is 6410+grade pay is 2200 now how much new basic pay sir

  13. vijaykumarmakode says:

    my 6 pay comation 20220 –4300–da 30650
    9300—garadpay— 4300
    pla 7 pay clacut

  14. N.K. Saini says:

    My present pay band is 9300-34800, basic pay is Rs.22220, Grade pay is 5400 and TA is 3200. What would be my basic pay, Sir?

  15. N.K. Saini says:

    My present pay band is 9300-34800, basic pay is Rs.22220, Grade pay is 5400 and TA is 3200. What would be my basic pay, Sir?

    N.K. SAini

  16. Sujit Kumar Hazra says:

    Please calculate my salary from Jyly 2016

  17. gopal says:

    Sir I am a Draughtsman , My Basic pay is 24525 and grade pay is 4200 in scale of pay 9300-34800 what will be my present as per 7th pay commission.

  18. Dipak kumar says:

    Is it true that service period reduced to 33 years only in government jobs,i think it is a good dissicions by central government I hope modi ji will increase the age limit from 27 to 37 to enter into government jobs

  19. aashu says:

    No it is not true yet..

  20. aashu says:

    Dear Gopal Ji….your new basic pay would be 74300 as on 01.01.2016

  21. aashu says:

    Dear N.K.Saini Ji….ur new basic is Rs71300…..Please share our site on facebook if you liked it.thnaks

  22. Ashutosh Biswas says:

    Sir l am a pharmacist ditails my pay is basic 15610 grade pay 4200 hra 10% pca 2070

  23. devindet says:

    my basic is 19160 and gradepay is 4600 what will be my new basic pay

  24. aashu says:

    Rs.62200…….Please share our site on facebook if you liked it….thanks

  25. aashu says:

    Dear Ashutosh ji…..Ur New basic pay is Rs.52000………Please share our site on facebook if you liked it….thanks

  26. SURESH TIWARI says:

    I am leaving in Delhi and how we can calculate about transport allownces

  27. sharad pandey says:

    my basic pay is 18560 and grade pay is 4600 what salary will be in New scale

  28. Zahid Husain says:

    Dear I am giving my details
    Pay band …. 9300-34800
    Basic pay……15860 Grade pay……4200
    DA……………….125% Please share our site on facebook if you liked it….thanks

  29. aashu says:

    Dea Zahid your new basic pay is Rs.52000….Please share our site on facebook if you liked it….thanks

  30. aashu says:

    Dear Sharad…ur new basic pay is Rs.60400……….Please share our site on facebook if you liked it….thanks

  31. aashu says:

    Dear Suresh…ur transport in Delhi is 7200+DA

  32. l jayaseelan says:

    I retired in 31 Oct 2013 as Accounts Asst with Basic pay 11575/- and pay band 4600/- what will be my pension now.


    m y basic pay -19750 GARAD pay-4200 HRA-20/ TA-800 what is basic pay HRA AND TA SEVENTH PAY COMISON

  34. Arnab bakshi says:

    Sir I am having basic 26000,grade pay 6600,living in Kolkata, what will be my hra, ta, and CCA according to 7th cpc.

  35. Daya nand says:

    my b p 18150 and p b 4200 what will be my total pay after 7th pay commission

  36. NK Saini says:

    This is N.K. Saini again here. You told my new basic pay would be 71300. I agan tell my current emollients. Please recalculate it. My BP as on 1.1.06 is 22220, GP Rs.5400, TA with DA on it 7200.
    The pay matrix table shows that my case is covered under level 9 index 12. Isn’t it correct. Because the figure 27620 will be multiplied by 2.62 and not by 2.57. Please recheck it.
    N.K. Saini

  37. BHAVESH says:

    Sir mera begic 7430 hai or gred 1800 hai to CPC me kitna fayda hoga or begic kitna hoga

  38. Kaptan says:

    My basic salary is 15600+grade pay 5400
    What is my new basic salary

  39. Dhamodhara rao says:

    What will be my salry if my basic pay is 9440 and grade pay is 2400

  40. mehak says:

    my basic pay is 11170 and grade pay is 2800 and i lie in the pay band 5200-20200..hra 10% .what will be my consolidated salary according yo 7CPC.

  41. aashu says:

    Dear Mehak…ur new basic will be Rs.37000 and including HRA …total is Rs.39960….pl share us on facebook…thanks

  42. aashu says:

    Dear Dhamodhara ….Your New Baisc Pay is 35300 ……..pl share us on facebook…thanks

  43. aashu says:

    Dear Kaptan ….Your New Baisc Pay is 56100 …..pl share us on facebook…thanks

  44. aashu says:

    Dear Saini Ji……multiplier factor is 2.57 for all……ur gross pay is Rs.78500…..pl share us on facebook…ty

  45. aashu says:

    Dear Daya nand ….Your New Baisc Pay is 58600 ……..pl share us on facebook……….thanks

  46. aashu says:

    Dear Arnab ….Your New Baisc Pay is Rs.85800 and total pay is Rs.113592 ……..pl share us on facebook……….thanks

  47. aashu says:

    Dear MACBETH ROBERTS ….Your New Baisc Pay is Rs.62200 and total pay is Rs.75352 ……..pl share us on facebook……….thanks

  48. aashu says:

    Dear Bhavesh ….Your New Baisc Pay is Rs.24200 ……..pl share us on facebook……….thanks

  49. Diganta konwar says:


  50. Jagdamba Prasad says:

    Am retired defence person. my basic 7550 what will be my new basic after 7th CPC

  51. Mamur Ali says:

    how to calculate salary as per matrix if current grade pay is 6000. and basic pay is 22000.

  52. balveer says:

    Sir my basic pay 11440 and grade pay2800 mera new pay scale kitna hoga

  53. balveer says:

    My basic pay 11440 and 2800 my new pay

  54. aashu says:

    Dear Balveer ….Your New Baisc Pay is Rs.37000 ……..pl share us on facebook……….thanks

  55. Shekhar Bendarkar. says:

    Satisfactory Payment increase in salary.

  56. devendra Kumar says:

    I am devendra kumar.I am teacher in basic education up. basic pay16140, grade pay4200, hra 2020, cca 180. da 125%. posted at ghaziabad in utter Pradesh. what would be my salary according to 7 pay commission?

  57. ravi shankar uikey says:

    ple reply my basic pay at face book

  58. ravi shankar uikey says:

    my old basic pay 7780 grad pay 1900 ……..pl share us on facebook new basic ……….thanks

  59. ravi shankar uikey says:

    my frnds basic pay 11050 and gradpay 2800 pl share us on facebook new basic ……….thanks

  60. Abdul Ateeq KHAN says:

    Sir my current salary structure is as follows
    Basic pay 18150
    Grade. 4600
    HRA 20%
    TA. 10%
    DA. 125%
    After 7th pay commission what is my salary slab .thank

  61. aashu says:

    Dear Abdul Ji….ur new basic is Rs.58600…

  62. aashu says:

    Dear Ravi Ji….ur new basic is rs.35900 …..pl share us on facebook

  63. aashu says:

    Dear Devendra Kumar…ur new basic is rs.53600

  64. V.R.Khare says:

    I am working in one of Research Institute of Govt.My basis pay at present is Rs.15230/- and Grade Pay is Rs.4600/- PayBand is 9300-34800. sir please tell me my expected salary according to the recommendations of 7th pay comission.

  65. aashu says:

    Dear V R Khare….your new Basic Pay is 52000…pl share us on facebook……….thanks

  66. Shah Nitesh says:

    Basic pay 12650 , grade pay 2800 , cpt 1600 , Hra 30% what is my new basic

  67. aashu says:

    Dear Nitesh ….Your New Baisc Pay is Rs.40400 ……..pl share us on facebook……….thanks

  68. Vijaykumar says:

    Sir . Abhi mera grade pay 1300, pay band 4440 to meri salrey kitni hogi

  69. sukhvinder singh says:

    my current basic is 15820 grade pay 4400 house rent 20% medical allowance 500, mobile allowance 300, conveyance allowance and dearness allowance is 124% what is my new pay grade


    BASIC = 14130 ( GP, 2800),CITY = KOLKATA, TA=1600.

  71. Dr.Sandeep says:

    Bp25850 gp 5400 NPA 7813 hra 30% tpt 7200,how to calculate.can some one tell me.

  72. shashi kant


    Hello sir
    I am a steno-typist in basic O/o Executive Engineer,Public Health Engg.Project Dn,Raipur sir please tell me my expected salary according to the recommendations of 7th pay comission. I am giving my details
    Pay band …. 5200-20200
    Basic pay……7684
    Grade pay……1900
    DA 11700%

  73. chham says:

    Dear my basic pay is….7800 and Grade pay is…2000. can u tell me sir my total payment

  74. I retired from Western Railway on 30/08/2016 as a Divisional Electrical Engineer with basic of Rs.34680.At retirement my Scale of pay with gradepay was Rs.15600–39100–6600.My basic pension was fixed at Rs.17340 and commutation to be deducted was Rs.6936.
    Kindly calculate and inform me about my Pension as per 7th pay commission now.


    My Basic Pay is Rs. 13800 and Grade Pay is 4200 and D.A. is 125% what will be my 7th Pay Commission basic pay ?

  76. My basic pay is 19560 and grade pay is 4800.Find my gross salary.

  77. santosh kumar mahto says:

    Hello sir
    I am center govt employee sir please tell me my expected salary according to the recommendations of 7th pay commission. I am giving my details
    Pay band …. 5200-20200
    Basic pay……74300
    Grade pay……1800

  78. Deshraj says:

    My current basice pay 15200 and grade pay 4200 what whould be expectedsallry as per 7th cpc

  79. ASHOK C says:

    My Pay band …10620
    Basic pay……13020
    Grade pay……2400
    DA……………….16275 wat will be my expected salary sir?

  80. Sachin kumar says:

    Sir basic pay 7250 gred pay 2000
    Meri sealry kitni hogi

  81. Subrata Goswami says:

    question bandh koro our bhgwan ko prayer koro ke aase din aye.Thik he

  82. ajit kumar gaur says:

    Mera basic 900 grade pay1900 to saelry kya ho gi

  83. ajit kumar gaur says:

    Mera basic 9000 hai grade pay 1900 to sailry hogi

  84. VIJAY says:

    My basic is 32240 Grade pay 5400 PB-2What will be new basic In seventh pay commision

  85. R.V. Bari says:

    Sir my particulars on 1.1,2016 are as follows:
    Pay Band 37400———
    Basic pay 43220
    Grade pay 8900
    DA. 125%
    What would be my basic pay as per the 7th pay commission recommendations?

  86. aashu says:

    R V Bari Ji, Your new basic as on 01.01.2016 would be Rs.135000/- and on 01.07.2016 it would be Rs.139100 +DA

  87. ashish upreti says:

    r my particulars on 1.1,2016 are as follows:
    Pay Band 5200———20200
    Basic pay 6720
    Grade pay 2000
    DA. 125%
    What would be my basic pay as per the 7th pay commission recommendations?

  88. F.ALAM says:

    MERI BASICE 1/1/16 KO 18930 THI,GP 4200,—– AB KITNI HOGI,

  89. paul david says:

    what will my baysic pay and total salary

  90. paul david says:

    total salary and basic pay


    pay band (9300-34800)
    Basic pay 15115
    grade pay 4600
    calculate my new basic pay

  92. shetra kotresha says:

    i am pensioner just out 30 june 2016 basic pay 10760 grade pay 2800 so which pension

  93. Rakesh Das says:

    Sir, my basic pay is 9870/- and GP is 2000/-. What would be my pay?

  94. junaid says:

    Sir my basic pay is ₹14420 and grade pay is ₹4800 along with 125% D.A..What will be my salary after implementation of 7th pay commission.I am working in Uttar Pradesh

  95. Sandeep Atkan says:

    Want to know my actual basic pay as per 7th pay commission. The details is as under:-

    My Basic Pay is – 12900
    Grade Pay – 3600
    HRA – 2580
    Medical Allow. – 500

  96. Arjun Singh says:

    I want to know my Basic Salary as per 7th Pay Commission on 30.06.2016, I am Haryana Government Employee & submitting my details as under:-

    Name:- Arjun Singh
    Basic Pay:- 5410
    Grade Pay:- 1900
    HRA :- 1650
    Med. all :- 500

  97. Hello I m jagodindu nath Pl. Tell me one thing my bp in January rs.16750. And I have got macp 2 in July 17th 2016. What is my new bp


    Hello sir,
    I want to know my basic pay as per 7th commission on 1.1.2016,I am submitting my details as below:-

    BASIC PAY:- 23740
    GRADE PAY:- 4800
    TA:- 1600
    HRA:- 8562

  99. K KRISHNA MURTY says:

    my name is K KRISHNA MURTY

    BASIC PAY 13400
    GRADE PAY 4600
    DA 125%


  100. Chandrashekhar Singh says:

    sir good afternoon i have given details my salraya as per 6th pay Commission as below mentioned
    1.1.2016. Pay band 9300-34800 GP,4200
    basic pay.11470 + GP 4200
    3.6.2016 ( Promotion As Assistant Director(H) Minister of Textiles
    basic pay.11940 + GP 4600(Promotion Increment)
    1.7.2016 basic pay 12430 + 4600 GP(Notional Increment)
    DA.125% and HRD 20% TA-1800 , hereby i kindly requesting plz tell what is may salary as per 7th pay commission

  101. Dr Chandrakant says:

    Hello Sir,
    My total salary is 93000/-
    Basic pay 20800, GP-6600, HRA-10000,NPA-6500, DA-40000,TA-3200 etc

    What will be my salary according to 7th pay commission.

    Thanks in advance.

  102. Utpal Kanti Chaudhuri says:

    My basic Pension pay is RS.17546 AS PER 6TH PAY Commission.What is my Grade pay and pay band?I am unable to calculate my basic pansion as per 7th pay commission for above unknown Pay band and Grade pay.Will you pl.helf me?

  103. Utpal Kanti Chaudhuri says:

    Thank you.

  104. sanjeev says:

    my basic pay is 19550 & grade pay is 4600 in jan 2016. I have govt accommodation. What will be my new basic pay & and my total salary.

  105. manmohan says:

    My basic 9720 gpay 2400 hra20% what is my new payscale

  106. bharat says:

    very poor our gujarat gov

  107. Suresh Solanki says:

    Dear I am giving my details as on 1.1.16
    Pay band …. 9300-34800
    Basic pay……14160 Grade pay……4200
    DA……………….125% hra20% what is my new payscale

  108. meghna says:

    my father is retired in march 1997. his basic pay is 10,487. according to 7th pay commission please let me know the latest figures. thankyou

  109. Nishikanta Debbarma says:

    We are working as Laboratory Assistant in a Central University. Joining month May’2016. Please reply us what will be our Basic Pay as per 7CPC.
    Starting Basic Pay (May’2016) = Rs.8460/- (with Rs.2000/- G.P)
    Pay fixation table shows minimum Rs.21700/- in our level.
    So what will be our balance amount of Rs.42/-

  110. D N Mathur says:

    I am retired pensioner .my basic pay is 8445 da 10557 medical 500 total 19502 grade pay 4200 what will be my pension as per 7 pay commission.p lease gave us calculation

  111. Shan says:

    Dear aashu,
    I got my promotion in the month of may 2016 and my grade pay is upgraded from 2800 to 4200. My basic pay after 3% increment in july 2016 is 12140 + 4200 grade pay makes total 16340. I want to opt my fixation only from july 2016 not from jan. What would be my revised basic pay as per 7th pay.

  112. aashu says:

    Dear Shan…ur new basic as on 01.07.16 would be Rs.42300……pl share us on facebook…thanks

  113. sukhdev singh says:

    Sir I am retire 01.12.2015. May basic pension is 6735.get my new 7cpc pension

  114. Hanuman S says:

    Sir my basic (11010+4200=15210) on 01/01/2016 and I was promoted as 4600Gp on 27/05/2016
    I got 2 increment ( annual+ promotional) in july16
    now my basic (11940+4600+16540) in july16 payment
    Pls.tell me my basic in 7 CPC & which increment would be beneficiary for me 1 Jan.or 1 July
    my WhatsApp 9004411299

  115. vinay kumar says:

    Sir my besic pay 7260 and grad pay 2000 my new besic pay

  116. Jagdev singh says:

    Basic pay 8500

  117. Hav. Jagdev singh says:

    Sir my basic pay is 8500 i am pension

Leave a Reply

Your email address will not be published. Required fields are marked *