Forum Discussion
I'm looking for a practical way to calculate Pakistan salary income tax in Excel.
The goal would be to enter a monthly salary and have the spreadsheet estimate the applicable tax and resulting take-home amount. Ideally, the calculation should be easy to update when the applicable tax slabs or salary-related rules change.
For someone building this in Excel, would you recommend keeping the tax slabs in a separate lookup table and using formulas against that table, rather than hard-coding the rates into one large formula?
I'm particularly interested in approaches that make the spreadsheet easier to maintain when tax rules change.
1 Reply
Yes, keep the tax slabs in a separate table. That makes changes easier to maintain and lets you check the thresholds and rates without digging through a long formula.
On a separate sheet, create a table named TaxSlabs with three columns: LowerBound, BaseTax and Rate. Fill it with the applicable annual salaried-income tax slabs published by Pakistan’s FBR. Include the zero-tax band, sort LowerBound in ascending order, and enter rates as percentages.
With monthly taxable salary in B2, this Excel 365 formula calculates the annual slab tax:
Each lookup finds the matching threshold or the next smaller one. The calculation then adds the base tax to the tax on income above that threshold.
Divide the annual result by 12 for estimated monthly tax. Subtract that and any other deductions from monthly gross salary to estimate take-home pay. Keep gross salary and taxable salary in separate cells if they differ.
Put any applicable surcharge, credits and other adjustments in separate calculations. Multiplying by 12 assumes the salary stays constant, so bonuses or midyear raises need additional handling.
Keep a dated copy of each tax year’s table instead of overwriting previous years. After an update, test income just below, exactly at and just above each threshold.
