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 Africa
$19
In the pack
Nigeria Tax Act 2025 pack
Files
5, Word and Excel
Buy the pack · $19
Global library · 110 packs

Get this pack and 109 more for $99

Nigeria Tax Act 2025 · this packAML complianceCharity accountsEstate administrationMTD for Income TaxP11D and payrollingUK SRS readinessReference lettersCarbon reduction plan+ 101 more

What the calculator looks like

PAYE calculator template
What the calculator works outSheet or column in the calculator
The income tax bands
✓
Settings: Band 1 to Band 6Width and rate of each band, with the top band open-ended
Rent relief settings
✓
Settings: rent relief rate and capEntered once, used for every employee
Settings still missing
✓
Settings still to fill inNo tax shows until every setting is complete
One line per employee
✓
Employees: Employee, Annual gross incomeRoom for 100 employees, amounts in naira
Employees exempt from income tax
✓
Exempt from income tax under the Act?Tax is set to nil for anyone marked Yes
Eligible deductions
✓
Pension contributions, National Housing Fund, Health insurance, Home loan interest, Life insurance premiumsThe amounts each employee has claimed in writing
Rent relief
✓
Annual rent paid, Rent reliefThe rate times annual rent, up to the cap
Income left to tax
✓
Chargeable incomeGross income less deductions and rent relief
Tax for the year and the month
✓
Annual tax, Monthly PAYE, Effective rateThe monthly figure to use in payroll
Mistakes caught as you type
✓
CheckMissing settings, missing gross income or an unanswered exemption question

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

  1. 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.
  2. List your employees. One line each, with annual gross income. Delete the example rows first.
  3. 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.
  4. Mark anyone exempt. Answer Yes or No for each employee, such as an employee earning the national minimum wage or less.
  5. 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

Small company test and tax positionDevelopment levy calculationClient letter on the 2026 tax changes

See the whole 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.