The Risks of Managing Payroll With Spreadsheets

Every month, in offices across Accra, Lagos, Nairobi and Johannesburg, the same ritual plays out. An HR or finance officer opens a familiar Excel file, updates a few salary figures, drags a formula down a column, and quietly hopes that nothing has broken since last month.

Most months, nothing does. And that's exactly the problem. Spreadsheets fail silently. There's no alarm when a formula stops referencing the right cell, no warning when a tax band changed in January and the file didn't, no flag when a pension deduction is calculated on gross salary instead of basic. The error simply sits there, compounding quietly, until the day it becomes very expensive.

If you're running payroll for a growing business anywhere in Africa, here's what that risk actually looks like, with receipts, from right here on the continent.

This is happening across Africa right now

Payroll failures are not an abstract, faraway problem. Some of the most costly examples in recent memory come from African institutions running payroll on manual processes, spreadsheets and poorly controlled records.

Ghana: over 67,000 people on the payroll who shouldn't have been. In 2025, the Minister of Finance told Parliament that a Ghana Audit Service review had found 67,311 illegitimate entries on the government payroll. The majority were not sophisticated fraud. There were 53,311 separated staff, people who had retired, resigned, been terminated or passed away, whose records were simply never updated. Around GH₵150.4 million in unearned salaries had to be

recovered. Earlier that year, a headcount at the National Service Authority uncovered more than 81,000 suspected ghost names on its allowance payroll. When records live in files that nobody reconciles, exits don't get processed and money keeps flowing to people who are no longer there.

Kenya: Sh5.2 billion paid outside the payroll system. A recent Controller of Budget report revealed that 43 of Kenya's 47 counties paid at least Sh5.19 billion in salaries through manual payrolls in just nine months, with some counties paying staff using vouchers. The report warned that manual payment is directly prone to abuse, including payments to ghost workers, precisely because there is no system enforcing who gets paid, how much, and against what records.

South Africa: R28.3 million paid to employees who had already left. The Auditor-General flagged the Mpumalanga Department of Education for R28.3 million in salary overpayments made to employees after their services had ended through death, resignation, retirement or dismissal. The cause was not a criminal syndicate. It was poor termination controls: nobody updated the records in time, and the payments kept going out month after month. Nationally, South Africa's Treasury estimates that ghost workers and payroll irregularities are draining billions of rand from public funds.

Notice the pattern. In every case, the failure wasn't one dramatic mistake. It was ordinary record-keeping done manually, without validation, without an audit trail, and without a system that forces payroll to match reality. That is exactly how spreadsheet payroll works in a private business, just at a smaller scale. Research by PwC has found that around 90% of spreadsheets with more than 150 rows contain at least one error. If your payroll file has a row per employee plus allowances, deductions and formulas, you're well past 150 rows.

Now translate that risk into an African payroll

Payroll on this continent is not a single calculation, and it does not stand still. Every market has its own stack of statutory deductions, its own deadlines, and its own regulators, and the rules change more often than most spreadsheets do.

In Ghana, employers juggle graduated PAYE bands of up to 35%, SSNIT Tier 1 calculated on basic salary only (not gross), a further Tier 2 contribution to a licensed private trustee, and hard deadlines: contributions must reach SSNIT by the 14th of the following month and PAYE must reach the GRA by the 15th. Miss the SSNIT deadline and the law imposes a compounding 3% penalty per month on the outstanding amount. That is not a one-off fine; a GHS 50,000 shortfall left uncorrected for a year grows into a materially larger debt, and SSNIT and the NPRA actively pursue and prosecute defaulting employers. PAYE bands are also revised after the national Budget, taking effect in January, and a spreadsheet doesn't update itself.

In Nigeria, the new Nigeria Tax Act took effect on 1 January 2026 and rewrote the PAYE playbook entirely: the Consolidated Relief Allowance was scrapped, new tax bands were introduced with a tax-free threshold on the first ₦800,000, rent relief was added, and pension

contributions are calculated on basic plus housing plus transport rather than total gross. Any payroll spreadsheet still running the old PITA formula became non-compliant from the very first pay run of the year, exposing the employer to fines, interest and back-dated reviews by the newly empowered Nigeria Revenue Service.

In Kenya, the statutory stack has changed repeatedly in just three years: NHIF was replaced by SHIF at 2.75% of gross salary with no cap, the Affordable Housing Levy added 1.5% from the employee matched by 1.5% from the employer, and NSSF contribution limits have risen in phases year after year, with remittances due by the 9th of the following month. An HR officer maintaining those rates by hand has had to correctly re-edit their formulas multiple times, and every missed update means every employee's payslip is wrong.

Multiply this across borders and the risk compounds. A company operating in two or three African markets on spreadsheets is effectively betting that several different files, maintained by different people, all reflect several different fast-moving legal regimes correctly, every single month.

So the SME version of the Mpumalanga story isn't hypothetical. It looks like this: an employee resigns, but the payroll spreadsheet is only updated two cycles later, and two months of salary go out to someone who no longer works for you. Or a formula error under-deducts pension contributions for eight months, and nobody notices until an employee checks their statement, finds a gap, and files a complaint. Now the employer owes the arrears, plus penalties, plus the trust of every employee who wonders what else has been miscalculated. And it's all sitting in a file with no audit trail showing who changed what, or when.

The costs nobody puts in the spreadsheet

Beyond fines, spreadsheet payroll carries quieter costs:

No audit trail. When an employee disputes their pay, a spreadsheet can't tell you who edited a cell or when. Disputes become arguments instead of lookups. The Kenyan counties paying by voucher learned this the hard way: without a system of record, you cannot prove who was paid what, or why.

Key-person risk. In many SMEs, exactly one person understands how the payroll file works. When they resign, travel or fall ill, salaries are late. And late salaries destroy morale faster than almost anything else.

Security. A payroll spreadsheet is the most sensitive file in the company, and it's typically emailed around, saved to laptops and shared on drives with no access control. One wrong recipient and every employee's salary is public knowledge.

Time. Manual payroll for even 30 to 50 employees consumes days each month: chasing figures, cross-checking deductions, formatting bank schedules and statutory reports by hand.

What the alternative looks like

This is the problem Akatua was built for. It's a cloud-based payroll and HR platform from theSOFTtribe, built in Ghana and designed for use across countries, with compliance management that adheres to the tax and labour laws of your specific jurisdiction. Statutory deductions are computed automatically from current rules, statutory reports are generated straight from payroll, multi-currency support handles cross-border operations, and every change is time-stamped and attributed to a named user. Joiners and leavers are recorded in the system, so payroll reflects who actually works for you, every single cycle.

And it's proven at a scale no spreadsheet could survive: the Akatua platform has run the Government of Ghana's payroll, covering over 600,000 civil servants in a single nationwide run completed in about two hours, and a leading Big Four audit firm has run payroll on Akatua since 2019. If the most demanding payroll workloads on the continent trust it, it can comfortably handle yours.

Spreadsheets were never designed to run payroll. They were designed to be flexible. And flexibility, in payroll, is just another word for risk.

Ready to retire the spreadsheet?

Akatua can move you to a system that gets it right, every pay period. See how Akatua works or request a demo and run your next pay cycle the modern way..