Income Tax Calculator Excel Pakistan 2026-27
Download the free Excel income tax calculator for Pakistan to work out salary tax offline. It applies the official FBR slabs for 2026-27, 2025-26 and 2024-25, so for 2026-27 income up to Rs 600,000 pays nothing and rates then rise from 1% to 35%. Change salary, bonus or Zakat and the formulas update.
Download a free Excel income tax calculator for Pakistan with the official FBR slabs for 2026-27, 2025-26 and 2024-25. Every number is a live formula, so you can change the salary, bonus or Zakat and see the tax update instantly. Prefer an online tool? Use the salary tax calculator.
- Salary tax for 2026-27, 2025-26 and 2024-25 in one sheet
- Bonus and Zakat inputs
- Business (non-salaried) tax row
- Slab tables on separate sheets you can edit
- Formulas you can copy into your own payroll sheet
Download the Excel tax calculator
A free .xlsx workbook with live formulas: enter your salary once and see tax for 2026-27, 2025-26 and 2024-25 side by side, plus non-salaried business tax.
- ✓ Finance Act 2026 rates
- ✓ Tax Year 2027 (1 July 2026 – 30 June 2027)
- ✓ Free & private
- ✓ Last reviewed 31 October 2026
- ✓ Written by Salma Rahim, Chartered Accountant
What’s Inside the Excel Tax Calculator
Calculator sheet
Enter monthly salary, bonus and Zakat. It shows annual tax, monthly tax, monthly take-home and effective rate for each year, including the 2025-26 and 2024-25 surcharges above Rs 10 million.
Slab sheets
One sheet per tax year, with each slab’s starting income, fixed amount and rate. Update a sheet when a new Finance Act changes the rates and the calculator follows.
Business sheet
Non-salaried slabs for business individuals and AOPs, with the 10% surcharge above Rs 10 million, so you can compare salary and business tax.
How to Make a Tax Calculator in Excel
- Make a slab table with three columns: From (start of slab), Fixed (tax at the start) and Rate, sorted from lowest to highest. Start the first row at 0.
- Put annual taxable income in a cell, for example B7.
- Use an approximate-match lookup to find the slab, then apply fixed amount + rate × income above the slab start (formula on the right).
- Divide by 12 for monthly tax, and subtract from salary for take-home pay.
The formula
All Pakistan Tax Calculators
Free calculators for every kind of income and tax in Pakistan, all on current FBR and provincial rates. See also the online salary tax calculator.
Pakistan Tax Guides
Plain-English guides to slabs, deductions, withholding, filing and filer status.
Frequently Asked Questions
Is the Excel tax calculator free?
Yes. It downloads directly in your browser with no sign-up and no personal details. Because it is an Excel file you can use it offline, but check that the slab rates match the tax year you are filing before relying on the result.
Does it work in Google Sheets?
Yes. Upload the .xlsx file to Google Drive and open it with Google Sheets; all formulas work. It also opens in LibreOffice and Apple Numbers.
Does it include the 2024-25 tax slabs?
Yes. The workbook has slab sheets for 2026-27, 2025-26 and 2024-25, including the surcharges that applied above Rs 10 million in 2024-25 and 2025-26.
How do I update it for next year’s budget?
Edit the slab sheet: change the From, Fixed and Rate columns to the new Finance Act values. The calculator sheet recalculates automatically.
Official sources & methodology
Slabs come from the Finance Acts 2024, 2025 and 2026 and the First Schedule to the Income Tax Ordinance 2001. Returns are filed and filer status is checked on the FBR IRIS portal; laws and circulars are published on fbr.gov.pk.
How to check your spreadsheet result
A spreadsheet is only as accurate as the slabs typed into it. Before you trust a figure, compare it with the salary tax calculator using the same monthly salary. If the two differ, check that your sheet uses the 2026-27 slabs listed on our income tax slabs page, and that annual income, not monthly, is what the slab formula reads.
Keep one cell for each slab threshold and rate, so next year you only change the inputs instead of rewriting formulas. Our guide on how to calculate income tax in Pakistan walks through the arithmetic the sheet should reproduce.
