7th Pay Commission salary calculator in Excel (free download, October 2026): download this simple Excel sheet, enter your basic pay and a few details, and it works out your DA at 60%, HRA, transport allowance, gross salary, NPS, CGHS, professional tax and net in-hand pay, using the current Central Government rates.
.webp)
What the Excel Calculator Does
A single sheet: you fill in seven yellow cells, and it shows your monthly salary and deductions.
| You enter | It calculates |
|---|---|
| Basic pay, DA rate, HRA city (X, Y, Z or None), transport allowance, NPS (Yes or No), CGHS and professional tax | DA, HRA (with its minimum), DA on TA, gross salary, NPS at 10% of basic + DA, total deductions and net in-hand salary |
How to Use the 7th Pay Commission Salary Calculator in Excel
- Download the file and open it in Excel, Google Sheets or LibreOffice Calc.
- Enter your basic pay from your pay slip, and keep DA at 60% or enter the latest rate.
- Choose your HRA city: X, Y, Z, or None if you live in Government accommodation.
- Enter your transport allowance from the table below, and your CGHS and professional tax.
- Choose Yes or No for NPS/UPS, and read your gross and net salary.
7th CPC Salary Components and Current Rates
| Component | Current rate |
|---|---|
| Basic pay | From your pay slip or the 7th CPC pay matrix (Level 1 starts at ₹18,000, Level 18 is ₹2,50,000) |
| Dearness allowance | 60% of basic pay from 1 January 2026 |
| HRA | X 30%, Y 20%, Z 10% of basic; minimum ₹5,400 / ₹3,600 / ₹1,800 |
| Transport allowance | Level 9+: ₹7,200 / ₹3,600; Levels 3-8: ₹3,600 / ₹1,800; Levels 1-2: ₹1,350 / ₹900 (₹3,600 / ₹1,800 at basic pay of ₹24,200 or more); higher TPTA city / other city; plus DA on TA |
| NPS / UPS | Employee 10% of basic + DA; Government 14% (NPS), shown separately |
| CGHS | ₹250 (Levels 1-5), ₹450 (Level 6), ₹650 (Levels 7-11), ₹1,000 (Level 12+) a month |
| Professional tax | Set by your state |
Rates: HRA and transport allowance under the Department of Expenditure OMs of 7 July 2017; DA from 1 January 2026 approved by the Cabinet on 18 April 2026.
Sample 7th Pay Commission Salary Calculation
The calculator's example: Level 7, cell 1, X city, higher TPTA city, NPS and CGHS, professional tax ₹200:
| Item | Working | Amount |
|---|---|---|
| Basic pay | Level 7, cell 1 | ₹44,900 |
| DA | 60% × ₹44,900 | ₹26,940 |
| HRA | 30% × ₹44,900 | ₹13,470 |
| Transport allowance + DA on TA | ₹3,600 + 60% | ₹5,760 |
| Gross salary | ₹91,070 | |
| NPS | 10% × (₹44,900 + ₹26,940) | ₹7,184 |
| CGHS + professional tax | ₹650 + ₹200 | ₹850 |
| Net in-hand salary | ₹83,036 |
No income tax is due at this pay under the new regime (annual taxable income ₹10.18 lakh, under ₹12 lakh). In a Y city, HRA falls to ₹8,980; in a Z city, to ₹4,490.
How Increments and Promotions Change Your Salary
The annual increment moves you one cell down your level, about 3% more basic pay, on 1 January or 1 July. Level 7 cell 1 (₹44,900) becomes cell 2 (₹46,200). On promotion or MACP you get one increment in your level and are placed in the same or next higher cell of the new level. In the Excel sheet, enter the new basic pay to see the new salary. To find your next cell and promotion pay, use the 7th Pay Matrix calculator.
Excel vs Online Salary Calculator
| Feature | Excel calculator | Online calculator |
|---|---|---|
| Works offline | Yes | No |
| Basic pay | You enter it | Pick your level and cell |
| Transport allowance and CGHS | You enter them | Worked out from your level |
| Professional tax | You enter it | Every state's schedule built in |
| Income tax | Not included | New regime estimate |
For the full calculation with income tax, use the 7th Pay Commission salary calculator online; for the same inputs, both give the same salary before tax.
Make Your Own 7th CPC Salary Calculator in Excel
To build your own sheet, put basic pay in B2 and DA rate in B3 (as 60%), then use these formulas (X city shown; change 30% and 5,400 for Y or Z):
DA =ROUND(B2*B3,0) HRA (X city) =ROUND(MAX(B2*30%,5400),0) TA (Level 9+, higher TPTA city) =7200 DA on TA =ROUND(TA*B3,0) Gross =B2+DA+HRA+TA+DA_on_TA NPS =ROUND((B2+DA)*10%,0) Net =Gross-NPS-CGHS-Professional_tax-Income_taxThe downloadable file already has these formulas, and also switches the HRA rate automatically with the DA rate (24/16/8% below 25% DA, 27/18/9% from 25%, 30/20/10% from 50%).
About the Excel Calculator
How the Figures Were Checked
The sheet was tested against the HR Calcy online calculator for five cases, from Level 1 to Level 12, X, Y and Z cities, no HRA, and DA below 25%, and gives the same gross and net salary before tax.
Assumptions and Limitations
- For Central Government civilian employees on the 7th CPC pay matrix. State employees follow their own pay matrix and rates.
- Income tax, special allowances and other deductions are not included.
- Your pay slip decides the actual figures.
Keeping the File Up to Date
When DA changes, enter the new rate in the DA cell; the HRA rate changes with it. After an increment or promotion, enter your new basic pay.
Frequently Asked Questions
Is the 7th Pay Commission salary calculator Excel free?
Yes. Download the .xlsx file from this page; no sign-up is needed. It works in Microsoft Excel, Google Sheets and LibreOffice Calc.
Which DA rate does the Excel calculator use?
60% of basic pay, the rate from 1 January 2026. Enter a new rate in the DA cell when the next instalment is announced; HRA updates with it.
Is this calculator applicable to all government employees?
It is for Central Government civilian employees on the 7th CPC pay matrix. State government employees have their own pay matrix and DA, so their figures differ.
Does the Excel calculator include income tax?
No. It shows salary before income tax. For a new-regime tax estimate, use the HR Calcy 7th Pay Commission salary calculator online.
What if my pay level changes after promotion?
Enter your new basic pay in the sheet. On promotion, pay is one increment in your old level, placed in the same or next higher cell of the new level.
Can I use this Excel calculator for pension?
No. It works out salary. For pension, DR and commutation, use the HR Calcy pension calculator.
Can it calculate DA arrears?
No. It shows the monthly DA at the rate you enter. For month-wise arrears of a DA hike, use the DA arrears calculator.
Are the results official?
They are estimates using the official rates. Your actual salary depends on your pay slip, any special allowances and your income tax.