PAYE Calculator Kenya
Menu

PAYE Calculator Excel Template for Kenya (2026)

📅 Last updated: 13 November 2026 • 🛡️ Rates checked: 20 October 2026 (Subject to KRA confirmation) • 🏛️ Sources: KRA, NSSF, SHA

In Short: Free 2026 Excel PAYE Template

Download our free, formula-driven Microsoft Excel payroll template configured with 2026 Kenya statutory deduction rates: NSSF Tier I & II limits (KES 108,000 UEL), SHIF (2.75%), Affordable Housing Levy (1.5%), progressive PAYE tax brackets (10% to 35%), and resident personal relief (KES 2,400). Compatible with Excel, Google Sheets, and LibreOffice.

While an online PAYE calculator is ideal for quick individual lookups, finance teams and small business owners often require offline spreadsheet models to process batch monthly payroll. Our downloadable Excel model provides transparent, open formulas with zero macro security warnings.

Download the template

PAYE Calculator Kenya 2026 (Spreadsheet Edition)

Version: v2026.1 | File Size: ~12 KB | Format: .xlsx / XML Spreadsheet

⬇️ Download Excel Template (.xlsx)

SHA-256 Checksum: Verified Clean | Live Formulas | No Macros | No Registration

What is inside the workbook

The downloadable workbook is organized into four clean, dedicated sheets:

  • Sheet 1: Calculator: An enterprise multi-employee payroll roster featuring dynamic Excel formulas (MIN, MAX, IF, VLOOKUP) computing gross earnings, NSSF, SHIF, Housing Levy, taxable income, banded PAYE, and net salaries.
  • Sheet 2: Rates: A centralized configuration table listing statutory constants, relief ceilings, and contribution thresholds. When statutory rates change, update this single tab to recalculate the entire sheet.
  • Sheet 3: Test Cases: Pre-loaded with our ten verified benchmark test cases (T1 through T10) to confirm mathematical integrity.
  • Sheet 4: Read Me: Complete user instructions and statutory legal citations.

How to use the spreadsheet

  1. Download and open paye-calculator-kenya-2026.xlsx in Microsoft Excel, Google Sheets, or LibreOffice Calc.
  2. Navigate to the Calculator tab and input your employees' names and monthly gross wages.
  3. Verify that the automated NSSF, SHIF, Housing Levy, and PAYE columns populate instantly.
  4. Export the calculated summary to CSV for direct integration with KRA iTax P10 upload templates.

Excel vs the online calculator

Use our browser-based net salary calculator for quick on-the-go payslip verification. For enterprise multi-employee processing with employer overhead summaries, use our online payroll calculator for employers or deploy this Excel template.

Frequently Asked Questions

Is the Excel PAYE template free to download?

Yes. The template is 100% free with no registration, email subscription, or license fee required.

Does the Excel sheet work in Google Sheets and LibreOffice?

Yes. The file is built with standard spreadsheet formulas compatible with Microsoft Excel (2016 and newer), Google Sheets, and LibreOffice Calc.

Which statutory tax year rates does the spreadsheet use?

The default model is configured with 2026 statutory rates, including NSSF Tier I & II caps, 2.75% SHIF, 1.5% Housing Levy, and 2026 PAYE brackets.

Does the template contain VBA macros or external web connections?

No. The spreadsheet uses pure native spreadsheet formulas (IF, MIN, MAX, VLOOKUP). It contains zero macros, external scripts, or security warnings.