Bulk PAYE Calculator for Payroll & HR

TaxLane's PAYE calculator normally computes tax one employee at a time — this bulk tool takes a whole staff roster instead, pasted or uploaded as a CSV file, and returns gross-to-net PAYE for every employee plus the total monthly and annual PAYE you need to remit.

How TaxLane's bulk PAYE calculator works

Each employee is taxed under the same 2026 PAYE bands as TaxLane's individual PAYE calculator. The first ₦800,000.00 of taxable income is tax-free, then 15% up to ₦3,000,000.00, 18% up to ₦12,000,000.00, 21% up to ₦25,000,000.00, 23% up to ₦50,000,000.00, 25% above ₦50,000,000.00.

Frequently asked questions

Can I include each employee's own reliefs (pension, NHF, rent)?

Yes — each line accepts Name, Monthly Gross Income, Annual Rent Paid, Annual Pension Contribution, Annual NHF Contribution, Annual NHIS Contribution, Annual Life Assurance Premium, and Annual Housing Loan Interest, the same reliefs the individual PAYE calculator accepts, applied per employee.

What format should I paste my staff roster in?

One employee per line, comma- or tab-separated — copy-paste straight from Excel or Google Sheets works, and a downloadable example template is available.

Can I upload a CSV file instead of pasting?

Yes — use "Upload a CSV file" next to the paste box to load a roster straight from a .csv export (from Excel, Google Sheets, or your payroll software) instead of copy-pasting. The uploaded file goes through the same validation as a pasted roster, including the per-row error checks.

Is there a downloadable Excel template with the PAYE formulas already built in?

Yes — "Download Excel template (with formulas)" generates a workbook with your staff roster, a Rates reference sheet, and a Read Me tab, with the same 2026 PAYE bands, pension/NHF/NHIS reliefs, and rent-relief cap as this calculator already built into live formulas, so you can re-enter figures for future pay periods without coming back to TaxLane.

Is TaxLane free, and does it store my data?

Yes, it's free with no account needed. Calculations run on your device and are never sent to a server — except the optional voice-input feature on amount fields, which sends your speech to your browser's own speech-recognition service to convert it to text.

Is this official tax advice?

No — for guidance only, not tax advice.