PAYE Calculator (Deep-Dive) | Excel Template for Kenyan Businesses

Calculate exact PAYE for any employee with every band, relief, and deduction shown clearly.

Description

Unlike a simple PAYE table, this template shows every calculation step so you understand exactly how the tax is arrived at. Enter 7 earnings components and it calculates gross pay, steps through each NSSF tier, SHIF, Housing Levy, taxable income, all 5 PAYE bands individually, personal relief, insurance relief, and disability exemption — arriving at net pay and effective tax rate. The annual summary reconciles 12 months of PAYE. The P9 Form Helper pre-populates the employee tax certificate fields ready for iTax submission.

What's Inside

•       PAYE Calculator — 7 earnings to gross pay to all deductions to net pay, step by step

•       NSSF Tier I + Tier II shown separately, SHIF 2.75%, Housing Levy 1.5%

•       All 5 PAYE bands shown individually, personal relief KES 2,400, insurance relief, disability exemption

•       Annual PAYE Summary — 12-month PAYE reconciliation table

•       P9 Form Helper — employee tax certificate fields with iTax submission notes

Best For

HR managers, payroll accountants, employees who want to verify their own deductions.

KRA / Tax Note

2025 rates. P9 certificates due to employees by 28 February. Supports iTax annual PAYE filing.