Nigeria PAYE calculator in Excel for 2026 payroll
Work out each employee's annual tax and monthly PAYE under the new income tax bands that apply from 1 January 2026, after pension, National Housing Fund, rent relief and the other eligible deductions. This Nigeria PAYE calculator is one Excel workbook with room for 100 employees.
Middle East and AfricaGet this pack and 109 more for $99
What the calculator looks like

When you need a Nigeria PAYE calculator
The Nigeria Tax Act, 2025 took effect on 1 January 2026. Section 58 taxes an individual's chargeable income at the rates in the Fourth Schedule, and section 30 sets the deductions allowed before tax, including a new rent relief. Every employer running payroll needs the new figures for each employee. Use the calculator when:
- You are setting up payroll for the 2026 year under the new bands
- Employees ask how much the changes save them each month
- You run payroll for clients and want to check each employee's PAYE
- An employee declares rent paid or another deduction part way through the year
- You want the effective tax rate for each employee in one sheet
How to use the Nigeria PAYE calculator
- Fill in Settings once. Enter the width and rate of each band and the rent relief rate and cap from the Act. Leave the width of the top band blank.
- List your employees. One line each, with annual gross income. Delete the example rows first.
- Enter each employee's deductions. Pension, National Housing Fund and health insurance contributions, home loan interest, life insurance premiums and annual rent paid, as claimed in writing.
- Mark anyone exempt. Answer Yes or No for each employee, such as an employee earning the national minimum wage or less.
- Use the monthly figure in payroll. Monthly PAYE is the annual tax divided across the year. The Check column shows OK or what is missing.
Questions
What are the new PAYE tax bands in Nigeria?
Under the Fourth Schedule of the Nigeria Tax Act, 2025: the first ₦800,000 at 0%, the next ₦2,200,000 at 15%, the next ₦9,000,000 at 18%, the next ₦13,000,000 at 21%, the next ₦25,000,000 at 23%, and anything above ₦50,000,000 at 25%.
How is PAYE calculated in Nigeria?
Start with the employee's total income for the year and take off the eligible deductions to reach chargeable income. Tax that income band by band at the Fourth Schedule rates, then divide the annual tax by 12 for the monthly PAYE.
What deductions are allowed before tax?
Section 30 allows the employee's contributions under the National Housing Fund, the National Health Insurance Scheme and the Pension Reform Act, interest on a loan for an owner-occupied home, life insurance or deferred annuity premiums, and rent relief. Deductions must be claimed in writing.
How does rent relief work?
Rent relief is 20% of the annual rent paid, up to ₦500,000, provided the employee declares the actual rent paid. For example, rent of ₦1,500,000 a year gives relief of ₦300,000.
Who is exempt from PAYE in Nigeria?
Section 163 exempts income from an employment where the person earns gross income of the national minimum wage or less from that employment. The calculator sets their tax to nil when you mark them exempt.
When did the new PAYE bands start?
On 1 January 2026, when the Nigeria Tax Act, 2025 took effect.
Also in the nigeria Tax Act 2025 pack
Who it's for
Nigerian accounting practices and the finance teams of small and mid-sized companies running payroll.
Last checked
Checked against the Nigeria Tax Act, 2025 as gazetted in November 2026.
