Income Tax calculation Excel sheet for Government Employees
Income Tax calculation Excel sheet for Government Employees 2025

Income Tax Calculation Sheet specifically for Financial Year 2025-26 (Assessment Year 2026-27) for Government Employees in India. This is excellent, as the Union Budget 2025 has introduced significant changes for this upcoming financial year, particularly for the New Tax Regime.

Here’s an updated and comprehensive guide and calculation sheet, incorporating the latest changes for FY 2025-26.


Income Tax Calculation Sheet for Government Employees (FY 2025-26 / AY 2026-27)

This document is designed to help government employees in India calculate their income tax liability for the Financial Year 2025-26 (Assessment Year 2026-27). It covers both the Old and the New Tax Regimes, considering the recent amendments.

Key Changes for FY 2025-26 (AY 2026-27) from Budget 2025:

Step 1: Determine Your Gross Salary

Your gross salary for a government employee typically includes:

  • Basic Pay
  • Dearness Allowance (DA)
  • House Rent Allowance (HRA) (if applicable)
  • Transport Allowance (TA)
  • Special Pay
  • Any other allowances received (e.g., Medical Allowance, Children Education Allowance, etc.)

Gross Salary = Basic Pay + DA + HRA + TA + Other Allowances

Step 2: Choose Your Tax Regime

You have the option to choose between the Old Tax Regime and the New Tax Regime. It is advisable to calculate your tax liability under both regimes and choose the one that results in lower tax.

A. Old Tax Regime

The Old Tax Regime allows you to claim various deductions and exemptions to reduce your taxable income. This regime is often beneficial for those who make significant investments and incur eligible expenses.

1. Deductions and Exemptions (Under Old Tax Regime Only)

2. Calculate Taxable Income (Old Tax Regime)

Taxable Income = Gross Salary – (Standard Deduction + HRA Exemption + Other Exemptions + Chapter VI-A Deductions + Section 24(b) Deduction)

3. Old Tax Regime Slabs (AY 2026-27 / FY 2025-26)

Income Slab (Individuals < 60 years)Income Tax Rate
Up to ₹ 2,50,000Nil
₹ 2,50,001 to ₹ 5,00,0005%
₹ 5,00,001 to ₹ 10,00,00020%
Above ₹ 10,00,00030%

Export to Sheets

Income Slab (Senior Citizens 60 to < 80 years)Income Tax Rate
Up to ₹ 3,00,000Nil
₹ 3,00,001 to ₹ 5,00,0005%
₹ 5,00,001 to ₹ 10,00,00020%
Above ₹ 10,00,00030%

Export to Sheets

Income Slab (Super Senior Citizens ≥ 80 years)Income Tax Rate
Up to ₹ 5,00,000Nil
₹ 5,00,001 to ₹ 10,00,00020%
Above ₹ 10,00,00030%

Export to Sheets

4. Rebate under Section 87A (Old Regime)

  • If your net taxable income (after all deductions) is up to ₹ 5,00,000, you are eligible for a tax rebate of up to ₹ 12,500. This effectively makes income up to 5,00,000 tax-free.

B. New Tax Regime (Default Regime with Revised Slabs)

The New Tax Regime offers lower tax rates and simplified compliance by allowing very few exemptions and deductions. It is the default regime from AY 2024-25 onwards.

1. Allowed Deductions/Exemptions (Under New Tax Regime)

  • Standard Deduction: For salaried individuals and pensioners, a standard deduction of ₹ 75,000 is allowed.
  • Employer’s contribution to NPS [Section 80CCD(2)]: Up to 14% of basic salary for central government employees and 10% for other employees.
  • Deduction for Agniveer Corpus Fund [Section 80CCH(2)]: Any amount paid to the Agniveer Corpus Fund will be deductible from the total income of the Agniveer.
  • Family Pension: A deduction of ₹ 25,000 or one-third of the family pension, whichever is less. (Increased from ₹ 15,000 in previous years)

2. Calculate Taxable Income (New Tax Regime)

Taxable Income = Gross Salary – (Standard Deduction + Employer’s NPS Contribution + Agniveer Corpus Fund + Family Pension Deduction)

3. New Tax Regime Slabs (AY 2026-27 / FY 2025-26)

The Union Budget 2025 has revised the New Tax Regime slabs significantly:

Income Slab (All Individuals)Income Tax Rate
Up to ₹ 4,00,000Nil
₹ 4,00,001 to ₹ 8,00,0005%
₹ 8,00,001 to ₹ 12,00,00010%
₹ 12,00,001 to ₹ 16,00,00015%
₹ 16,00,001 to ₹ 20,00,00020%
₹ 20,00,001 to ₹ 24,00,00025%
Above ₹ 24,00,00030%

Export to Sheets

4. Rebate under Section 87A (New Regime)

  • A major change for FY 2025-26: If your net taxable income (after allowed deductions) is up to ₹ 12,00,000, you are eligible for a tax rebate of up to ₹ 60,000. This effectively makes income up to ₹ 12,00,000 tax-free under the new regime.

Step 3: Calculate Income Tax

Apply the relevant tax slab rates to your calculated taxable income under your chosen regime.

Step 4: Add Surcharge (if applicable)

Surcharge is levied on the income tax amount if your total income exceeds certain limits. Note that the surcharge rates and thresholds are generally the same for both regimes, but the maximum surcharge in the New Regime is capped at 25% for very high incomes.

  • For both Old & New Regimes:
    • Total income > ₹ 50 Lakhs up to ₹ 1 Crore: 10% of income tax
    • Total income > ₹ 1 Crore up to ₹ 2 Crore: 15% of income tax
  • For Old Regime Only:
    • Total income > ₹ 2 Crore up to ₹ 5 Crore: 25% of income tax
    • Total income > ₹ 5 Crore: 37% of income tax
  • For New Regime Only:
    • Total income > ₹ 2 Crore: 25% of income tax (This means the 37% surcharge rate is not applicable in the new regime).

Step 5: Add Health & Education Cess

A 4% Health and Education Cess is levied on the income tax (including surcharge, if any) in both regimes.

Total Tax Payable = Income Tax + Surcharge (if applicable) + Health & Education Cess


Income Tax Calculation Sheet Template

Here’s a template you can use for your article. Consider providing this as a downloadable Excel sheet for your users!

Income Tax Calculation Sheet for Government Employees (FY 2025-26 / AY 2026-27)

Employee Details:


PART A: Income Details

Sr. No.ParticularsAmount (₹)
1.Basic Pay
2.Dearness Allowance (DA)
3.House Rent Allowance (HRA) Received
4.Transport Allowance (TA)
5.Special Pay / Other Allowances
6.Gross Salary (Total of 1-5)
7.Income from House Property (Rent Received – Municipal Taxes – 30% Standard Deduction – Home Loan Interest)
8.Income from Other Sources (e.g., Bank Interest, Dividends, Family Pension)
9.Gross Total Income (6 + 7 + 8)

Export to Sheets


PART B: Tax Calculation – Old Tax Regime

Sr. No.ParticularsAmount (₹)
1.Gross Salary (from A.6)
2.Less: Standard Deduction50,000
3.Less: HRA Exemption (Calculate as per rules, max as per formula or actual received)
4.Less: Professional Tax Paid
5.Income from Salary (1 – 2 – 3 – 4)
6.Add: Income from House Property (from A.7)
7.Less: Interest on Home Loan for Self-occupied Property [Sec 24(b)] (Max ₹ 2,00,000)
8.Add: Income from Other Sources (from A.8)
9.Gross Total Income (for Old Regime)
10.Less: Deductions under Chapter VI-A
– Sec 80C (Max ₹ 1,50,000)
– Sec 80CCD(1B) (NPS, Max ₹ 50,000)
– Sec 80D (Health Insurance)
– Sec 80E (Education Loan Interest)
– Sec 80G (Donations)
– Sec 80TTA/80TTB (Interest on Savings/FD)
– Other applicable deductions
11.Total Deductions (Sec 80C to 80U)
12.Net Taxable Income (9 – 11)
13.Tax on Net Taxable Income (as per Old Regime Slabs)
14.Less: Rebate under Sec 87A (if applicable, Max ₹ 12,500 for income up to ₹ 5L)
15.Add: Surcharge (if applicable, refer rates above)
16.Add: Health & Education Cess @ 4%
17.Total Tax Payable (Old Regime)

Export to Sheets


PART C: Tax Calculation – New Tax Regime

Sr. No.ParticularsAmount (₹)
1.Gross Salary (from A.6)
2.Less: Standard Deduction (for salaried)75,000
3.Less: Employer’s NPS Contribution [80CCD(2)]
4.Less: Agniveer Corpus Fund [80CCH(2)]
5.Less: Family Pension Deduction (Max ₹ 25,000 or 1/3rd)
6.Income from Salary (1 – 2 – 3 – 4 – 5)
7.Add: Income from House Property (from A.7)
8.Add: Income from Other Sources (from A.8)
9.Net Taxable Income (6 + 7 + 8)
10.Tax on Net Taxable Income (as per New Regime Slabs, FY 2025-26)
11.Less: Rebate under Sec 87A (if applicable, Max ₹ 60,000 for income up to ₹ 12L)
12.Add: Surcharge (if applicable, refer rates above)
13.Add: Health & Education Cess @ 4%
14.Total Tax Payable (New Regime)

Export to Sheets


PART D: Comparison and Recommendation

RegimeTotal Tax Payable (₹)
Old Tax Regime
New Tax Regime

Export to Sheets

Recommendation: Choose the regime where your “Total Tax Payable” is lower.


Important Notes for Government Employees:

  • Form 16: Always refer to your Form 16 issued by your DDO (Drawing and Disbursing Officer). This form provides a summary of your salary, perquisites, allowed exemptions, and TDS (Tax Deducted at Source).
  • Proof of Investments/Expenses: If you opt for the Old Tax Regime, ensure you have all the necessary proofs for deductions and exemptions (e.g., rent receipts, LIC premium receipts, PPF passbook, home loan interest certificates, medical bills, etc.). These must be submitted to your DDO for TDS purposes and also kept for your records.
  • ITR Form:
    • Most salaried government employees will file ITR-1 (Sahaj) if their total income is up to ₹ 50 lakhs and includes income from salary, one house property, and other sources (like interest).
    • If you have capital gains, multiple house properties, foreign income/assets, or income exceeding ₹ 50 lakhs, you may need to file ITR-2.
  • Due Dates: The due date for filing Income Tax Returns for salaried individuals for FY 2025-26 (AY 2026-27) is generally July 31, 2026, unless extended by the government.
  • Marginal Relief: If your income just crosses a surcharge threshold, you may be eligible for marginal relief, which limits the increase in tax payable to the amount of income exceeding the threshold.
  • Official Sources: Tax laws are subject to changes. Always verify information with official government sources like the Income Tax Department website (incometax.gov.in) and the Finance Act for the respective financial year.

This detailed breakdown, along with the template, will provide a clear and actionable guide for government employees calculating their income tax for FY 2025-26.