₦7,500 ₦4,500
Excel (.xlsx) workbook and Word (.docx) guide, 2 files
- Instant download after payment
- Download link sent to your email
- Edit and reuse for your business
Look inside the pack
Real pages from the files you download. Tap an image to view it larger.
Getting ready for January 2027 payroll? The tax changes that started in 2026 made most old payroll spreadsheets wrong. The consolidated relief allowance is gone, the first ₦800,000 is now tax-free, and tenants get a new rent relief. This Excel workbook does the new calculation for you, for every staff member, every month. It uses the Nigeria Tax Act 2025 bands, which took effect on 1 January 2026 and continue for 2027 payroll unless the law is amended, and every rate sits on an editable settings sheet.
What it calculates
- Gross pay, annual taxable income and PAYE under the 2026 bands (0%, 15%, 18%, 21%, 23%, 25%)
- Employee pension at 8% and employer pension at 10% of basic, housing and transport
- National Housing Fund at 2.5% of basic, only for staff who contribute
- Rent relief at 20% of annual rent, capped at ₦500,000
- Net pay and total cost to company, with monthly totals
Why buy this instead of using a free calculator?
Free online calculators work one person at a time and keep nothing. This workbook keeps your whole staff list, prints payslips, and tells you exactly how much to remit to the State IRS, PFAs and FMBN. Tax rates sit on a settings sheet, so you can update them yourself if the law changes again.
What is included
- Payroll workbook for up to 50 staff, set up for January 2027 payroll under the Nigeria Tax Act 2025
- Automatic PAYE with the new ₦800,000 tax-free band and 15% to 25% rates
- Rent relief, pension (8% and 10%) and NHF calculated for you
- Printable payslip for any staff member in one click
- Monthly remittance summary: PAYE, pension, NHF and net salaries
- Plain-English PAYE guide for 2027 with a worked example
Who this pack is for
- Small and medium businesses paying 1 to 50 staff
- Accountants and bookkeepers who run payroll for several clients
- Schools, clinics, churches and NGOs with monthly salaries
- HR officers who need printable payslips without buying software
How to use the Nigeria Payroll & PAYE Calculator for 2027 (Excel)
- Open the Settings sheet and enter your company name and payroll month.
- Replace the three example staff on the Staff sheet with your own team.
- Check the Payroll sheet, where PAYE, pension, NHF and net pay are calculated automatically.
- Print each payslip from the Payslip sheet and use the Remittance sheet to pay PAYE, pension and NHF on time.
Why not just use a free template?
Most payroll templates sold or shared online still use the old consolidated relief allowance, which no longer applies from January 2026. This workbook uses the new bands and rent relief, keeps rates editable, and has been checked against a worked example (₦3,000,000 gross, ₦1.2m rent: ₦251,250 PAYE a year).
Questions
Can I use it for 2027 payroll?
Yes. It is set up for January 2027 and uses the personal income tax bands in the Nigeria Tax Act 2025, which apply from 1 January 2026 onwards, including the ₦800,000 tax-free band and the rent relief. If the rates are amended, change them on the Settings sheet and the whole payroll updates.
Does it work on Google Sheets or my phone?
Yes. It opens in Excel, Google Sheets, WPS and Excel for Android or iPhone. Payslips print best from a laptop.
What if the rates change again?
All rates and bands are on the Settings sheet in yellow cells. Change them once and the whole payroll updates.
How do I get the files?
Right after payment you see download buttons on this page, and we email you a download link that works for 60 days.
Can I edit the templates?
Yes. They are normal Word and Excel files. Add your logo, business details and change anything you need.
Is this legal advice?
No. These are general templates for Nigerian businesses. For important or unusual matters, have a lawyer or accountant review your final documents. Book a consultation if you want us to help.
I paid but did not get my files.
Check your spam folder first, then message us on WhatsApp with your payment email.
General templates for information and convenience, not legal, tax or accounting advice.
Customers also buy
Staff HR Starter Pack
Employee handbook, offer letter, employment contract, HR forms and a staff, leave and payroll register for Nigerian small businesses.
₦10,000
View packEmployer, Visa & Sponsorship Letter Templates
Employment confirmation for visa, leave approval, salary confirmation, reference, no objection, sponsorship, invitation, self-employment and travel consent letters, ready to edit.
₦3,000
View packSmall Business Bookkeeping & Inventory Workbook (Excel)
Record sales, stock, expenses and debtors in one Excel workbook. See monthly profit, stock value and what to reorder automatically.
₦4,500
View pack

