TaxCalc.pk FY 2026-27

Pakistan Salary Tax In Excel: FY 2026–27 Formulas

Calculate Pakistan salary tax in Excel with verified FY 2026–27 formulas, worked examples and checks at each tax-slab boundary.

By Syed Asad Hussain Zaidi · 7 September 2026

Author Note / Last Updated: Updated for Tax Year 2027 (FY 2026–27) by Syed Asad Hussain Zaidi | Advocate High Court | Professional Tax Consultant

Calculating salary withholding tax in Microsoft Excel is an essential workflow for payroll accountants, HR managers, and finance professionals in Pakistan. Under the Finance Act 2026 (Tax Year 2027: 1 July 2026 to 30 June 2027), the Federal Board of Revenue (FBR) enforces an eight-bracket progressive slab schedule on salaried income under Division I, Part I of the First Schedule to the Income Tax Ordinance, 2001.

This guide provides copy-paste ready nested IF, modern IFS, and LET formulas for Microsoft Excel, complete with worked calculations and verification at each tax-slab boundary.

1. Statutory Salary Tax Slabs (Tax Year 2027 Framework)

Before writing formulas in Excel, ensure your logic reflects the enacted eight-tier progressive schedule for salaried individuals (where salary exceeds 75% of total taxable income):

| Taxable Annual Income Bracket (PKR) | Fixed Base Tax (PKR) | Marginal Tax Rate | Applicable Excess Calculation | | :--- | :--- | :--- | :--- | | Up to 600,000 | Rs. 0 | 0% | Nil | | 600,001 to 1,200,000 | Rs. 0 | 1% | Amount exceeding Rs. 600,000 | | 1,200,001 to 2,200,000 | Rs. 6,000 | 11% | Amount exceeding Rs. 1,200,000 | | 2,200,001 to 3,200,000 | Rs. 116,000 | 20% | Amount exceeding Rs. 2,200,000 | | 3,200,001 to 4,100,000 | Rs. 316,000 | 25% | Amount exceeding Rs. 3,200,000 | | 4,100,001 to 5,600,000 | Rs. 541,000 | 29% | Amount exceeding Rs. 4,100,000 | | 5,600,001 to 7,000,000 | Rs. 976,000 | 32% | Amount exceeding Rs. 5,600,000 | | Exceeding 7,000,000 | Rs. 1,424,000 | 35% | Amount exceeding Rs. 7,000,000 |

Note on Surcharge: Section 4AB high-income surcharge on salaried individuals was abolished under Finance Act 2026 (0% surcharge on salaried income).

2. Method 1: The Classic Nested IF Formula in Excel

The nested IF structure evaluates the employee's taxable annual salary in descending order (highest bracket to lowest bracket). This ensures that each condition triggers only when the taxable salary crosses into that specific marginal tax band.

Assumption:

Cell A2 contains the Annual Taxable Salary in PKR.

Copy-Paste Excel Formula:

=IF(A2>7000000, 1424000 + (A2-7000000)*0.35,
IF(A2>5600000, 976000 + (A2-5600000)*0.32, IF(A2>4100000, 541000 + (A2-4100000)*0.29, IF(A2>3200000, 316000 + (A2-3200000)*0.25, IF(A2>2200000, 116000 + (A2-2200000)*0.20, IF(A2>1200000, 6000 + (A2-1200000)*0.11, IF(A2>600000, (A2-600000)*0.01, 0)))))))

Formula Logic Breakdown:

A2 > 7,000,000: Base Rs. 1,424,000 plus 35% on every rupee above 7 million.
A2 > 5,600,000: Base Rs. 976,000 plus 32% on the excess above 5.6 million.
A2 > 4,100,000: Base Rs. 541,000 plus 29% on the excess above 4.1 million.
A2 > 3,200,000: Base Rs. 316,000 plus 25% on the excess above 3.2 million.
A2 > 2,200,000: Base Rs. 116,000 plus 20% on the excess above 2.2 million.
A2 > 1,200,000: Base Rs. 6,000 plus 11% on the excess above 1.2 million.
A2 > 600,000: Applies 1% on the excess above Rs. 600,000.
Else (≤ 600,000): Returns 0 (tax-exempt threshold).

3. Method 2: The Modern IFS Formula (Excel 2019, 2021 & Microsoft 365)

If you are using Microsoft 365 or Excel 2019/2021, the IFS function provides a clean, sequential evaluation without nested closing parentheses.

Copy-Paste Excel Formula:

=IFS(
A2<=600000, 0, A2<=1200000, (A2-600000)*0.01, A2<=2200000, 6000 + (A2-1200000)*0.11, A2<=3200000, 116000 + (A2-2200000)*0.20, A2<=4100000, 316000 + (A2-3200000)*0.25, A2<=5600000, 541000 + (A2-4100000)*0.29, A2<=7000000, 976000 + (A2-5600000)*0.32, A2>7000000, 1424000 + (A2-7000000)*0.35 )

4. Calculating Monthly Withholding Tax from Monthly Salary

In corporate payroll, compensation is typically entered as a monthly figure. Under Section 149, tax withholding is determined by annualizing monthly earnings, applying the statutory brackets, and dividing the resulting tax by 12.

Assumption:

Cell B2 contains the Monthly Taxable Salary.

Monthly Tax Formula:

=ROUND((
IF(B212>7000000, 1424000 + (B212-7000000)*0.35, IF(B212>5600000, 976000 + (B212-5600000)*0.32, IF(B212>4100000, 541000 + (B212-4100000)*0.29, IF(B212>3200000, 316000 + (B212-3200000)*0.25, IF(B212>2200000, 116000 + (B212-2200000)*0.20, IF(B212>1200000, 6000 + (B212-1200000)*0.11, IF(B212>600000, (B212-600000)*0.01, 0))))))) )/12, 0)

5. Handling Mandatory Payroll Exemptions in Excel

Tax withholding should be calculated on taxable salary, not total gross package. The following statutory deductions apply:

1. Medical Allowance Exemption (Clause 139, Part I, Second Schedule)

Medical allowance provided by an employer is exempt up to 10% of basic salary, provided the employee is not covered under an employer-funded medical reimbursement or hospitalization scheme.

Excel Formula for Taxable Salary:

=GrossSalary - IF(HasMedicalInsurance, 0, MIN(MedicalAllowance, BasicSalary*0.10))

2. Provident Fund Deductions

Contributions to a recognized provident fund (RPF) and interest credited within statutory limits are exempt and should not be added to taxable salary.

6. Modern LET Formula for Microsoft 365

The LET function assigns names to calculation steps, improving formula performance and readability across large payroll sheets:

=LET(
salary, A2, annualTax, IF(salary>7000000, 1424000 + (salary-7000000)*0.35, IF(salary>5600000, 976000 + (salary-5600000)*0.32, IF(salary>4100000, 541000 + (salary-4100000)*0.29, IF(salary>3200000, 316000 + (salary-3200000)*0.25, IF(salary>2200000, 116000 + (salary-2200000)*0.20, IF(salary>1200000, 6000 + (salary-1200000)*0.11, IF(salary>600000, (salary-600000)*0.01, 0))))))), annualTax )

7. Practical Reference Table: Monthly Salary vs. Tax Withheld

Verify your Excel formulas against these benchmark figures for Tax Year 2027:

| Monthly Gross Salary (PKR) | Projected Annual Salary (PKR) | Annual Income Tax (PKR) | Monthly Withholding Tax (PKR) | Effective Tax Rate | | :--- | :--- | :--- | :--- | :--- | | 50,000 | 600,000 | 0 | 0 | 0.00% | | 75,000 | 900,000 | 3,000 | 250 | 0.33% | | 100,000 | 1,200,000 | 6,000 | 500 | 0.50% | | 150,000 | 1,800,000 | 72,000 | 6,000 | 4.00% | | 200,000 | 2,400,000 | 156,000 | 13,000 | 6.50% | | 250,000 | 3,000,000 | 276,000 | 23,000 | 9.20% | | 300,000 | 3,600,000 | 416,000 | 34,667 | 11.56% | | 400,000 | 4,800,000 | 744,000 | 62,000 | 15.50% | | 500,000 | 6,000,000 | 1,104,000 | 92,000 | 18.40% | | 600,000 | 7,200,000 | 1,494,000 | 124,500 | 20.75% |

Related Tools

To test individual income scenarios and compare take-home pay, see the TaxCalc.pk Salary Tax Calculator or read the comprehensive Pakistan Salary Tax Slabs 2026–27 Guide.

Legal & Statutory Notice: The information provided in this publication is for general educational, academic, and statutory informational purposes only under the relevant laws of Pakistan (including the Income Tax Ordinance, 2001, the Companies Act, 2017, and the Trade Marks Ordinance, 2001). This content does not constitute formal legal, financial, or tax advice. For specific assessments, consult a licensed Advocate or qualified tax professional.

#taxcalc-loading-shell { display: none !important; } #prerender-content { position: static !important; width: auto !important; height: auto !important; clip: auto !important; overflow: visible !important; white-space: normal !important; margin: 0 auto !important; padding: 24px 16px !important; } .noscript-wrap { max-width: 860px; margin: 32px auto; padding: 28px 24px; font-family: 'Outfit', -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, sans-serif; color: #0f172a; background: #ffffff; border: 1px solid #e2e8f0; border-radius: 16px; box-shadow: 0 4px 20px rgba(15, 23, 42, 0.06); line-height: 1.6; } @media (prefers-color-scheme: dark) { .noscript-wrap { background: #1e293b; color: #f8fafc; border-color: #334155; } .noscript-wrap a { color: #34d399 !important; } .noscript-table th { background: #0f172a !important; color: #f8fafc !important; } .noscript-table td { border-color: #334155 !important; } } .noscript-table { width: 100%; border-collapse: collapse; margin: 20px 0; font-size: 0.875rem; } .noscript-table th, .noscript-table td { padding: 10px 14px; border: 1px solid #e2e8f0; text-align: left; } .noscript-table th { background: #f1f5f9; font-weight: 700; } .noscript-badge { display: inline-block; padding: 3px 10px; font-size: 0.75rem; font-weight: 700; border-radius: 999px; background: rgba(16, 185, 129, 0.15); color: #047857; margin-bottom: 12px; }

FBR Finance Act 2026 · Tax Year 2027

TaxCalc.pk — Pakistan Tax Calculator & Statutory Compliance Hub

Reviewed by Syed Asad Hussain Zaidi, Advocate High Court, LLM, Member Lahore Tax Bar Association.

Official Salaried Tax Slabs (FY 2026-27 / Tax Year 2027)

Under the First Schedule, Part I, Division I of the Income Tax Ordinance, 2001 (as amended by Finance Act 2026):

Taxable Income Slab (Annual)	Statutory Rate & Fixed Tax
Up to Rs. 600,000	0% (Exempt)
Rs. 600,001 to Rs. 1,200,000	1% of the amount exceeding Rs. 600,000
Rs. 1,200,001 to Rs. 2,200,000	Rs. 6,000 + 11% of the amount exceeding Rs. 1,200,000
Rs. 2,200,001 to Rs. 3,200,000	Rs. 116,000 + 20% of the amount exceeding Rs. 2,200,000
Rs. 3,200,001 to Rs. 4,100,000	Rs. 316,000 + 25% of the amount exceeding Rs. 3,200,000
Rs. 4,100,001 to Rs. 5,600,000	Rs. 541,000 + 29% of the amount exceeding Rs. 4,100,000
Rs. 5,600,001 to Rs. 7,000,000	Rs. 976,000 + 32% of the amount exceeding Rs. 5,600,000
Exceeding Rs. 7,000,000	Rs. 1,424,000 + 35% of the amount exceeding Rs. 7,000,000

Pakistan Tax Calculators & Statutory Resources Directory

Explore our authoritative calculation tools and advocate-led compliance guidance:

Salary, Business & AOP Tax Calculator — Full progressive slab computation with VPS relief.
Property WHT Calculator (236C / 236K) — Advance withholding on purchase and sale.
Rent Withholding Tax Calculator (Section 155) — Monthly & annual gross rent withholding.
Freelancer & IT Export Tax Calculator (154A) — 0.25% PSEB concessionary vs 1% regime.
Corporate & Small Company Tax Calculator — 29% normal, 20% small company, 1.25% minimum tax.
Super Tax Calculator (Section 4C) — High-earner progressive slabs above Rs. 500M.
Tax Slabs Schedule (FY 2026-27 & FY 2025-26) — Comprehensive rate tables.
Accuracy & Sources Framework — Governing legal sections, Gazette sources, and assumptions.
Advocate-Led Income Tax Filing Services — Formal IRIS return preparation and submission.
Contact Tax Practice (Lahore Office & Remote) — Advocate consultation and FBR support.

Notice: Official Pakistan statutory tax schedules and advisory resources. Enable JavaScript to use the interactive progressive salary, AOP, property, and corporate calculators.