Lifehampers Global Consults

  1. Home
  2. Blog
  3. Business Compliance Updates
Business Compliance Updates

PAYE Calculation in Nigeria for 2027: Tax Bands, Worked Examples and Excel Payroll Template

LGLifehampers TeamBusiness and digital consultants, IbadanUpdated 5 min read
PAYE Calculation in Nigeria for 2027: Tax Bands, Worked Examples and Excel Payroll Template

PAYE Calculation in Nigeria for 2027: Tax Bands, Worked Examples and Excel Payroll Template

Nigeria Payroll & PAYE Calculator 2026 (Excel) template pack cover

If you run payroll in Nigeria, January 2027 is the first payroll of a new tax year, and many businesses are still using spreadsheets built for the old rules. This guide shows exactly how PAYE is calculated for 2027 under the Nigeria Tax Act 2025, with worked examples you can check, the remittance deadlines, and a ready Excel payroll that does it for your whole team.

Quick answer: for 2027, PAYE is calculated on annual taxable income (gross pay minus pension, NHF and rent relief). The first ₦800,000 is tax-free, then rates rise from 15% to 25%. Divide the annual tax by 12 for monthly PAYE.

Need to do this for your whole staff?

The Nigeria Payroll & PAYE Calculator for 2027 is an Excel workbook that calculates PAYE, pension, NHF, rent relief and net pay for up to 50 staff, prints payslips and gives you a monthly remittance summary. Instant download, works in Excel and Google Sheets.

Get the Excel payroll for ₦4,500   See what is inside

What changed, and why old payroll sheets are now wrong

  • The consolidated relief allowance (CRA) no longer exists.
  • The first ₦800,000 of taxable income is taxed at 0%.
  • Tax rates rise in bands from 15% to 25% instead of the old 7% to 24%.
  • Tenants get rent relief of 20% of annual rent paid, capped at ₦500,000.
  • Pension (8% of basic, housing and transport) and NHF (2.5% of basic) are still deductible.

These rules took effect on 1 January 2026 and apply to 2027 payroll unless the law is amended. A spreadsheet that still deducts CRA will give the wrong PAYE for every employee.

PAYE tax bands for 2027

Annual taxable incomeRate
First ₦800,0000%
Next ₦2,200,000 (up to ₦3 million)15%
Next ₦9,000,000 (up to ₦12 million)18%
Next ₦13,000,000 (up to ₦25 million)21%
Next ₦25,000,000 (up to ₦50 million)23%
Above ₦50,000,00025%

How to calculate PAYE step by step

  1. Annual gross pay = (basic + housing + transport + other allowances) × 12.
  2. Subtract employee pension: 8% of (basic + housing + transport) × 12.
  3. Subtract NHF if the employee contributes: 2.5% of basic × 12.
  4. Subtract rent relief: 20% of annual rent paid, maximum ₦500,000. Keep evidence of rent on file.
  5. What is left is taxable income. Apply the bands above.
  6. Divide the annual tax by 12 to get monthly PAYE.

Worked examples

Junior staffAccountantManager
Monthly pay (basic / housing / transport / other)₦100,000 total₦150k / ₦60k / ₦40k / ₦0₦400k / ₦160k / ₦100k / ₦50k
Annual gross₦1,200,000₦3,000,000₦8,520,000
Pension (8%)₦96,000₦240,000₦633,600
NHF (2.5% of basic)Not contributing₦45,000₦120,000
Annual rent / rent relief₦300,000 / ₦60,000₦1,200,000 / ₦240,000₦3,000,000 / ₦500,000 (cap)
Taxable income₦1,044,000₦2,475,000₦7,266,400
Annual PAYE₦36,600₦251,250₦1,097,952
Monthly PAYE₦3,050₦20,938₦91,496

For the manager: 15% of ₦2,200,000 (₦330,000) plus 18% of ₦4,266,400 (₦767,952) = ₦1,097,952. In the junior example, pension is calculated on the full ₦100,000 because it is all basic, housing and transport. These are the same figures you will see in the sample staff of the Excel payroll, so you can check the workbook against this page.

Who pays no PAYE

A worker on the ₦70,000 national minimum wage earns ₦840,000 a year. After 8% pension (₦67,200), taxable income is ₦772,800, which is inside the ₦800,000 tax-free band, so PAYE is zero. Many junior staff now pay little or no PAYE, which is why using the old rules overcharges them.

What employers must remit each month

DeductionPay toUsual deadline
PAYEState IRS where each employee lives10th of the following month
Pension (8% employee + 10% employer)Each employee’s PFAWithin 7 working days of paying salary
NHF (2.5% of basic)Federal Mortgage Bank of NigeriaMonthly
Annual return of emoluments (Form H1)State IRSBy 31 January

Get free email reminders before these deadlines with Lifehampers compliance reminders.

Free calculator, Excel payroll or software: which do you need?

OptionBest forCost
Free PAYE calculatorChecking one person’s salaryFree
Excel payroll and PAYE calculator1 to 50 staff: payroll, payslips and remittance summary every month₦4,500 one-time
HR and payroll softwareLarger teams that need approvals, leave, staff self-service and bank uploadsCustom quote

Run January 2027 payroll in minutes

Enter your staff once. The workbook calculates every deduction under the new tax law, prints a payslip for each person and tells you how much PAYE, pension and NHF to remit. Rates are on an editable settings sheet, so you can update them if the law changes.

Get the Excel payroll for ₦4,500   See what is inside

Common PAYE mistakes to avoid

  • Still deducting CRA, which no longer exists.
  • Calculating pension on basic salary only instead of basic + housing + transport.
  • Giving rent relief without evidence of rent paid, or above the ₦500,000 cap.
  • Remitting PAYE to the state where the office is instead of where the employee lives.
  • Forgetting the annual Form H1 return in January.

Running several businesses or clients? The Complete Business Template Bundle includes the payroll workbook plus HR, bookkeeping, compliance and agreement templates.

Frequently Asked Questions

Are the PAYE tax bands different for 2027?

The bands in the Nigeria Tax Act 2025 took effect on 1 January 2026 and continue to apply to 2027 payroll unless the law is amended. Check for any amendment or State IRS circular before your January 2027 payroll.

Is the first ₦800,000 tax-free for everyone?

Yes. The first ₦800,000 of annual taxable income is taxed at 0%. Taxable income is gross pay minus pension, NHF, rent relief and other allowable deductions.

Do minimum wage earners pay PAYE?

Usually not. A worker on ₦70,000 a month earns ₦840,000 a year. After the 8% pension deduction, taxable income is below ₦800,000, so PAYE is zero.

What happened to the consolidated relief allowance (CRA)?

It was abolished under the Nigeria Tax Act 2025. Tenants now get rent relief of 20% of annual rent paid, up to ₦500,000.

Is there an Excel template for PAYE in Nigeria?

Yes. The Lifehampers Nigeria Payroll & PAYE Calculator for 2027 calculates PAYE, pension, NHF and rent relief for up to 50 staff, prints payslips and shows what to remit each month. It costs ₦4,500 with instant download.

When must employers remit PAYE?

PAYE deducted from staff is remitted to the State Internal Revenue Service of the state where each employee lives, usually by the 10th day of the following month.

This article explains the law as published and is not tax advice. Confirm complex cases with a tax professional or your State IRS.

Share this guide

Leave a Comment

Your email address will not be published. Required fields are marked *

Talk to an expert

Need help with Business Compliance Updates?

Book a free consultation and get clear, practical next steps for your business.

Scroll to Top