In short: The Business Radar Kenya payroll Excel template works out PAYE, SHIF, NSSF and the Affordable Housing Levy for every employee, then prints payslips, an employer cost summary and a P10-style PAYE schedule. It costs KES 999 for up to 50 staff or KES 1,999 for up to 150 staff, paid once. Every rate was checked against KRA, NSSF and SHA sources on 10 November 2026.
Standard edition: up to 50 employees
KES 999 one-off, instant download
Secure checkout by Paystack. The download link arrives by email from info@businessradar.co.ke.
Business edition: up to 150 employees
KES 1,999 one-off, instant download
Secure checkout by Paystack. The download link arrives by email from info@businessradar.co.ke.
What the workbook calculates
You type each employee’s basic pay, allowances and overtime. The workbook does the rest with live Excel formulas, in the order KRA set out after the Tax Laws (Amendment) Act, 2024:
- NSSF Year 4 rates (from February 2026): Tier I at 6% of pay up to KES 9,000 and Tier II at 6% of pay between KES 9,000 and KES 108,000, matched by the employer. The maximum is KES 6,480 each.
- SHIF at 2.75% of gross pay, with the KES 300 minimum and no upper cap.
- Affordable Housing Levy at 1.5% from the employee plus 1.5% from the employer.
- Taxable pay after deducting NSSF and registered pension (capped at KES 30,000), SHIF, the Housing Levy, post-retirement medical fund (capped at KES 15,000) and qualifying mortgage interest (capped at KES 30,000).
- PAYE on the five KRA bands from 10% to 35%, less the KES 2,400 personal relief and any insurance relief (15% of premiums, up to KES 5,000 a month).
- Net pay after loans, SACCO and salary advance deductions, with a check that each employee keeps at least one-third of pay, as the Employment Act requires.
- Employer cost: gross pay plus employer NSSF, the employer Housing Levy and the KES 50 NITA training levy.
What’s inside the file
| Sheet | What it does |
|---|---|
| Start here | Company name, employer PIN, pay month and payment date, plus a seven-step guide. |
| Rates & sources | Every rate in one place with the date it took effect, a link to the official source and the date we checked it. |
| Employees | Register with KRA PIN, ID, SHA and NSSF numbers, department, resident and NSSF settings, leaver status and how each person is paid. |
| Payroll | The monthly run: 9 input columns and 21 locked formula columns per employee, with totals. |
| Payslip | Pick an employee number and print a one-page payslip. |
| All payslips | Every employee’s payslip, one per page, ready to print or save as PDF in one go. |
| Employer cost summary | What to remit to KRA, SHA and NSSF, the due date, total employer cost and cost by department. |
| P10 monthly totals | A PAYE schedule with the fields the iTax P10 return asks for, so you can copy rows into KRA’s template. |
| Net pay list | Each employee’s net pay with bank or M-Pesa details for your transfer batch. |
Yellow cells are inputs. Every formula cell is locked, so a stray keystroke cannot break the calculations. The sheets are protected without a password, so you stay in control of your own file.

Worked example: KES 50,000 gross pay
| Gross pay | KES 50,000.00 |
| NSSF (Tier I 540 + Tier II 2,460) | KES 3,000.00 |
| SHIF (2.75%) | KES 1,375.00 |
| Housing Levy (1.5%) | KES 750.00 |
| Taxable pay | KES 44,875.00 |
| Tax before relief | KES 8,245.85 |
| PAYE after KES 2,400 personal relief | KES 5,845.85 |
| Net pay | KES 39,029.15 |
| Employer cost (adds NSSF 3,000, Housing Levy 750, NITA 50) | KES 53,800.00 |
Before release we checked the workbook against an independent calculator on 14 salary cases, from KES 5,000 to KES 1,000,000, including a non-resident, an employee outside NSSF and one with pension, mortgage and insurance reliefs. Every figure matched to the cent. For a quick single-salary check, use our free tax calculators or see the PAYE tax bands and Housing Levy table.
Standard or Business edition?
| Standard | Business | |
|---|---|---|
| Price (one-off) | KES 999 | KES 1,999 |
| Employees | Up to 50 | Up to 150 |
| All nine sheets, payslips and P10-style schedule | Yes | Yes |
| Free updated file if a statutory rate changes before 31 December 2027 | Yes | Yes |
How delivery works
Pay by M-Pesa or card through Paystack using the form above. You get a private download link on screen and by email from info@businessradar.co.ke. The link works five times over seven days.
Frequently asked questions
Does the template use the 2026 PAYE, SHIF and NSSF rates?
Yes. It uses the KRA PAYE bands in force since July 2023, which the Finance Act 2026 did not change, the KES 2,400 personal relief, SHIF at 2.75% with a KES 300 minimum, the 1.5% Housing Levy and the NSSF Year 4 limits of KES 9,000 and KES 108,000 that apply from February 2026.
Are SHIF and the Housing Levy deducted before PAYE?
Yes. Since 27 December 2024, SHIF contributions and the employee’s Housing Levy are deducted from pay before PAYE is worked out, and the old affordable housing relief no longer applies. The workbook follows KRA’s public notice on the Tax Laws (Amendment) Act, 2024.
What happens if the government changes a rate?
All rates sit on one Rates & sources sheet, so you can change a figure once and every payslip updates. If PAYE, SHIF, NSSF or Housing Levy rates change before 31 December 2027, buyers can ask for the updated file free. For example, the Treasury has proposed exempting pay of KES 32,800 or less from PAYE, but this was not law when we checked on 10 November 2026.
Does it work in Google Sheets or LibreOffice?
It is built for Microsoft Excel and we tested it in LibreOffice Calc. It opens in Google Sheets too, though sheet protection and print layouts work best in Excel.
Does it file returns with KRA, SHA or NSSF for me?
No. It works out the figures and lays them out the way the returns ask for them. You still file and pay on iTax, the SHA employer portal and the NSSF portal by the 9th of the following month.
Can I use it every month?
Yes. Save a copy for each pay month, update the inputs and print. There is no subscription and no limit on how many months you run.
Sources: KRA PAYE, KRA notice on the Tax Laws (Amendment) Act, 2024, NSSF Year 4 notice, Social Health Insurance Regulations, 2024 and NITA levy. Checked 10 November 2026. The workbook is a calculation aid, not tax advice.
