Payroll + Tax Calculator Template
Description
Pay your team correctly. Stay compliant. File with confidence.
Paying staff in Nigeria involves more than just transferring money. PAYE, pension, NHF, NHIS, if you're not calculating and remitting these correctly, you're exposed to serious risk. And most fashion designers have no idea they're non-compliant.
The Payroll + Tax Calculator handles every statutory deduction automatically using current Nigerian rates. Toggle which deductions apply per employee. Generate payslips. Track your VAT obligations. Know exactly what you owe FIRS each month without needing an accountant for every payroll run.
WHAT'S INSIDE:
• 👥 Staff Register — Log unlimited staff — name, role, annual gross salary, bank details and deduction toggles per employee. PAYE, pension, NHF and NHIS can be turned on or off individually.
• 💰 Monthly Payroll — Select the payroll month. All deductions calculate automatically: PAYE (full 6-band progressive rate), employee pension 8%, employer pension 10%, NHF 2.5%, NHIS employee 5%, NHIS employer 10%. Net pay calculated for every staff member.
• 🧾 Payslip Summary — Formatted payslip per employee, enter the employee number, get a clean payslip. Print or save as PDF each month.
• 📅 Annual Payroll Summary — Full-year gross, total PAYE deducted, total pension and net pay per employee — ready for annual FIRS filings.
• 🧾 VAT Tracker — Log output VAT on sales and input VAT on purchases. Net VAT payable to FIRS calculates automatically each quarter.
• 📋 Tax Prep Sheet — Toggle Yes/No for PAYE, pension, NHF, NHIS, VAT, Withholding Tax and Company Income Tax. One-page consolidated view to share with your accountant.
• 📈 Charts — Gross vs net pay by staff member, deduction breakdown pie chart, pay composition stacked bar.
• ⚙ Settings — All statutory rates PAYE bands, pension %, NHF, NHIS, VAT, WHT. Update when FIRS changes regulations.
PRODUCT DETAILS
Who this is for: Fashion businesses with 1 or more staff members who want to run payroll correctly and stay compliant without hiring an accountant every month.
Format: Microsoft Excel (.xlsx) — works on Windows, Mac and Google Sheets
Includes: 1 workbook · 8 sheets · 1,541 pre-built formulas · 3 auto-updating charts
Care
To maintain the beauty and integrity of your purchase, we recommend treating it with care. Simple maintenance practices, such as gentle washing and proper storage, can effectively preserve the longevity of your favorites. We encourage you to refer to the care instructions included with each item, designed to help you keep your purchase in top condition.
Design
Our dedication to excellence extends beyond materials; it encompasses the artistry and craftsmanship illustrated in every piece we create.