Running Payroll in Four Countries Without Four Spreadsheets

Four Markets, Four Rulebooks

The assumption that sinks most regional payroll setups is that the four East African markets are variations on a theme — same calculation, different rates. They are not. The differences are structural, and a system that models one market and parameterises the rest will be wrong in ways that are hard to see.

Here is what actually differs.

The Order of Operations Is Not the Same

In Kenya, PAYE is charged on pay after allowable deductions. NSSF, SHIF and the Affordable Housing Levy come off first; the bands apply to what remains.

In Uganda, PAYE is charged on the gross. The employee's NSSF contribution is not deductible against it.

In Rwanda, the sequence runs the other way for one component: CBHI is charged on pay after tax, so it has to be calculated last, once pension, maternity and PAYE are all settled.

A system with a fixed deduction order cannot produce correct payslips in all three. This is not a rate that can be configured. It is the shape of the calculation.

Some Contributions Never Touch the Employee

Tanzania adds two employer-side obligations that never appear as employee deductions: the Workers Compensation Fund and the Skills Development Levy. They are real costs of employment and they belong in any cost-of-hire figure, but an employee's net pay is unaffected by them.

Kenya has a smaller version of the same thing in NITA — a flat monthly employer charge.

Present either as an employee deduction and the payslip is wrong. Omit them from the employer side and every budget is understated.

Some Charges Are Not Monthly

Uganda's Local Service Tax is an annual amount set by income band, collected in four instalments between July and October. It is not one-twelfth a month.

Spreading it monthly produces the same annual total, which is exactly why the error persists — it reconciles perfectly at year end while producing twelve incorrect payslips and a remittance pattern that does not match the collection period.

Tiering Exists in One Market and Not the Others

Kenya's NSSF is charged across two tiers with separate bases and an upper earnings limit that has been rising in phases. Uganda's is a flat 5% and 10% on gross with no ceiling. Tanzania's is a flat percentage on each side. Rwanda splits pension from maternity, each with its own rate.

Model NSSF once and reuse it and you will have the Kenyan complexity imposed on markets that do not need it, or the flat treatment imposed on Kenya, which does.

What Four Spreadsheets Actually Cost

The maintenance burden is the visible cost, and it is the smaller one. The larger cost is that group-level questions become unanswerable without a week of work.

What is our total cost of employment this quarter? How many people do we employ today, across all entities? Which entity carries the most leave liability? Which market has the highest employer-side burden as a percentage of gross?

None of these are difficult questions. They are only hard because the numbers live in four incompatible files maintained by four people who each interpret a column heading slightly differently. By the time they have been reconciled the figure is a month old.

There is also a continuity problem. Each of those four files usually has exactly one person who knows how it works — which cells are formulas, which are hardcoded, and which exception is handled by hand each December. Four single points of failure, in four countries, discovered during somebody's annual leave.

What a Single System Has to Do

The requirement is narrow but non-negotiable. Statutory rules have to be data, versioned per country — rates, bands, thresholds, contribution order and the labels themselves — rather than branches in shared code. Adding a market should mean adding a country's rulebook, not editing the engine.

That is the only arrangement under which a rate change in one country cannot break another, and under which the group-level question can be answered immediately, in each entity's own currency, under each country's own law.

You can compare the four markets side by side in our payroll calculator — the deductions, the labels and the employer-side costs all change with the country, because underneath they are genuinely different calculations.