HR software or Excel? The
threshold where you must switch
Excel runs payroll for most
Senegalese SMEs, and that is not absurd: it is often the right choice at the
start. The problem is not the tool, it is keeping it too long. Past a certain
threshold, a payroll spreadsheet no longer costs time β it creates risk: a
misapplied IPRES ceiling, a late filing, a disputed payslip. Here is how to
recognise that threshold, what Excel really costs, and how to switch without
breaking a payroll cycle.
Why Excel works β genuinely
Let's start with what most
software vendors won't say: for a company of five to ten employees, with fixed
salaries and little movement, Excel is a rational choice.
β
Zero
acquisition cost, or already amortised in the office suite
β
No
training needed: everyone can open a spreadsheet
β
Total
flexibility β you shape the calculation exactly as you want
β
No
dependence on a provider or an internet connection
A competent manager produces ten
compliant payslips in Excel without difficulty. If that is your situation, this
article does not concern you yet β keep it for when one of the signs below
appears.
The 6 signs you have passed the
threshold
In the companies we support, the
decision to leave Excel almost never comes after strategic reflection. It comes
after an incident. These six signs precede the incident.
1. The spreadsheet has a single
owner
Only one person understands the
formulas. If they are away at run time, payroll stops. The most serious sign,
and the most common.
2. You fix the same errors every
month
An inserted row that shifts a
range, a formula overwritten by manual entry, a copy-paste that breaks a
reference. You are no longer calculating payroll, you are repairing the file.
3. Employees dispute their payslip
Not because the amount is wrong,
but because no one can trace where it comes from. A spreadsheet has no reliable
history: impossible to say who changed what, and when.
4. Filings are prepared in a rush
IPRES and CSS filing is now done
online, which requires clean, structured data. Reconstructing it from a
spreadsheet, every deadline, under pressure, is a risk factor in itself.
5. You have several versions of
the same file
"Payroll_2026_v3_final_corrected.xlsx".
If that phrase is familiar, you no longer have one source of truth, you have
five.
6. You can't answer a simple
question in under an hour
"How has our payroll mass
evolved over twelve months by department?" In software, one click. In
Excel, a project.
The rule of three signs: one isolated sign can be fixed. Two are
bearable. From three simultaneous signs, our deployment experience shows the
spreadsheet has become a liability: the time spent maintaining it exceeds the
time saved using it.
The hidden cost of Excel,
quantified
The "Excel is free"
argument does not survive the maths, because it ignores the one item that truly
counts: the payroll manager's time. Below is the model applied to an SME of 45
employees.
Assumptions to adjust to your
situation: a payroll manager whose monthly employer cost is 450,000 FCFA, i.e.
about 2,600 FCFA per hour on a 173.33-hour basis.
| Monthly time | Monthly cost | |
Entering and checking payroll variables | 20 h | 52 000 FCFA | |
Preparing IPRES and CSS filings | 8 h | 20 800 FCFA | |
Corrections and employee queries | 6 h | 15 600 FCFA | |
Issuing and distributing payslips | 5 h | 13 000 FCFA | |
Monthly total | 39 h | 101 400 FCFA | |
Annual total | 468 h | 1 216 800 FCFA |
A little over 1.2 million FCFA a
year, i.e. 468 hours β nearly three months of full-time work β spent on a
process that adds no value to the company.
And this estimate is conservative:
it counts neither management time on approvals nor the cost of an error. A
retroactive adjustment across several employees, or a penalty for a late
filing, adds directly to this amount.
The real risk: compliance
Lost time is measurable, therefore
manageable. Compliance risk is invisible until the audit. Four points of
vigilance specific to the Senegalese context that we regularly see fail in
spreadsheets:
β
The
two IPRES schemes. A spreadsheet applying uniform treatment produces an error
on executives.
β
The
sector-based work-accident rate. Construction and industry are not at the
services rate. A spreadsheet built once does not follow a change of activity.
β
Affiliation
to a Health Insurance Institution. Mandatory, and regularly omitted.
β
Traceability.
In case of a Labour Inspectorate audit or a dispute, you must be able to
reconstruct an old payslip's calculation. A spreadsheet overwritten each month
cannot.
None of these errors is dramatic.
All accumulate silently over several years, and it is the accumulation that is
costly.
Beware of rates found online. Rates, ceilings and exemptions
evolve, and published sources often contradict one another. Always confirm your
parameters with the relevant body or your legal adviser, at run time.
The threshold is not a headcount
It is the question we are asked
most: at how many employees should you switch? The honest answer is that
headcount is only one of three indicators. Under 10 with fixed salaries, Excel
stays rational. Between 10 and 25, it is a grey zone that depends on complexity
β assess with the six signs. Over 25, the volume of variables is unmanageable
by hand: switch. And at any headcount, if you are multi-site, multi-country or
in a sector with a raised work-accident rate, switch regardless.
The two other factors often weigh
more than the number of employees:
β
Variable
complexity. Overtime, performance bonuses, travel allowances, salary advances,
sundry deductions. Twenty employees with ten variables each are harder to
handle than sixty on a fixed salary.
β
Turnover.
Each arrival and departure triggers a series of acts β affiliation, pro rata,
final settlement, certificates. A high-turnover company reaches the threshold
well before a stable one of the same size.
What Excel will never be able to
do
β
Employee
self-service: checking a leave balance, downloading a payslip, without going
through HR
β
A
full audit trail, showing who changed which element and when
β
Automatic
updates of legal parameters when a text changes
β
A
leave-and-absence approval workflow, with manager notification
β
Legally
sound archiving of payslips, admissible in a dispute
This last point is the most
underestimated: employee self-service alone absorbs a large share of the daily
requests an HR team receives β leave and payslip questions, essentially.
How to switch without breaking a
payroll cycle
β
Choose
the right moment. Switch at the start of a year or after a close, never
mid-adjustment period.
β
Clean
the data before migrating. An incomplete record in Excel stays incomplete in
the software. The longest step, and the most often skipped.
β
Run
one month in parallel. Produce payroll in both systems and compare line by
line. The only check that gives real confidence.
β
Migrate
the accruals, not just salaries. Contribution accruals, earned leave, seniority
history: without them, your year-end filings will be wrong.
β
Train
managers, not only HR. An approval workflow not adopted by managers saves no
one time.
β
Keep
the spreadsheet read-only for six months. Your safety net, and your reference
in case of a dispute over a prior period.
A well-prepared deployment for an
SME of this size is measured in weeks, not months β provided step two is taken
seriously.
Key takeaways
β
Excel
stays rational below ten employees with fixed salaries β the problem is keeping
it too long
β
Three
simultaneous signs among the six mean the spreadsheet has become a liability
β
The
real cost for a 45-employee SME is around 468 hours a year, nearly three months
full-time
β
The
main risk is not slowness but compliance: two IPRES schemes, sector-based rate,
IPM, traceability
β
The
threshold depends less on headcount than on variable complexity and turnover
β
A
successful migration requires one month of parallel payroll and upfront data
cleaning
Are you in the grey zone? Socium
calculates Senegalese payroll with IPRES and CSS parameters kept up to date by
our legal team, and delivers payslips directly to employees. Discover the
payroll module or book a demo to compare a real cycle with your current spreadsheet.
Want to go further?
See how Socium transforms HR and payroll practices across 12 African countries.