How to Calculate Pakistan Income Tax in Excel with IF Formulas

Step-by-step tutorial on calculating Pakistan salary tax in Excel using nested IF, IFS, and VLOOKUP formulas for Tax Year 2026. Includes copy-paste ready formulas.

By Syed Asad Hussain Zaidi · 7 September 2026

How to Calculate Pakistan Income Tax in Excel with IF Formulas Author Note / Last Updated: Updated September 2026 by Syed Asad Hussain Zaidi | Advocate High Court | Professional Tax Consultant Calculating salary withholding tax in Microsoft Excel is an essential skill for payroll accountants, HR managers, and salaried individuals in Pakistan. Under the Finance Act 2026 (Tax Year 2026 / 2027), the Federal Board of Revenue (FBR) enforces progressive slab rates on salaried income under Division I, Part I of the First Schedule to the Income Tax Ordinance, 2001. If you attempt to calculate monthly payroll deductions manually across dozens or hundreds of employees, human error is inevitable. This master guide provides the exact mathematical framework, copy-paste ready nested formulas, modern formulas, and the progressive lookup method to automate your Pakistan income tax calculations in Excel with 100% accuracy. --- Statutory Salary Tax Slabs (Tax Year 2026 Framework) Before writing any Excel formula, you must understand the exact progressive brackets mandated by the FBR for salaried individuals (where salary constitutes more than 75% of total taxable income): | Taxable Annual Income Bracket (PKR) | Fixed Base Tax (PKR) | Marginal Tax Rate | Applicable Excess Amount | | :--- | :--- | :--- | :--- | | Up to 600,000 | Rs. 0 | 0% | Nil | | 600,001 to 1,200,000 | Rs. 0 | 5% | Amount exceeding Rs. 600,000 | | 1,200,001 to 2,200,000 | Rs. 30,000 | 15% | Amount exceeding Rs. 1,200,000 | | 2,200,001 to 3,200,000 | Rs. 180,000 | 25% | Amount exceeding Rs. 2,200,000 | | 3,200,001 to 4,100,000 | Rs. 430,000 | 30% | Amount exceeding Rs. 3,200,000 | | Exceeding 4,100,000 | Rs. 700,000 | 35% | Amount exceeding Rs. 4,100,000 | Note: For annual taxable income exceeding Rs. 10,000,000, a high-earner surcharge of 10% applies on the computed income tax under the Finance Act. --- Method 1: The Classic Nested IF Formula in Excel The nested 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 contains the Annual Taxable Salary in PKR. Copy-Paste Excel Formula: Formula Logic Breakdown: : Applies Rs. 700,000 plus 35% on every rupee above 4.1 million. : Applies Rs. 430,000 plus 30% on the excess above 3.2 million. : Applies Rs. 180,000 plus 25% on the excess above 2.2 million. : Applies Rs. 30,000 plus 15% on the excess above 1.2 million. : Applies 5% on the excess above Rs. 600,000. : Returns (tax-exempt threshold). --- Method 2: The Modern IFS Formula (Excel 2019, 2021 & Microsoft 365) If you are using Microsoft 365 or Excel 2019/2021, the function eliminates the need for deeply nested parentheses, making the formula significantly cleaner and easier to audit during financial reviews. Copy-Paste Excel Formula: --- Calculating Monthly Withholding Tax from Monthly Salary In real-world payroll, HR departments receive monthly gross salaries rather than annual figures. Because Pakistan tax law requires withholding tax under Section 149 to be calculated on the projected annual income and then divided by 12, here is the direct monthly formula. Assumption: Cell contains the Monthly Taxable Salary. Monthly Tax Formula: --- Handling Mandatory Payroll Exemptions in Excel A common payroll mistake is calculating tax directly on the employee's gross salary without adjusting for statutory exemptions under the Second Schedule to the Income Tax Ordinance. 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 insurance scheme. Excel Formula for Taxable Salary: Provident Fund Deductions Contributions to a recognized provident fund (RPF) and interest credited up to the prescribed threshold are exempt from tax and must not be inflated into taxable gross income. --- High-Earner Surcharge Formula (Income > Rs. 10 Million) Under Finance Act 2026, if an employee's annual taxable salary exceeds Rs. 10,000,000, a 10% surcharge is levied on the computed income tax. Formula with Surcharge Incorporated: --- Practical Comparison Table: Monthly Salary vs. Tax Withheld Use this reference table to verify your spreadsheet calculations against official FBR rates: | 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 | 15,000 | 1,250 | 1.67% | | 100,000 | 1,200,000 | 30,000 | 2,500 | 2.50% | | 150,000 | 1,800,000 | 120,000 | 10,000 | 6.67% | | 200,000 | 2,400,000 | 230,000 | 19,167 | 9.58% | | 300,000 | 3,600,000 | 550,000 | 45,833 | 15.28% | | 400,000 | 4,800,000 | 945,000 | 78,750 | 19.69% | | 500,000 | 6,000,000 | 1,365,000 | 113,750 | 22.75% | --- Summary: Best Practices for Corporate Payroll Always annualize first: Never calculate marginal tax rates on monthly tiers directly without multiplying by 12, or seasonal bonuses will be taxed in incorrect brackets. Track Section 149 Certificates: Ensure that employees who adjust advance tax paid on private vehicles (Section 231B/234) or cellular telephone bills (Section 236) submit authentic withholding receipts before payroll deduction adjustments. Use TaxCalc for instant online verification: You can always verify your company payroll computations against our live Salary Tax Calculator or test reverse gross-up figures via our Reverse Salary Tax Calculator. --- Disclaimer: Tax rates and slabs are established by the Parliament of Pakistan through annual Finance Acts and circulars issued by the FBR. While this guide provides verified formulas for Tax Year 2026, always verify calculations with a qualified chartered accountant or tax advocate before issuing statutory annual withholding certificates.