Skip to content

We've built 201+ tools — open your toolbox, there's something in here you probably need.

← TemplatesKRA & statutory

Free SHA (SHIF) Contribution Calculator (Excel) — how much you pay per month & year

SHA (SHIF) took over from NHIF in October 2024, and the question everyone asks is the same: how much comes off my pay? This free calculator answers it — type a gross salary and the deduction (2.75% of gross, floor KES 300) appears for the month and for the year, exactly as our online SHA guide explains.

Choose free basic or KES 500 premium · opens in Excel or Google Sheets
Prefer Google Sheets? You don't need Microsoft Excel →
  1. Download the file above.
  2. Open Google Drive, then New → File upload and choose the file.
  3. Right-click it in Drive → Open with → Google Sheets. It becomes a fully editable Google Sheet — every formula and tab intact — and works on your phone too.

The .xlsx format opens free in Google Sheets, LibreOffice, or Excel for the web — no paid software required.

What's inside

  • SHA at 2.75% of gross, with the KES 300 floor applied automatically
  • Per month and per year, for one salary or a whole team
  • Effective rate and take-home-after-SHA on any salary
  • Rate on an editable, sourced, dated tab — no hard-coded numbers
  • Formulas locked; only the yellow cells accept typing

The tabs

  • Start Here (guide)
  • Rates (editable + dated)
  • Calculator
  • Team

Yellow cells only. You type in the yellow cells; the rest are locked formulas. Gridlines are off and it prints clean on A4.

Basic vs Premium

The free version does the job. The premium does more of it.

The free basic workbook above is a complete, formula-driven template you can use forever. The premium upgrade adds the extras that turn record-keeping into a management tool.

Basic — Free

  • The core sheets and formulas, in KES
  • Works in Excel or Google Sheets, on your phone
  • Yours to keep, no sign-up

Premium — KES 500

  • Dashboard: SHA at every common Kenyan pay level, with share-of-pay bars
  • Team roll-up: total SHA per month and per year to remit to the SHA
  • Salary-band reference table that updates from the live rate
  • Printable-friendly layout

Choose Basic or Premium from the Get this template button at the top of the page — one click, pay once via M-Pesa.

The rate sits on one editable, dated Rates tab — 2.75% and the KES 300 minimum — linked to the Social Health Authority as the source. Nothing is hard-coded into a formula, so if the law moves the rate you change one cell and the whole workbook follows. That is the honest way to keep a statutory template accurate.

The Calculator tab handles one salary and shows the effective rate and your take-home after SHA. The Team tab does a whole payroll — one row per employee — and totals what you remit to the SHA each month and each year. SHA is only one of the statutory deductions, so when you need full net pay (PAYE, NSSF and the Housing Levy too) the Kenya Payroll & PAYE template carries the lot.

Do it online instead

How SHA & SHIF work in Kenya — full guide

Open the free tool →

Custom work

Need a template made just for you?

Can't find the exact workbook, or want one branded and built around how your business actually runs? We build custom Excel & Google Sheets — bespoke financial models, dashboards, sector trackers, data clean-up and automation. Need it in English or Kiswahili, or another language? Just ask. Tell us what you need and we'll quote.

Frequently asked questions

How much is SHA per month?

SHA (SHIF) is 2.75% of your gross monthly salary, with a minimum of KES 300 and no upper cap. On KES 50,000 gross it is KES 1,375 a month; on KES 8,000, the 2.75% works out below 300 so the KES 300 floor applies. Type any salary and the calculator shows the exact figure.

Is the basic version free?

Yes. The basic calculator and team sheet are free to download and keep. The premium upgrade — a dashboard showing SHA across pay levels and a fuller team roll-up — is an optional KES 500.

Is SHA deducted before or after PAYE?

Before. SHA, NSSF and the Housing Levy are all taken off gross to arrive at taxable pay, and PAYE is then charged on that. This calculator shows SHA on its own; for the full net-pay order use the Kenya Payroll & PAYE template.