Switching from spreadsheets to cloud payroll without breaking April

Roughly two-thirds of Kenyan SMEs still run monthly payroll in a spreadsheet. It works - until it doesn't. Here is the migration playbook we've refined across 180+ Pay Kenya onboardings, including the pitfalls that show up on payday.

The five-day plan

1. 01Day 1 · Export everything. Pull a clean snapshot of your current employee list, salaries, allowances, deductions, NSSF and KRA PINs, and three months of historic payslips.
2. 02Day 2 · Reconcile. Compare your last spreadsheet payroll with what the new platform computes for the same month. Differences over Ksh 10 per employee need investigation.
3. 03Day 3 · Configure. Set up your statutory rates, payslip template, payment file format, and approval workflow.
4. 04Day 4 · Parallel run. Run the upcoming month on both the spreadsheet and the new platform. Investigate any variance line by line.
5. 05Day 5 · Cutover. File and pay from the new platform. Archive the spreadsheet read-only.

Common pitfalls

1. Mid-month joiners

Spreadsheets often pro-rate joiners differently than statutory software does. The KRA convention is to pro-rate gross pay by working days, then apply full monthly PAYE bands - not to pro-rate the bands themselves. Get this wrong on a senior hire and you'll over-deduct by tens of thousands of shillings.

2. Year-to-date carryover

When you switch mid-year, KRA expects you to file P9s with full year-to-date figures. Carry over the YTD gross, PAYE, SHIF, NSSF and AHL columns from January - not just the month you migrate.

3. Non-cash benefits

Company cars, subsidised housing, school fees, and group life cover are all taxable benefits that many spreadsheet payrolls ignore. KRA's iTax cross-references these against your annual return. Settle the chargeable values before you migrate.

What to look for in a platform

• Direct iTax, SHA and NSSF filings (not just CSV exports).
• M-Pesa B2C bulk payments alongside bank transfers.
• An audit trail on every payslip line, signed off by an approver.
• Locale-correct date and currency formatting, including SHIF and AHL line items.
• A bureau-mode option for months when your finance lead is on leave.

We did our last spreadsheet payroll in March 2025. The first cloud cycle felt strange because it took twenty minutes instead of three days.

— Wanjiru K., Finance Manager · 60-person logistics SME

Cost of switching

For a 25-person SME, plan on roughly six hours of finance time over five days, plus the platform's onboarding fee (we don't charge one at Pay Kenya). The biggest cost is psychological - payroll is a sensitive process, and your team needs a parallel run before they trust the new numbers.

Once you're past that first cycle, the time savings compound. Most of our clients run a 50-person payroll in under thirty minutes a month, including filings.